The brief: build a project finance model for a Build-Operate-Transfer (BOT) toll road concession to investment-banking standards.
What we delivered: a nine-sheet model with over 1,000 linked formulas and zero errors, modelling the full concession life with standard IB colour coding — blue inputs, black formulas, green links.
Headline outputs: Project IRR 13.0%, Equity IRR 17.9%, Equity NPV ~INR 121 Cr, average DSCR 1.89x — and a balance sheet that ties in every year of the concession.
Why it matters: lenders and equity investors read the DSCR profile and the IRR spread before anything else. This model gives both, transparently, with every driver traceable.
Download the BOT toll road model (XLSX)
Raising or appraising infrastructure debt or equity? Get a model built.
BOT Toll Road Project Finance Model: IRR, DSCR and Investor Returns