# PPP Availability Model Build a public-private partnership model for social infrastructure projects with availability-based revenue, sculpted debt sizing, lifecycle reserve mechanics, and equity return analysis over a 25 to 30 year concession. - Canonical: https://finamodel.com/templates/ppp-availability-model - Excel download: https://finamodel.com/templates/ppp-availability.xlsx - Category: Infrastructure - Model type: Project finance - Difficulty: Advanced - Audiences: Public sector, Developers & sponsors, Infrastructure sponsors, Project developers, Equity investors, Lenders - Tags: ppp, availability-payments, dscr, equity-irr, public-private ## Overview Determine PPP infrastructure project viability under availability-payment structuring, where the government grantor guarantees a minimum annual unitary fee regardless of usage, reducing private sector demand risk. This template projects project traffic demand and corresponding toll/usage revenue, models availability payment mechanics with inflation indexing, and calculates debt service coverage ratio (DSCR) by year. The debt sculpting mechanism maintains target DSCR (typically 1.25–1.35x) by tailoring principal repayment as usage rises, while interest-reserve accounts ensure lenders are protected during ramp-up. The workbook includes traffic forecasts with ramp-up profiles (new infrastructure typically reaches 80–100% of mature demand over 2–3 years), opex assumptions (O&M scales with asset condition and usage), a debt schedule with sculpted amortisation, and a waterfall that prioritizes debt service, covenant monitoring (DSCR, leverage ratios), equity distributions, and reserve funding. The model calculates both project IRR (on unlevered cash flows) and equity IRR (on levered distributions). It handles both operating years and any construction phase with interest capitalization. Target users are pension funds, infrastructure investment advisors, public-sector sponsors, and project finance lenders evaluating PPP projects ranging from toll roads and rail concessions to water/utility assets valued at $500M to $5B+. ## What's included - Unitary charge calculation with indexation and abatement logic - Sculpted debt sizing to target constant DSCR - Lifecycle maintenance reserve funding and release mechanics - Construction phase modelling with interest capitalisation - Equity IRR and project-level return outputs - Traffic or usage forecast assumptions and growth rates - Availability payment calculation and annual escalation - Operating expense and maintenance cost schedules - Debt schedule, interest, and principal repayment - Debt service coverage ratio and covenant monitoring - Equity IRR and return on invested capital by scenario ## PPP Availability Model: How the Template Works and When to Use It This PPP availability model template lets you evaluate an availability-payment PPP for social infrastructure. It covers a 25–30 year concession, with revenue driven by an indexed unitary charge, sculpted senior debt to a target DSCR, lifecycle reserve mechanics, and equity return analysis. Use it to check whether a project earns acceptable equity returns while debt clears covenants. ### Revenue drivers and cost structure The PPP availability model template captures revenue through a single indexed unitary charge. The gross payment grows annually by an inflation factor. - Deductions for unavailability and poor performance are subtracted to arrive at net availability revenue. Crucially, there is no demand or volume term in the revenue build. - This reflects the availability-payment structure, where the SPV bears no demand risk. Operating costs are split into hard and soft facilities management, insurance, and SPV administration. Lifecycle major maintenance is handled separately via a reserve account, not as an annual P&L line, because refurbishment spend is lumpy and pre-funded. ### Debt sculpting and cover ratios Senior debt is sculpted to a target DSCR. The effective sculpting DSCR is calculated as the NPV of pre-financing CFADS divided by senior debt drawn. - Principal repayments are set so that total debt service equals the target, amortising the loan exactly over the tenor. This avoids a balloon payment at maturity. - The covenant DSCR floor is a separate input used only for verification, not to floor the sculpt ratio. The model also computes DSCR, LLCR, and PLCR. Pre-financing CFADS excludes tax to keep the model non-circular. These mechanics help you assess whether the debt structure is robust under the project's cash flows. Calculation summary: ```text The effective sculpting DSCR = the NPV of pre-financing CFADS ÷ senior debt drawn ``` ### Cash flow waterfall and reserves The cash flow waterfall follows strict priority. CFADS equals EBITDA minus tax and working capital changes. - From CFADS, senior debt service is paid first, then any DSRA top-up, then the MMRA contribution. What remains is distributable cash, which is paid out as equity distributions, with any residue retained. - Two reserve accounts are central: the DSRA, funded at COD and maintained at a target based on forward debt service, and the MMRA, which accumulates a level annual charge to fund periodic refurbishment every fifth operating year. The model includes checks to ensure neither reserve goes negative and that deductions do not exceed gross revenue. ### Outputs and practical use The model produces project and equity IRRs, NPVs, MOIC, and payback, alongside a full three-statement set that balances each period. It includes integrity checks for sources and uses, debt repayment, DSCR compliance, and reserve balances. - Two sensitivity grids show how equity IRR responds to construction-cost overruns and availability-deduction rates, and how minimum DSCR varies with senior margin and indexation. This template is designed for evaluating availability-payment PPPs in social infrastructure. - It is not a demand-risk model. The public download is a values-only preview, so you can explore the relationships without live formulas. ## Built for infrastructure concessions Use this model when you need to price an availability-based PPP, size debt against sculpted cash flows, or evaluate equity returns over a long concession period. ## Structured around project finance standards A useful PPP model needs sculpted debt, reserve accounts, and lifecycle costing that reflect how infrastructure projects are actually financed and evaluated. ## Better for bid and lender work This gives you a proper project finance framework instead of a generic cash flow model that does not account for concession mechanics, indexation, or coverage ratios. ## Built for infrastructure concessions Use this model when you need to price an availability-based PPP, size debt against sculpted cash flows, or evaluate equity returns over a long concession period. ## Structured around project finance standards A useful PPP model needs sculpted debt, reserve accounts, and lifecycle costing that reflect how infrastructure projects are actually financed and evaluated. ## Better for bid and lender work This gives you a proper project finance framework instead of a generic cash flow model that does not account for concession mechanics, indexation, or coverage ratios. ## Features - **Availability payment mechanics:** Models unitary fees indexed to inflation, adjusted for availability penalties and performance deductions. - **Debt service coverage tracking:** Calculates DSCR from operating cash flows to ensure compliance with lender covenants and headroom. - **Equity waterfall and IRR:** Tracks distributions to equity holders after debt service and covenant compliance to show leveraged returns. ## Use cases - **PPP project bid and feasibility:** Model sponsor equity returns and debt serviceability to evaluate bid pricing and project attractiveness. - **Lender due diligence and covenant setting:** Stress-test coverage ratios under downside scenarios to support debt sizing and financial covenants. - **Equity investor returns analysis:** Show IRR, cash-on-cash returns, and payback period to support investment committee decisions. ## Frequently asked questions ### What is a PPP availability payment model? It is a project finance model for public-private partnerships where the private partner earns revenue through availability payments rather than user charges or tolls. ### What should a PPP model include? It should include unitary charge calculations, sculpted debt, DSCR and LLCR metrics, lifecycle costing, construction phase modelling, and equity return outputs. ### Who uses PPP availability models? Infrastructure developers, project finance lenders, financial advisors, and government agencies use them for bid pricing, due diligence, and value-for-money analysis. ### What is debt sculpting? Debt sculpting adjusts principal repayments so that debt service matches available cash flow over time, typically targeting a constant DSCR throughout the concession. ### Does this cover the construction phase? Yes. The model includes construction period modelling with interest capitalisation and drawdown scheduling before transitioning to the operations phase. ## Related templates - [Project Finance Debt Sculpting Model](https://finamodel.com/templates/project-finance-sculpting-model) - [Railway Concession and Operations Model](https://finamodel.com/templates/rail-concession-model) - [Toll Road Concession Model](https://finamodel.com/templates/toll-road-model)