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:
    
- :download:`Financial Modeling All Downloads (updated June  9,  4:48 AM) </_static/Financial Modeling All Downloads.zip>`
        
Course Materials
===================

- :download:`1 Financial Modeling Syllabus (updated October 18,  4:23 PM) </_static/generated/pdfs/C1 Financial Modeling Syllabus.pdf>`
        
- :download:`2 Course Schedule (updated November 19,  1:27 AM) </_static/generated/pdfs/C2 Course Schedule.pdf>`
        
Slides
=========

- :download:`1 Financial Modeling with Python and Excel (updated October 14,  8:27 PM) </_static/generated/pdfs/S1 Financial Modeling with Python and Excel.pdf>`
        
- :download:`1 Advanced Financial Modeling (updated December 15,  1:28 AM) </_static/generated/pdfs/SA1 Advanced Financial Modeling.pdf>`
        
- :download:`2 Getting Started with Python and Excel (updated October 14,  8:27 PM) </_static/generated/pdfs/S2 Getting Started with Python and Excel.pdf>`
        
- :download:`3 The Depth of a Financial Model (updated September 21,  3:24 PM) </_static/generated/pdfs/S3 The Depth of a Financial Model.pdf>`
        
- :download:`4 Going Beyond an Initial Python Script (updated May 26,  5:05 AM) </_static/generated/pdfs/S4 Going Beyond an Initial Python Script.pdf>`
        
- :download:`5 The Depth of a Financial Model, Continued (updated September 21,  3:24 PM) </_static/generated/pdfs/S5 The Depth of a Financial Model, Continued.pdf>`
        
- :download:`6 Understanding Complex Results (updated September 28,  7:15 PM) </_static/generated/pdfs/S6 Understanding Complex Results.pdf>`
        
- :download:`7 Exploring the Parameter Space (updated October 14,  8:27 PM) </_static/generated/pdfs/S7 Exploring the Parameter Space.pdf>`
        
- :download:`8 Probabilistic Modeling (updated October 27, 11:01 PM) </_static/generated/pdfs/S8 Probabilistic Modeling.pdf>`
        
- :download:`9 Combining Excel and Python (updated September 21,  3:24 PM) </_static/generated/pdfs/S9 Combining Excel and Python.pdf>`
        
- :download:`10 Monte Carlo Simulation (updated November  6,  1:46 PM) </_static/generated/pdfs/S10 Monte Carlo Simulation.pdf>`
        
- :download:`11 Introduction to DCF Valuation and Cost of Capital Estimation (updated June  9,  4:48 AM) </_static/generated/pdfs/S11 Introduction to DCF Valuation and Cost of Capital Estimation.pdf>`
        
- :download:`12 Free Cash Flow Estimation and Forecasting (updated November 26,  5:08 PM) </_static/generated/pdfs/S12 Free Cash Flow Estimation and Forecasting.pdf>`
        
Lecture Notes
================

- :download:`1 Financial Modeling with Python and Excel (updated September 20,  1:18 PM) </_static/generated/pdfs/LN1 Financial Modeling with Python and Excel.pdf>`
        
- :download:`1 Advanced Financial Modeling (updated December 15,  1:28 AM) </_static/generated/pdfs/LNA1 Advanced Financial Modeling.pdf>`
        
- :download:`2 Getting Started with Python and Excel (updated September  4, 11:33 AM) </_static/generated/pdfs/LN2 Getting Started with Python and Excel.pdf>`
        
- :download:`3 The Depth of a Financial Model (updated September  7,  6:57 PM) </_static/generated/pdfs/LN3 The Depth of a Financial Model.pdf>`
        
- :download:`4 Going Beyond an Initial Python Script (updated September  7,  6:57 PM) </_static/generated/pdfs/LN4 Going Beyond an Initial Python Script.pdf>`
        
- :download:`5 The Depth of a Financial Model, Continued (updated September 28,  5:14 PM) </_static/generated/pdfs/LN5 The Depth of a Financial Model, Continued.pdf>`
        
- :download:`6 Understanding Complex Results (updated September 28,  5:14 PM) </_static/generated/pdfs/LN6 Understanding Complex Results.pdf>`
        
