Downloads

Find all the individual files for course content on this page. Files will be updated over time so the last updated date is displayed next to the file. To download all the content as a zip file, use the following link:

• Financial Modeling All Downloads (updated June  9,  4:48 AM)

Course Materials

• 1 Financial Modeling Syllabus (updated October 18,  4:23 PM)

• 2 Course Schedule (updated November 19,  1:27 AM)

Slides

• 1 Financial Modeling with Python and Excel (updated October 14,  8:27 PM)

• 1 Advanced Financial Modeling (updated December 15,  1:28 AM)

• 2 Getting Started with Python and Excel (updated October 14,  8:27 PM)

• 3 The Depth of a Financial Model (updated September 21,  3:24 PM)

• 4 Going Beyond an Initial Python Script (updated May 26,  5:05 AM)

• 5 The Depth of a Financial Model, Continued (updated September 21,  3:24 PM)

• 6 Understanding Complex Results (updated September 28,  7:15 PM)

• 7 Exploring the Parameter Space (updated October 14,  8:27 PM)

• 8 Probabilistic Modeling (updated October 27, 11:01 PM)

• 9 Combining Excel and Python (updated September 21,  3:24 PM)

• 10 Monte Carlo Simulation (updated November  6,  1:46 PM)

• 11 Introduction to DCF Valuation and Cost of Capital Estimation (updated June  9,  4:48 AM)

• 12 Free Cash Flow Estimation and Forecasting (updated November 26,  5:08 PM)

Lecture Notes

• 1 Financial Modeling with Python and Excel (updated September 20,  1:18 PM)

• 1 Advanced Financial Modeling (updated December 15,  1:28 AM)

• 2 Getting Started with Python and Excel (updated September  4, 11:33 AM)

• 3 The Depth of a Financial Model (updated September  7,  6:57 PM)

• 4 Going Beyond an Initial Python Script (updated September  7,  6:57 PM)

• 5 The Depth of a Financial Model, Continued (updated September 28,  5:14 PM)

• 6 Understanding Complex Results (updated September 28,  5:14 PM)

• 7 Exploring the Parameter Space (updated October 14,  8:27 PM)

• 8 Probabilistic Modeling (updated October 27, 11:01 PM)

• 9 Combining Excel and Python (updated October 27, 11:01 PM)

• 10 Monte Carlo Simulation (updated November  3, 11:30 PM)

• 11 Introduction to DCF Valuation and Cost of Capital Estimation (updated November 10, 11:35 PM)

• 12 Free Cash Flow Estimation and Forecasting (updated November 26,  5:08 PM)

• 13 Q&A (updated December 15,  1:28 AM)

Practice Problems

• 1 Python Retirement Savings Rate Problem (updated September  4,  7:05 AM)

• 2 Scenario Modeling Problems (updated September  4,  7:05 AM)

• 3 Internal Randomness Problems (updated September  4,  7:05 AM)

• 4 xlwings Problems (updated September  4,  7:05 AM)

• 5 Monte Carlo Simulation Problems (updated September  4,  7:05 AM)

Project Descriptions

• 0 Project Grading Overview (updated September  7,  6:57 PM)

• 1 Excel and Python TVM (updated September  7,  6:57 PM)

• 2 Probabilistic Loan Pricing (updated September  4,  7:05 AM)

• 3 Monte Carlo Cost of Capital (updated November 14,  7:14 PM)

• 4 Full DCF Valuation (updated September  4,  7:05 AM)

Project Materials

Project 1

• Project 1 Template (updated September  7,  2:39 PM)

• Project 1 Template (updated September  7,  2:39 PM)

Project 2

• Project 2 Template (updated September  7,  2:39 PM)

• Project 2 Template (updated September  7,  2:39 PM)

Project 3

• Project 3 Template (updated September  7,  2:39 PM)

• Project 3 Template (updated September  7,  2:39 PM)

• SP500 Prices (updated September  7,  2:39 PM)

• WMT Balance Sheet (updated September  7,  2:39 PM)

• WMT Debt Details (updated September 20,  9:40 AM)

• WMT Income Statement (updated September  7,  2:39 PM)

• WMT Prices (updated September  7,  2:39 PM)

Practice Problem Solutions

Retirement

• Practice 1 - Retirement Model with Dynamic Savings Rate (updated September  7,  5:46 AM)

Scenario Modeling

• Capital Budgeting (updated September  7,  5:46 AM)

Internal Randomness

• Stock Portfolio (updated September  7,  5:46 AM)

Connecting Python and Excel

xlwings

• CAPM Returns (updated September  7,  5:46 AM)

capm_returns

• capm_returns (updated September 20,  9:42 AM)

Monte Carlo

• Airplane Monte Carlo (updated September  7,  5:46 AM)

Materials for Lab Exercises

Python Basics

• Dicts and List Comprehensions Lab (updated September  7,  5:46 AM)

• Python Basics Lab (updated December 14, 10:30 AM)

Visualization

• Pandas and Visualization Labs (updated December 14, 10:30 AM)

Connecting Python and Excel

pandas

• Financial Data (updated September  7,  5:46 AM)

• MSFT Financials (updated September 20,  9:40 AM)

xlwings

