Back to all always-free tools
ALWAYS-FREE THREE-STATEMENT FORECAST

See how profit turns into cash—and where it gets stuck.

Enter a service business P&L, opening balance sheet and the assumptions that move cash. The model connects all three statements, updates instantly and gives you a workbook you can open in Excel.

Always freeData stays in your browserExcel-compatible exportBuilt for service businesses
MODEL INPUTS

Build the forecast

Base annual P&L

Use the latest normal trading year, before forecast growth.

Opening balance sheet

Enter balances at the date immediately before the forecast starts.

Forecast drivers

The assumptions that connect profit, working capital, debt and cash.

Service-business model: inventory is excluded, so DIO is not required. Opening equity is calculated automatically as the balancing amount.

CONNECTED OUTPUT

Forecast financial statements

ENDING CASH
204,563
FINAL-PERIOD REVENUE
108,000
FINAL EBITDA MARGIN
21.9%
ENDING DEBT
120,000

Revenue and ending cash

RevenueEnding cash
Jan Y1Feb Y1Mar Y1Apr Y1May Y1Jun Y1Jul Y1Aug Y1Sep Y1Oct Y1Nov Y1Dec Y1
Line itemJan Y1Feb Y1Mar Y1Apr Y1May Y1Jun Y1Jul Y1Aug Y1Sep Y1Oct Y1Nov Y1Dec Y1
Revenue100,643101,291101,943102,599103,259103,923104,592105,265105,942106,624107,310108,000
Direct costs30,19330,38730,58330,78030,97831,17731,37831,57931,78331,98732,19332,400
Gross profit70,45070,90471,36071,81972,28172,74673,21473,68574,15974,63675,11775,600
Operating expenses50,16450,32850,49350,65850,82450,99051,15751,32551,49351,66151,83052,000
EBITDA20,28720,57620,86721,16121,45721,75622,05722,36122,66722,97523,28623,600
Depreciation4,1924,1724,1544,1364,1184,1014,0854,0694,0544,0404,0264,013
EBIT16,09516,40316,71317,02517,33917,65517,97218,29118,61218,93519,26019,587
Interest expense900875850825800775750725700675650625
Profit before tax15,19515,52815,86316,20016,53916,88017,22217,56617,91218,26018,61018,962
Tax3,1913,2613,3313,4023,4733,5453,6173,6893,7623,8353,9083,982
Net income12,00412,26712,53212,79813,06613,33513,60513,87714,15114,42614,70214,980

All calculations and the workbook export run locally in your browser. The financial inputs are not sent to Manic Accounting.

How the model connects

Revenue and margin assumptions build the forecast P&L. DSO converts revenue into receivables, while DPO converts direct costs into payables. Capex, depreciation, debt repayment, interest and tax complete the operating picture.

The indirect cash flow starts from net income, adjusts for non-cash depreciation and working-capital movements, then connects investing and financing cash flows back to the closing balance sheet.

Useful model, sensible boundaries

This first tool is designed for service businesses. It intentionally excludes inventory and DIO, complex debt facilities, dividends, deferred tax, acquisitions and detailed fixed-asset registers.

The result is an illustrative planning model, not accounting, tax, investment or lending advice. Review material decisions with a qualified professional who understands your business and jurisdiction.

MANICACCOUNTING
© 2026 Manic Accounting