Financial Analysis and Modeling Using Excel and VBA

Front Cover
John Wiley & Sons, Nov 9, 2009 - Business & Economics - 816 pages
An updated look at the theory and practice of financial analysis and modeling

Financial Analysis and Modeling Using 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 2007 and VBA (as well as earlier versions of both). This expanded and fully updated guide reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial problems and models that you can learn from, use for practice, and easily adapt for work and classroom use. A companion website includes several useful modeling tools and fully working versions of all the models discussed in the book.

  • Teaches financial analysis and modeling and illustrates advanced features of Excel and VBA, using a learn-by-doing approach
  • Contains detailed coverage of the powerful features of Excel 2007 essential for financial analysis and modeling, such as the Ribbon interface, PivotTables, data analysis, and statistical analysis
  • Other titles by Sengupta: Financial Modeling Using C++ and The Only Proven Road to Investment Success
  • Designed for self-study, classroom use, and reference

This comprehensive guide is an essential read for anyone who has to perform financial analysis or understand and implement financial models.

 

Selected pages

Contents

Part One Excel for Financial Analysis and Modeling
13
Excel Basics
25
Advanced Excel Features
43
Making Decisions and Looking Up Values
77
Analyzing Databases
109
Answering WhatIf Questions
161
Finding Iterative Solutions
171
Using the Financial Functions
221
Modeling Examples
438
Options and Option Portfolios
449
Introduction to VBA
505
VBA Essentials
529
Sub and Function Procedures
577
Debugging VBA Codes
589
How to Build Good VBA Models
597
Time Value of Money
607

Other Useful Excel Functions
243
Part Two Financial Modeling Using Excel
255
Financial Statements Forecasting
271
Time Value of Money
327
Financial Planning and Investments
365
Analyzing Market History
389
Bond Pricing and Duration
409
Simulating Stock Prices
427
Financial Planning and Investments
663
Analyzing Market History
691
Simulating Stock Prices
717
Options and Option Portfolios
725
Binomial Option Pricing
741
APPENDIX A Keyboard Shortcuts for Excel
755
About the CDROM
777
Copyright

Common terms and phrases

American options amortization table analysis annual payment annualPmnt arguments array formula asset binomial tree bond Building the Model calculate called cash flows Cells(outRow chapter chart click OK column copy coupon create data table database depreciation dialog box discussed dividend dividend yield dollars enter the formula equal equations European options example Excel and VBA final balance financial modeling format free cash flow Function procedure funds future value Goal Seek implied volatility income independent variables initial input variables interest rate intRate investment iteration labels loanLife logical values look loop macro menu Modeling Strategy module output period pivot table portfolio problem put options range reference rNum row number sheet shown in Figure specified step stock price Sub procedure syntax Testing the Model versions of Excel volatility window workbook worksheet yearNum yield to maturity zero

About the author (2009)

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. Formerly, he was vice president at the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for ten years. He is also the author of the first edition of this book as well as Financial Modeling Using C++ and The Only Proven Road to Investment Success, all of which are published by Wiley.

Bibliographic information

TitleFinancial Analysis and Modeling Using Excel and VBA
Wiley Finance
AuthorChandan Sengupta
Edition2, illustrated
PublisherJohn Wiley & Sons, 2009
ISBN047027560X, 9780470275603
Length816 pages
Subjects ›  › 

Business & Economics / Accounting / General
Business & Economics / Finance / General
Business & Economics / General
  
Export CitationBiBTeX EndNote RefMan