Financial Modeling: Complete Finance Course On Excel

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

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

Requirements

Access to Microsoft Excel

Description

If you are interested in finance careers, such as Private Equity, M&A, financial control or financial management, you must have realized that there is a key skill to master in all these finance fields: it's financial modeling.Whether you are building a business plan, a financial reporting, or performing a company valuation, you will need this skill.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.In this training, you will learn about financial modeling standards and the rules to follow to achieve a professional outcome.You will learn how to design a comprehensive financial model with multiple investment scenarios, a debt schedule with multiple financing tranches and varying characteristics, a clear Sources & Uses table, a professional Business Plan, and a company valuation model based on comparable transactions using a normative EBITDA. Finally, we will calculate the IRR and we will sensitize it according to the investment exit parameters.Of course, if you are not yet familiar with all these concepts, we will go over what they refer to before starting the financial modeling on Excel.This course covers essential fundamentals in finance that are necessary to master if you are interested in financial controlling, financial analysis, or transactional careers (PE, M&A, TS).

Overview

Section 1: Introduction: objectives and program

Lecture 1 Introduction

Lecture 2 Overview and structure of the financial modeling course

Lecture 3 Available resources for the course

Lecture 4 Why this course is valuable?

Section 2: The basics of financial modeling

Lecture 5 Navigating between sessions in the course

Lecture 6 What is financial modeling?

Lecture 7 What is financial modeling used for?

Lecture 8 How different players in finance can use this skill?

Section 3: Detailed presentation of the Excel model

Lecture 9 Guidelines for the appearance and structure of your model

Lecture 10 Transforming your model through simple actions

Lecture 11 Adjusting tab layout for improved clarity

Lecture 12 Modifying cell formats to enhance the model's presentation

Lecture 13 Taking a step back from the template approach

Lecture 14 Creating a clear and user-friendly multi-scenario financial model

Lecture 15 Creating a Sources & Uses table to provide an overview of the operation

Lecture 16 Building the debt tab, including debt schedule and interest calculations

Lecture 17 The main tab: Developing the Business Plan and calculating IRR

Lecture 18 The business valuation tab: Determining company value

Section 4: Building the assumptions tab and the basics of a multi-scenario model.

Lecture 19 Before starting: preparation and necessary steps

Lecture 20 Tab structure: how to efficiently organize the assumptions tab

Lecture 21 The basics of our multi-scenario model: understanding the concept and its import

Lecture 22 The first assumptions of the model: initial input and data required for the mode

Lecture 23 Debt assumptions for Tranche A: specific assumptions regarding debt for Tranche

Lecture 24 Debt assumptions for Tranche B: specific assumptions regarding debt for Tranche

Lecture 25 Multi-scenario assumptions: how to handle different scenarios in financial model

Lecture 26 A simple button to change the whole model: tips and tricks to simplify the model

Lecture 27 Other assumptions of the business plan: additional assumptions to consider in th

Lecture 28 First assessment

Section 5: The business valuation tab

Lecture 29 Study of our comparable companies: analyzing the sample of comparables

Lecture 30 Understanding the organization of the tabs related to business valuation

Lecture 31 determining the criteria for selecting the most relevant comparables

Lecture 32 showcasing the valuation results based on the transaction comparables method

Lecture 33 Understanding and choosing the appropriate valuation multiple for the model

Section 6: Modeling the Sources & Uses tab and the debt schedule

Lecture 34 Construction of the Sources & Uses table

Lecture 35 Setting up the debt schedule and necessary calculations

Lecture 36 Understanding the calculation of interest on bank debt

Lecture 37 Building the model for an amortizing debt tranche (1/2)

Lecture 38 Building the model for an amortizing debt tranche (2/2)

Lecture 39 Modeling the "bullet" debt tranche

Lecture 40 Creating a comprehensive overview of the bank debt schedule

Section 7: Construction of the business plan and calculation of the IRR

Lecture 41 Top line forecast: forecasting the company's revenue

Lecture 42 Estimating operating expenses and EBITDA

Lecture 43 Determining EBIT and income before tax

Lecture 44 Completing and fine-tuning the projected income statement

Lecture 45 Building the cash flow statement for future periods

Lecture 46 Analyzing the cash flow statement

Lecture 47 Determining the normative EBITDA based on model inputs

Lecture 48 Evaluating the net financial debt and leverage ratio

Lecture 49 The bridge from Enterprise Value to Equity Value

Lecture 50 Determining the CoC multiple and IRR for the investment

Lecture 51 Exploring the sensitivity of the IRR to different variables

Lecture 52 Adjusting the model to achieve a desired target IRR

Lecture 53 Modifying the EBITDA to achieve a specific target IRR

Section 8: Conclusion and Bonuses

Lecture 54 Conclusion: summarizing the key points covered in this financial modeling course

Lecture 55 Additional resources and materials provided as a bonus

Master of 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,Finance interview candidates 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