Excel Modeling in the Fundamentals of 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. U.S. Yield Curve Dynamics.


Dynamic Chart. Problems.

III. CAPITAL BUDGETING.

9. Project NPV.


Basics. Forecasting Cash Flows. Working Capital. Sensitivity Analysis. Problems.

10. Break-Even Analysis.


Based on Accounting Profit. Based on NPV. Problems.

IV. FINANCIAL PLANNING.

11. Corporate Financial Planning.


Actual. Forecast. Cash Flow. Ratios. Sensitivity. Full-Scale Real Data. Problems.

12. Life-Cycle Financial Planning.


Basics. Problems.

V. OPTIONS AND CORPORATE FINANCE.

13. Binomial Option Pricing.


Single Period. Multi-Period. Risk Neutral. Full-Scale Real Data. Problems.

14. Black Scholes Option Pricing.


Basics. Dynamic Chart. Continuous Dividend. Implied Volatility. Problems.

15. Real Options.


Using Black-Scholes. Using the Binomial Model. Sensitivity to Standard Deviation. Problems.