Explore water supply, wastewater treatment, reuse, and desalination investments through BOO/BOT simulations. Enter your project assumptions to evaluate IRR, NPV, payback, and required tariffs.
Sanmata can help validate raw water quality, capacity, CAPEX, OPEX, and BOO/BOT structures.
Define ownership, construction period, and operating term.
All amounts in IDR billion, recognized at the end of the final operating year. Enter zero if not applicable. Values are pre-tax assumptions.
Distinguish actual treated water from contractually billable volume.
Unlevered calculation. Investor cash flow share may differ from funding share.
Variable treatment costs follow actual physical volume, not minimum contracted volume.
—
First operating year unit economics. All figures in nominal IDR.
Funding contributions may differ from cash distribution entitlements.
The model excludes bank financing, interest, distribution waterfalls, dividend withholding taxes, and transaction costs.
From initial investment to the end of the concession, in IDR billion.
Starts at funding year (T0), includes construction and operating years through contract expiry.
| Funding year | Operations | Actual volume m³ | Billable volume m³ | Tariff IDR/m³ | Revenue IDR bn | OPEX IDR bn | EBITDA IDR bn | Depreciation IDR bn | Tax IDR bn | Replacement IDR bn | Terminal IDR bn | Project FCF IDR bn | Investor FCF IDR bn | Cumulative investor IDR bn |
|---|
The model assumes all CAPEX is paid at T0, with no revenue during construction. Actual EPC milestone payments may differ.
Adjust selling price and utilization to assess projection resilience. All example parameters are illustrative.
Single-variable impact on investor IRR without changing base inputs.
| Scenario | Investor IRR | Difference from baseline |
|---|
Minimum starting tariff mathematically meeting the investor target IRR.
Target tariff is solved from investor NPV at the target IRR; it is not a market survey or a guarantee of customer willingness to pay.
Commonly confused investment metrics.
The public simulation assumes 100% equity funding. Project and investor IRR are equal when all project cash flows accrue to the investor.
Project NPV uses the entered WACC / discount rate. Investor NPV at the target IRR is used by the calculator to find the minimum tariff. A positive NPV at the discount rate means the project’s present value exceeds its initial investment under the stated assumptions.
Payback is measured from CAPEX funding at T0 until cumulative investor cash flow turns positive, interpolating annual cash flows. It is not discounted payback and does not represent total contract profitability.
BOT assumes asset transfer at contract expiry, so terminal value is set to zero. Under BOO, assets remain owned and a terminal realization value may be entered, subject to market, contract, and technical validation.
Do not use this model as a final investment memorandum without further verification.