CHANDAN SENGUPTA . in all major areas of finance using both Excel and VBA. I will teach you VBA and modeling with VBA using a simple class-tested. Buy Financial Analysis and Modeling Using Excel and VBA (Wiley Finance) 2nd by Chandan Sengupta (ISBN: ) from Amazon’s Book Store. Praise for Financial Modeling Using Excel and VBA “Excel and VBA have vast capabilities, yet until this book, users were on their own to figure out just how to.

Author: Shaktijinn Vokree
Country: Guinea
Language: English (Spanish)
Genre: Marketing
Published (Last): 14 June 2009
Pages: 451
PDF File Size: 10.13 Mb
ePub File Size: 10.36 Mb
ISBN: 792-8-22005-620-8
Downloads: 97020
Price: Free* [*Free Regsitration Required]
Uploader: Shakarg

Incorporating Names in Formulas 4.

Financial Analysis and Modeling Using Excel and VBA : Chandan Sengupta :

Daniel Ervi added it Apr 14, Conditions Usod In Do Loops Rashmita marked it as to-read May 29, The Wisdom of Finance Mihir Desai. Common terms and phrases American options amortization table exccel payment annualPmnt answer arguments array formula Assats asset binomial tree bond Building the Model built-in functions calculate called cash flows Cells outRow chapter chart click OK column copy coupon data table data type debugging dependent variables dialog box discussed dividend dividend yield dollars End Sub enter kodeling formula equal equations error European options example Excel model final balance format free cash flow Function procedure future value Goal Seek implied volatility income input cell input variables interest rate intRate investment iteration labels Loan Amort loanLife logical values loop macro mcome Modeling Strategy module option price output payoff period portfolio present value problem put options rNum row number specified step stock price Sub procedure Testing the Model tool Totel VBA models Venguerd volatility window workbook worksheet yearNum yield curve yield to maturity zero.


X To apply for permission please send your request to permissions wiley.

Binomial Option Pricing The New Features in Excel 2. Calculating Income Tax, Version 2 5.

Taxable versus Tax-Deferred Accounts Data Tables Are Dynamic 7. Financial Analysis and Modeling Amd Excel and VBA, Second Edition presents a comprehensive approach to analyzing financial problems and developing simple to sophisticated financial models in all major areas of finance using Excel and VBA as well as earlier versions of both.

Visit our homepage and find this week’s Massive Discounts on worldwide bestsellers until Friday.

Financial Modeling Using Excel and VBA – Chandan Sengupta – Google Books

Chapter 10 Using Excel’s Financial Functions. About Chandan Sengupta Chandan Sengupta teaches finance in the MBA program at the Fordham University Graduate School of Business, specializing in financial modeling, business valuation, corporate finance, and investment management.

Chirag Panchal marked it as to-read Aug 29, Functions to Convert Dollar Pricing With Safari, you learn the way you learn best.

A Note at Caution 4. Excel for Financial Analysis and Modeling.

Financial Analysis and Modeling Using Excel and VBA

Using Data Tables to Create Charts 7. Binding the Model Formerly, he was vice president of the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for 10 years. Working with Comments 4. Variables, Constants, and Arrays Deepak Motiramani marked it as to-read Dec 21, Want to Read Currently Reading Read.


Financial Analysis and Modeling Using Excel and VBA, 2nd Edition

Benefits of Learning Programming Protecting an Entire Worksheet 4. Answering What-If Questions 7. Functions That Return Arrays Limitations and Flexibility of the Model The Bisection Method exce Want to Read saving….

finsncial Omololu added it Apr 30, Bad Blood John Carreyrou. A Simple Model for Stock Prices Linking Finance and Quality by Yosef D. Chapter 17 Bond Pricing and Duration. William Kowalski rated it liked it Nov 27, Removing a Module Using Decision Trees to Represent Logic 5. Using a Custom View to Print Reports 4.

Visit our Beautiful Books page and find lovely books for kids, photography lovers and more. Finding Help in Previous Versions of Excel 3. Using Built-In Functions