Financial Modeling with Python and Excel
107 videos • 229,658 views • by Nick DeRobertis
1
About Me - Financial Modeling with Python and Excel
Nick DeRobertis
Download
2
Syllabus - Financial Modeling with Python and Excel
Nick DeRobertis
Download
3
What is a Financial Model? - Financial Modeling with Python and Excel
Nick DeRobertis
Download
4
Tools and Skills - Financial Modeling with Python and Excel
Nick DeRobertis
Download
5
Installing Python - Financial Modeling with Python and Excel
Nick DeRobertis
Download
6
Introduction and an Example Model - Getting Started with Python and Excel
Nick DeRobertis
Download
7
Building a Simple Excel Model - Getting Started with Python and Excel
Nick DeRobertis
Download
8
Building a Simple Python Model - Getting Started with Python and Excel
Nick DeRobertis
Download
9
Basic Iteration - Getting Started with Python and Excel
Nick DeRobertis
Download
10
Extending a Simple Excel Model - Getting Started with Python and Excel
Nick DeRobertis
Download
11
Extending a Simple Python Model - Getting Started with Python and Excel
Nick DeRobertis
Download
12
Getting Started with Python and Excel Labs - Getting Started with Python and Excel
Nick DeRobertis
Download
13
Simple Retirement Model Assumptions - The Depth of a Financial Model
Nick DeRobertis
Download
14
Relaxing the Salary Assumption - The Depth of a Financial Model
Nick DeRobertis
Download
15
Skills for the Advanced Excel Model - The Depth of a Financial Model
Nick DeRobertis
Download
16
Implementing the Dynamic Salary Model - The Depth of a Financial Model
Nick DeRobertis
Download
17
Lab Exercise - The Depth of a Financial Model
Nick DeRobertis
Download
18
Structuring a Complex Python Model - Going Beyond an Initial Python Script
Nick DeRobertis
Download
19
Branching Logic with Python Conditionals - Going Beyond an Initial Python Script
Nick DeRobertis
Download
20
Grouping Objects with Python Lists - Going Beyond an Initial Python Script
Nick DeRobertis
Download
21
Grouping Logic with Python Functions - Going Beyond an Initial Python Script
Nick DeRobertis
Download
22
Python Basic Data Types - Going Beyond an Initial Python Script
Nick DeRobertis
Download
23
Creating Python Data Types with Classes - Going Beyond an Initial Python Script
Nick DeRobertis
Download
24
Handling Errors in Python - Going Beyond an Initial Python Script
Nick DeRobertis
Download
25
Project 0 - Project Grading Overview - Projects
Nick DeRobertis
Download
26
Project 1 - Excel and Python TVM - Projects
Nick DeRobertis
Download
27
Using Jupyter to Structure a Python Model - The Depth of a Financial Model, Continued
Nick DeRobertis
Download
28
Salaries in the Python Dynamic Salary Retirement Model - The Depth of a Financial Model, Continued
Nick DeRobertis
Download
29
Wealth in the Python Dynamic Salary Retirement Model - The Depth of a Financial Model, Continued
Nick DeRobertis
Download
30
Retirement in the Python Dynamic Salary Retirement Model - The Depth of a Financial Model, Continued
Nick DeRobertis
Download
31
Lab Exercise - The Depth of a Financial Model, Continued
Nick DeRobertis
Download
32
Introduction to Visualization - Understanding Complex Results
Nick DeRobertis
Download
33
Visualization in Excel Example - Understanding Complex Results
Nick DeRobertis
Download
34
Introduction to Pandas - Understanding Complex Results
Nick DeRobertis
Download
35
Styling Pandas DataFrames - Understanding Complex Results
Nick DeRobertis
Download
36
Introduction to Graphs in Python with Pandas - Understanding Complex Results
Nick DeRobertis
Download
37
Visualization in Python Example - Understanding Complex Results
Nick DeRobertis
Download
38
Lab Exercises - Understanding Complex Results
Nick DeRobertis
Download
39
Introduction to Parameter Exploration - Exploring the Parameter Space
Nick DeRobertis
Download
40
Introduction to Sensitivity Analysis - Exploring the Parameter Space
Nick DeRobertis
Download
41
Sensitivity Analysis in Excel - Exploring the Parameter Space
Nick DeRobertis
Download
42
Using Python Dictionaries - Exploring the Parameter Space
Nick DeRobertis
Download
43
Python List Comprehensions - Convenient List Building - Exploring the Parameter Space
Nick DeRobertis
Download
44
Python Imports and Installing Packages - Exploring the Parameter Space
Nick DeRobertis
Download
45
Introduction to Sensitivity Analysis in Python - Exploring the Parameter Space
Nick DeRobertis
Download
46
Sensitivity Analysis in Python Example - Exploring the Parameter Space
Nick DeRobertis
Download
47
Lab Exercise - Adding Sensitivity Analysis to Project 1 - Python - Exploring the Parameter Space
Nick DeRobertis
Download
48
Introduction to Probabilistic Modeling - Probabilistic Modeling
Nick DeRobertis
Download
49
Math Review for Probabilistic Modeling - Probabilistic Modeling
Nick DeRobertis
Download
50
Introduction to Scenario Analysis - Probabilistic Modeling
Nick DeRobertis
Download
51
Scenario Analysis in Excel - Probabilistic Modeling
Nick DeRobertis
Download
52
Project 2 - Probabilistic Loan Pricing - Projects
Nick DeRobertis
Download
53
Scenario Analysis in Python - Probabilistic Modeling
Nick DeRobertis
Download
54
Introduction to Internal Randomness - Probabilistic Modeling
Nick DeRobertis
Download
55
Intro to Randomness in Excel - Probabilistic Modeling
Nick DeRobertis
Download
56
Intro to Randomness in Python - Probabilistic Modeling
Nick DeRobertis
Download
57
Lab Exercise - Generating Continuous Random Numbers in Excel and Python - Probabilistic Modeling
Nick DeRobertis
Download
58
Discrete Randomness - Probabilistic Modeling
Nick DeRobertis
Download
59
Adding Internal Randomness to an Excel Model - Probabilistic Modeling
Nick DeRobertis
Download
60
Adding Internal Randomness to a Python Model - Probabilistic Modeling
Nick DeRobertis
Download
61
Internal Randomness Lab Exercises Overview - Probabilistic Modeling
Nick DeRobertis
Download
62
Introduction to Combining Excel and Python - Combining Excel and Python
Nick DeRobertis
Download
63
Combining Excel and Python using Pandas - Combining Excel and Python
Nick DeRobertis
Download
64
Combining Excel and Python using xlwings - Combining Excel and Python
Nick DeRobertis
Download
65
Introduction to Monte Carlo Simulations - Monte Carlo Simulation
Nick DeRobertis
Download
66
Monte Carlo Investment Returns - Monte Carlo Simulation
Nick DeRobertis
Download
67
Monte Carlo Dividend Discount Model (DDM) Lab Exercise - Monte Carlo Simulation
Nick DeRobertis
Download
68
Formal Introduction to Monte Carlo Simulations - Monte Carlo Simulation
Nick DeRobertis
Download
69
Analyzing Relationships with Monte Carlo Simulations - Monte Carlo Simulation
Nick DeRobertis
Download
70
Applying Monte Carlo Simulation to a Python Model - Monte Carlo Simulation
Nick DeRobertis
Download
71
Applying Monte Carlo Simulation to an Excel Model - Monte Carlo Simulation
Nick DeRobertis
Download
72
Relationship of Inputs and Outputs in Excel Monte Carlo Simulation - Monte Carlo Simulation
Nick DeRobertis
Download
73
Project 3 - Monte Carlo Cost of Capital - Projects
Nick DeRobertis
Download
74
Introduction to Discounted Cash Flow DCF Valuation - DCF Cost of Capital
Nick DeRobertis
Download
75
Enterprise Value and Equity Value - Introduction to DCF Valuation and Cost of Capital Estimation
Nick DeRobertis
Download
76
Introduction to Cost of Equity - Introduction to DCF Valuation and Cost of Capital Estimation
Nick DeRobertis
Download
77
Cost of Equity in Python - Introduction to DCF Valuation and Cost of Capital Estimation
Nick DeRobertis
Download
78
Cost of Equity in Excel - Introduction to DCF Valuation and Cost of Capital Estimation
Nick DeRobertis
Download
79
Market Value of Equity - Introduction to DCF Valuation and Cost of Capital Estimation
Nick DeRobertis
Download
80
Cost of Debt - Introduction to DCF Valuation and Cost of Capital Estimation
Nick DeRobertis
Download
81
Introduction to Market Value of Debt - Introduction to DCF Valuation and Cost of Capital Estimation
Nick DeRobertis
Download
82
Calculating the Market Value of Debt in Python - DCF Cost of Capital
Nick DeRobertis
Download
83
Calculating the Weighted Average Cost of Capital (WACC) - DCF Cost of Capital
Nick DeRobertis
Download
84
Introduction to Free Cash Flows - Free Cash Flow Estimation and Forecasting
Nick DeRobertis
Download
85
Introduction to Calculating Historical Free Cash Flows - Free Cash Flow Estimation and Forecasting
Nick DeRobertis
Download
86
Historical Free Cash Flows in Python Using Pandas and finstmt - FCF Estimation and Forecasting
Nick DeRobertis
Download
87
Historical Free Cash Flows Lab Exercise Overview - Free Cash Flow Estimation and Forecasting
Nick DeRobertis
Download
88
Introduction to Forecasting - Free Cash Flow Estimation and Forecasting
Nick DeRobertis
Download
89
Simple Time-Series Forecasting Models - Free Cash Flow Estimation and Forecasting
Nick DeRobertis
Download
90
Simple Time-Series Forecasting in Excel - Free Cash Flow Estimation and Forecasting
Nick DeRobertis
Download
91
Simple Time-Series Forecasting in Python - Free Cash Flow Estimation and Forecasting
Nick DeRobertis
Download
92
Simple Time-Series Forecasting Lab Overview - Free Cash Flow Estimation and Forecasting
Nick DeRobertis
Download
93
Forecasting Simple Financial Statements in Python with finstmt - FCF Estimation and Forecasting
Nick DeRobertis
Download
94
Project 4 - Full DCF Valuation - Projects
Nick DeRobertis
Download
95
Complex Time-Series Forecasting - Free Cash Flow Estimation and Forecasting
Nick DeRobertis
Download
96
Complex Time Series Forecasting in Python - Manual Method - FCF Estimation and Forecasting
Nick DeRobertis
Download
97
Complex Time-Series Forecasting in Python - finstmt Method - FCF Estimation and Forecasting
Nick DeRobertis
Download
98
Complex Time-Series Forecasting Lab Overview - Free Cash Flow Estimation and Forecasting
Nick DeRobertis
Download
99
Applying Forecasting to Free Cash Flows - Free Cash Flow Estimation and Forecasting
Nick DeRobertis
Download
100
Calculating a Terminal Value - Free Cash Flow Estimation and Forecasting
Nick DeRobertis
Download
101
Introduction to Advanced Financial Modeling - Advanced Financial Modeling
Nick DeRobertis
Download
102
Additional Types of Financial Models - Advanced Financial Modeling
Nick DeRobertis
Download
103
Data Pipelines for Financial Modeling - Advanced Financial Modeling
Nick DeRobertis
Download
104
Advanced Mathematical Tools for Financial Modeling - Advanced Financial Modeling
Nick DeRobertis
Download
105
Better Presentation of Python Financial Models - Advanced Financial Modeling
Nick DeRobertis
Download
106
Programming Skills for Advanced Financial Models - Advanced Financial Modeling
Nick DeRobertis
Download
107
Extra Resources for Python Financial Modeling - Advanced Financial Modeling
Nick DeRobertis
Download