This course is open to anyone interested in starting their journey in the field of finance. Financial modeling is a fundamental skill that will benefit every finance enthusiast. Just your drive to be the smartest and coolest person matters!

Business Understanding

Johnnie Walker, Smirnoff, and VAT 69 are just a few of the well-known liquor brands. However, did you realize that they are all owned by United Spirits Limited? So let's take a closer look at the corporation and its alcohol portfolio.

Business Analysis

This episode provides an overview of a specific industry by examining its previous performance, evaluating the existing status, and forecasting future trends. We go over the MOAT, growth drivers, COVID-19's impact, and much more.Start this session now!

Industry Analysis

A cow, a dog, a star, and a question mark stroll into a pub... Does this ring a bell? No? Don't worry!  Because this episode will explain how these seemingly random elements make sense and are crucial to the success of some of the world's most powerful corporations.

Boston Matrix

Companies also require a framework for determining how to prioritize their businesses based on their profitability levels. One of the most pressing matters that companies must address is whether or not they are making the best capital allocation decisions. So, let's get started with the video to learn more about the details and how this framework works.

McKinsey Matrix

It's time to apply everything we've learned to the current company we're discussing. This session will assist you in establishing the discussed frameworks for United Spirits Limited. What exactly are you waiting for? Begin right now!

Boston & McKinsey for USL

Profit and Loss Statement

USL Financial Model - Skeleton

P & L

Balance Sheet Forecasting

Tangible assets are one of the most fundamental asset types on a balance sheet. Using the asset turnover ratio let’s begin forecasting this sheet!

Understanding Tangible Assets

Tangible Assets

Long-term investments that are difficult to convert to cash or are not expected to become cash within an accounting year are categorized as non-current assets. Let’s understand how to forecast non-current assets in this session.

Current assets are short-term assets that are required to meet a company's immediate demands. Begin forecasting current assets now!

Non-Current & Current Assets Forecasting

Liabilities that must be settled within one financial year are referred to as current liabilities. Noncurrent liabilities that are not to be paid off within a single financial year. Delve deeper into the liabilities with this video.

Non-Current & Current Liabilities

Balance Sheet Completion

Cash Flow Statement

The amount of cash created by a company's typical business operations is measured by operating cash flow (OCF). It reveals if a company can create enough positive cash flow to maintain and increase its operations. Check out the episode to know more!

Operating Cash Flow

Interested to know more about the Cash Flow Statements? Well, here we go- Investing cash flows are generated when a company buys or sells long-term assets. Financing cash flows are generated when a company raises capital via debt or equity and repaying debt. This is just the starting point, binge on the episode to know the details!

Financing & Investing Cash Flow

Absolute & Relative Valuation

In order to find intrinsic value of the company, we need to calculate the free cash flow to firm and a discount rate to discount those free cash flows, which will help us in forecasting free cash flows to firm. Start the session now.

Cost of Equity (Sheet)

Cost of Equity

The WACC is an important concept for finance professionals because it is an integral part of the Discounted Cash Flow (DCF) model. So what are you waiting for? Tap the play button and get started with it!

Cost of Capital

Perpetual Growth Rate

To estimate the intrinsic value of a company, you must first estimate its free cash flow, understand what it means, discount it, and then calculate the company's intrinsic value. Let’s begin.

DCF - FCFF

We need to check with other companies in the same industry when we apply relative multiples. So, let's see how USL stacks up against the competition.

Relative Valuation

Risk Management

We’ve prepared three case scenarios - Base case, bear case, and bull case scenarios. Let’s understand how the three scenarios differ from each other. Start now!

Scenario Analysis

We’re depicting various valuation approaches in this session. The chart's name comes from the fact that the bars resemble yard lines on a real football field. Let's delve in!

Football Field Analysis

Relative Valuation - Multiple Industries

This episode goes through various relative valuation matrices used in various industries. We should have different matrices for different industries, but we can always rely on DCF to assess a company's health.

Kunal, the co-founder of Upsurge.club, has a background in equity research and merchant banking, where he played a pivotal role in helping numerous companies raise millions of dollars. Notably, the companies he selected achieved remarkable returns of 8x-10x for the asset management company.Before starting Upsurge.club in 2020, Kunal made a career in equity research & merchant banking. During his stint in the banking industry, he has helped multiple companies raise 20 Million dollars; and while he was working as an equity analyst, his selected companies gave 8-10x returns to the asset management company

Welcome to the "Financial Modeling and Business Valuation" course on Upsurge.club, where you will learn to analyze a company, forecast its financial statements, and estimate its intrinsic value to make an informed investing decision.

Lesson 1, Understanding the Industry & Business, is an introduction to fundamental analysis. You will learn to analyze a company and understand the industry it operates in. You will also learn the Boston Matrix and McKinsey Matrix methods, which will help you in analyzing a company's portfolio of brands.

In lesson 2, Analyzing & Forecasting the Profit & Loss Statement, you will learn to forecast the important line items of the profit and loss statement like the revenue, expenses, operatin margins, etc., using USL as an example. You will also get an Excel financial model template to get started.

In lesson 3, Analyzing & Forecasting the Balance Sheet, you will learn to forecast tangible assets, current and non-current assets, as well as the different types of liabilities. You will also complete forecasting the remaining items of the profit and loss statement.

In lesson 4, Analyzing & Forecasting the Cash Flow Statement, you will use the skills gained from the previous modules and learn to forecast the 3 cash flow statements - operating, investing, and financing. This module concludes oyur financial statement forecasting process.

Lesson 5, Absolute & Relative Valuation, delves into the technique of valuing the shares of a company. You will learn to calculate different assumptions like the cost of equity, cost of capital, and the prepetual growth rate, required to estimate the intrinsic value of a comapny.

Lesson 6, Risk Management, is all about matching our assumptions with reality. You will learn scenario analysis and 'football field analysis', which will help you determine how appropriate your conclusions are.

Lesson 7, Relative Valuation for Multiple Industries, will touch upon the different valuation techniques you can employ while evaluating businesses from different industries. After this concluding module, you will be able to analyze and forecast the financial statements of a company and value it appropriately, depending on the industry it operates in.


Course Highlights:

- Build a comprehensive & dynamic financial model on Excel
- Undertake company analysis and industry analysis using various methods
- Forecast income statement, balance sheet, and cash flow statements
- Estimate the intrinsic value of a company using different techniques

Who is this course for:
 
- Anyone eager to learn financial modeling and valuation to make better investing decisions
- Equity research and investment banking aspirants
- Anyone who is considering a career in the field of finance

Super valuable course with practical knowledge in every video.

Helped me learn about business valuation with all the concepts crystal clear now.

Analyze and forecast the financials of companies from different industries and build their valuation models.