Project finance model XLS: Excel layout and checks

A project finance model XLS workbook should show where construction funding comes from, how operations generate cash and whether that cash covers scheduled debt payments. Keep construction, operations and financing in separate schedules with explicit links. The layout below gives a corporate project team a working structure for reviewing an existing project budget and its cash assumptions.

Build a workbook reviewers can follow

Use columns for periods and rows for inputs, calculations and checks. Include a scenario name and version date on the assumptions worksheet. Label inputs by unit and source, then link schedules to those cells rather than retyping a price or borrowing amount in several places.

Funding and cash generation need separate checks. The Department of Energy's Title 17 financing FAQs explains that project cash flows and credit risk affect leverage. A construction budget that balances does not establish that operations can meet debt payments. This article supplies an operating review layout, not a loan-sizing method.

For driver-based production rows, use the relevant mining workbook layout or agriculture workbook layout. Keep those operating assumptions as inputs to the project cash schedule rather than duplicating the calculations here.

Start with construction sources and uses

Consider a fictional US contracted-service facility. Its construction-period budget includes equipment, installation, construction interest and fees, and cash retained for the start of operations. All amounts below are USD, entered as positive uses or sources.

In a worksheet named Funding, put labels in column A and amounts in column B. Enter uses in rows 2 through 5 and funding sources in rows 8 and 9.

The zero in row 11 is the first check. Phase the inputs across construction months before relying on it: total commitments can cover total uses while money arrives after a supplier payment is due. Add approved contingency funding or other uses as separate rows when applicable.

Microsoft documents that SUM adds all numbers in a range of cells. Keep the range boundaries visible when adding budget lines so a new use does not fall outside the total. Covirage is not affiliated with Microsoft.

Connect operations to debt service

The first operating year starts with the $100,000 initial cash balance included in construction uses. The facility has $800,000 of revenue and the operating assumptions below. Working capital increases by $20,000, representing the net cash absorbed by receivables, operating inventory and payables; that timing adjustment has not already been deducted elsewhere.

Create an Operations worksheet with the following rows. The example assumes all stated costs, taxes and maintenance capital are cash amounts or cash-adjusted amounts. There are no distributions or additional financing during the operating year.

The coverage ratio is displayed to two decimal places; formulas keep the unrounded result. The Department of Energy's Southeastern Power Administration annual report describes debt service coverage as cash available relative to principal and interest payments. The exact definition of available cash for your project must follow its financing documents, including any required reserves or adjustments.

In a period with no scheduled debt service, show an explicit label instead of dividing by zero:

=IF(B10=0,"No debt service",B7/B10)

Do not replace that result with an arbitrary large ratio. Keep periods with no debt service out of numeric coverage comparisons and review the cash balance separately.

Check the debt bridge alongside cash

The opening operating debt balance is $1,200,000. For this simplified example, annual interest is 6% of opening debt and the $200,000 principal payment occurs at year-end. Interest is therefore $72,000 and closing debt is $1,000,000.

Use the supplied repayment schedule when principal falls during the year, rates change or interest accrues on different dates. Keep construction interest out of operating-year interest unless the payment schedule explicitly includes it. The cash remaining after debt service is retained in this example; distributions would require their own cash row.

Change revenue and keep the comparison honest

Reduce annual revenue to $720,000 and hold the other operating and financing assumptions constant. This isolates revenue sensitivity; it does not assume that costs and taxes would always stay fixed in a real downturn.

The $80,000 revenue reduction flows through to available cash and closing cash. Compare the ratios with the actual thresholds in the financing documents; no universal threshold is assumed here. Broader FP&A analysis can use the same scenario labels when reconciling planning outputs to actual operating results.

Where it goes wrong

• Construction cash mixed with operating cash. Record the handoff once so the initial operating balance is neither lost nor counted twice.
• Coverage built from profit. Depreciation and timing differences mean accounting profit is not automatically cash available for debt service.
• Different coverage periods. Annual available cash divided by a quarterly payment produces a misleading ratio. Match the dates.
• Principal omitted from debt service. Interest alone does not capture the scheduled cash obligation.
• A balanced workbook treated as approval. Reconciliations verify links and totals. They do not certify financing terms, covenant compliance or funding availability.

Review your project workbook in Covirage

Bring your funding, project cash and debt schedules, plus the actual revenue and expense exports behind them. Covirage maps the columns, and its tools compute and check the supplied figures; the external AI model explains differences with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See Covirage for project cost control for the supporting project-finance workflow.