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.
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.
Forecast financial statements
Revenue and ending cash
| Line item | Jan Y1 | Feb Y1 | Mar Y1 | Apr Y1 | May Y1 | Jun Y1 | Jul Y1 | Aug Y1 | Sep Y1 | Oct Y1 | Nov Y1 | Dec Y1 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 100,643 | 101,291 | 101,943 | 102,599 | 103,259 | 103,923 | 104,592 | 105,265 | 105,942 | 106,624 | 107,310 | 108,000 |
| Direct costs | 30,193 | 30,387 | 30,583 | 30,780 | 30,978 | 31,177 | 31,378 | 31,579 | 31,783 | 31,987 | 32,193 | 32,400 |
| Gross profit | 70,450 | 70,904 | 71,360 | 71,819 | 72,281 | 72,746 | 73,214 | 73,685 | 74,159 | 74,636 | 75,117 | 75,600 |
| Operating expenses | 50,164 | 50,328 | 50,493 | 50,658 | 50,824 | 50,990 | 51,157 | 51,325 | 51,493 | 51,661 | 51,830 | 52,000 |
| EBITDA | 20,287 | 20,576 | 20,867 | 21,161 | 21,457 | 21,756 | 22,057 | 22,361 | 22,667 | 22,975 | 23,286 | 23,600 |
| Depreciation | 4,192 | 4,172 | 4,154 | 4,136 | 4,118 | 4,101 | 4,085 | 4,069 | 4,054 | 4,040 | 4,026 | 4,013 |
| EBIT | 16,095 | 16,403 | 16,713 | 17,025 | 17,339 | 17,655 | 17,972 | 18,291 | 18,612 | 18,935 | 19,260 | 19,587 |
| Interest expense | 900 | 875 | 850 | 825 | 800 | 775 | 750 | 725 | 700 | 675 | 650 | 625 |
| Profit before tax | 15,195 | 15,528 | 15,863 | 16,200 | 16,539 | 16,880 | 17,222 | 17,566 | 17,912 | 18,260 | 18,610 | 18,962 |
| Tax | 3,191 | 3,261 | 3,331 | 3,402 | 3,473 | 3,545 | 3,617 | 3,689 | 3,762 | 3,835 | 3,908 | 3,982 |
| Net income | 12,004 | 12,267 | 12,532 | 12,798 | 13,066 | 13,335 | 13,605 | 13,877 | 14,151 | 14,426 | 14,702 | 14,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.