Financial Modeling on Excel Complete finance course on Excel

Name: Financial Modeling on Excel Complete finance course on Excel
Rating: 4.4 (327 reviews)

Financial Modeling practical case and training on Excel - Business Plan, Valuation, and Financial Modeling on Excel

Created byYassine Rochd

Last updated 10/2025

English

What you'll learn

Gain proficiency in the modeling rules followed by investment bankers, private equity professionals, and transaction services consultants
Build a clear, comprehensive, and well-organized financial model in Excel
Acquire a solid foundation in financial modeling fundamentals
Create a complete business plan in Excel
Review the essential and fundamental accounting and corporate finance concepts for financial modeling
Construct a cash flow statement and calculate free cash flows (FCF)
Model financial debt and simulate principal and interest repayments.
Determine the company's Enterprise Value using the comparable method and deduct the Equity Value
Establish a normative EBITDA
Using Excel, calculate the investment multiple and the internal rate of return (IRR) for a transaction

Course content

8 sections • 55 lectures • 3h 25m total length

Introduction2:24
This comprehensive course on financial modeling on Excel will provide you with the knowledge, codes, and best practices to be able to create a clear, well-structured Excel model that meets the expectations of investment banks, Private Equity funds, and financial management teams.
Overview and structure of the financial modeling course2:14
Introductory video: Let's get to know each other before we start the financial modeling.
Available resources for the course2:19
This is the general structure of the course.
We'll look at what financial modeling is. Why it's so important and why finance juniors have such a hard time with these technical subjects.
We'll look at best practices in financial modeling.
Then I'll show you a complete Excel model.
I'll share my screen with you and we'll rebuild the Excel file together. The aim is to guide you step by step as you learn.
With a model of 6 - 7 tabs, you'll have seen the vast majority of modeling topics. I'll show you how to build the model and try to get you involved too, with quizzes at the end of each section.
I'll share tips throughout the videos on how to become a good financial analyst and build the best Excel models.
Why this course is valuable?2:19
Before I get to the heart of the course, I'll summarize in this short video the reasons that led me to build this course.

Navigating between sessions in the course0:50
Feel free to watch some videos at x1.25 or even x1.5 speed if you are familiar with the concepts presented in these first introductory sections. You can return to x1.0 speed when modeling on Excel.
What is financial modeling?1:24
In this video, we'll look at what financial modeling is and why we use Excel rather than any other spreadsheet program.
What is financial modeling used for?0:36
Financial Modeling can serve several purposes:
Represent an operational/accounting/financial situation.
Facilitate decision-making (after studying a situation): (invest, lend) or (sell, buy machines, raw materials, accumulate more stock, raise debt, manage cash flow, etc.).
Simulate and forecast multiple scenarios.
How different players in finance can use this skill?2:56
take a look at how entrepreneurs, business leaders, CFOs, bankers, consultants and private equity or VC investors use financial modeling.
Assessing financial modeling fundamentals

Guidelines for the appearance and structure of your model3:08
In the previous section, I told you that the aim of financial modeling is to use an Excel file to clearly summarize a financial, operational or accounting situation.
In this session, we'll focus on the adverb "clearly" and the rules to follow to get the best Excel model.
Transforming your model through simple actions6:35
In this video, I'm going to show you how, by applying a few of the financial modeling rules I've presented, you can totally transform your income statement and quickly give your Excel document a much more professional look.
Adjusting tab layout for improved clarity6:52
Modifying cell formats to enhance the model's presentation5:06
Taking a step back from the template approach0:47
In the next few videos, I'm going to introduce you to each of the tabs of the financial model before we rebuild them together.
I'm going to present each tab 1 by 1. Their purpose, the role of each tab and an outline of their structure.
Creating a clear and user-friendly multi-scenario financial model1:50
Here we'll see how to structure our assumptions tab and, above all, how to create a multi-scenario Excel model with a single button.
Creating a Sources & Uses table to provide an overview of the operation0:54
Building the debt tab, including debt schedule and interest calculations1:19
This Excel tab alone is worth a course in financial modeling.
In our model, I gave you 2 debt tranches to practice with, and obviously, each of these tranches will have different characteristics.
The main tab: Developing the Business Plan and calculating IRR1:49
The Business Plan is a document (generally designed on Excel or Google sheet) that presents the company's financial forecasts over 3 to 5 years. Let's see how to build it.
The business valuation tab: Determining company value0:28
The company valuation tab will enable us to set the EBITDA multiple at which we will buy our company. We'll see in detail how this list of companies and the company's EBITDA will enable us to value our target.
Assessing modeling standards

Before starting: preparation and necessary steps1:07
Tab structure: how to efficiently organize the assumptions tab7:43
The basics of our multi-scenario model: understanding the concept and its import3:01
The multi-scenario model, a must-have for finance and controlling models.
The first assumptions of the model: initial input and data required4:45
Here we complete the assumptions in our Excel file.
Debt assumptions for Tranche A: specific assumptions regarding debt for TrancheA4:42
Let's fill in the bank credit assumptions.
Debt assumptions for Tranche B: specific assumptions regarding debt for TrancheB2:02
Multi-scenario assumptions: how to handle different scenarios in financial model5:38
A simple button to change the whole model: tips and tricks to simplify the model2:05
Here's how to create a dynamic Excel template. A single button changes the entire template.
Other assumptions of the business plan: additional assumptions to consider6:14
First assessment1:14
Applying the concepts and skills learned in the previous sections

