SPREADSHEET MODELING EXERCISES



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

___________________________________________________________________________________

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!

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download