- :download:`7 Exploring the Parameter Space (updated October 14,  8:27 PM) </_static/generated/pdfs/LN7 Exploring the Parameter Space.pdf>`
        
- :download:`8 Probabilistic Modeling (updated October 27, 11:01 PM) </_static/generated/pdfs/LN8 Probabilistic Modeling.pdf>`
        
- :download:`9 Combining Excel and Python (updated October 27, 11:01 PM) </_static/generated/pdfs/LN9 Combining Excel and Python.pdf>`
        
- :download:`10 Monte Carlo Simulation (updated November  3, 11:30 PM) </_static/generated/pdfs/LN10 Monte Carlo Simulation.pdf>`
        
- :download:`11 Introduction to DCF Valuation and Cost of Capital Estimation (updated November 10, 11:35 PM) </_static/generated/pdfs/LN11 Introduction to DCF Valuation and Cost of Capital Estimation.pdf>`
        
- :download:`12 Free Cash Flow Estimation and Forecasting (updated November 26,  5:08 PM) </_static/generated/pdfs/LN12 Free Cash Flow Estimation and Forecasting.pdf>`
        
- :download:`13 Q&A (updated December 15,  1:28 AM) </_static/generated/pdfs/LN13 Q&A.pdf>`
        
Practice Problems
====================

- :download:`1 Python Retirement Savings Rate Problem (updated September  4,  7:05 AM) </_static/generated/pdfs/PR1 Python Retirement Savings Rate Problem.pdf>`
        
- :download:`2 Scenario Modeling Problems (updated September  4,  7:05 AM) </_static/generated/pdfs/PR2 Scenario Modeling Problems.pdf>`
        
- :download:`3 Internal Randomness Problems (updated September  4,  7:05 AM) </_static/generated/pdfs/PR3 Internal Randomness Problems.pdf>`
        
- :download:`4 xlwings Problems (updated September  4,  7:05 AM) </_static/generated/pdfs/PR4 xlwings Problems.pdf>`
        
- :download:`5 Monte Carlo Simulation Problems (updated September  4,  7:05 AM) </_static/generated/pdfs/PR5 Monte Carlo Simulation Problems.pdf>`
        
Project Descriptions
=======================

- :download:`0 Project Grading Overview (updated September  7,  6:57 PM) </_static/generated/pdfs/PJ0 Project Grading Overview.pdf>`
        
- :download:`1 Excel and Python TVM (updated September  7,  6:57 PM) </_static/generated/pdfs/PJ1 Excel and Python TVM.pdf>`
        
- :download:`2 Probabilistic Loan Pricing (updated September  4,  7:05 AM) </_static/generated/pdfs/PJ2 Probabilistic Loan Pricing.pdf>`
        
- :download:`3 Monte Carlo Cost of Capital (updated November 14,  7:14 PM) </_static/generated/pdfs/PJ3 Monte Carlo Cost of Capital.pdf>`
        
- :download:`4 Full DCF Valuation (updated September  4,  7:05 AM) </_static/generated/pdfs/PJ4 Full DCF Valuation.pdf>`
        


Project Materials
====================



Project 1
------------



- :download:`Project 1 Template (updated September  7,  2:39 PM) </_static/Project Materials/Project 1/Project 1 Template.ipynb>`
        
- :download:`Project 1 Template (updated September  7,  2:39 PM) </_static/Project Materials/Project 1/Project 1 Template.xlsx>`
        
Project 2
------------



- :download:`Project 2 Template (updated September  7,  2:39 PM) </_static/Project Materials/Project 2/Project 2 Template.ipynb>`
        
- :download:`Project 2 Template (updated September  7,  2:39 PM) </_static/Project Materials/Project 2/Project 2 Template.xlsx>`
        
Project 3
------------



- :download:`Project 3 Template (updated September  7,  2:39 PM) </_static/Project Materials/Project 3/Project 3 Template.ipynb>`
        
- :download:`Project 3 Template (updated September  7,  2:39 PM) </_static/Project Materials/Project 3/Project 3 Template.xlsx>`
        
