Reproducible feasibility model
Enter project inputs and their source. Published ROI ranges do not generate results. Use one currency; annual inputs include your chosen inflation and price changes.
Enter every annual value; use an explicit zero for inapplicable items. Market inputs have not been approved for this study.
Asset disposal proceeds belong only in the final year; do not count the same sale more than once.
| Years | Units sold | Revenue | OPEX | EBITDA | Annual depreciation | Project operating tax | Change in working capital | Subsequent CAPEX | Free cash flow before exit | Net asset disposal in final year only | Working capital recovery | Project cash flow | Interest paid | Tax after interest | Debt principal repayment | Debt balance settled at exit | Equity cash flow | Operating break-even units | Operating break-even revenue | Break-even utilization % | Cumulative project cash flow since initial investment | Cumulative equity cash flow since initial investment | Cumulative gap beyond initial equity | Cash available for debt service (model estimate) | Debt service: interest + principal + final balloon | Outstanding debt after payments | Debt service coverage ratio (estimate) |
|---|
Annual cash flows by scenario
All figures are recomputed year by year from your inputs, in the model currency. A scenario above declared capacity has no fabricated values.
| Scenario | Years | Revenue | EBITDA | Project cash flow | Equity cash flow | Cumulative gap beyond initial equity | Cash available for debt service (model estimate) | Debt service: interest + principal + final balloon | Debt service coverage ratio (estimate) | Operating break-even status |
|---|
| Reproducible feasibility model | Project NPV | Project IRR | Average annual accounting return on initial equity (not cash yield) | Payback including exit | Peak additional funding requirement | Minimum debt service coverage | Years operating cash falls short of debt service | Years break-even is not achievable at capacity |
|---|
CSV units: IRR, ROI, utilization and shocks are percentage points (12 means 12%); DSCR is a ratio (1.2 means 1.2×); payback is in years. All money uses the selected currency. Source review dates are user-provided, not independent verification.
Methodology · 5.0
Revenue = capacity × utilization × unit price. EBITDA = revenue minus variable, fixed, payroll and fixed energy costs. Production-linked energy belongs only in unit cost. FCF = EBITDA minus operating tax, subsequent CAPEX and working-capital change. Annual positive profits are taxed without automatic loss carryforwards or incentives. Depreciation, working capital and inflation are explicit annual inputs. Final working capital is fully recovered and remaining debt repaid at the horizon. NPV uses year-end cash flows in model currency, without implicit FX conversion. You set sensitivity changes within capacity. Fractional payback assumes even cash flows during the year. Recovery that depends on disposal proceeds or working-capital release at year end is dated at that year end. Asset disposal proceeds belong only in the final year; do not count the same sale more than once. The year-end gap assumes earlier positive cash flows are retained. It excludes intra-year cash shortfalls and new financing charges and does not double-count initial equity. Scenario cannot be calculated: assumed demand exceeds declared operating capacity. Revise assumptions or document extra capacity; no return is reported for this case. Indicative coverage, not a lender covenant: available cash = EBITDA − estimated profit tax after interest − reinvestment − working-capital change. Debt service includes interest, scheduled principal and the final balloon. Asset sale and final working-capital recovery are excluded. This is not verified cash tax or the definition in a loan contract. Operating break-even compares required units with declared annual capacity; a displayed theoretical amount is not proof it can be achieved.
Revenue = capacity × utilization × unit price
EBITDA = revenue − variable costs − fixed costs − payroll − fixed energy
FCF = EBITDA − operating tax − CAPEX − ΔWC
NPV = Σ CF(t)/(1+r)^t
Break-even units = fixed operating costs / (price − variable unit cost)
CFADS (model proxy) = EBITDA − equity cash-tax estimate − subsequent CAPEX − ΔWC
Debt service = interest + scheduled principal + final balloon
DSCR = CFADS / debt service (not a contractual lender ratio)