Tabellab
Intermediate

Budgeting & Cash-Flow Forecasting (FP&A)

Build a full master budget, a cash budget and a 13-week forecast, then explain the variances, every cell checked as you go.

8 lessons 8 labs 1.9 h Certificate

The first lesson is free — no account needed.

About this course

A practical budgeting and forecasting course for FP&A work. You build a master budget from the sales budget down to the budgeted profit and loss statement, a cash budget with collection lags, minimum cash and borrowing, and a 13-week cash-flow forecast. Then you explain budget-versus-actual variances and run a rolling forecast with base, best and worst cases, with every cell checked as you go.

Lessons

  1. The Sales Budget: Volume × Price with SeasonalityLab12 minFree
  2. Production and Materials Purchases BudgetLab15 min Pro
  3. Operating Expense Budget: Fixed vs VariableLab12 min Pro
  4. The Budgeted Profit & Loss StatementLab12 min Pro
  5. The Cash Budget: Collection Lags, Minimum Cash and BorrowingLab18 min Pro
  6. The 13-Week Cash-Flow ForecastLab16 min Pro
  7. Budget vs Actual: Variance AnalysisLab15 min Pro
  8. Rolling Forecast with Base, Best and Worst ScenariosLab16 min Pro