The Complete Financial Modeling and Valuation Course Video Course

Curriculum For This Course

• 1. Beginner to Pro in Excel: Financial Modeling and Valuation - Welcome! 1 Videos 00:02:26
  • What does the course cover? 02:26
• 2. Introduction to Excel 10 Videos 00:28:25
  • Introduction to Excel - Welcome Lecture 00:37
  • Overview of Excel 03:39
  • Basic Manipulations with Rows & Columns 01:48
  • The Excel Ribbon 02:42
  • Data Entry in Excel 03:03
  • Introduction to Formatting 05:38
  • Introduction to Excel Formulas 02:58
  • Introduction to Excel Functions 03:47
  • Cut, Copy & Paste 02:08
  • Paste Special 01:28
• 3. Useful tips and tools for your work in Excel 19 Videos 00:33:57
  • Excel Best Practices - Welcome Lecture 00:41
  • Initial formatting of an Excel sheet in order to render it professional 01:53
  • Fast scrolling through Excel sheets 01:29
  • Introduction to fixing of cell references 02:08
  • Using the Alt plus Enter combination 00:38
  • Learn how to organize your data with Text to Columns 01:53
  • Learn how to Use the Wrap Text Button 00:44
  • Create easily printable documents in Excel by using Set Print Area 01:11
  • Find and select special types of cells with Select Special (F5) 01:31
  • Learn how to assign dynamic names within a Financial Model 01:21
  • Define a named range in Excel 01:34
  • Assign custom formats to specific cells within a Financial Model (ex. Multiples) 01:33
  • Macros are a great timesaver! Here's why! 02:51
  • Create a drop-down list by using Data Validation 01:44
  • Using Custom-sort in order to sort multiple columns within a table 01:23
  • Create a great Index page at the beginning of your models - Hyperlinks 01:12
  • Fix the top row of your table with Freeze Panes 01:11
  • Filter by color - an excellent tool 01:44
  • Working with conditional formatting 05:40
• 4. Keyboard shortcuts in Excel 1 Videos 00:04:38
  • Keyboard Shortcuts Save LOTS of time in Excel 04:32
• 5. Excel's key functions and functionalities made easy 15 Videos 00:49:33
  • Excel's Key Functions - Welcome Lecture 00:45
  • Key Excel Functions: Sum, Sumif and Sumifs 04:20
  • Key Excel Functions: Count, Counta, Countif, Countifs 04:00
  • Key Excel Functions: Average and Averageif 01:53
  • Elaborate text efficiently: Left, Right, Mid, Upper, Lower,Proper, Concatenate 04:24
  • Find the minimum or maximum value in a range of cells in Excel 00:51
  • Include Round in your Financial Models 01:01
  • Learn how to transfer data efficiently in Excel: Vlookup and Hlookup 07:31
  • Index, Match and their combination - the perfect substitute of Vlookup 07:18
  • A great Excel technique: Index, Match, Match 04:59
  • Using Excel's Iferror function to trap spreadsheet errors 01:42
  • Learn how to render your models flexible with Choose 02:18
  • Use Goal Seek in order to find the result that you are looking for 02:13
  • Include sensitivity analysis in your models through Data Tables 04:06
  • Excel's dynamic and interactive tables: Pivot tables 02:12
• 6. Global Econ. +Excel Part 4/4: Fiscal Policy, WTO, Monopolies, Bitcoin & More 1 Videos 00:08:36
  • Exercise - Excel's "Sumifs" function - explained & solved 08:00
• 7. Financial functions in Excel 4 Videos 00:22:26
  • Future and present values in Excel 07:02
  • Calculating the rate of return of an investment with the IRR function 03:30
  • Calculating a complete loan schedule in Excel 06:16
  • Date functions in Excel 05:38
• 8. Microsoft Excel's Pivot Tables in Depth 6 Videos 00:20:14
  • Introduction to Pivot Tables & Their Application 01:30
  • Creating Pivot Tables is easy! 03:42
  • Give Your Excel Pivot Tables a Makeover 02:09
  • Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need 04:28
  • Learn More About GetPivotData - A Very Important Excel Function 03:40
  • An Introduction to Slicers - The Moden Day Pivot Table Filters 04:20
