Blog · Board and management reporting · Finance and FP&A teams
A project finance dashboard connects operating cash, scheduled debt service, restricted reserves and covenant headroom. This worked US project example includes a cash waterfall, reconciliation checks and a change in collections.
A project finance dashboard connects the cash an operating asset generates with scheduled debt payments, reserve funding and agreement-defined coverage headroom. It should show whether the project can meet its obligations and explain where the cash goes. A large bank balance alone cannot answer those questions.
Project finance depends on project cash flows for repayment within a set of contractual relationships, as EXIM's project finance guidance explains. The reporting unit is therefore the financed project company and its permitted cash flows, rather than an entire sponsor group.
Bring the operating cash workbook, bank reconciliations, debt schedule, reserve statement and relevant finance definitions. Keep project ID, payment date, reporting period, account, currency, amount and source reference on each underlying row. Distinguish actual payments from forecast amounts and invoices that remain unpaid.
The project finance workbook method covers the supporting calculations. This dashboard brings their outputs into a review that treasury, the project controller and asset operations can use together.
Consider an illustrative Arizona solar project company reporting the quarter ended September 30, 2026. All amounts are USD. The example has senior debt only, no new borrowing, no equity distributions, no reserve withdrawals and no financing fees or hedge payments in the quarter.
For this example only, assume the financing agreement defines cash available for debt service, or CFADS, as customer cash receipts less operating payments, cash taxes and maintenance capital spending. It defines debt service as scheduled interest plus principal, and requires quarterly DSCR of at least 1.20x. These are illustrative terms, not market standards.
DSCR = Agreement-defined CFADS / Agreement-defined debt service
Cash headroom = CFADS − Required DSCR × Debt service
Use the signed agreement's definitions in practice. The DFC financial projections guide illustrates why the debt-service denominator must include the relevant interest, fees and scheduled principal rather than interest alone.
| Quarter input or calculation | Amount (USD) | Source or calculation |
|---|---|---|
| Customer cash receipts | 1,200,000 | Reconciled bank receipt rows |
| Operating cash payments | 300,000 | Operating payment rows |
| Cash taxes | 50,000 | Tax payment rows |
| Maintenance capital spending | 50,000 | Approved maintenance payment rows |
| CFADS | 800,000 | 1,200,000 − 300,000 − 50,000 − 50,000 |
| Scheduled interest | 100,000 | Debt schedule |
| Scheduled principal | 400,000 | Debt schedule |
| Total debt service | 500,000 | 100,000 + 400,000 |
| Cash required at 1.20x | 600,000 | 1.20 × 500,000 |
| Cash headroom | 200,000 | 800,000 − 600,000 |
DSCR is 800,000 / 500,000 = 1.60x. Ratio headroom is 1.60x − 1.20x = 0.40x. Display ratios to two decimal places and dollars to whole dollars; calculate from unrounded source amounts.
The treasury lead can see that current-quarter eligible cash covers scheduled debt service. That does not by itself authorize a distribution: other agreement conditions, reserve tests and required approvals may apply.
The project begins with unrestricted cash of $100,000 and a debt service reserve of $500,000. Its illustrative required reserve at quarter-end is $550,000, so it transfers $50,000 into that account after paying debt service.
| Unrestricted cash waterfall | Amount (USD) | Running balance (USD) |
|---|---|---|
| Opening unrestricted cash | 100,000 | 100,000 |
| Customer receipts | 1,200,000 | 1,300,000 |
| Operating payments | −300,000 | 1,000,000 |
| Cash taxes | −50,000 | 950,000 |
| Maintenance capital spending | −50,000 | 900,000 |
| Scheduled interest | −100,000 | 800,000 |
| Scheduled principal | −400,000 | 400,000 |
| Transfer to debt service reserve | −50,000 | 350,000 |
| Equity distributions | 0 | 350,000 |
| Closing unrestricted cash | 350,000 |
The reserve closes at 500,000 + 50,000 = $550,000, exactly its stated requirement. The reserve funding gap is therefore 550,000 − 550,000 = $0. DFC's guide describes the purpose of a restricted reserve as support when a liquidity shortage prevents a scheduled debt payment; it is not ordinary cash available for distribution.
The reserve transfer changes which account holds the money. It does not reduce total project cash. Keep that distinction visible instead of subtracting the transfer twice.
Opening total cash is 100,000 + 500,000 = $600,000. Net external cash movement is 800,000 CFADS − 500,000 debt service = $300,000. Closing total cash must therefore be 600,000 + 300,000 = $900,000, matching 350,000 unrestricted + 550,000 restricted.
| Debt roll-forward | Amount (USD) |
|---|---|
| Opening senior principal | 8,000,000 |
| New debt draws | 0 |
| Principal repaid | −400,000 |
| Closing senior principal | 7,600,000 |
Tie the cash balances to bank reconciliations and the principal balance to the lender statement. The debt payment includes interest, but only principal reduces the loan balance. The controller owns those ties; treasury owns payment and covenant definitions; operations explains changes in receipts and maintenance spending.
Now change only customer receipts to $1,000,000. Hold every other input and the illustrative agreement terms constant. This is a sensitivity, not a forecast of lower generation or prices.
| Dashboard measure | Base case | Lower collections |
|---|---|---|
| Customer receipts (USD) | 1,200,000 | 1,000,000 |
| CFADS (USD) | 800,000 | 600,000 |
| Debt service (USD) | 500,000 | 500,000 |
| DSCR | 1.60x | 1.20x |
| Cash headroom (USD) | 200,000 | 0 |
| Closing unrestricted cash (USD) | 350,000 | 150,000 |
| Closing restricted reserve (USD) | 550,000 | 550,000 |
| Closing total cash (USD) | 900,000 | 700,000 |
The changed CFADS is 1,000,000 − 300,000 − 50,000 − 50,000 = $600,000. Unrestricted cash closes at 100,000 + 600,000 − 500,000 − 50,000 = $150,000. The project meets the illustrative minimum exactly, with no coverage headroom, even though it still has cash in the bank.
Use a project KPI dashboard for broader delivery measures and a financial services dashboard for institution-level reporting. Neither replaces this project's contractual cash definitions.
Upload a file or Google Sheet with a sample of your own project cash, debt and reserve records: Covirage maps the columns, and its tools compute and check the comparisons using the definitions you supply. The external AI model explains the result with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your project export.
See finance planning and reporting for the supporting analysis workflow.
Include operating cash receipts and payments, cash available for debt service, scheduled principal and interest, debt balances, reserve requirements and coverage headroom. Show the reporting period, actual or forecast status, source files and financing definitions beside the figures so users know what each measure means.
No. Coverage compares a defined period's eligible cash flow with its debt service. Bank balances also contain opening cash, financing receipts and restricted reserves. A project may make a payment using accumulated cash while its current-period coverage remains weak. Show both measures and reconcile them separately.
Use a cadence that supports the project's payment dates, finance review and contractual reporting obligations. A monthly internal update can expose changes before a formal test date, but its ratio may differ from a rolling annual or semiannual covenant calculation. Label the period explicitly and retain the required formal calculation.