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)
Study scope and how to read it
This page is a project-specific decision model, not a generic sector template. Library capital and ROI ranges are planning variables for comparison, not fixed prices or return promises. Before investing, replace each material assumption with a quotation, contract, operating record or reviewable market source.
This study is specifically for Energy audit service. The library capital range is $57,000 to $473,000; ROI: 13–27% · Planning range; not model-calculated. Cost inputs: equipment and EPC, roof/land rights, grid connection where applicable, permits, finance, insurance, scheduled maintenance, replacements and performance degradation. Revenue is built from: kWh generated or saved × sale tariff/savings value × availability, adjusted for losses, degradation and downtime; service businesses use installations/contracts and service value instead of kWh.
Sector context
Energy projects require generation modelling, grid connection, land/roof rights, electricity sale or savings assumptions, financing, maintenance, equipment degradation and project life.
Project economics map
| Dimension | Project-specific variables |
|---|---|
| Revenue engine | projects delivered and billed · service / maintenance contracts |
| Operating KPIs | billable utilization · qualified project pipeline · customer concentration |
| Sensitivity variables | projects delivered and billed · billable utilization · customer concentration |
| Evidence pack | customer contracts / bookings / orders · bank and collection records · actual operating logs · licences, approvals and official files |
| Red flags | customer concentration · applicable licences and compliance |
Revenue engine
For Energy audit service, revenue does not start from a headline ROI. It starts from measurable units: projects delivered and billed · service / maintenance contracts. Every unit must tie to a reviewable price, volume and time period.
Operating KPIs
The operating dashboard for this project should monitor: billable utilization · qualified project pipeline · customer concentration. An operating assumption without a record or source remains a scenario, not a fact.
Sensitivity variables
Project sensitivity testing changes the variables that matter most here: projects delivered and billed · billable utilization · customer concentration. Each change is traced to break-even, cash flow and return rather than a standalone marketing percentage.
Evidence pack
Evidence required before accepting the base case: customer contracts / bookings / orders · bank and collection records · actual operating logs · licences, approvals and official files. If a material document is missing, the variable remains “needs verification” rather than being silently estimated.
Red flags
Key red flags that lower confidence or trigger deeper review: customer concentration · applicable licences and compliance.
Energy audit service — Project-specific financial model
These weights are a capital-allocation planning anchor, not market prices or supplier quotes. They total 100% and must be replaced by project evidence before the Base Case is accepted.
Model status: planning; not yet evidence-validated · CAPEX allocations and stress tests are recorded planning inputs, not verified quotations or actual cash flows. Source links alone do not substantiate the return or costs of a particular project.
Planning CAPEX allocation
| Dimension | Share of initial capital |
|---|---|
| equipment CAPEX | 35% |
| staff | 25% |
| launch & working capital | 30% |
| execution/liquidity reserve | 10% |
OPEX drivers
- staff
- utilities
- maintenance & repairs
- insurance
- licensing/compliance cost
KPIs that must appear in the model
- projects delivered and billed
- service / maintenance contracts
- billable utilization
- qualified project pipeline
- customer concentration
- operating margin
- payback period
Numeric stress tests
Apply these shocks to the Base Case after real project data are entered; they are not market forecasts.
| Driver | Stress change |
|---|---|
| projects delivered and billed | -20% |
| billable utilization | -20% |
| customer concentration | -20% |
Worked example: if customer/operating volume is X, the result is Y
Owner-requested 2026 educational hypothetical: X, price and cost figures here are constructed illustrations, NOT numbers in the PDF, proven project prices, or realized income. The separate PDF planning ROI range is not derived from these cases.
Illustrative assumptions: monthly price/saving per unit 4,500.00 USD; unit variable cost 1,100.00 USD; monthly fixed cost 5,100.00 USD; comparison capital 265,000.00 USD (midpoint of the PDF planning range).
Revenue/saving = X × unit price; total cost = X × variable unit cost + fixed cost; Y = revenue/saving − total cost. Annual = Y × 12 at unchanged volumes; taxes, interest, depreciation and changing prices excluded.
| Scenario | X: monthly volume (projects/month) | Monthly revenue/savings USD | Variable cost USD | Monthly fixed cost USD | Y: monthly operating surplus/(deficit) USD | Illustrative annual USD |
|---|---|---|---|---|---|---|
| Low | 1 | 4,500.00 | 1,100.00 | 5,100.00 | -1,700.00 | -20,400.00 |
| Medium | 3 | 13,500.00 | 3,300.00 | 5,100.00 | 5,100.00 | 61,200.00 |
| High | 5 | 22,500.00 | 5,500.00 | 5,100.00 | 11,900.00 | 142,800.00 |
Monthly break-even: 2 projects/month
Annual operating surplus / illustrative capital = 23.09%; this is NOT full investment ROI.
How to build the actual feasibility model
1. Build revenue
Start from a measurable operating unit and connect it to actual price, volume and time. Never start from a target ROI and reverse-engineer assumptions to reach it. kWh generated or saved × sale tariff/savings value × availability, adjusted for losses, degradation and downtime; service businesses use installations/contracts and service value instead of kWh.
2. Build cost
Separate entry price or CAPEX from OPEX, working capital, finance, tax and contingency. Every material line should have a source, date and verification owner. equipment and EPC, roof/land rights, grid connection where applicable, permits, finance, insurance, scheduled maintenance, replacements and performance degradation.
3. Build cash flow
Convert revenue and cost into monthly or quarterly cash flow showing when money is collected and paid, not accounting profit alone. Show working-capital needs and any funding gap before break-even.
4. Break-even
Calculate how many units, nights, tonnes, contracts or customers are needed to cover fixed cost after contribution margin. Without a measurable operating unit, the model is not decision-ready.
5. Currency and tax
Separate operating performance from FX and tax effects. Measure the result in the investor’s base currency too, and do not include an incentive or exemption in the base case before eligibility is verified.
Scenario matrix
Most sensitive variables for this project: projects delivered and billed · billable utilization · customer concentration
| Scenario | Assumption rule | What changes |
|---|---|---|
| Conservative | Lower or slower revenue, higher cost and realistic delay. Use defensible boundaries rather than arbitrary worst-case figures. | projects delivered and billed · billable utilization · customer concentration |
| Base | Only numbers supported by documents, comparables or operating records. Missing inputs remain explicitly unverified. | customer contracts / bookings / orders · bank and collection records · actual operating logs · licences, approvals and official files |
| Upside | Operationally explainable improvement such as higher utilisation, better productivity or stronger pricing; never the core purchase justification. | projects delivered and billed · billable utilization · customer concentration |
Decision gates before investing
Legal & regulatory
Ownership, rights, licences, approvals and required contracts exist and are enforceable or transferable.
Market & demand
End customer, price, volume and competition are proven in the actual micro-market, not only at country level.
Operations & capacity
Capacity, labour, suppliers, operator and schedule can produce the assumed revenue unit.
Finance & cash flow
Cash flow, working capital, tax and debt remain serviceable under the conservative case.
Capital structure
Funding source, covenants, security, drawdowns and repayment do not turn a good asset into a fragile deal.
Exit & liquidity
A credible buyer or exit mechanism exists, with realistic time, cost and transferability understood.
Capital allocation map
Do not apply one reserve percentage to every project. Size contingency from schedule, supply, volatility and ramp-up risk.