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)

Excel Formatting and Utility Spreadsheat Examples (pdf)
  Manurwkst_classic.xls
  Manurwkst.xls
  Grain Truck Transportation Cost Calculator (xls)
  Conditional formatting (xls)
  Transpose authors3 (xls)
  Digester econ (xls)
  BioPET (xls)

Excel Tips/Tools/Tricks (pdf)

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

Get Adobe Reader