• 9. Case Study - Building a Complete P&L from scratch in Excel 20 Videos 01:07:45
  • Case Study - Build a P&L From Scratch - Welcome Lecture 01:02
  • Introduction to the Case Study 00:37
  • Understand your data source before you start working on It 02:22
  • Order the source worksheets 01:57
  • Create a code: the best way to organize your data and work efficiently with It 01:48
  • Learn how to create a Database 01:50
  • Use Vlookup in order to fill the Database sheet 05:17
  • Use Sumif in order to complete the Database sheet 04:07
  • Use Index & Match as a substitute of Vlookup 03:59
  • Mapping of the rows in the Database sheet 02:07
  • Building the structure of the P&L sheet 01:59
  • Formatting sets You apart from the competition in Excel - A Practical Example 03:15
  • Populate the P&L sheet with Sumif 02:39
  • Learn how to find mistakes with Countif 02:17
  • Calculating year-on-year percentage variations the proper way 02:59
  • Create professional and good-looking charts - Introduction 00:20
  • Build a Column Stacked Chart with a secondary line axis in Excel 05:52
  • Learn how to build effective Doughnut Charts in Excel 04:06
  • Learn how to build an Area Chart in Excel 04:01
  • Learn how to create Bridge Charts 10:41
• 10. Case Study - Building an FMCG Model from Scratch 11 Videos 00:35:10
  • Introduction to the Case Study 01:55
  • Preliminary mapping of the data extraction 02:05
  • Working with an SAP data extraction 03:17
  • Creating an output structure of the FMCG model 02:24
  • Improving the layout and appearance of the FMCG report 04:13
  • Inserting formulas and automating calculations 02:25
  • Creating a Master Pivot Table: The main data source for the FMCG report 01:50
  • GetPivotData is great! Extracting data from the Master Pivot Table 05:40
  • Combining Slicers and GetPivotData: The key to our success 03:14
  • Getting fancy with Excel slicers - Good-looking Excel slicers 03:07
  • This is how the report can be used in practice by high-level executives 03:54
• 11. Financial Modeling Fundamentals 12 Videos 00:42:06
  • Financial Modeling Basics - Welcome Lecture 00:42
  • What is a Financial model? 02:02
  • Why use Financial models? 02:35
  • Financial modeling: Worst Practices - Things you should avoid 05:49
  • Financial modeling: Best practices 04:58
  • Financial modeling: The types of models that are built in practice 04:42
  • Financial modeling: The right level of detail in a model 02:35
  • Financial modeling: Forecasting guidelines 02:51
  • Building a complete model - Important considerations 02:15
  • Modeling the Income statement 05:58
  • Modeling the Balance sheet - Part 1 02:35
  • Modeling the Balance sheet - Part 2 05:08
• 12. Learn how to build a Discounted Cash Flow model in Excel 33 Videos 01:27:10
  • Valuation Case Study - Welcome Lecture 00:33
  • Introduction to the DCF exercise 01:07
  • The various stages of a complete DCF Valuation 06:30
  • Description of the structure of the DCF model 02:53
  • A glimpse at the company we are valuing - Cheeseco 01:09
  • Modeling the top line 03:39
  • Introducing scenarios to the model with Choose 02:12
  • Modeling other items: Other revenues and Cogs 03:46
  • Modeling other items: Operating expenses and D&A 02:33
  • Modeling other items: Interest expenses, Extraordinary items and Taxes 02:28
  • Forecasting Balance Sheet items 00:43
  • An introduction to the "Days" methodology 01:35
  • Calculation of DSO, DPO and DOI for the historical period 01:30
  • Forecasting DSO, DPO and DOI 02:23
  • Forecasting Property, Plant & Equipment, Other assets and Other liabilities 02:27
  • Creating an output P&L sheet 02:36
  • Populating the output P&L sheet 02:14
  • Populating the output BS sheet 01:49
  • Completing the output BS sheet for the historical period 03:41
  • Creating a structure for the calculation of Unlevered Free Cash Flows 03:05
  • Bridging Unlevered Free Cash Flow to Net Cash Flow 01:55
  • Calculating Unlevered Free Cash Flow 06:01
  • Calculating Net Cash Flow 03:56
  • Obtaining the rest of the Cash Flows through Find and Replace 03:52
  • Introducing Weighted Average Cost of Capital and Perpetuity Growth 01:56
  • Discounting Unlevered Free Cash Flows in order to obtain their Present Value 02:50
  • Calculating Continuing Value and Enterprise Value of the business 02:17
  • Calculating Equity Value 01:21
  • Sensitivity analysis for WACC and perpetuity growth 04:17
  • A possible application of Goal Seek 01:40
  • Using charts in order to summarize the results of the DCF Model 04:38
  • You Made It! 02:16
  • Congratulations!! 01:02