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.