1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!

  1. What does the course cover.vtt

  2. Bonus! Welcome gift.html

  4. The approach to take this course.mp4

  5. Download all course materials.html

 10. Case Study - Building an FMCG Model from Scratch

  1. Introduction to the Case Study.vtt

  10. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4

  10.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx

  11. This is how the report can be used in practice by high-level executives.vtt

  12. Dynamic reporting with GETPIVOTDATA and slicers.html

  2. Preliminary mapping of the data extraction.vtt

  3. Working with an SAP data extraction.mp4

  4. Creating an output structure of the FMCG model.mp4

  4.1 2. Exercise - Build an FMCG Model_Structure.xlsx.xlsx

  5. Improving the layout and appearance of the FMCG report.vtt

  6. Inserting formulas and automating calculations.mp4

  6.1 4. Exercise - Build an FMCG Model_Adding Calculations.xlsx.xlsx

  7. Creating a Master Pivot Table The main data source for the FMCG report.vtt

  8. GetPivotData is great! Extracting data from the Master Pivot Table.mp4

  8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA.xlsx.xlsx

  9. Combining Slicers and GetPivotData The key to our success.vtt

 11. Financial Modeling Fundamentals

  1. Financial Modeling basics - Welcome lecture.vtt

  11. Building a complete model - Important considerations.mp4

  12. Modeling the Income statement.mp4

  13. Modeling the Balance sheet - Part 1.mp4

  14. Modeling the Balance sheet - Part 2.mp4

  15. Building a financial model - Quiz.html

  2. What is a financial model.vtt

  3. Why use financial models.vtt

  4. Financial modeling - worst practices - things you should avoid.vtt

  5. Financial modeling - best practices.vtt

  6. Financial modeling - The types of models that are built in practice.vtt

  8. Financial modeling The right level of detail in a model.mp4

  9. Financial modeling Forecasting guidelines.mp4

 12. Introduction to Company Valuation

 13. Introduction to Mergers & Acquisitions

 14. Learn how to build a Discounted Cash Flow model in Excel

  1. Valuation Case study - Welcome lecture.vtt

  10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt

  10.2 9. Interest expenses, Extraordinary items and Taxes – Unsolved.xlsm.xlsm

  11. Forecasting Balance Sheet items.vtt

  11.2 10. Project BS items – Unsolved.xlsm.xlsm

  12. An introduction to the Days methodology.vtt

  13. Calculation of DSO, DPO and DOI for the historical period.mp4

  13.1 12. Calculating DSO, DPO and DIO - Solved.xlsm.xlsm

  14. Forecasting DSO, DPO and DOI.mp4

  14.1 13. Forecasting DSO, DPO and DIO - Solved.xlsm.xlsm

  15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4

  15.1 14. Forecasting PP&E, Other assets and Other liabilities - Unsolved.xlsm.xlsm

  16. Creating an output P&L sheet.mp4

  16.1 15. P&L structure - Solved.xlsm.xlsm

  17. Populating the output P&L sheet.mp4

  17.1 16. Populating the P&L sheet - Solved.xlsm.xlsm

  18. Populating the output BS sheet.mp4

  18.1 17. Populating the Balance sheet – Unsolved.xlsm.xlsm

  19. Completing the output BS sheet for the historical period.mp4

  19.1 18. Completing the BS items - Solved.xlsm.xlsm

  2. Introduction to the DCF exercise.mp4

  20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4

  20.1 19. Building a Cash Flow Format – Solved.xlsm.xlsm

  21. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4

  21.1 20. From UFCF to Net Cash Flow – Solved.xlsm.xlsm

  22. Calculating Unlevered Free Cash Flow.mp4

  22.1 21. Calculating UFCF - Unsolved.xlsm.xlsm

  23. Calculating Net Cash Flow.mp4

  23.1 Cash Flow Classification By Activities.xlsx

  23.3 22. From UFCF to Net Cash Flow - Solved.xlsm.xlsm

  24. Obtaining the rest of the cash flows through Find and Replace.vtt

  24.2 23. Use Find and Replace - Solved.xlsm.xlsm

  25. Introducing Weighted Average Cost of Capital and Perpetuity Growth.vtt

  25.2 24. Introducing WACC and g - Solved.xlsm.xlsm

  26. Discounting Unlevered Free Cash Flows to obtain their Present Value.vtt

  26.2 25. Calculating PV of Cash Flows - Solved.xlsm.xlsm

  27. Calculating Continuing Value and Enterprise Value of the business.vtt

  27.2 26. Calculating CV of the business - Unsolved.xlsm.xlsm

  28. Calculating Equity Value.vtt

  28.2 27. Calculating Equity Value - Solved.xlsm.xlsm

  29. Sensitivity analysis for WACC and perpetuity growth.vtt

  29.2 Sensitivity Analysis.xlsx

  3. The various stages of a complete DCF Valuation.mp4

  3.1 Valuation exercise.pdf.pdf

  30. A possible application of Goal Seek.vtt

  30.2 29. Goal seek - Solved.xlsm.xlsm

  31. Using charts to summarize the results of the DCF model.vtt

  31.2 30. Charts - Solved.xlsm.xlsm

  32. You Made It!.vtt

  4. Description of the structure of the DCF model.vtt

  4.2 3. Beginning of exercise.xlsm.xlsm

  5. A glimpse at the company we are valuing - Cheeseco.vtt

  6. Modeling the top line.mp4

  6.1 5. Modeling revenues - Solved.xlsm.xlsm

  7. Introducing scenarios to the model with Choose.mp4

  7.1 6. Choose - Solved.xlsm.xlsm

  8. Modeling other items Other revenues and Cogs.mp4

  8.1 7. Modeling Cogs – Unsolved.xlsm.xlsm

  9. Modeling other items Operating expenses and D&A.mp4

  9.1 8. Opex and D&A - Solved.xlsm.xlsm

 15. Tesla valuation - Complete practical exercise

  1. Organizing external inputs in a 'Drivers' sheet.vtt

  1.2 0a. Drivers_after.xlsx.xlsx

  10. Forecasting 'energy' and 'services' revenue.vtt

  10.2 6. Energy and Other revenue - Before.xlsx.xlsx

  11. Calculating 'energy' and 'services' gross profit and cost of sales.vtt

  11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx

  12. Forecasting operating expenses.vtt

  12.2 8. Opex - After.xlsx.xlsx

  13. Building a fixed asset roll forward estimating Capex.vtt

  13.2 9. PP&E forecasting and comparables_before.xlsx.xlsx

  14. Building a fixed asset roll forward D&A schedule.vtt

  14.2 10. PP&E schedule_after.xlsx.xlsx

  15. Peer comparison D&A as a percentage of revenues.vtt

  16. Calculating DSO, DIO, DPO.mp4

  16.1 11. Working capital forecasting_after.xlsx.xlsx

  17. Producing a clean P&L output sheet.mp4

  17.1 12. P&L.xlsx.xlsx

  18. Fill in the P&L output sheet.vtt

  18.2 12a. P&L fill in_after.xlsx.xlsx

  19. Calculating investments in working capital.vtt

  19.2 13. Calculating working capital_after.xlsx.xlsx

  2. The input data we will work with.vtt

  2.2 0aa. Inputs_before.xlsx.xlsx

  20. Forecasting Unlevered Free Cash Flow.vtt

  20.2 14. Cash flow - UFCF_after.xlsx.xlsx

  21. Forecasting other assets.vtt

  21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx

  22. Forecasting other liabilities.vtt

  22.2 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx

  23. Completing Unlevered Free Cash Flow.vtt

  23.2 16a. Complete UFCF_before.xlsx.xlsx

  24. Modeling Tesla's financing needs in the forecast period.vtt

  24.2 17. Financing_before.xlsx.xlsx

  25. Calculating Net income.vtt

  25.2 18. P&L complete_after.xlsx.xlsx

  26. Bridging Unlevered Free Cash Flow to Net Cash Flow.vtt

  26.2 19. Cash flow_complete_after.xlsx.xlsx

  27. Balancing the Balance sheet.vtt

  27.2 20. Complete the BS_after.xlsx.xlsx

  28. Estimating Weighted Average Cost of Capital (WACC).vtt

  28.2 21. WACC_before.xlsx.xlsx

  29. Performing Discounted Cash Flow valuation (DCF).vtt

  29.2 22. DCF_after.xlsx.xlsx

  3. Forecasting Tesla's expected deliveries.vtt

  3.2 1. Deliveries_after.xlsx.xlsx

  30. Calculating enterprise value, equity value, and price per share.vtt

  30.2 23. EV, Equity value, Price per share_before.xlsx.xlsx

  31. Final comments.vtt

  4. Comparing delivery figures with the ones of industry peers.vtt

  5. Estimating an average selling price of Tesla vehicles.mp4

  5.1 2. Average price_after.xlsx.xlsx

  6. Calculating automotive revenue.mp4

  6.1 3. Revenue calculation and scenarios - after.xlsx.xlsx

  7. Peer comparison Gross profit %.mp4

  7.1 4. Gross profit automotive.xlsx.xlsx

  8. Calculating automotive gross profit.vtt

  8.2 4a. Gross profit automotive - before.xlsx.xlsx

  9. Calculating automotive cost of sales.vtt

 16. Capital budgeting - The theory

  1. Introduction to Capital budgeting.vtt

  2. Why we need Capital budgeting.vtt

  3. The time value of money.vtt

  4. Calculating future and present Value.vtt

  5. Calculating cost of equity.vtt

  6. Coming up with project-specific beta.vtt

  7. Weighted Average Cost of Capital (WACC).vtt

  8. The type of cash flows we will have in a project.vtt

  9. Estimating the project's cash flows.vtt

 17. Capital Budgeting - A Complete Case Study

  1. Introduction to the Capital Budgeting exercise.vtt

  10. Finding cost of equity.vtt

  10.2 8. WACC.xlsx.xlsx

  11. Discounting the project's cash flows and residual value.vtt

  11.2 9. Discounted cash flow_unsolved.xlsx.xlsx

  12. Performing sensitivity analysis and completing the exercise.vtt

  12.2 10. Sensitivty analysis.xlsx.xlsx

  14. Congratulations!!.mp4

  2. Organizing an Inputs sheet.mp4

  2.1 1. Drivers.xlsx.xlsx

  3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.vtt

  3.2 2. Savings Forecast.xlsx.xlsx

  4. Fixed asset rollforward.vtt

  4.2 3. Fixed Asset Rollforward.xlsx.xlsx

  5. The impact of working capital.vtt

  5.2 4. Working Capital_unsolved.xlsx.xlsx

  6. Modeling debt financing.vtt

  6.2 5. Financing_unsolved.xlsx.xlsx

  7. Adding a P&L sheet.vtt

  7.2 6. P&L.xlsx.xlsx

  8. Calculating project cash flows.vtt

  8.2 7. Cash flow.xlsx.xlsx

  9. Estimating the weighted average cost of capital (WACC).vtt

  9.2 8. WACC_unsolved.xlsx.xlsx

 18. Bonus lecture

 2. Introduction to Excel

  1. Introduction to Excel - welcome lecture.vtt

  11. Introduction to Excel functions.mp4

  11.1 02 12 Functions Exercise & Text.xlsx.xlsx

  11.3 02 12 Functions Solved.xlsx.xlsx

  12. Cut, copy, & paste.mp4

  12.1 02 13 Copy Cut Paste Exercise Text.xlsx.xlsx

  13. Cut, copy, & paste.html

  14. Paste special.vtt

  14.2 02 14 Paste Special Solved.xlsx.xlsx

  2. Overview of Excel.mp4

  2.1 02 6 Overview of Excel Exercise & Text.xlsx.xlsx

  3. Overview of Excel.html

  4. Basic manipulations with rows and columns.vtt

  4.2 02 7 Basic Manipulations Solved.xlsx.xlsx

  6. The Excel ribbon.mp4

  6.1 02 8 The Ribbon Solved.xlsx.xlsx

  7. Data entry in Excel.mp4

  7.1 02 9 Data Entry Exercise Text.xlsx.xlsx

  8. Introduction to formatting.mp4

  8.1 Formatting - Solved.xlsx.xlsx

  8.3 02 10 Formatting Exercise Text.xlsx.xlsx

  9. Introduction to Excel formulas.mp4

  9.1 Formulas – Unsolved.xlsx.xlsx

  9.3 02 11 Formulas Exercise Text.xlsx.xlsx

 3. Useful tips and tools for your work in Excel

  1. Excel best practices - Welcome lecture.vtt

  10. Learn how to use the Wrap Text button.vtt

  10.2 03 22 Wrap Text Exercise & Text.xlsx.xlsx

  10.4 Wrap text – Unsolved.xlsx.xlsx

  11. Create easily printable documents in Excel by using Set Print Area.mp4

  11.1 Useful Tips & Tools PDF Version.pdf

  11.3 Set Print Area - Solved.xlsx.xlsx

  12. Find and select special types of cells with Select Special (F5).vtt

  12.2 03 24 Select Special (F5) Solved.xlsx.xlsx

  12.4 Select Special.xlsx.xlsx

  14. Learn how to assign dynamic names within a financial model.mp4

  14.1 03 25 Assigning Dynamic Names Exercise & Text.xlsx.xlsx

  14.3 Dynamic Naming - Solved.xlsx.xlsx

  14.5 03 25 Assigning Dynamic Names Solved.xlsx.xlsx

  16. Define a named range in Excel.mp4

  16.1 Naming ranges - Solved.xlsx.xlsx

  16.3 Useful Tips & Tools PDF Version.pdf

  16.5 03 26 Defining a Named Range Exercise & Text.xlsx.xlsx

  17. Assign custom formats to specific cells within a financial model (e.g Multiples).vtt

  17.2 03 27 Assigning Custom Formats Solved.xlsx.xlsx

  18. Macros are a great timesaver! Here's why!.mp4

  18.1 03 28 Macros Solved.xlsx.xlsx

  18.3 Creating a Macro - Unsolved.xlsx.xlsx

  18.5 Useful Tips & Tools PDF Version.pdf

  2. Initial formatting of an Excel sheet to render it professional.mp4

  2.1 Formatting a worksheet – Unsolved.xlsx.xlsx

  2.3 03 17 Formatting a Worksheet Exercise & Text.xlsx.xlsx

  2.5 03 17 Formatting a Worksheet Solved.xlsx.xlsx

  20. Create a drop-down list by using Data Validation.vtt

  20.2 03 29 Drop-down List Solved.xlsx.xlsx

  20.4 Data Validation – Unsolved.xlsx.xlsx

  21. Using Custom-sort in order to sort multiple columns within a table.mp4

  21.1 03 30 Custom Sort Solved.xlsx.xlsx

  21.3 03 30 Custom Sort Exercise & Text.xlsx.xlsx

  21.5 Sort data – Unsolved.xlsx.xlsx

  22. Create a great Index page at the beginning of your models - Hyperlinks.vtt

  22.2 Useful Tips And Tools Excel File.xlsx

  22.4 03 31 Hyperlinks Solved.xlsx.xlsx

  23. Fix the top row of your table with Freeze Panes.vtt

  23.2 Freeze Panes – Unsolved.xlsx.xlsx

  24. Filter by color - an excellent tool.mp4

  24.1 Exercise_Filter by Color.xlsx.xlsx

  25. Working with conditional formatting.mp4

  25.1 Exercise_Conditional Formatting.xlsx.xlsx

  26. Useful tips and tools for your work in Excel - quiz.html

  3. Fast scrolling through Excel sheets.vtt

  3.2 Useful tips and tools - Excel file.xlsx.xlsx

  3.4 Useful Tips & Tools PDF Version.pdf

  4. Fast scrolling through Excel sheets.html

  5. Introduction to fixing of cell references.vtt

  5.2 Fixing references - Solved.xlsx.xlsx

  5.4 03 19 Fixing Cells Solved.xlsx.xlsx

  6. Introduction to fixing of cell references.html

  7. Using the 'Alt + Enter' combination.vtt

  7.2 Useful Tips & Tools PDF Version.pdf

  7.4 03 20 Alt+Enter Exercise & Text.xlsx.xlsx

  8. Learn how to organize your data with Text to Columns.mp4

  8.1 Useful Tips & Tools PDF Version.pdf

  8.3 03 21 Text to Columns Exercise & Text.xlsx.xlsx

  8.5 Text to columns - Solved.xlsx.xlsx

 4. Keyboard shortcuts in Excel

  1. Keyboard shortcuts Save LOTS of time in Excel.vtt

 5. Excel's key functions and functionalities made easy

  1. Excel's key functions - Welcome lecture.vtt

  10. Include Round in your financial models.vtt

  10.2 Key Functions In Excel.pdf

  10.4 05 42 Round Solved.xlsx.xlsx

  11. Learn how to transfer data efficiently in Excel Vlookup and Hlookup.vtt

  11.2 05 43 Vlookup, Hlookup Solved.xlsx.xlsx

  11.4 Vlookup, Hlookup - Unsolved.xlsx.xlsx

  12. Index, Match and their combination - the perfect substitute for Vlookup.mp4

  12.1 Solution_Index; Match; Index and Match.xlsx.xlsx

  12.3 Index & Match – Solved.xlsx.xlsx

  12.5 Key Functions In Excel.pdf

  12.7 05 44 Index, Match Exercise & Text.xlsx.xlsx

  13. A great Excel technique Index, Match, Match.vtt

  13.2 Solution_Index, Match, Match.xlsx.xlsx

  15. Using Excel's Iferror function to trap spreadsheet errors.mp4

  15.1 Iferror.xlsx.xlsx

  15.3 05 45 IFERROR Exercise & Text.xlsx.xlsx

  15.5 Iferror – Unsolved.xlsx.xlsx

  16. Learn how to render your models flexible with Choose.vtt

  16.2 Choose – Unsolved.xlsx.xlsx

  16.4 Choose - Solved.xlsx.xlsx

  17. Use Goal Seek to find the result that you are looking for.mp4

  17.1 Goal Seek – Unsolved.xlsx.xlsx

  17.3 Goal Seek - Solved.xlsx.xlsx

  17.5 05 47 Goal Seek Solved.xlsx.xlsx

  19. Include sensitivity analysis in your models through Data Tables.mp4

  19.1 Data Tables – Unsolved.xlsx.xlsx

  19.3 05 48 Sensitivity Analysis Solved.xlsx.xlsx

  19.5 05 48 Sensitivity Analysis Exercise & Text.xlsx.xlsx

  20. Include sensitivity analysis in your models through Data Tables.html

  21. Excel's dynamic and interactive tables Pivot tables.vtt

  21.2 05 49 Pivot Tables Intro Exercise & Text.xlsx.xlsx

  21.4 05 49 Pivot Tables Intro Solved.xlsx.xlsx

  22. Excel's key functions and functionalities made easy.html

  3. Key Excel functions Sum, Sumif and Sumifs.vtt

  3.2 Key Functions In Excel.pdf

  3.4 Sum, Sumif, Sumifs – Solved.xlsx.xlsx

  4. Key Excel functions Count, Counta, Countif, Countifs.mp4

  4.1 05-38-Counts-Solved.xlsx.xlsx

  4.3 05 38 Counts Exercise & Text.xlsx.xlsx

  4.5 Key Functions In Excel.pdf

  5. Key Excel functions Average and Averageif.vtt

  5.2 05 39 Average, AverageIF Exercise & Text.xlsx.xlsx

  5.4 05 39 Average, AverageIF Solution.xlsx.xlsx

  7. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.mp4

  7.1 Key Functions In Excel.pdf

  7.3 Text Functions - Unsolved.xlsx.xlsx

  7.5 05 40 2 Left, Right etc Solved.xlsx.xlsx

  9. Find the minimum or maximum value in a range of cells in Excel.mp4

  9.1 Max, min – Solved.xlsx.xlsx

  9.3 05 41 MIN MAX Solved.xlsx.xlsx

 6. Update! 15 December - Exercise

  2. Exercise - Excel's Sumifs function - solved & explained.mp4

  2.1 Exercise Sumifs With Solutions.xlsx

 7. Financial functions in Excel

  1. Future and present values in Excel.vtt

  2. Calculating the rate of return of an investment with the IRR function.vtt

  2.2 05 14 IRR.xlsx.xlsx

  3. Calculating a complete loan schedule in Excel.mp4

  3.1 Solution-Loan-Schedule.xlsx.xlsx

  3.3 Exercise-Loan-Schedule.xlsx.xlsx

  4. Date functions in Excel.vtt

  4.2 Solution-Date-Functions (2).xlsx.xlsx

  4.4 05 16 Date Functions.xlsx.xlsx

 8. Microsoft Excel's Pivot Tables in Depth

  1. Introduction to Pivot Tables and the way they are applied.vtt

  2. Creating Pivot Tables easily!.vtt

  3. Give your Excel Pivot Tables a makeover.mp4

  3.1 3. Formatting a Pivot Table.xlsx.xlsx

  4. Modifying and pivoting fields to obtain the Pivot Table you need.vtt

  5. Learn more about GetPivotData - A very important Excel function.mp4

  5.1 5. GetPivotData.xlsx.xlsx

  6. An introduction to slicers - The modern-day Pivot Table filters.vtt

  6.2 Database - Pivot & Slicers.xlsm.xlsm

 9. Case study - Building a complete P&L from scratch in Excel

  1. Case study - Build a P&L from scratch - Welcome lecture.vtt

  10. Use Index & Match as a substitute for Vlookup.vtt

  10.2 9. Index & Match - Solved.xlsx.xlsx

  11. Mapping the rows in the Database sheet.vtt

  11.2 10. Mapping - Unsolved.xlsx.xlsx

  12. Building the structure of the P&L sheet.vtt

  12.2 11. Building a P&L - Solved.xlsx.xlsx

  13. Formatting sets You apart from the competition in Excel - A Practical Example.vtt

  13.2 12. Formatting the P&L - Unsolved.xlsx.xlsx

  14. Populate the P&L sheet with Sumif.vtt

  14.2 13. Populating the P&L sheet - Unsolved.xlsx.xlsx

  15. Learn how to find mistakes with Countif.vtt

  15.2 14. Countif - Unsolved.xlsm.xlsm

  16. Calculating year-on-year percentage variations the proper way.vtt

  16.2 15. Adding % variations - Solved.xlsx.xlsx

  17. Create professional and good-looking charts - Introduction.vtt

  18. Build a Column Stacked chart with a secondary line axis in Excel.vtt

  18.2 Case Study Building A P&L From Scratch Complete.xlsx

  19. Learn how to build effective Doughnut charts in Excel.mp4

  19.1 Doughnut Chart - Unsolved.xlsm.xlsm

  2. Introduction to the case study.mp4

  20. Learn how to build an Area chart in Excel.mp4

  20.1 Area Chart - Solved.xlsm.xlsm

  21. Learn how to create Bridge charts.mp4

  21.1 Bridge Chart - Solved.xlsm.xlsm

  21.3 Bridge Chart – Unsolved.xlsm.xlsm

  23. Course Challenge - Apply your skills in practice!.mp4

  23.1 1. SOULUTIONS - Course Challenge.xlsx.xlsx

  3. Understand your data source before you start working on it.mp4

  4. Order the source worksheets.mp4

  4.1 4. Order a worksheet - Unsolved.xlsx.xlsx

  5. Create a code the best way to organize your data and work efficiently with it.mp4

  5.1 5. Creating a code - Unsolved.xlsm.xlsm

  6. Learn how to create a database.mp4

  6.1 6. Creating a database - Solved.xlsx.xlsx

  7. Use Vlookup to fill the Database sheet.mp4

  7.1 7. Vlookup - Solved.xlsx.xlsx

  7.3 7. Vlookup - Unsolved.xlsx.xlsx

  8. 50% Completed!.vtt

  9. Use SUMIF to complete the Database sheet.vtt

  9.2 8. Sumif - Unsolved.xlsx.xlsx

 [FCS Forum].url