P&L Budget vs Actual + Cash Flow Model in Excel (sample project) by Renata LimaP&L Budget vs Actual + Cash Flow Model in Excel (sample project) by Renata Lima

P&L Budget vs Actual + Cash Flow Model in Excel (sample project)

Portfolio project
Renata Lima
Sample Excel model with fictional data that answers two questions every month: are we on budget, and will there be cash to pay the bills?
What it includes: monthly P&L with gross margin and EBITDA; budget vs actual with monthly and year-to-date variances in value and %; a 12-month cash flow forecast; and a KPI summary page with charts. Favorable and unfavorable variances are color-coded.
Inputs are separated from formulas and totals are reconciled. Management model only (no tax filing or audited statements). Built from my experience preparing monthly closings and budgets as a former corporate controller.

0 likes · 1 view · Nov 13, 2026

Sample Excel model: monthly P&L, budget vs actual (monthly and YTD) and a 12-month cash flow forecast with a KPI page. Fictional data.

Tags