- :download:`SP500 Prices (updated September  7,  2:39 PM) </_static/Project Materials/Project 3/SP500 Prices.xlsx>`
        
- :download:`WMT Balance Sheet (updated September  7,  2:39 PM) </_static/Project Materials/Project 3/WMT Balance Sheet.xlsx>`
        
- :download:`WMT Debt Details (updated September 20,  9:40 AM) </_static/Project Materials/Project 3/WMT Debt Details.xls>`
        
- :download:`WMT Income Statement (updated September  7,  2:39 PM) </_static/Project Materials/Project 3/WMT Income Statement.xlsx>`
        
- :download:`WMT Prices (updated September  7,  2:39 PM) </_static/Project Materials/Project 3/WMT Prices.xlsx>`
        
Practice Problem Solutions
=============================



Retirement
-------------



- :download:`Practice 1 - Retirement Model with Dynamic Savings Rate (updated September  7,  5:46 AM) </_static/Practice Problem Solutions/Retirement/Practice 1 - Retirement Model with Dynamic Savings Rate.ipynb>`
        
Scenario Modeling
--------------------



- :download:`Capital Budgeting (updated September  7,  5:46 AM) </_static/Practice Problem Solutions/Scenario Modeling/Capital Budgeting.ipynb>`
        
Internal Randomness
----------------------



- :download:`Stock Portfolio (updated September  7,  5:46 AM) </_static/Practice Problem Solutions/Internal Randomness/Stock Portfolio.ipynb>`
        
Connecting Python and Excel
------------------------------



xlwings
^^^^^^^^^^



- :download:`CAPM Returns (updated September  7,  5:46 AM) </_static/Practice Problem Solutions/Connecting Python and Excel/xlwings/CAPM Returns.ipynb>`
        
capm_returns
"""""""""""""""



- :download:`capm_returns (updated September 20,  9:42 AM) </_static/Practice Problem Solutions/Connecting Python and Excel/xlwings/capm_returns/capm_returns.py>`
        
Monte Carlo
--------------



- :download:`Airplane Monte Carlo (updated September  7,  5:46 AM) </_static/Practice Problem Solutions/Monte Carlo/Airplane Monte Carlo.ipynb>`
        
Materials for Lab Exercises
==============================



Python Basics
----------------



- :download:`Dicts and List Comprehensions Lab (updated September  7,  5:46 AM) </_static/Materials for Lab Exercises/Python Basics/Dicts and List Comprehensions Lab.ipynb>`
        
- :download:`Python Basics Lab (updated December 14, 10:30 AM) </_static/Materials for Lab Exercises/Python Basics/Python Basics Lab.ipynb>`
        
Visualization
----------------



- :download:`Pandas and Visualization Labs (updated December 14, 10:30 AM) </_static/Materials for Lab Exercises/Visualization/Pandas and Visualization Labs.ipynb>`
        
Connecting Python and Excel
------------------------------



pandas
^^^^^^^^^



- :download:`Financial Data (updated September  7,  5:46 AM) </_static/Materials for Lab Exercises/Connecting Python and Excel/pandas/Financial Data.xlsx>`
        
- :download:`MSFT Financials (updated September 20,  9:40 AM) </_static/Materials for Lab Exercises/Connecting Python and Excel/pandas/MSFT Financials.xls>`
        
xlwings
^^^^^^^^^^



- :download:`xlwings Lab (updated September  7,  5:46 AM) </_static/Materials for Lab Exercises/Connecting Python and Excel/xlwings/xlwings Lab.xlsx>`
        
DCF
------



Cost of Equity
^^^^^^^^^^^^^^^^^



- :download:`prices (updated September  7,  5:46 AM) </_static/Materials for Lab Exercises/DCF/Cost of Equity/prices.xlsx>`
        
FCF
^^^^^^



- :download:`WMT Balance Sheet (updated September  7,  5:46 AM) </_static/Materials for Lab Exercises/DCF/FCF/WMT Balance Sheet.xlsx>`
        
- :download:`WMT Income Statement (updated September  7,  5:46 AM) </_static/Materials for Lab Exercises/DCF/FCF/WMT Income Statement.xlsx>`
        
Forecasting
^^^^^^^^^^^^^^



Complex
""""""""""



