Ratio Snapshot: Liquidity, Leverage and Working Capital Days
Lessons in this course
- Monthly P&L Variance: What to Explain to Your ManagerFree
- Budget vs Forecast: Rolling the Latest Estimate (6+6) Locked
- Revenue Bridge: Volume and Price Effects in a Waterfall Locked
- Headcount Cost Model: Salaries, Start Months and On-Costs Locked
- Driver-Based Forecast: Sessions × Conversion × Order Value Locked
- KPI Pack: Margins, Year-on-Year Growth and Run-Rate Locked
- Trailing Twelve Months (TTM): A Moving SUM Locked
- Ratio Snapshot: Liquidity, Leverage and Working Capital Days Locked
- Scenario Toggle: Base, Upside and Downside with CHOOSE Locked
- Sensitivity Table: EBITDA for Price and Volume Changes Locked
- Reconciling Two Exports: XLOOKUP and the Difference Column Locked
- One-Page Management Dashboard: KPIs, Chart and Highlights Locked
- From Trial Balance to P&L: Account Mapping with XLOOKUP and the Tie-Out Check Locked
- Budget Phasing: Seasonal Monthly Budgets, YTD Variance and What Is Left to Spend Locked
- Forecast Accuracy: Errors, MAPE and Bias by Product Line Locked
- Allocating Shared Costs: Drivers, Department Contribution and Why the Driver Matters Locked
- Cash Conversion: From EBITDA to Free Cash Flow with Working Capital and a Waterfall Locked
- Capex Request: Payback, NPV and IRR for a New Store Fit-Out Locked
- Group Reporting in USD: FX Translation, Reported vs Constant-Currency Growth Locked
- Final Project: Month-End Board Pack – YTD vs Budget and Last Year, Margins & a Combo Chart Locked