• xlwings Lab (updated September  7,  5:46 AM)

DCF

Cost of Equity

• prices (updated September  7,  5:46 AM)

FCF

• WMT Balance Sheet (updated September  7,  5:46 AM)

• WMT Income Statement (updated September  7,  5:46 AM)

Forecasting

Complex

• CAT Balance Sheet (updated September  7,  5:46 AM)

• CAT Income Statement (updated September  7,  5:46 AM)

• Forecasting Quarterly Financial Statements Lab (updated September  7,  5:46 AM)

Simple

• Debt Interest (updated September  7,  5:46 AM)

Examples

Data Pipelines

Debt Details

• Pfizer Debt Details (updated December 14, 10:30 AM)

• capiq_debt (updated December 14, 10:30 AM)

Introduction

Excel

• Dynamic Salary Retirement Model (updated September  4,  9:10 AM)

• Simple Retirement Model (updated September  4,  9:10 AM)

Python

• Dynamic Salary Retirement Model (updated September  4,  9:10 AM)

• Python Basics (updated December 14, 10:30 AM)

• Python Dicts, List comprehensions, and Imports (updated September  4,  9:10 AM)

• Simple Retirement Model (updated September  4,  9:10 AM)

• car_example (updated September 20,  9:42 AM)

Visualization

Excel

• Dynamic Salary Retirement Model Visualized (updated September  4,  9:10 AM)

Python

• Dynamic Salary Retirement Model Visualized (updated September  4,  9:10 AM)

• Intro to Graphics (updated September  4,  9:10 AM)

• Intro to Pandas and Table Visualization (updated September  4,  9:10 AM)

Sensitivity Analysis

Excel

• Dynamic Salary Retirement Model Sensitivity (updated September  4,  9:10 AM)

Python

• Dynamic Salary Retirement Model Sensitivity (updated December 14, 10:30 AM)

• Sensitivity Analysis (updated December 14, 10:30 AM)

Scenario Analysis

Excel

• Dynamic Salary Retirement Model External Scenarios (updated September  4,  9:10 AM)

Python

• Dynamic Salary Retirement Model Scenario Analysis (updated September  4,  9:10 AM)

Internal Randomness

Excel

• Dynamic Salary Retirement Model Internal Randomness (updated September  4,  9:10 AM)

• Generating Random Numbers (updated September  4,  9:10 AM)

Python

• Dynamic Salary Retirement Model Internal Randomness (updated December 14, 10:30 AM)

• Generating Random Numbers (updated September  4,  9:10 AM)

Connecting Python and Excel

pandas

• New Book (updated September  4,  9:10 AM)

• Read Write Excel Pandas (updated September  4,  9:10 AM)

• Stock Data (updated September  4,  9:10 AM)

xlwings

• Combining Excel and Python (updated September  4,  9:10 AM)

• Example Workbook (updated September  4,  9:10 AM)

Monte Carlo

Excel

• Dynamic Salary Retirement Model with Monte Carlo (updated September  4,  9:10 AM)

• Dynamic Salary Retirement Model (updated September  4,  9:10 AM)

• Excel Monte Carlo (updated September  4,  9:10 AM)

Python

• Dynamic Salary Retirement Model Monte Carlo (updated September  4,  9:10 AM)

• MC Investment Returns (updated September  4,  9:10 AM)

DCF

Cost of Debt

• Market Value of Debt (updated September  4,  9:10 AM)

• debt data (updated September  4,  9:10 AM)

Cost of Equity

• DCF Cost of Equity (updated September  4,  9:10 AM)

• Determining the Cost of Equity (updated September  4,  9:10 AM)

• price data (updated September  4,  9:10 AM)

Forecasting

Complex

• Forecasting Quarterly Financial Statements (updated December 14, 10:30 AM)

• WMT Balance Sheet (updated September  4,  9:10 AM)

• WMT Income Statement (updated September  4,  9:10 AM)

Simple

• Forecast Sales COGS Simple-Copy1 (updated September  4,  9:10 AM)

• Forecast Sales COGS Simple (updated September  4,  9:10 AM)

• Forecasting Financial Statements (updated December 14, 10:30 AM)

• Sales COGS Forecasted (updated December 14, 10:30 AM)

• Sales COGS (updated September  4,  9:10 AM)

• cat_annual_bs (updated September  4,  9:31 AM)

• cat_annual_income (updated September  4,  9:31 AM)

Full DCF

• Brinks Operating Model V 2.0 (updated September  4,  9:10 AM)

• Brinks Paper Final (updated September 20,  9:44 AM)

• Presentation_V3.5 regionals (updated September 20,  9:45 AM)

Historical FCF

• Calculating Historical FCF (updated December 14, 10:30 AM)

• Exxon Mobil Corporation NYSE XOM Financials (updated September 20,  9:40 AM)

Extra Examples

These examples are related to content not covered in the course. This may be content which was covered in prior versions of the course or other supplementary examples.

xlwings

Create xlwings UDF Project

• First xlwings Project (updated September  4,  9:10 AM)

Dynamic UDFs

• Dynamic Array UDFs (updated September  4,  9:10 AM)

portfolio_ret

• portfolio_ret (updated September 20,  9:42 AM)