This product has no pricing plans and so is not available for purchase

• 1

  What is EBITDA and why its important?

  • 1. Course Outline Free Preview
  • 2. What is EBITDA
  • 3. Why are interest, tax and depreciation excluded?
  • 4. When and how is EBITDA used?
  • 5. EBITDA % or EBITDA Margin
  • 6. Download Course Reference Material
• 2

  How to analyze a Company's Gross profit the right way

  • 1. Income statement (P&L) variances explained Free Preview
  • 2. Introduction to profit variance hierarchy Free Preview
  • 3. Our Case Study (The sample data)
  • 4. Automating variance calculations - Part 1
  • 5. Automating variance calculations - Part 2
  • 6. Automating variance calculations - Part 3
  • 7. Sales price variance
  • 8. Cost of sales variance
  • 9. Quantity Variance - Introduction
  • 10. How to calculate Quantity variance
  • 11. FAQ: how to deal with new or unbudgeted products
  • 12. Impact on Sales vs Impact on Profit
  • 13. Volume vs Mix Variances - The difference
  • 14. Volume Variance and Profit impact
  • 15. Volume Variance and impact on Sales
  • 16. Calculating Mix Variances - Option 1
  • 17. Calculating Mix Variances - Option 2
  • 18. Mix Variances - Impact on Sales
• 3

  Sales and profit variance walks (Variance bridges)

  • 1. Sales variance walk (Bridge) Free Preview
  • 2. Gross profit variance walk (Bridge)
  • 3. EBITDA Variance walk (Bridge)
  • 4. EBITDA Variance walk (Continued)
  • 5. Waterfall chart for variances in Excel
• 4

  Profit percentage (%) walks for Gross profit and EBITDA

  • 1. Introduction to Gross Profit % and EBITDA % Free Preview
  • 2. Percentage Math - How it works!
  • 3. Gross Profit % change walk
  • 4. EBITDA % change walk
• 5

  Present income statement performance with Charts and Graphs

  • 1. P&L variances - Ask the right questions. Free Preview
  • 2. Presenting variances using waterfall charts
  • 3. Price variance visualization
  • 4. Linked Excel file for Charts and Graphs
  • 5. Quantity variance visualization
  • 6. Mix Variance Visualization
  • 7. Gross Profit and Gross Margin visualization
  • 8. Cost of Sales Visualization
  • 9. Selling and Advertising expenses visualization
  • 10. General and Admin expenses Visualization
  • 11. Depreciation expense Visualization
• 6

  Wrap Up!

  • 1. Wrap up and Conclusion
• 7

  Bonus!

  • 1. Vertical Analysis of income statement
  • 2. Create Waterfall Chart in older version of Excel