Financial Modeling & Valuation for Investment Analysis
5.00 (1 Rating)
Enrolled:38
$80
$106
-
LevelBeginner
-
Last UpdatedApril 14, 2024
-
Enrollment validityEnrollment validity: 365 days
-
CertificateCertificate of completion
Hi, Welcome back!
About Course
We welcome you as you embark on this transformative journey into the very heart of financial modeling and valuation, where you'll learn and master the essential concepts and techniques that Wall Street Analysts use in modeling and valuing a company. From constructing the 3-Statement financial statements— Income Statement, Balance Sheet, and Cash Flow, along with its appropriate schedule —from scratch, to crafting bespoke models for diverse businesses, the hands-on experience you will gain in this course equips you to seamlessly apply modeling and valuation principles to real-world business scenarios.
In this course, you master three key valuation techniques—Discounted Cash Flow (DCF) analysis, precedent transaction analysis, and comparable company analysis—enabling you to accurately assess and value businesses. With a focus on spreadsheet-based models, you'll not only gain proficiency but also cultivate the indispensable skills required for financial analysts and modelers across diverse industries.
Delve into this course like a budding enthusiast and come out like a Wall Street analyst!
What will I learn?
- Acquire a comprehensive understanding of essential financial modeling concepts and techniques.
- Learn to build and forecast the three key financial statements—Income Statement, Balance Sheet, and Cash Flow—from scratch.
- Gain hands-on experience in constructing financial models tailored for diverse businesses and projects, enabling you to apply modeling principles to real-world scenarios.
- Explore and master three prominent valuation techniques employed by Wall Street analysts—Discounted Cash Flow (DCF) analysis, precedent transaction analysis, and comparable company analysis—to accurately assess and value businesses.
- Develop proficiency in using spreadsheet-based models for valuation purposes, honing skills that are essential for financial analysts working in various industries.
Course Curriculum
Introduction to Financial Modeling
-
02:12
-
02:14
-
01:28
-
01:44
-
01:55
-
05:41
-
01:44
-
00:50
-
Obtaining Historical Financial Data (DOWNLOAD ATTACHED FILE)
10:54
Financial Model Order & Structure
-
Download Course Model Templete Here!
-
Module Outline
00:48 -
Worksheet Order in a FInancial Model
01:23 -
Financial Model Worksheet Linkage
05:08
Financial Modeling – The Income Statement
-
Module Outline
01:12 -
Model Template Walkthrough
03:06 -
Calculating Revenue Down to Gross Profit
06:43 -
Operating Expenses
01:52 -
Handling Depreciation
09:00 -
Completing Income Statement Historical Data Calculation
09:11 -
Introduction to Financial Statement Projection – Income Statement
01:11 -
Forecasting Revenue
12:06 -
Forecasting COGS and Gross Profit
05:59 -
Forecasting Operating Expenses
05:51 -
Forecasting Margins and Dealing with Other Income (Expenses)
09:41 -
Dealing with Tax Forecast and Totalling Net Income
06:05 -
Forecasting EPS and Common Shares Outstanding
04:03
Financial Modeling – The Cashflow Statement
-
Module Outline
00:46 -
Linking Net Income and Depr. and Amort. to Cashflow Statement
03:14 -
Completing Historical Operating Activities
01:00 -
Completing Historical Investing Activities
01:40 -
Completing Historical Financing Activities and Total Cash Change
07:11 -
Forecasting Operating Activities
07:21 -
Forecasting Investing Activities
11:29 -
Forecasting Financing Activities and Total Changes in Cash
02:55
Financial Modeling – Depreciation Schedule
-
Module Outline
00:43 -
Understanding Depreciation in a Company’s Context
07:15 -
Forecasting Depreciation for Existing PP&E
03:31 -
Forecasting Depreciation for CAPEX
06:28 -
Linking Depreciation to Income Statement
01:16 -
Forecasting Deferred Income Taxes
04:17
Financial Modeling – Operating Working Capital Schedule
-
Module Outline
00:48 -
Historical Current Assets and Metrics
06:42 -
Historical Current Liabilities and Metrics
04:45 -
Forecasting Current Assets in OWC
04:28 -
Forecasting Current Liabilities in OWC
04:35 -
Changes in Total Operating Working Capital
07:00 -
Linking OWC Items to Complete Cash flow Statement
06:18
Financial Modeling – The Balance Sheet
-
Module Outline
01:06 -
Dealing with Balance Sheet Projections
04:26 -
Forecasting Cash and cash Equivalents
02:48 -
Forecasting Inventories and Other Asset Items
07:01 -
Forecasting Non-current Assets
05:01 -
Forecasting Current Liabilities
02:19 -
Forecasting Non-Current Liabilities
01:49 -
Balancing the Balance Sheet
05:55
Financial Modeling – Debt Schedule
-
Course Module
02:03 -
Linking Cash, Long-Term Debt, and Long-Term Lease Liabilities
05:18 -
Finding and Calculating Short-Term Debt
06:50 -
Calculating Short-Term Debt and Revolver
06:50 -
Calculating Long-Term Debt
02:48 -
Calculating Long-Term Lease Liabilities Section
03:19 -
Calculating Total Interest Expenses
05:02 -
Calculating Cash Available to Pay Down Debt
08:15 -
Calculating Cash at the end of the year
02:02 -
Calculating Interest Expense
05:38 -
Exploring Cash in Details
03:43 -
Linking Interest Expense and Income
03:53 -
Dealing with Circular Reference
05:21 -
Model Walkthrough and Finalization
11:55
Understanding Company Value
-
Module Outline
01:19 -
Types of Company Value
01:39 -
Company Book Value
00:54 -
Company Market Value
00:44 -
Enterprise Value
02:19 -
Enterprise Value – Illustration
01:55 -
Understanding Enterprise Value with Balance Sheet Formula
06:12 -
Multiples
02:20 -
Choosing Multiples Metrics
06:00 -
Methods of Valuation
00:30 -
Valuation Method- Comparable Company Analysis
01:10 -
Valuation Method – Precedent Transaction Analysis
00:54 -
Valuation Method – Discounted Cashflow Analysis (DCF)
02:19
Company Valuation – Discounted Cash Flow Analysis (DCF)
-
Module Outline
01:42 -
Introduction to DCF Analysis
02:14 -
DCF Analysis – Calculating Present Value
01:08 -
DCF Analysis – Unlevered Free Cash Flow (UFCF)
07:41 -
DCF Analysis – Weighted Average Cost of Capital (WACC) I
02:28 -
DCF Analysis – Weighted Average Cost of Capital (WACC) II
02:24 -
WACC – Cost of Debt and Equity
01:05 -
CAPM – Illustration I
05:11 -
CAPM – Illustration II
02:00 -
CAPM – Beta
02:26 -
CAPM – Cost of Equity
02:32 -
DCF Analysis – Terminal Value
01:01 -
Terminal Value – Multiple Method
00:58 -
Terminal Value – Perpetuity Method
01:23 -
Multiple Vs Perpetuity Method
02:10 -
Varaibles for Unlevered Free Cash Flow (UFCF)
06:05 -
DCF Modeling – Cost of Equity
05:09 -
DCF Modeling – Cost of Debt
02:15 -
DCF Modeling – Weighted Average Cost of Capital
04:56 -
DCF Modeling – Net Present Value
03:57 -
DCF Modeling – EBITDA Method Variables
03:40 -
DCF Modeling – EBITDA Method
02:17 -
DCF Modeling – Perpetuity Method
10:11
Company Valuation – Comparable Company Analysis
-
Module Outline
01:15 -
Obtaining and Identifying Company Comparable (DOWNLOAD ATTACHED FILE)
00:00 -
LTM and Calendarization
01:07 -
Last Twelve Months (LTM)
03:18 -
Calendarization
04:44 -
Obtaining Financial Data for Comps I
12:28 -
Obtaining Financial Data for Comps II
16:59 -
Calculating Comps Company Last Twelve Months (LTM)
12:52 -
Forecasting Income Statement for Comps Analysis
09:48 -
Calculating Enterprise Value for Comps Company
06:52 -
Populating the Operating Statistics for Comps Analysis
03:35 -
Calculating Multiple Values
13:00 -
Calculating Median, High and Low Multiples
04:09
Company Valuation – Precedent Transaction Analysis
-
Module Outline
00:54 -
Obtaining Relevant Precedent Acquisition Transactions
11:00 -
Operating Statistics and Multiples I
08:23 -
Operating Statistics and Multiples II
07:15 -
Precedent Transaction- Calculating Median, High and Low
04:17
Company Valuation – Valuation Summary (Footbal Field Analysis)
-
Module Outline
01:25 -
Football Field Analysis – 52 Week High – Low
09:06 -
Football Field Analysis – Comps (Group 1)
05:35 -
Football Field Analysis – Comps (Group 2)
03:18 -
Football Field Analysis – Comps (Group 3)
02:36 -
Football Field Analysis – Precedent Transactions Analysis
06:23 -
Football Field Analysis – Discounted Cashflow Analysis
11:56 -
Football Field Analysis – Valuation Graph
12:35 -
Course Wrap up
05:05 -
Download Finalized Model Here!
CAPSTONE PROJECT
Please download the Capstone Instruction and adhere strictly to the outlined requirements. The course will be considered complete only upon the submission of your project. To pass the course, you must achieve a minimum score of 60%. Refer to the Capstone Instruction File for the detailed scoring breakdown.
-
Capstone Project
Student Ratings & Reviews
5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
This course has to be the most simplified course on financial modeling and valuation I have seen so far. The tutor took time to explain step by step, and it was so easy to follow through. Best part is you can get feedbacks and ask questions. Superb!