Project Inputs
Key Formulas
Coverage & Return Metrics
Coverage Ratios Over Time
Cash Flow Analysis
Cash Flow Schedule
| Year | Phase | CFADS | Interest | Principal | Debt Svc | ADSCR | Debt Out | LLCR |
|---|
Sensitivity Analysis: Min ADSCR
Shows how Minimum ADSCR varies with changes in interest rate (rows) and operating cash flow (columns).
| Rate \ CF | -20% | -10% | Base | +10% | +20% |
|---|
Model Assumptions
- Cash flows occur at end of each annual period
- Flat operating cash flows (no escalation)
- Debt is a direct input (not sized to target DSCR)
- No interest capitalized during construction
- Pro-rata equity drawdown during construction
- Level-payment (annuity) debt amortization
Understanding Project Finance Coverage Ratios
Project finance coverage ratios are critical metrics used by lenders to assess a project's ability to service its debt. Unlike corporate finance, project finance loans must be fully repaid from project cash flows, making these ratios essential for structuring and monitoring deals.
Debt Service Cover Ratio (DSCR/ADSCR)
The Annual DSCR measures the project's ability to pay interest and principal from operating cash flow in each period. A DSCR of 1.20x means the project generates 20% more cash than required for debt service. Minimum requirements typically range from 1.20x for low-risk projects to 2.00x for merchant power plants.
Loan Life Cover Ratio (LLCR)
The LLCR provides a forward-looking view by comparing the NPV of all remaining cash flows over the loan term to outstanding debt. It smooths out year-to-year DSCR fluctuations and gives lenders confidence that debt can be fully repaid.
Project Life Cover Ratio (PLCR)
The PLCR extends the LLCR calculation to cover the entire project life. The difference between PLCR and LLCR represents the "debt tail" - extra cash flow capacity after scheduled debt repayment that provides additional security to lenders.
Frequently Asked Questions
Related Calculators
Wharton Online
Financial Planning & Analysis Certificate
Develop FP&A skills for corporate finance leadership with Wharton Online.
- Wharton Online curriculum
- Budgeting & forecasting
- Strategic financial planning
Use code RYANOC for up to $500 off
via