SPREADSHEET MODELING EXERCISES

How To Build Real-world

Financial Models In Excel

BY CRAIG W. HOLDEN

For Students: Spreadsheet Modeling is a Core Skill of Real-World Finance

For Faculty: Tips on Using Spreadsheet Modeling Exercises in Your Course

NOTE: The below files are provided to you in MS Word format.
To access them, click the appropiate file and view from Word.

___________________________________________________________________________________

Section 3. 8 Corporate Financial Planning

Section 9. 2 Discounted Dividend Model

Section 4. 3 -- 4.6 DCF Calculations

Section 12. 3 Portfolio Optimization

Section 4. 8 Mortgage Loan Amortization

Section 14. 7 Financial Futures

Section 4.10 Inflation and DCF Calculations

Section 15. 6 Binomial Option Pricing

Section 5. 1 Life-Cycle Financial Planning

Section 15. 7 Black-Scholes

Section 6. 3 Net Present Value

Section 15. 8 Implied Volatility

Section 6. 4 Forecasting Project Cash Flows

Section 15. 9 Stocks and Risky Bonds

Section 6. 7 NPV of a Cost-Reducing Project

Section 16.10 Three Valuation Methods

Section 8. 4 Reading Bond Listings

Section 17. 3 Real Options

Section 8. 7 Vasicek Yield Curve

  

___________________________________________________________________________________

Note: If you have any trouble using the hyperlinks above, then just open the files directly from your word processor. All files are located in the \Finance\spreadsheets\Spreadsheet Modeling Exercises\Bodie-Merton subdirectory.

Craig’s Challenge. Don’t click on this hyperlink unless you are willing to consider an important challenge that goes beyond the minimum effort needed for your class.

Craig’s e-mail address: cholden@indiana.edu. Please send me your feedback and suggestions.

Craig’s Profile and Acknowledgements. Thank you!