1 Introduction (45.79 MB)
2 Overview and structure of the financial modeling course (22.61 MB)
3 Available resources for the course (22.32 MB)
4 Why this course is valuable (24.17 MB)
5 Navigating between sessions in the course (8.25 MB)
6 What is financial modeling (13.93 MB)
7 What is financial modeling used for (6.04 MB)
8 How different players in finance can use this skill (29.75 MB)
10 Transforming your model through simple actions (86.39 MB)
11 Adjusting tab layout for improved clarity (85.9 MB)
12 Modifying cell formats to enhance the model's presentation (64.89 MB)
13 Taking a step back from the template approach (15.76 MB)
14 Creating a clear and user-friendly multi-scenario financial model (17.88 MB)
15 Creating a Sources & Uses table to provide an overview of the operation (8.14 MB)
16 Building the debt tab, including debt schedule and interest calculations (13.07 MB)
17 The main tab Developing the Business Plan and calculating IRR (19.17 MB)
18 The business valuation tab Determining company value (5.35 MB)
9 Guidelines for the appearance and structure of your model (38.59 MB)
19 Before starting preparation and necessary steps (14.83 MB)
20 Tab structure how to efficiently organize the assumptions tab (62.34 MB)
22 The first assumptions of the model initial input and data required (66.26 MB)
27 Other assumptions of the business plan additional assumptions to consider (90.73 MB)
28 First assessment (15 MB)
29 Study of our comparable companies analyzing the sample of comparables (22.92 MB)
30 Understanding the organization of the tabs related to business valuation (52.6 MB)
31 determining the criteria for selecting the most relevant comparables (115.13 MB)
32 showcasing the valuation results based on the transaction comparables method (117.71 MB)
33 Understanding and choosing the appropriate valuation multiple for the model (89.93 MB)
34 Construction of the Sources & Uses table (59.01 MB)
35 Setting up the debt schedule and necessary calculations (41.36 MB)
36 Understanding the calculation of interest on bank debt (56.53 MB)
37 Building the model for an amortizing debt tranche (12) (61.56 MB)
38 Building the model for an amortizing debt tranche (22) (30.7 MB)
39 Modeling the bullet debt tranche (28.74 MB)
40 Creating a comprehensive overview of the bank debt schedule (27.29 MB)
41 Top line forecast forecasting the company's revenue (32 MB)
42 Estimating operating expenses and EBITDA (43.18 MB)
43 Determining EBIT and income before tax (41.3 MB)
44 Completing and fine-tuning the projected income statement (71.75 MB)
45 Building the cash flow statement for future periods (78.36 MB)
46 Analyzing the cash flow statement (51.65 MB)
47 Determining the normative EBITDA based on model inputs (93.81 MB)
48 Evaluating the net financial debt and leverage ratio (39.33 MB)
49 The bridge from Enterprise Value to Equity Value (41.89 MB)
50 Determining the CoC multiple and IRR for the investment (41.11 MB)
51 Exploring the sensitivity of the IRR to different variables (42.15 MB)
52 Adjusting the model to achieve a desired target IRR (65.32 MB)
53 Modifying the EBITDA to achieve a specific target IRR (36.31 MB)
54 Conclusion summarizing the key points covered in this financial modeling course (118.76 MB)
55 Additional resources (28.16 MB)