- :download:`CAT Balance Sheet (updated September  7,  5:46 AM) </_static/Materials for Lab Exercises/DCF/Forecasting/Complex/CAT Balance Sheet.xlsx>`
        
- :download:`CAT Income Statement (updated September  7,  5:46 AM) </_static/Materials for Lab Exercises/DCF/Forecasting/Complex/CAT Income Statement.xlsx>`
        
- :download:`Forecasting Quarterly Financial Statements Lab (updated September  7,  5:46 AM) </_static/Materials for Lab Exercises/DCF/Forecasting/Complex/Forecasting Quarterly Financial Statements Lab.ipynb>`
        
Simple
"""""""""



- :download:`Debt Interest (updated September  7,  5:46 AM) </_static/Materials for Lab Exercises/DCF/Forecasting/Simple/Debt Interest.xlsx>`
        
Examples
===========



Data Pipelines
-----------------



Debt Details
^^^^^^^^^^^^^^^



- :download:`Pfizer Debt Details (updated December 14, 10:30 AM) </_static/Examples/Data Pipelines/Debt Details/Pfizer Debt Details.xls>`
        
- :download:`capiq_debt (updated December 14, 10:30 AM) </_static/Examples/Data Pipelines/Debt Details/capiq_debt.py>`
        
Introduction
---------------



Excel
^^^^^^^^



- :download:`Dynamic Salary Retirement Model (updated September  4,  9:10 AM) </_static/Examples/Introduction/Excel/Dynamic Salary Retirement Model.xlsx>`
        
- :download:`Simple Retirement Model (updated September  4,  9:10 AM) </_static/Examples/Introduction/Excel/Simple Retirement Model.xlsx>`
        
Python
^^^^^^^^^



- :download:`Dynamic Salary Retirement Model (updated September  4,  9:10 AM) </_static/Examples/Introduction/Python/Dynamic Salary Retirement Model.ipynb>`
        
- :download:`Python Basics (updated December 14, 10:30 AM) </_static/Examples/Introduction/Python/Python Basics.ipynb>`
        
- :download:`Python Dicts, List comprehensions, and Imports (updated September  4,  9:10 AM) </_static/Examples/Introduction/Python/Python Dicts, List comprehensions, and Imports.ipynb>`
        
- :download:`Simple Retirement Model (updated September  4,  9:10 AM) </_static/Examples/Introduction/Python/Simple Retirement Model.ipynb>`
        
- :download:`car_example (updated September 20,  9:42 AM) </_static/Examples/Introduction/Python/car_example.py>`
        
Visualization
----------------



Excel
^^^^^^^^



- :download:`Dynamic Salary Retirement Model Visualized (updated September  4,  9:10 AM) </_static/Examples/Visualization/Excel/Dynamic Salary Retirement Model Visualized.xlsx>`
        
Python
^^^^^^^^^



- :download:`Dynamic Salary Retirement Model Visualized (updated September  4,  9:10 AM) </_static/Examples/Visualization/Python/Dynamic Salary Retirement Model Visualized.ipynb>`
        
- :download:`Intro to Graphics (updated September  4,  9:10 AM) </_static/Examples/Visualization/Python/Intro to Graphics.ipynb>`
        
- :download:`Intro to Pandas and Table Visualization (updated September  4,  9:10 AM) </_static/Examples/Visualization/Python/Intro to Pandas and Table Visualization.ipynb>`
        
Sensitivity Analysis
-----------------------



Excel
^^^^^^^^



- :download:`Dynamic Salary Retirement Model Sensitivity (updated September  4,  9:10 AM) </_static/Examples/Sensitivity Analysis/Excel/Dynamic Salary Retirement Model Sensitivity.xlsx>`
        
Python
^^^^^^^^^



- :download:`Dynamic Salary Retirement Model Sensitivity (updated December 14, 10:30 AM) </_static/Examples/Sensitivity Analysis/Python/Dynamic Salary Retirement Model Sensitivity.ipynb>`
        
- :download:`Sensitivity Analysis (updated December 14, 10:30 AM) </_static/Examples/Sensitivity Analysis/Python/Sensitivity Analysis.ipynb>`
        
Scenario Analysis
--------------------



Excel
^^^^^^^^



- :download:`Dynamic Salary Retirement Model External Scenarios (updated September  4,  9:10 AM) </_static/Examples/Scenario Analysis/Excel/Dynamic Salary Retirement Model External Scenarios.xlsx>`
        
Python
^^^^^^^^^



- :download:`Dynamic Salary Retirement Model Scenario Analysis (updated September  4,  9:10 AM) </_static/Examples/Scenario Analysis/Python/Dynamic Salary Retirement Model Scenario Analysis.ipynb>`
        
Internal Randomness
----------------------



Excel
^^^^^^^^



- :download:`Dynamic Salary Retirement Model Internal Randomness (updated September  4,  9:10 AM) </_static/Examples/Internal Randomness/Excel/Dynamic Salary Retirement Model Internal Randomness.xlsx>`
        
- :download:`Generating Random Numbers (updated September  4,  9:10 AM) </_static/Examples/Internal Randomness/Excel/Generating Random Numbers.xlsx>`
        
Python
^^^^^^^^^



- :download:`Dynamic Salary Retirement Model Internal Randomness (updated December 14, 10:30 AM) </_static/Examples/Internal Randomness/Python/Dynamic Salary Retirement Model Internal Randomness.ipynb>`
        
- :download:`Generating Random Numbers (updated September  4,  9:10 AM) </_static/Examples/Internal Randomness/Python/Generating Random Numbers.ipynb>`
        
Connecting Python and Excel
------------------------------



pandas
^^^^^^^^^



- :download:`New Book (updated September  4,  9:10 AM) </_static/Examples/Connecting Python and Excel/pandas/New Book.xlsx>`
        
- :download:`Read Write Excel Pandas (updated September  4,  9:10 AM) </_static/Examples/Connecting Python and Excel/pandas/Read Write Excel Pandas.ipynb>`
        
- :download:`Stock Data (updated September  4,  9:10 AM) </_static/Examples/Connecting Python and Excel/pandas/Stock Data.xlsx>`
        
xlwings
^^^^^^^^^^



- :download:`Combining Excel and Python (updated September  4,  9:10 AM) </_static/Examples/Connecting Python and Excel/xlwings/Combining Excel and Python.ipynb>`
        
- :download:`Example Workbook (updated September  4,  9:10 AM) </_static/Examples/Connecting Python and Excel/xlwings/Example Workbook.xlsx>`
        
Monte Carlo
--------------



Excel
^^^^^^^^



- :download:`Dynamic Salary Retirement Model with Monte Carlo (updated September  4,  9:10 AM) </_static/Examples/Monte Carlo/Excel/Dynamic Salary Retirement Model with Monte Carlo.xlsx>`
        
- :download:`Dynamic Salary Retirement Model (updated September  4,  9:10 AM) </_static/Examples/Monte Carlo/Excel/Dynamic Salary Retirement Model.xlsx>`
        
- :download:`Excel Monte Carlo (updated September  4,  9:10 AM) </_static/Examples/Monte Carlo/Excel/Excel Monte Carlo.ipynb>`
        
Python
^^^^^^^^^



- :download:`Dynamic Salary Retirement Model Monte Carlo (updated September  4,  9:10 AM) </_static/Examples/Monte Carlo/Python/Dynamic Salary Retirement Model Monte Carlo.ipynb>`
        
- :download:`MC Investment Returns (updated September  4,  9:10 AM) </_static/Examples/Monte Carlo/Python/MC Investment Returns.ipynb>`
        
DCF
------



Cost of Debt
^^^^^^^^^^^^^^^



- :download:`Market Value of Debt (updated September  4,  9:10 AM) </_static/Examples/DCF/Cost of Debt/Market Value of Debt.ipynb>`
        
- :download:`debt data (updated September  4,  9:10 AM) </_static/Examples/DCF/Cost of Debt/debt data.xlsx>`
        
Cost of Equity
^^^^^^^^^^^^^^^^^



- :download:`DCF Cost of Equity (updated September  4,  9:10 AM) </_static/Examples/DCF/Cost of Equity/DCF Cost of Equity.xlsx>`
        
- :download:`Determining the Cost of Equity (updated September  4,  9:10 AM) </_static/Examples/DCF/Cost of Equity/Determining the Cost of Equity.ipynb>`
        
- :download:`price data (updated September  4,  9:10 AM) </_static/Examples/DCF/Cost of Equity/price data.xlsx>`
        
Forecasting
^^^^^^^^^^^^^^



Complex
""""""""""



