Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Financial Modelling with Python & Excel : DCF Valuation

Name: Financial Modelling with Python & Excel : DCF Valuation
Rating: 4.5 (67 reviews)

The Ultimate Financial Modelling Course that covers Complete DCF (Discounted Cash Flow) Valuation both in Python & Excel

Created byInstitute of Mathematical Thinking

Last updated 11/2022

English

What you'll learn

Be able to build a complete DCF (Discounted Cash Flow) model, from scratch
Be able to code and perform financial modelling in Python Language like an expert
Be able to create various different DCF Models both in Python & Excel
Be able to perform fundamental analysis of Financial Statements of a Company
Be able to Value a company and calculate the intrinsic share price, using real market data
Be able to link Balance Sheet, P&L and Cash Flow Statements with key indicators
Be able to articulate complex concepts related to Financial Valuation, in an interview
Be able to perform analysis and modelling in Excel, like an Expert

Course content

6 sections • 91 lectures • 10h 12m total length

Introduction - Value of an Asset5:07
Learn how earnings minus debt obligations and expenditures yield free cash flow, define assets by future cash flows, and discount them to present value to determine asset value.
Discount Rates5:21
Discounted Cash Flow7:59
Learn discounted cash flow by converting future cash flows to present value using a discount rate, derived from the cost of capital and the debt-to-equity mix.
Autofill Functionality6:03
Autofill - Lab - Excel3:05
Autofill - Lab - Python6:12
List Operations - Python8:34
DCF Steps - Theory7:35
Weighted Average Cost of Capital (WACC) - 13:53
Define capital as debt and equity, explain the debt-to-equity ratio, and introduce cost of capital with debt and equity components, leading to the weighted average cost of capital.
WACC - 24:41
Explore the cost of equity and the weighted average cost of capital using CAPM components—risk-free rate, beta, and market risk premium—and apply debt-to-equity considerations and tax effects in WACC calculations.
WACC - Lab - Excel4:14
WACC - Lab - Python5:42
WACC -2 - Lab - Python3:35
Intrinsic Value - Lab - Excel12:22
Build a five-year explicit dcf model from wacc to intrinsic value by projecting earnings, calculating free cash flow, and deriving terminal value, discount factors, and equity value.
FCF - Lab - Python6:33
FCF 2 - Lab - Python5:13
Intrinsic Value 1 - Lab - Python10:41
Intrinsic Value 2 - Lab - Python2:54
Additional Content - Autofill 2 - Python4:45
Ex.Recreate the DCF model given here, with your computer and compare the results
Py.Recreate the DCF Model given in the attachment, in your local Python software
Autofill - Python Notebook

FCFE vs DDM - Theory5:56
FCFE vs DDM - Lab - Excel8:29
Compare fcfe and ddm valuations in excel by modeling growth, reinvestment, and dividends, then discount future cash flows to present value using cost of equity.
FCFE vs DDM-Lab 1-Python1:49
Learn how to set up inputs for FCFE and DDM calculations in Python, including net income, debt obligations, miscellaneous reinvestment rate, growth rate, cost of equity, and perpetual growth rate.
FCFE vs DDM-Lab 2-Python5:32
Learn to implement a Python discounted cash flow model by recreating autofill with temp, calc, and lists, applying growth and discounting to net income, debt obligations, miscellaneous cash, and dividends.
FCFE vs DDM-Lab 3-Python4:20
FCFE vs DDM-Lab 4-Python6:35
The Spreadsheet model used in this section, is attached as downloadable file0:03
The Python code, used in this section, is attached as downloadable notebook0:03

Return on Capital & Reinvestment - Theory6:53
ROC & Reinvestment-Lab-Excel3:37
ROC & Reinvestment 2- Lab-Excel4:31
ROC & Reinvestment -Lab- Python7:23
Recreate the financial model from spreadsheet in Python, calculating return on capital and reinvestment using tax, EBIT, debt and equity, capex, depreciation, and working capital.
Dividend Discounted Model - Theory10:01
Dividend Discounted Model - Excel9:10
Dividend Discounted Model - Python10:26
Free cash flow to Equity -Theory6:48
Free cash flow to Equity -Excel7:50
Free cash flow to Equity -Python7:54
Compute inputs and cost of equity, forecast net income and FCF, discount cash flows, and derive the equity value with a Python-based discounted cash flow model.
Estimating Beta - Theory8:29
Equity vs Firm Discounted Models7:12
FCFF - Lab - Excel14:38
FCFF - Lab2 - Excel6:00
FCFF - Lab3 - Excel6:02
FCFF - Lab1 - Python4:28
FCFF - Lab2 - Python4:51
Additional Content - Cost of Equity and Beta-Theory4:55
Additional Content - Cost of Equity and Beta-Theory3:35
Additional Content - CoE and Beta-Lab5:55
Additional Content - CoE and Beta-Lab6:20
The spreadsheets and Python codes, is attached as downloadable files & notebooks0:02

