Excel Modeling in Corporate Finance

Excel Modeling in Corporate Finance

4 (1 rating by Goodreads)
By (author)  , By (author) 

List price: US$49.01

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks


This book teaches readers how to build financial models with step-by-step instructions in Excel. Progressing from simple examples to practical, real-world applications, this book covers the time value of money, valuation, capital budgeting, financial planning, and options and corporate finance. For financial planners and analysts.show more

Product details

  • Mixed media product
  • 212 x 272 x 14mm | 439.98g
  • Pearson Education (US)
  • Prentice Hall
  • Upper Saddle River, United States
  • English
  • Revised
  • 2nd Revised edition
  • 013132165X
  • 9780131321656

Table of contents

I. TIME VALUE OF MONEY. 1. Single Cash Flow. Present Value. Future Value. Problems. 2. Annuity. Present Value. Future Value. System of Four Annuity Variables. Problems. 3. Net Present Value. Constant Discount Rate. General Discount Rate. Problems. 4. Real and Inflation. Constant Discount Rate. General Discount Rate. Problems. 5. Loan Amortization. Basics. Sensitivity Analysis. Problems. II. VALUATION. 6. Bond Valuation. Annual Payments. APR vs. EAR. By Yield to Maturity. System of Five Bond Variables. Dynamic Chart. Problems. 7. Stock Valuation. Two Stage. Dynamic Chart. Problems. 8. The Yield Curve. Obtaining It from Bond Listings. Using It to Price a Coupon Bond. Using It to Determine Forward Rates. Problems. 9. U.S. Yield Curve Dynamics. Dynamic Chart. Problems. III. CAPITAL BUDGETING. 10. Project NPV. Basics. Forecasting Cash Flows. Working Capital. Sensitivity Analysis. Problems. 11. Cost-Reducing Project. Basics. Sensitivity Analysis. Problems. 12. Break-Even Analysis. Based on Accounting Profit. Based on NPV. Problems. 13 Three Valuation Methods. Adjusted Present Value. Flows to Equity. Weighted Average Cost of Capital. Problems. IV. FINANCIAL PLANNING. 14. Corporate Financial Planning. Actual. Forecast. Cash Flow. Ratios. Sensitivity. Full-Scale Real Data. Problems. 15. Du Pont System of Ratio Analysis. Basics. Problems. 16. Life-Cycle Financial Planning. Basics. Problems. V. OPTIONS AND CORPORATE FINANCE. 17. Binomial Option Pricing. Single Period. Multi-Period. Risk Neutral. Full-Scale Real Data. Problems. 18. Black Scholes Option Pricing. Basics. Dynamic Chart. Continuous Dividend. Implied Volatility. Problems. 19. Debt and Equity Valuation. Two Methods. Impact of Risk. Problems. 20. Real Options. Using Black-Scholes. Using the Binomial Model. Sensitivity to Standard Deviation. Problems.show more

Rating details

1 ratings
4 out of 5 stars
5 0% (0)
4 100% (1)
3 0% (0)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X