| Excel Files |
Homework Assignments |
| Homework #1 Template (xls) |
Financial Statements Model & Analysis - Homework #1 (Pederson)
|
Credit Scoring Model 1
Credit Scoring Model 2
|
Credit Scoring Model- Homework #2 (Pederson)
Sample Report
Functions & IF Statements
Farm Finance Scorecard
Risk Model FinBin Comparison
Risk Model Loan Scoring
Risk Model Vermont Scorecard
|
Rates of Return Data (.xlsx)
|
Portfolio Models & Value at Risk Analysis - Homework #3 (Pederson)
|
General Mills Financial Data (.xls)
ValuePro Template |
Cost of Capital & Capital Structure Analysis - Homework #4 (Pederson)
EVA Tutorial
EVA for Small Business
Ross, Westefield, and Jordan. Fundamentals of Corporate Finance, p. 547-558.
|
| Option Pricing Models (.xls) |
Option Pricing Models & Estimating Implied Volatility - Homework #5 (Pederson)
Benninga, Chapter 13 notes (Excel Macro)
Benninga, Chapter 14 notes (Excel Macro)
The 2 Excel Macro files will not open in Internet Explorer or Firefox. You can save these files to a flash drive in Mozilla Firefox by right-licking with your mouse and using "Save Link As".
|
| S&P 500 Returns Data (.xls) |
Monte Carlo Simulation Methods Using @Risk (Pederson)
Monte Carlo Simulation ~ In-Class Problem
Palisade @Risk Manual - Chapter 2, Chapter 3, Chapter 4, Chapter 5, Chapter 6
A Concise Summary of @Risk Probability Distribution Functions |
Spreadsheet for Lecture
Homework # 6 Spreadsheet |
Capital Budgeting Methods - Homework #6 (Lazarus)
IRS publication 946, How to Depreciate Property
|
| |
Purchase/Lease Decisions - Homework #7 (Lazarus)
|
| re_homework_data.xls |
Real Options - Homework #8 (Lazarus)
|
|
VBA Essentials - Homework #9 and Homework #10 NEW (Lazarus)
|
