Financial Modelling Best Practices for PPP
Executive Summary
Key Takeaways
- ✓ The payment mechanism, including performance deductions and indexation, should be built directly from the concession contract's formula, not a flat assumed availability payment.
- ✓ Lifecycle capital expenditure should be scheduled against the contract's specific renewal timing and condition standards, funded through an explicit lifecycle reserve mechanism, not treated as ordinary discretionary maintenance.
- ✓ Termination compensation should be calculated at every period using the contract's specific formula for each termination scenario, not a single simplified approximation applied uniformly.
- ✓ Handback costs should be modelled explicitly in the terminal concession years from a technical assessment of the condition standard required, not omitted or left as a placeholder.
- ✓ Following these construction disciplines makes a PPP model easier to review and more likely to pass structural verification cleanly, but it is not itself a verification step.
Why PPP Models Need a Distinct Build Approach¶
A public-private partnership or concession model carries contractual mechanics that a standard project finance model does not: an availability or demand-based payment mechanism, performance deduction regimes, scheduled lifecycle capital expenditure, and termination and handback provisions. How closely a builder ties each of these mechanics to the actual concession contract, rather than a generic assumption, is the central construction question this page addresses.
This page covers construction — how the model should be built — as a companion to the definitional and audit treatment on PPP Model and the independent-verification checks on the PPP Model Checklist.
Core Modelling Components¶
Payment mechanism build. The availability or demand-based payment should be constructed directly from the contract: base payment, performance deduction formulas by failure category, deduction caps, and the specific proportion of the payment subject to indexation. A flat assumed payment stream that omits deduction mechanics cannot represent the revenue risk the contract actually creates.
Lifecycle cost schedule. Capital expenditure required to maintain the asset at the contractual condition standard should be scheduled against the specific timing set out in the concession's technical schedules, funded through an explicit lifecycle reserve account accruing ahead of each event, not modelled as undifferentiated annual maintenance.
Termination compensation formulas. Compensation payable on early termination should be calculated at every period, applying the contract's own formula separately for each termination scenario — government default, private party default, force majeure — since these typically produce materially different outcomes that a single blended approximation cannot represent.
Handback provision. Asset condition obligations at concession end should be built as an explicit terminal-year cost, derived from a technical assessment of the work required to meet the handback standard, funded from operating cash flow or a dedicated handback reserve.
Debt structure under project finance principles. PPP debt is typically non-recourse, secured on project cash flows, and covenant-tested (DSCR, LLCR) throughout the loan life; build this module following the same sculpting discipline described on Project Finance Model Audit, with tenor matched to the concession term less an appropriate tail.
Typical Workbook Structure¶
A well-structured PPP model sequences construction-phase drawdown, the payment mechanism and performance deduction module, the lifecycle cost schedule and reserve, the debt and covenant module, and the termination/handback calculation — following the module ordering already documented in full on PPP Model and the general layout discipline on Workbook Design and Model Architecture.
Common Construction Pitfalls¶
Flat availability payment. Assuming full payment with no deductions, rather than building the actual deduction formula, is the most common construction shortcut and materially overstates revenue in periods where deductions are realistically expected.
Incomplete lifecycle schedules. Omitting lifecycle events from the technical schedule, or underfunding the reserve relative to the timing of each event, is one of the most common sources of understated project cost in this sector.
Simplified termination formulas. Using a single approximate termination compensation calculation rather than the contract's scenario-specific formula misrepresents the government's or lender's actual exposure.
Relationship to Financial Model Audit¶
Building a PPP model to these disciplines makes it easier to review and more likely to pass structural verification cleanly, but construction discipline is not itself verification. These practices do not assess whether the underlying demand, cost, or technical condition assumptions are themselves reasonable — that is a commercial and technical due diligence question. See PPP Model for the full audit-considerations treatment of this model type.
DCF Application¶
A concession's cash flows can, in principle, be valued using standard unlevered DCF logic, but PPP-specific mechanics change how that logic is applied relative to a corporate DCF:
- The payment mechanism drives the cash flow, not a generic revenue forecast. Whether the concession is availability-based or demand-based fundamentally changes the risk profile of the cash flow being discounted, and therefore the appropriate discount rate — an availability-payment concession backed by a government counterparty typically warrants a materially lower discount rate than a demand-risk concession bearing patronage risk.
- Termination compensation formulas effectively cap or floor the DCF's downside. Because termination compensation is calculated contractually rather than emerging from the DCF's own cash flow projection, a full valuation of the concession must consider the termination formula as a distinct value component, not something the base-case cash flow forecast alone captures.
- No perpetuity-style terminal value. As with infrastructure concessions generally, a PPP has a finite, contractually defined term, so the "terminal" value in a PPP DCF is the calculated handback/reversion position, not a Gordon Growth perpetuity — a structural difference from the corporate DCF terminal value methodology described on the DCF Valuation pillar.
Sector-specific DCF glossary terms and technical guides for PPP structures are being added to the DCF Valuation pillar as this domain expands.
Social Infrastructure¶
Hospitals, schools, and other social infrastructure PPPs use the identical availability-payment, performance-deduction, and lifecycle-cost mechanics described above, applied against technical schedules specific to the asset class rather than a different construction discipline. The payment mechanism is built from the same contractual formula approach: a base availability payment subject to performance deductions, typically tied to facilities-management service standards (cleanliness, maintenance response times, equipment uptime) rather than the traffic or demand metrics relevant to some economic infrastructure concessions.
Lifecycle cost scheduling for social infrastructure follows the same reserve-funded discipline described above, but against technical schedules for building fabric, mechanical and electrical systems, and, in a hospital PPP, clinical equipment replacement cycles that are typically shorter and more numerous than the lifecycle events in a comparable economic infrastructure concession. A model that reuses a generic lifecycle schedule from an economic infrastructure precedent, rather than the specific technical adviser's schedule for the social infrastructure asset in question, will misstate the timing and cost of these events.
Facilities management deduction regimes in social infrastructure PPPs are frequently more granular than the availability-based deduction regimes in economic infrastructure concessions, with a larger number of individually tracked service failure categories. The payment mechanism build described above should represent each deduction category the contract specifies, rather than collapsing them into a single blended deduction assumption, since the specific mix of failure categories realized in a given period materially affects the payment outcome.
The construction-phase funding mechanics (sources and uses, interest during construction, drawdown and funding competition) and debt structuring principles described elsewhere on this page and in the Project Finance Modelling technical guides apply identically to social infrastructure PPPs as to any other project finance transaction.
Recommended Practices¶
- Build the payment mechanism directly from the contract's formula, including performance deductions, caps, and indexation basis.
- Schedule lifecycle capex against the contract's specific timing, funded through an explicit reserve mechanism.
- Calculate termination compensation at every period using the contract's own scenario-specific formula.
- Model handback costs explicitly in the terminal years from a technical condition assessment.
- Structure the debt module under standard project finance sculpting principles, tenor matched to the concession term less a tail.
Continue Reading¶
Related Pillars¶
Related Glossary¶
Related Technical Guides¶
- Workbook Design and Model Architecture
- Sources and Uses Modelling
- Reserve Accounts in Project Finance Models
- Inflation and Indexation in Project Finance Models
Related Industries¶
Related Checklists¶
Related Products¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
How should a PPP or concession model be structured?
As a sequence from construction-phase drawdown, to the payment mechanism (availability or demand-based) built from the specific contract formula, to lifecycle capex scheduling, to debt sculpting and covenant testing, to termination and handback calculations, each as its own clearly separated module.
How should the availability payment mechanism be built?
Directly from the contract's formula, including performance deduction categories, deduction rates, payment caps, and the indexation basis, rather than a flat assumed payment stream that ignores deduction exposure.
How should lifecycle capital expenditure be scheduled?
Against the contract's specific renewal timing and condition standards, with a dedicated lifecycle reserve mechanism funding each event, rather than treated as an ad hoc annual maintenance assumption.
How should termination compensation be modelled?
As an explicit calculation at every period, applying the contract's specific formula for each termination scenario, government default, private party default, and force majeure, since these typically produce materially different compensation outcomes.
Should handback costs be included in the model?
Yes, modelled explicitly in the terminal concession years, based on a technical assessment of the condition required at handback, funded from operating cash flow or a dedicated handback reserve.
Does following these construction practices mean the model has been audited?
No. These are disciplines applied by the model's own builder. An independent audit is a distinct check applied after the model exists. See the PPP Model glossary page and PPP Model Checklist for that perspective.
Related Articles
Financial Modelling Best Practices — Standards Compared
Financial modelling best practice is not a single document but a landscape of named institutional standards, each publishing its own conventions for how a model should be structured, formatted, and documented. This page defines that landscape — what a named modelling standard actually is, how the FAST Standard and the ICAEW Financial Modelling Code differ in approach and scope, and how a practitioner chooses between them or applies more than one. It sits beside, not instead of, the Knowledge Centre's structural-foundation page on what makes an Excel financial model reliable — this page is about who has codified that discipline into a named standard, and how those standards compare to one another.
PPP Model
A PPP model (Public-Private Partnership model) is a financial model purpose-built to analyse the economics of a project structured as a public-private partnership. A PPP is a long-term contractual arrangement between a government authority and a private entity in which the private party designs, builds, finances, and/or operates a public asset or service in exchange for a defined payment stream over a concession period. The PPP model reflects the specific structural features that distinguish PPP transactions from standard commercial financing: - A defined concession period (typically 20 to 35 years or more) - A payment mechanism that is availability-based, demand-based, or a combination - Performance deduction regimes that reduce payment when the facility fails to meet defined standards - Lifecycle obligations requiring the private party to maintain the asset to a defined condition throughout the concession - Termination provisions specifying the compensation payable on early contract termination - A handback obligation returning the asset to the government at concession end
PPP Model Checklist
This checklist covers the structural checks specific to public-private partnership (PPP) and concession financial models, on top of the general project finance and financial model audit baseline. It focuses on availability payment mechanism calculations, concession-life and handback assumptions, and demand-risk versus availability-risk allocation. It is intended for government agencies, lenders, sponsors, and advisors reviewing a PPP or concession model ahead of a tender, financial close, or investment decision.
What Is a Project Finance Model Audit?
A project finance model audit is a financial model audit applied to the specific class of model used to finance infrastructure, energy, and long dated capital projects: debt sculpted, multi decade, cash flow driven structures with mechanics that do not appear in a typical corporate model. It is frequently a formal condition of financial close, not an optional check, and lender requirements for it exist almost entirely inside non public bank credit policy rather than any single consolidated public source. This page defines what makes project finance models structurally distinct, why lenders require independent verification of them specifically, and what the audit process looks like in this context.
Workbook Design and Model Architecture
Workbook design and model architecture is the specific skill of deciding how a financial model's worksheets are ordered, how a reader moves through them, how cell types are visually distinguished, and how sheets and files are named. It is distinct from the broader engineering principles covered in Spreadsheet Engineering and the policy-level standards covered in Model Standards — this guide addresses the concrete layout decisions a model builder makes before entering a single formula. A well-architected workbook is not a matter of taste — it determines how quickly a reviewer, lender, or successor analyst can navigate the model and trust what they find.
Discounted Cash Flow (DCF) Valuation
Discounted cash flow (DCF) valuation values a business, project, or asset as the present value of the cash flows it is expected to generate in the future. It is the most theoretically grounded of the major valuation methodologies, resting directly on the principle that a dollar of cash flow is worth more today than the same dollar received in the future, and that value is created when future cash flows exceed what capital providers require as compensation for the time value of money and risk. This page is the hub for the Knowledge Centre's DCF content: what DCF is and why it works, how free cash flow and discount rates are built, how terminal value is calculated and stress-tested, the method variants practitioners choose between, and — distinctively — how DCF failure modes map onto FMAE's existing structural audit rule taxonomy, since no generic valuation resource ties DCF mechanics to a named, testable audit standard.