Department of Applied Economics

Glenn D. Pederson

Teaching

ApEc 4501
Financial Modeling

Glenn Pederson
Department of Applied Economics
217b Classroom Office Building
Phone: (612) 625-8770
E-mail: pederson@umn.edu

William Lazarus
Department of Applied Economics
249a Classroom Office Building
Phone: (612) 625-8150
Email: wlazarus@umn.edu

Course Outline (pdf)
Benning - 3rd Edition Typos (pdf) (NEW)

Quiz #1 (xls)

Excel Files	Homework Assignments
Homework #1 Template (xls)	Pederson Homework #1 – Financial Statements Model & Analysis (pdf)
Credit Scoring Model 1 (xls) Credit Scoring Model 2 (xls)	Pederson Homework #2 – Credit Scoring Model (pdf) Sample Report (pdf) Functions & IF Statements (pdf) Farm Finance Scorecard (pdf) Risk Model FinBin Comparison (pdf) Risk Model Loan Scoring (pdf) Risk Model Vermont Scorecard (pdf)
Rates of Return Data (xls)	Pederson Homework #3 – Portfolio Models & Value at Risk Analysis (pdf) Homework #3 - Class Demo (.xls) Tutorial for Monte Carlo Simulation Using @Risk (pdf) Palisade @Risk Manual – Chapter 2, Chapter 3, Chapter 4, Chapter 5, Chapter 6 A Concise Summary of @Risk Probability Distribution Functions (pdf)
Option Pricing Models (xls) (New)	Pederson Homework #4 – Option Pricing Models & Estimating Implied Volatility (pdf) (New)
Spreadsheet for Lecture (xls) Homework # 5 Spreadsheet (xls)	Lazarus Homework #5 – Capital Budgeting Methods (pdf) IRS publication 946, How to Depreciate Property (pdf) Purchase/Lease Decisions (pdf)
	Lazarus Homework #6 – Real Options
	Lazarus Homework #7 and Homework #8 – VBA Essentials