Excel Solutions
Investments
Schedule
Syllabus
Data
Excel Solutions
Lectures
Lecture 1: The Investment Environment
Pre-class Reading
Lecture 2: Foundations of Financial Markets
Pre-class Reading
Lab
Lecture 3: Measuring and Comparing Returns
Pre-class Reading
Lab
Lecture 4: Measuring Risk and Expected Return
Pre-class Reading
Lab
Lecture 5: Portfolio Risk and Returns
Pre-class Reading
Lab
Lecture 6: Optimal Capital Allocation
Pre-class Reading
Lab
Lecture 7: Mean-Variance Portfolio Optimization
Pre-class Reading
Lab
Lecture 8: Optimal Asset Allocation
Pre-class Reading
Lab
Lecture 9: Review Session
Lab
Lecture 10: Single-Index Model
Pre-class Reading
Lab
Lecture 11: Treynor-Black Model
Pre-class Reading
Lab 1
Lab 2
Lecture 12: CAPM
Pre-class Reading
Lab
Lecture 13: Cost of Capital Estimation
Pre-class Reading
Lab
Lecture 14: Bond Pricing
Pre-class Reading
Lecture 15: Bond Yields
Pre-class Reading
Lecture 16: Bond Risk
Pre-class Reading
Lecture 17: Review Session
Lab
Lecture 18: Valuation Using Multiples
Pre-class Reading
Lab
Lecture 19: Dividend Discount Models
Pre-class Reading
Lab
Lecture 20: Discounted Cash Flow Analysis
Pre-class Reading
Lab
Lecture 21: Introduction to Options
Pre-class Reading
Lecture 22: Option Trading Strategies
Pre-class Reading
Lecture 23: Option Valuation
Pre-class Reading
Lecture 24: Review Session
Lab
Excel Solutions
Posted Excel solution files for labs and textbook exercises.
File
Lecture_02_lab_solutions.xlsx
lecture_03_lab_solutions.xlsx
Lecture_04_lab_solutions.xlsx
Lecture_05_lab_solutions.xlsx
Lecture_06_Lab_Solutions.xlsx
Lecture_07_solutions.xlsx
Lecture_08_lab_solution.xlsx
Lecture_09_solution.xlsx
Lecture_10_Lab_Solutions.xlsx
Lecture_11_Lab2_Solutions.xlsx
Lecture_11_Lab_Solutions.xlsx
Lecture_12_Lab_Solutions.xlsx
Lecture_13 Lab Solutions.xlsx
Lecture_14 Solutions.xlsx
Lecture_15 Solutions.xlsx
Lecture_16 Solutions.xlsx
Lecture_17 Solutions.xlsx
Lecture_18_Textbook_Examples.xlsx
Lecture_19 Lab Solutions.xlsx
Lecture_19 Textbook Examples.xlsx
Lecture_20 Lab Solutions Part 1.xlsx
Lecture_20 Lab Solutions Part 2.xlsx
Lecture_20 Texbook Examples.xlsx
Lecture_21_Textbook_Solutions.xlsx
Lecture_22_Textbook_Solutions.xlsx
Lecture_23_Textbook_Solutions.xlsx
Lecture_24_Review_Session.xlsx