Patrick DeCorla-Souza
P3 Program Manager
Center for Innovative Finance Support
Wim Verdouw
Financial Modeler
IMG/Rebel
Intro - Project Background
Part A - Financial Viability of Conventional Delivery
Part B - Financial Viability of P3 Delivery
Recap - Summary of Webinar
A study was done previously by a state DOT to estimate VfM and net social benefits of P3 delivery for a highway project. The various inputs required for the analysis are included in the P3-VALUE 2.0 spreadsheet model.
Item | Nominal values | |
---|---|---|
PSC | P3 | |
Pure risks | 121 | 109 |
Base variability | 112 | 104 |
Lifecycle performance risk | 574 | 515* |
Revenue uncertainty adjustment | 377 | 382* |
Total risks transferred under P3 (row 45) | 1,184 | 1,110 |
* P3 transferred risks that are accounted for in P3 weighted average cost of capital (WACC)
Year | Average Daily Traffic Volume (in thousands) |
---|---|
2015 | 25 |
2020 | 30 |
2030 | 35 |
2040 | 40 |
2050 | 45 |
> 2050 | 1.00% |
Traffic Type | Toll Rate ($/vehicle) |
Passenger cars - Weekday Peak | 4.00 |
Passenger cars - Weekday Off-peak | 2.00 |
Passenger cars - Weekend | 2.00 |
Trucks - Weekday Peak | 6.00 |
Trucks - Weekday Off-peak | 4.00 |
Trucks - Weekend | 4.00 |
Financing Condition | Value |
---|---|
Debt maturity: | 35 years |
Debt interest rate: | 4 % |
Minimum required DSCR: | 1.3 |
Public subsidy allocated to project: | $100 M. |
Financing Condition | Value |
---|---|
Cost of equity | 12%. |
Gearing (debt-to-equity ratio) | 75% |
Debt maturity | 30 years |
Debt interest rate | 6% |
Equity bridge loan interest rate | 6% |
Minimum required DSCR | 1.3 |
Subsidy allocated to project: | $100 M. |
Base Case: Given scope, revenues and financing conditions.
Please stand by as we open the Excel file
Base Case
Test 1: Base case plus DSCR of 1.2
Test 2: Test 1 case plus 40-year debt maturity
Test 3: Test 2 case plus 3% interest rate
Conventional Delivery - Debt service coverage ratio | Ratio | Unit |
---|---|---|
Average calculated DSCR | 1.30 | ratio |
Minimum calculated DSCR | 1.30 | ratio |
Minimum calculated vs. minimum required DSCR alert | - | alert |
Conventional Delivery - Sources of funding and financing | Amount | Unit |
---|---|---|
Debt amount | 334,775 | USD k |
Subsidy/milestone payment | 110,408 | USD k |
Additional required subsidy | 171,611 | USD k |
Total sources of funding and financing | 616,794 | USD k |
Conventional Delivery - Debt service coverage ratio | Ratio | Unit |
---|---|---|
Average calculated DSCR | 1.20 | ratio |
Minimum calculated DSCR | 1.20 | ratio |
Minimum calculated vs. minimum required DSCR alert | - | alert |
Conventional Delivery - Sources of funding and financing | Amount | Unit |
Debt amount | 362,789 | USD k |
Subsidy/milestone payment | 110,408 | USD k |
Additional required subsidy | 146,798 | USD k |
Total sources of funding and financing | 619,996 | USD k |
Test 2: Increase Debt Maturity
Conventional Delivery - Debt service coverage ratio | Ratio | Unit |
Average calculated DSCR | 1.20 | ratio |
Minimum calculated DSCR | 1.20 | ratio |
Minimum calculated vs. minimum required DSCR alert | - | alert |
Conventional Delivery - Sources of funding and financing | Amount | Unit |
---|---|---|
Debt amount | 418,638 | USD k |
Subsidy/milestone payment | 110,408 | USD k |
Additional required subsidy | 95,663 | USD k |
Total sources of funding and financing | 624,708 | USD k |
Conventional Delivery - Debt service coverage ratio | Ratio | Unit |
---|---|---|
Average calculated DSCR | 1.20 | ratio |
Minimum calculated DSCR | 1.20 | ratio |
Minimum calculated vs. minimum required DSCR alert | - | alert |
Conventional Delivery - Sources of funding and financing | Amount | Unit |
---|---|---|
Debt amount | 503,152 | USD k |
Subsidy/milestone payment | 110,408 | USD k |
Additional required subsidy | 7,122 | USD k |
Total sources of funding and financing | 620,682 | USD k |
Scenario | Debt size ($M) N12 | Average calculated DSCR N7 | Minimum calculated DSCR N8 | Subsidy ($M) N13+N14 |
---|---|---|---|---|
Base Case: Sculpted with 30-year maturity, minimum DSCR 1.30, 4% interest rate, default tolls | 334.4 | 1.30 | 1.30 | 282.0 |
Test 1: Reduce minimum DSCR to 1.20 | 362.8 | 1.20 | 1.20 | 257.2 |
Test 2: Increase debt maturity to 40 years | 418.6 | 1.20 | 1.20 | 206.1 |
Test 3: Lower interest rate to 3% | 503.2 | 1.20 | 1.20 | 117.5 |
Submit a question using the chat box
Base Case: Given scope, revenues and financing conditions
Please stand by as we open the Excel file
Base Case
Test 1: Reduced DSCR, increased debt maturity and lower interest rate
Test 2: Test 1 Case plus increased leverage
Test 3: Test 2 Case plus increased revenues
P3 - Debt service coverage ratio | Ratio | Unit |
---|---|---|
Average calculated DSCR | 1.63 | ratio |
Minimum calculated DSCR | 1.63 | ratio |
Minimum calculated DSCR vs. minimum required DSCR alert | - | alert |
P3 - Sources of funding and financing | Amount | Unit |
Debt amount | 238,618 | USD k |
Subsidy/milestone payment to Developer | 108,243 | USD k |
Additional required subsidy to Developer | 96,812 | USD k |
Equity contribution | 79,539 | USD k |
Total sources of funding and financing | 523,212 | USD k |
P3 - Financial outputs | Value | Unit |
Equity IRR (post tax) | 12.00% | % p.a. |
P3 WACC | 8.84% | % p.a. |
P3 - Debt service coverage ratio | Ratio | Unit |
---|---|---|
Average calculated DSCR | 1.89 | ratio |
Minimum calculated DSCR | 1.89 | ratio |
Minimum calculated DSCR vs. minimum required DSCR alert | - | alert |
P3 - Sources of funding and financing | Amount | Unit |
Debt amount | 268,187 | USD k |
Subsidy/milestone payment to Developer | 108,243 | USD k |
Additional required subsidy to Developer | 51,926 | USD k |
Equity contribution | 89,396 | USD k |
Total sources of funding and financing | 517,752 | USD k |
P3 - Financial outputs | Value | Unit |
Equity IRR (post tax) | 12.00% | % p.a. |
P3 WACC | 8.02% | % p.a. |
P3 - Debt service coverage ratio | Ratio | Unit |
---|---|---|
Average calculated DSCR | 1.66 | ratio |
Minimum calculated DSCR | 1.66 | ratio |
Minimum calculated DSCR vs. minimum required DSCR alert | - | alert |
P3 - Sources of funding and financing | Amount | Unit |
Debt amount | 305,624 | USD k |
Subsidy/milestone payment to Developer | 108,243 | USD k |
Additional required subsidy to Developer | 29,894 | USD k |
Equity contribution | 76,406 | USD k |
Total sources of funding and financing | 520,167 | USD k |
P3 - Financial outputs | Value | Unit |
Equity IRR (post tax) | 12.00% | % p.a. |
P3 WACC | 7.66% | % p.a. |
P3 - Debt service coverage ratio | Ratio | Unit |
---|---|---|
Average calculated DSCR | 1.66 | ratio |
Minimum calculated DSCR | 1.66 | ratio |
Minimum calculated DSCR vs. minimum required DSCR alert | - | alert |
P3 - Sources of funding and financing | Amount | Unit |
Debt amount | 314,722 | USD k |
Subsidy/milestone payment to Developer | 108,243 | USD k |
Additional required subsidy to Developer | 18,565 | USD k |
Equity contribution | 78,680 | USD k |
Total sources of funding and financing | 520,210 | USD k |
P3 - Financial outputs | Value | Unit |
Equity IRR (post tax) | 12.00% | % p.a. |
P3 WACC | 7.66% | % p.a. |
Scenario | Equity ($M) N30 | Equity IRR N34 | Minimum DSCR N23 | Concession fee/subsidy ($M) N28+N29 |
---|---|---|---|---|
Base Case: Sculpted with 30- yr maturity, minimum DSCR 1.30, gearing 75%-25%, 6% interest rate, default toll rates | 79.5 | 12.00 | 1.63 | 205.1 |
Test 1: Reduce DSCR to 1.25x, increase maturity to 35 years, lower interest rate to 5% | 89.4 | 12.00 | 1.89 | 160.2 |
Test 2: Increase gearing to 80%-20% | 76.4 | 12.00 | 1.66 | 138.1 |
Test 3: Increase peak tolls for passenger cars by $0.25 | 78.7 | 12.00 | 1.66 | 126.8 |
Submit a question using the chat box
Intro - Project Background
Part A - Financial Viability of Conventional Delivery
Part B - Financial Viability of P3 Delivery
P3-VALUE 2.0 Excel Spreadsheet
FHWA's Center for Innovative Finance Support Website:
https://www.fhwa.dot.gov/ipd/
P3 Website:
https://www.fhwa.dot.gov/ipd/p3/
Submit a question using the chat box
Patrick DeCorla-Souza
P3 Program Manager
Center for Innovative Finance Support
Federal Highway Administration
(202) 366-4076
Patrick.DeCorla-Souza@dot.gov