Financial Modeling & Business Valuation Masterclass
Published 3/2026
Created by Upsurge Club
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Expert | Genre: eLearning | Language: English | Duration: 23 Lectures ( 4h 46m ) | Size: 4.6 GB
Build Excel models, forecast financials, and calculate intrinsic value step by step
What you'll learn
✓ Understand how to analyze a company and its industry using structured frameworks
✓ Learn to apply tools like Boston Matrix and McKinsey Matrix for business analysis
✓ Build and forecast the Profit & Loss statement, including revenue, expenses, and margins
✓ Analyse and forecast the Balance Sheet, including assets and liabilities
✓ Prepare and forecast the Cash Flow Statement (operating, investing, and financing)
✓ Build a dynamic financial model in Excel for company analysis
✓ Learn absolute valuation methods such as intrinsic value calculation
✓ Learn absolute valuation methods such as intrinsic value calculation
Requirements
● Basic understanding of the stock market and financial concepts
● Familiarity with accounting terms (P&L, Balance Sheet, Cash Flow) is helpful but not mandatory
Description
In this course, you will learn how to analyze a company from the ground up, understand its industry, and evaluate its competitive position. You will be introduced to powerful frameworks like the Boston Matrix and McKinsey Matrix, which help you assess business segments and growth potential.
The course then takes you step by step through building a complete financial model in Excel. You will learn how to forecast the Profit & Loss statement, including revenue, expenses, and margins, followed by the Balance Sheet, where you will project assets and liabilities. You will also learn to build and forecast the Cash Flow Statement, completing a full three-statement financial model.
Once your financial model is ready, you will move into business valuation techniques. You will learn how to estimate the intrinsic value of a company using key assumptions such as cost of equity, cost of capital, and growth rates. The course also covers relative valuation methods, helping you compare companies across industries.
To make your analysis more robust, you will learn risk management techniques such as scenario analysis and football field analysis, allowing you to test your assumptions and understand different valuation outcomes.
Throughout the course, concepts are explained using real-world examples, and you will receive an Excel financial model template to apply your learning practically.
By the end of this course, you will have a clear framework to analyze companies, forecast financial statements, and value businesses with confidence.
Who this course is for
■ Students and beginners who want to learn financial modeling from scratch
■ Investors looking to understand company valuation and intrinsic value
■ Finance professionals aiming to improve their valuation and analysis skills
■ Individuals interested in fundamental analysis and long-term investing
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
