Useful next calculations
When to use this calculator
- Before pricing a job, setting margin targets or reviewing hiring costs.
- When you want to test sensitivity around volume, tax, markup or overheads.
- When you need a practical estimate before committing to a budget or proposal.
- When you are modelling break-even volume as costs or prices change.
A worked example
These are the example figures the calculator opens with.
| Input | Value |
|---|---|
| Monthly Revenue (€) | €20,000 |
| Cost of Goods Sold (€) | €8,000 |
| Operating Expenses (€) | €5,000 |
| Tax Rate (%) | 20% |
For those figures the calculator returns:
- Net cash flow: €5,600.00
- Revenue: €20,000.00
- Gross profit: €12,000.00
- EBIT: €7,000.00
- Tax: €1,400.00
- Gross margin: 60.00%
Method & assumptions
This calculator produces a rolling cash flow forecast by taking your opening bank balance, adding projected cash receipts from sales, and deducting cash payments for costs in each period. Enter figures as cash amounts — that is, money you actually expect to receive or pay in the period, not accruals or invoices raised. VAT-registered businesses should include the VAT element in both receipts and payments and show the net VAT settlement as a separate line in the period it falls due.
The model does not incorporate capital expenditure, loan repayments, or tax liabilities unless you add them explicitly. It is a planning tool and will only be as accurate as the assumptions you feed into it. Review and update your forecast monthly against actuals to keep it useful.
Common mistakes
- Using an assumption that is not supported by a current local quote, bill, statement or official source.
- Treating a generic estimate as a lender, provider, payroll or tax authority decision.
- Mixing monthly and annual inputs without converting them consistently.
- Testing only one scenario instead of checking how a cautious assumption changes the result.
What to do next
- Run a second scenario with a cautious assumption so you can see the downside clearly.
- Compare the result with the related calculators below before making a decision.
- Check current local rules, eligibility and provider terms before applying or committing money.
- Keep a record of the assumptions so you can update the estimate when a quote, bill or pay figure changes.