Financial Modeling Complete Finance Course On Excel

Published 5/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.48 GB | Duration: 3h 24m
Financial Modeling practical case and training on Excel – Business Plan, Valuation, and Financial Modeling on Excel

Free Download 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

Homepage

https://www.udemy.com/course/financial-modeling-complete-finance-course-on-excel/