Excel for Finance: Building a Three-Statement Operating Model Online Class | LinkedIn Learning, formerly Lynda.com (2024)

Contents

• • What you should know 1m 24s
  • What you're going to build 4m 11s
• • Call with the CFO 3m 26s
  • Initial groundwork and freeze frames 3m 8s
  • Identifying hardcoded data 2m 19s
  • Applying the currency format 3m 28s
  • The value of a placeholder row 4m 7s
  • Initial error checking 3m 2s
  • Expanding on error checking 5m 50s
  • Formatting guide 2m 42s
  • Indenting and cleanup 3m 43s
• • Build the cash from operations 7m 35s
  • Build the cash from investing 2m 58s
  • Build the cash from financing 3m 27s
  • Build the change in cash and ending cash 5m 59s
• • An overview of EBITDA 4m 54s
  • Building the EBITDA schedule 8m 39s
• • Foundation of a good forecast 7m 34s
  • Build the annual income statement 5m 53s
  • Build the annual balance sheet 4m 29s
  • Calculating year-over-year growth 4m 39s
  • Forecasting the revenue 6m 55s
  • Forecasting the cost of goods sold 6m 17s
  • Forecasting the variable expenses 6m 30s
  • Forecasting the fixed expenses 4m 8s
  • Forecasting the headcount 5m 30s
  • Headcount in outer years 5m 59s
  • Forecast the income tax expense 2m 41s
• • An overview of the balance sheet 1m 40s
  • How to lay the net working capital 3m 51s
  • Forecasting the accounts receivable 6m 40s
  • Forecasting the inventory 3m 11s
  • Forecasting the accounts payable 3m 20s
  • Modeling prepaid expenses and accruals 6m 31s
  • Building the bonus accrual 11m 10s
  • Building the tax accrual 9m 27s
• • An overview of CapEx and depreciation 4m 22s
  • How to lay the fixed assets schedule 2m 50s
  • Building the CapEx forecast 4m 36s
  • Building the depreciation waterfall 8m 40s
  • Modeling existing depreciation 3m 16s
  • Connecting the fixed assets to the model 4m 16s
  • Quick cleanup 3m 48s
  • How to lay the debt schedule 4m 45s
  • Groundwork of the cash flow sweep 6m 30s
  • Finishing the cash flow sweep 4m 56s
  • Modeling the revolver 4m 59s
  • Getting started with term debt 3m 3s
  • Setting up term debt amortization 4m
  • Modeling the term debt amortization 4m 38s
  • Connecting the debt schedule to the model 5m 26s
• • Model the leverage ratio 7m 26s
  • Model the fixed charge coverage ratio 8m 46s
• • Pre-summary cleanup 8m 7s
  • Link up the one-pager: Part 1 8m 32s
  • Link up the one-pager: Part 2 5m 28s
  • Stress testing the model 3m 57s
• • Email to the CFO 3m 16s
  • Epilogue: Real-life application of the model 5m 34s

What’s included

Similar courses

Download courses