Financial model of a project or business
Sales, costs, investment, working capital, taxes and debt year by year: cash flow, NPV, IRR, payback, peak funding need, scenarios and sensitivity.
A model with your assumptions, not a validated business plan
The results depend entirely on the sales, prices and costs you enter. It isn't financial or tax advice.
Enter your data: no value is filled in for you.
Result
Waiting for your data. Fill in all the fields (use 0 if not applicable).
Compare your projects or versions
Save each version with “Save” and it will appear here.Save this model and create another (or another version with other assumptions) to compare them side by side.
Calculation version: venture@1.0.0. The calculation runs in your browser: we don't send or store the amounts you enter.
How it calculates
- Sales in year t = units × (1 + growth)^(t−1) × price × (1 + price increase)^(t−1). Variable and fixed costs rise with cost inflation.
- EBITDA = sales − variable costs − fixed costs. Straight-line depreciation of the investment over its useful life. EBIT = EBITDA − depreciation.
- Tax on positive EBIT, offsetting losses from previous years. Debt interest doesn't reduce tax in this model (simplification).
- Free cash flow = EBITDA − tax − increase in working capital; year 0 is the investment. In the final year working capital is recovered and the sale value of the assets is added.
- NPV at the discount rate entered; IRR and payback on the project cash flows. With debt, constant payments and equity IRR on the equity cash flows (including repayment of the outstanding debt at the end).
- Peak funding need = the lowest point of the cumulative cash flow: what would have to be financed at the worst moment.
Limits
- Annual model: it doesn't capture seasonality or collection timing within the year.
- A single product or an average sale; no reinvestment during the horizon.
- It doesn't include VAT or grants; the sale value of the assets isn't taxed in this model.