- :download:`Forecasting Quarterly Financial Statements (updated December 14, 10:30 AM) </_static/Examples/DCF/Forecasting/Complex/Forecasting Quarterly Financial Statements.ipynb>`
        
- :download:`WMT Balance Sheet (updated September  4,  9:10 AM) </_static/Examples/DCF/Forecasting/Complex/WMT Balance Sheet.xlsx>`
        
- :download:`WMT Income Statement (updated September  4,  9:10 AM) </_static/Examples/DCF/Forecasting/Complex/WMT Income Statement.xlsx>`
        
Simple
"""""""""



- :download:`Forecast Sales COGS Simple-Copy1 (updated September  4,  9:10 AM) </_static/Examples/DCF/Forecasting/Simple/Forecast Sales COGS Simple-Copy1.ipynb>`
        
- :download:`Forecast Sales COGS Simple (updated September  4,  9:10 AM) </_static/Examples/DCF/Forecasting/Simple/Forecast Sales COGS Simple.ipynb>`
        
- :download:`Forecasting Financial Statements (updated December 14, 10:30 AM) </_static/Examples/DCF/Forecasting/Simple/Forecasting Financial Statements.ipynb>`
        
- :download:`Sales COGS Forecasted (updated December 14, 10:30 AM) </_static/Examples/DCF/Forecasting/Simple/Sales COGS Forecasted.xlsx>`
        
- :download:`Sales COGS (updated September  4,  9:10 AM) </_static/Examples/DCF/Forecasting/Simple/Sales COGS.xlsx>`
        
- :download:`cat_annual_bs (updated September  4,  9:31 AM) </_static/Examples/DCF/Forecasting/Simple/cat_annual_bs.csv>`
        
- :download:`cat_annual_income (updated September  4,  9:31 AM) </_static/Examples/DCF/Forecasting/Simple/cat_annual_income.csv>`
        
Full DCF
^^^^^^^^^^^



- :download:`Brinks Operating Model V 2.0 (updated September  4,  9:10 AM) </_static/Examples/DCF/Full DCF/Brinks Operating Model V 2.0.xlsx>`
        
- :download:`Brinks Paper Final (updated September 20,  9:44 AM) </_static/Examples/DCF/Full DCF/Brinks Paper Final.pdf>`
        
- :download:`Presentation_V3.5 regionals (updated September 20,  9:45 AM) </_static/Examples/DCF/Full DCF/Presentation_V3.5 regionals.pptx>`
        
Historical FCF
^^^^^^^^^^^^^^^^^



- :download:`Calculating Historical FCF (updated December 14, 10:30 AM) </_static/Examples/DCF/Historical FCF/Calculating Historical FCF.ipynb>`
        
- :download:`Exxon Mobil Corporation NYSE XOM Financials (updated September 20,  9:40 AM) </_static/Examples/DCF/Historical FCF/Exxon Mobil Corporation NYSE XOM Financials.xls>`
        
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
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^



- :download:`First xlwings Project (updated September  4,  9:10 AM) </_static/Extra Examples/xlwings/Create xlwings UDF Project/First xlwings Project.ipynb>`
        
Dynamic UDFs
^^^^^^^^^^^^^^^



- :download:`Dynamic Array UDFs (updated September  4,  9:10 AM) </_static/Extra Examples/xlwings/Dynamic UDFs/Dynamic Array UDFs.ipynb>`
        
portfolio_ret
""""""""""""""""



- :download:`portfolio_ret (updated September 20,  9:42 AM) </_static/Extra Examples/xlwings/Dynamic UDFs/portfolio_ret/portfolio_ret.py>`