Study of our comparable companies: analyzing the sample of comparables1:49
Understanding the organization of the tabs related to business valuation4:30
We turn to our company valuation tab and commence our financial valuation process. In doing this, we pay attention to the pitfalls that must be avoided.
determining the criteria for selecting the most relevant comparables9:27
How do you choose the best comparables for a company valuation exercise? That's what we'll be looking at in this video from the Financial Modeling course.
showcasing the valuation results based on the transaction comparables method9:15
Here we'll finish the exercise and see how to clearly present our company valuation.
Understanding and choosing the appropriate valuation multiple for the model6:59

Construction of the Sources & Uses table6:09
Let's build the Sources and Uses tab of our Excel model.
Setting up the debt schedule and necessary calculations4:17
Understanding the calculation of interest on bank debt5:37
Before modeling our debt, let's see how to calculate bank interest.
Building the model for an amortizing debt tranche (1/2)6:07
Let's model our first tranche of bank debt: the amortizing tranche.
Building the model for an amortizing debt tranche (2/2)2:59
Let's model our first tranche of bank debt: the amortizing tranche.
Modeling the "bullet" debt tranche2:59
let's model our second tranche of bank debt: the bullet tranche.
Creating a comprehensive overview of the bank debt schedule2:44
Let's build the bank debt summary table.

Top line forecast: forecasting the company's revenue2:35
We begin the financial modeling of the main tab: the Business Plan tab.
Estimating operating expenses and EBITDA3:21
We continue modeling the income statement, tackling operating expenses up to EBITDA.
Determining EBIT and income before tax3:08
We continue with D&A, EBIT and pre-tax income.
Completing and fine-tuning the projected income statement5:13
Here we see how to model corporate income tax. The P&L is completed by arriving at net income.
Building the cash flow statement for future periods5:29
Financial modeling in Excel with the cash flow statement.
Analyzing the cash flow statement3:43
Financial Analysis Video: We step back to examine this crucial financial statement. How can we analyze and interpret the cash flow statement?
Determining the normative EBITDA based on model inputs6:11
Let's calculate normative EBITDA and see how useful it is.
Evaluating the net financial debt and leverage ratio2:55
We now calculate the net financial debt. We'll then see how it can be used to obtain the Equity Value.
The bridge from Enterprise Value to Equity Value3:49
In this video, I show you how to move from Enterprise Value to Equity Value.
Determining the CoC multiple and IRR for the investment4:16
We're nearing the end of our Excel model. Here we calculate our investment performance indicators, in particular the IRR.
Exploring the sensitivity of the IRR to different variables4:14
After calculating our IRR, we sensitize it according to 2 major parameters of our exit valuation.
Adjusting the model to achieve a desired target IRR5:38
Let's move on to the next questions to see more Excel financial modeling techniques and tips.
Modifying the EBITDA to achieve a specific target IRR3:29
Final modeling video to conclude the model.

Requirements

Access to Microsoft Excel

Description

If you are interested in finance careers, such as Private Equity, M&A, financial controling or financial management, you've likely realized that one key skill is indispensable across all these finance fields: it's financial modeling.

Financial modeling is the cornerstone of finance, underpinning essential tasks such as developing Business Plans, generating reports in Excel, and valuing companies. The ability to create reliable and well-structured financial models is therefore crucial if you aim to pursue a career in corporate finance.

This is why many job interviews include technical cases on Excel. Within 30 minutes to an hour, employers can assess candidates by providing them with a computer and specific instructions, effectively identifying the top 10% who excel in financial modeling.

This comprehensive finance course on Excel will provide you with the knowledge, techniques, and best practices to create clear, well-structured models that meet the high standards of investment banks, Private Equity firms and financial management teams.

In this training, you will learn the standards and rules of financial modeling to produce professional, rigorous, optimized, and error-free outputs. You will be guided through designing a complete financial model with various investment and development scenarios for a company, including a debt schedule with multiple financing tranches, a Sources and Uses table, a clear Business Plan, and valuation using the transaction comparables method based on a normative EBITDA. Finally, we will calculate the IRR and analyze it according to investment exit parameters.

If these concepts are unfamiliar to you, we will cover them before diving into financial modeling in Excel. This course revisits essential finance fundamentals and the necessary knowledge you must master if you are interested in financial controlling, financial analysis, or transactional careers (PE, M&A, TS).

Instructor Introduction:

My name is Yassine, and I am the founder of a corporate finance training organization that has helped thousands of students and recent graduates prepare for interviews in Private Equity, investment banking, and consulting firms in Transaction Services, Valuation, and Financial Restructuring.

I am also a former Associate in Private Equity, having worked for two years in two different investment funds in Paris on small-cap operations across various sectors, including hospitality and real estate, tech and media, and renewable energy.

Additionally, I was a senior consultant in Valuation and Financial Modeling at EY, where I worked on multiple financial models in transactional contexts and investment projects.

Who this course is for:

Finance students who are interested in highly competitive areas of corporate finance such as Private Equity, Venture Capital, M&A, Leveraged Finance, ECM, Transaction Services, Restructuring, Valuation, and, of course, financial modeling
Candidates for an interview in finance who want to practice and prepare for Excel-based financial modeling cases
Corporate finance interns seeking to enhance their skills in finance, financial modeling and Excel
Junior analysts in corporate finance
Senior finance analysts who aim to enhance their proficiency in financial modeling using Excel

Financial Modeling on Excel Complete finance course on Excel

What you'll learn

Explore related topics

Course content

Introduction: objectives and program4 lectures • 9min

The basics of financial modeling4 lectures • 6min

Detailed presentation of the Excel model10 lectures • 29min

Building the assumptions tab and the basics of a multi-scenario model.10 lectures • 39min

The business valuation tab5 lectures • 32min

Modeling the Sources & Uses tab and the debt schedule7 lectures • 31min

Construction of the business plan and calculation of the IRR13 lectures • 54min

Conclusion and Bonuses2 lectures • 7min

Requirements

Description

Who this course is for: