Financial Modeling [2023]: Complete finance course on Excel

سرفصل های دوره

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

1 - Introduction objectives and program

1 - Financial-Modeling-Course-Invest-Prep.pdf

1 - Introduction

2 - Overview and structure of the financial modeling course

3 - Available resources for the course

4 - Why this course is valuable

2 - The basics of financial modeling

5 - Navigating between sessions in the course

6 - What is financial modeling

7 - What is financial modeling used for

8 - How different players in finance can use this skill

3 - Detailed presentation of the Excel model

9 - 02.Invest-Prep-Advanced-case-model-structure.xlsx

9 - Guidelines for the appearance and structure of your model

10 - Transforming your model through simple actions

11 - Adjusting tab layout for improved clarity

12 - Modifying cell formats to enhance the models presentation

13 - Taking a step back from the template approach

14 - 01.Invest-Prep-Advanced-case-blank.xlsx

14 - Creating a clear and userfriendly multiscenario financial model

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

16 - Building the debt tab including debt schedule and interest calculations

17 - The main tab Developing the Business Plan and calculating IRR

18 - The business valuation tab Determining company value

4 - Building the assumptions tab and the basics of a multiscenario model

19 - 01.Invest-Prep-Advanced-case-blank.xlsx

19 - Before starting preparation and necessary steps

20 - Tab structure how to efficiently organize the assumptions tab

21 - The basics of our multiscenario model understanding the concept and its import

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

23 - Debt assumptions for Tranche A specific assumptions regarding debt for Tranche

24 - Debt assumptions for Tranche B specific assumptions regarding debt for Tranche

25 - Multiscenario assumptions how to handle different scenarios in financial model

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

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

28 - First assessment

5 - The business valuation tab

29 - 02.Invest-Prep-Advanced-case-model-structure.xlsx

29 - Study of our comparable companies analyzing the sample of comparables

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

31 - determining the criteria for selecting the most relevant comparables

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

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

6 - Modeling the Sources Uses tab and the debt schedule

34 - Construction of the Sources Uses table

35 - Setting up the debt schedule and necessary calculations

36 - Understanding the calculation of interest on bank debt

37 - Building the model for an amortizing debt tranche 12

38 - Building the model for an amortizing debt tranche 22

39 - Modeling the bullet debt tranche

40 - Creating a comprehensive overview of the bank debt schedule

7 - Construction of the business plan and calculation of the IRR

41 - Top line forecast forecasting the companys revenue

42 - Estimating operating expenses and EBITDA

43 - Determining EBIT and income before tax

44 - Completing and finetuning the projected income statement

45 - Building the cash flow statement for future periods

46 - Analyzing the cash flow statement

47 - Determining the normative EBITDA based on model inputs

48 - Evaluating the net financial debt and leverage ratio

49 - The bridge from Enterprise Value to Equity Value

50 - Determining the CoC multiple and IRR for the investment

51 - Exploring the sensitivity of the IRR to different variables

52 - Adjusting the model to achieve a desired target IRR

53 - Modifying the EBITDA to achieve a specific target IRR

8 - Conclusion and Bonuses

4 - Final Quiz.html

54 - 03.Invest-Prep-Advanced-case-correction.xlsx

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

55 - Additional resources and materials provided as a bonus

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training