GUIDE TO THE CALCULATION
Methodology, worked examples and limitations
Investment appraisal methodology and assumptions
The investment appraisal calculator builds an unlevered annual project-cash-flow forecast. It combines initial capital expenditure (CAPEX), initial working capital, operating revenue, cash operating expenditure (OPEX), a simplified income-tax charge and terminal recovery. It then calculates NPV, IRR, a profitability index, simple ROI and payback periods. It is an initial financial screening model, not a complete bankable feasibility study.
Construction of the cash flows
At year zero the model records an outflow equal to initial CAPEX plus initial working capital. For each subsequent year, revenue grows by the entered annual revenue-escalation rate and OPEX grows by the entered OPEX-escalation rate. The model assumes straight-line depreciation of CAPEX across the modeled operating life. Tax is calculated at the entered rate only on positive earnings before interest and tax after depreciation. Annual operating cash flow equals revenue minus cash OPEX minus the calculated tax charge. At the end of the last year the model adds the assumed net residual proceeds and full recovery of the initial working capital.
For example, with initial CAPEX of USD 1,500,000, a ten-year operating life and no other depreciation adjustments, the modeled annual depreciation is USD 150,000. If first-year revenue is USD 450,000 and cash OPEX is USD 180,000, earnings before depreciation and tax are USD 270,000 and modeled taxable earnings are USD 120,000. At an illustrative 9% tax assumption, the tax charge is USD 10,800 and first-year cash flow is USD 259,200. The correct tax treatment must be assessed under the actual legal and accounting circumstances, not inferred from this example.
How to use the output
Positive NPV means the forecast exceeds the return threshold implied by the selected discount rate, on the model assumptions. IRR is a useful comparative indicator but should not replace NPV where projects differ in size, timing or risk. The profitability index relates discounted future receipts to initial investment; an index above one corresponds to a positive NPV for the conventional model. The discounted payback period measures recovery after allowing for time value of money, not profitability over the full project life.
Model limitations: no financing structure, debt service, tax-loss carryforwards, deferred taxes, VAT cash-flow timing or staged CAPEX are modeled. The assumed tax rate is illustrative. Test alternative utilization, tariffs, operating costs, construction delays and residual values before relying on the result. For a basic cash-flow analysis without depreciation assumptions, compare the ROI, NPV & IRR Calculator.