Overview of the Company1:54
Analysis of Balance Sheet4:57
Analysis of Profit & Loss Statement3:08
Analysis of Cash Flow Statement2:57
Inputs for Valuation - 16:52
Inputs for Valuation - 22:31
Forecasting Free Cash Flows6:51
Cost of Capital and Present Value11:21
Compute the discount rate from cost of capital or cost of equity, discount forecast free cash flows, and derive the firm’s present value and intrinsic value.
Intrinsic Value and P/B Ratio14:14
Potential Pitfalls8:07
Learn how basic free cash flow and dividend inputs affect equity value, intrinsic value, compare with price-to-book, and identify pitfalls in forecasting and financial statement reading.
Annual Report which contains the Financial Statements used in this section0:03

Basic Elements - Theory16:13
Basic Elements - Lab9:17
Branching Programs - Theory10:09
Branching Programs - Lab9:51
Strings and Input - Theory7:56
Explore core string concepts in Python, including indexing, slicing, length, and concatenation, and practice input handling and type errors, with emphasis on string operations and Python 3 input.
Strings and Input - Lab13:28
Iterations - Theory6:31
Iterations - Lab6:11
Exhaustive Enumeration and For Loops - Theory9:02
Exhaustive Enumeration and For Loops - Lab15:45
Functions & Scoping - Theory7:26
Functions & Scoping - Lab11:51
Explore defining functions, formal and actual parameters, and function scope. Learn to implement max, min, and square as examples, and distinguish inside versus outside the function scope.
Recursion 1 - Theory4:11
Recursion 1 - Lab7:00
Recursion 2 - Theory6:21
Recursion 2 - Lab7:33
Tuples and Lists - Theory5:50
Tuples and Lists - Lab9:45
Mutability in Lists - Theory5:32
Mutability in Lists - Lab 15:55
Mutability in Lists - Lab 27:31
Functions as Objects - Theory4:18
Functions as Objects - Lab6:19
Testing and Debugging - Theory6:57
Testing and Debugging - Lab12:46
Classes and Inheritance - Theory7:42
Classes and Inheritance - Lab13:26
Project - Theory4:28
Project - Lab and Solution15:45

Requirements

No prior programming experience is required. Basic knowledge of Excel would be good
Lots of enthusiasm, dedication and focus is mandatory. This is a comprehensive course.

Description

Do you want to become a Python Wizard ? Would you like to learn how to value a company ?

Even people who don't have a Finance or coding background can take this course and learn how to build end-to-end Discounted Cash Flow Models, for the 1st time ever, with Python & Excel !!

All the models used in this course, are available as free downloadable files (jupyter notebooks & excel workbooks) !!

Attention! You will have to go through the videos and the course materials in order to obtain the promised result!

If you want to:

Become a Pro in Python Programming
Improve your Excel modelling skills
Learn how to value a company using different approaches
Understand what drives a company's value and what are it's risks
Learn Fundamental Analysis of Financial Statements

Then this is the right course for you!

What we offer:

Well designed and easy to understand materials
Detailed and comprehensible explanation of theoretical concepts, using a digital whiteboard
Detailed Lab sessions both in Python and Excel
Complete coverage of DCF (Discounted Cash Flow) using multiple different approaches

By the completion of this course you will:

Be able to build a complete cash flow statement
Be able to build financial models with Python & Excel
Know how to value a company, using real world Financial Statements and Market Data
Be able to build multiple different valuation models, from scratch (in Python & Excel)
Know how to create a model with multiple scenarios, parameters
Be able to analyse financial statements of a Company (Balance Sheet, P&L and Cash Flow Statements)
Be able to articulate complex concepts related to Financial Valuation, in interviews

The course is developed by experts, who have extensive experience in the field of Investment Banking, Market Risk, Financial Modeling and Quantitative Finance

About the course:

An unconditional Udemy 30 day money-back guarantee – because we believe in the quality of our content
No significant previous experience is needed to understand the course well and benefit fully from its content
Unlimited lifetime access to all course materials
Emphasis on learning by doing
You can always contact us for any clarification free of charge
Our goal is to take your Financial Valuation skills to the next level. We are going to take you away from the spreadsheet, for the very 1st time !

Make an investment that will pay for itself in terms of career progression, professional opportunities and growth.

Just go ahead and enrol for this course! Stay ahead and beat the race, in this competitive job market and become a rock star, by completing this course ! You will be a rare gem, with a unique combination Python, Financial modelling and Valuation skills !

Happy Learning !

Who this course is for:

Professionals who want to learn Financial Valuation and all its underlying concepts
Professionals who want to become experts in Python & Excel based Financial Modelling
Learners who want to master Python Programming and improve their Excel Skills, in one shot
Finance Experts, who want to be able to analyse and value a company, using real world data

Financial Modelling with Python & Excel : DCF Valuation

What you'll learn

Explore related topics

Course content

Part 1 - Building Blocks of Financial Valuation20 lectures • 1hr 54min

Part 2- Equity Discounted Models8 lectures • 33min

Part 3 - Valuation in Action22 lectures • 2hr 27min

Part 4 - Capstone Project (Completely in Python)11 lectures • 1hr 3min

A Comprehensive Crash Course in Python29 lectures • 4hr 15min

Congratulations (Surprise at the end !)1 lecture • 1min

Requirements

Description

Who this course is for: