Cross-sector tool

Cash-flow & DCF model

A standard, asset-aware cash-flow template. Pick an asset type, set every major revenue and cost line on a slider, then read a full year-by-year projection — line items down, years across — and the DCF it implies: unlevered and levered IRR, NPV, equity multiple and payback.

Asset type

—

Revenue lines · year-1 ($m)

Operating cost lines · year-1 ($m)

Assumptions

Growth & operating

Projection yearsy

Revenue growth p.a.%

Cost inflation p.a.%

Maintenance capex%

Depreciation%

Tax rate%

Valuation

Discount rate (WACC)%

Entry EV / EBITDA×

Exit EV / EBITDA×

Financing

Leverage (Net debt / EBITDA)×

Cost of debt%

Debt amortisation p.a.%

Unlevered IRR

—

asset return

Levered IRR

—

to equity

NPV @ WACC

—

unlevered, net of entry

Equity multiple

—

MOIC

Payback

—

undiscounted

Avg EBITDA margin

—

over the hold

Projection · line items × years ($m)

Unlevered free cash flow by year■ entry ■ operating ■ incl. exit

Illustrative model. Figures are in generic $m and are not a forecast of any specific asset. EBITDA = revenue − operating costs; unlevered FCF = EBITDA − cash tax − maintenance capex; the DCF discounts unlevered FCF (plus an exit at the EV/EBITDA multiple) at the chosen rate. Levered cash flow is after debt drawn at entry, interest and amortisation. Excludes transaction costs, working capital, refinancing and construction phasing. For illustration only — not investment advice.