Excel Modeling in Corporate Finance Book and CD-ROM

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.