Renewable energy financial modeling: inputs and checks

Renewable energy financial modeling connects electricity sold and contracted prices to the cash a project can retain after operating expenses and debt payments. Build that connection from the planning workbook and actual project exports, with a source for every assumption. The first useful answer is which input changes available cash and by how much.

Start with comparable project records

Use one project, one currency and one reporting period before combining a portfolio. Bring the approved generation schedule, electricity settlement records, operating expense detail, maintenance spending, working capital balances and the debt payment schedule. Add project ID, period, scenario, unit and source reference to each input row.

Separate gross production from the electricity eligible for payment. The EIA definition of net generation deducts the generating station's own electricity consumption from gross generation. Even net generation can differ from billable deliveries because the settlement boundary and contract adjustments matter. Tie the revenue volume to the contract's delivery point.

Capacity is a reasonableness check, not a substitute for measured output. EIA defines capacity factor using energy actually produced relative to continuous full-power production over the same period. Keep capacity and generation in compatible units when reviewing a supplied production estimate.

Use the solar project finance model and wind farm financial model guides for technology-specific inputs. This worksheet starts from approved generation assumptions; it does not engineer them.

Build the cash calculation in a worksheet

For the operating comparison below, define cash available for debt service explicitly:

Cash available for debt service = Electricity revenue − Variable operating cost − Fixed operating cost − Cash taxes − Increase in operating working capital − Maintenance capital spending

Debt coverage = Cash available for debt service / Scheduled interest and principal

This is the example's management definition. A financing agreement may define permitted deductions, reserve movements and coverage differently. Use its definition for any formal covenant assessment.

Set column A to the row label, B to the approved plan and C to a lower-generation case. Enter assumptions in rows 2–11. Costs and an increase in working capital are positive cash uses; a working capital release is negative.

These are illustrative annual inputs for a US project, not market benchmarks. The downside changes electricity sold only; taxes and financing remain supplied assumptions to isolate the output effect.

Enter these formulas in column B and copy them across to C:

B12 = B2*B3
B13 = B2*B4
B14 = B12-B13-SUM(B5:B8)
B15 = SUM(B9:B10)
B16 = IF(B15=0,NA(),B14/B15)
B17 = B14-B15
B18 = B11+B17

The text before each equals sign identifies the destination cell. A period without scheduled debt payments has undefined coverage, rather than an invented zero ratio.

Read the worked cash bridge

Currency amounts are exact; coverage is rounded to two decimals. The plan's cash available is 550,000 − 40,000 − 140,000 − 20,000 − 15,000 − 25,000 = $310,000. Interest and principal total $240,000, leaving $70,000.

The output reduction is 1,000 MWh, or 10%. Revenue falls by $55,000 and variable cost falls by $4,000, so available cash falls by $51,000. The same reduction appears in retained cash and closing cash because every other input is held constant. Storage needs separate charging and discharging economics; see the energy storage workbook.

Prove the result against actuals

Add an Actual column using the same row definitions. Reconcile delivered MWh to settlement records, revenue to the project ledger, and operating expenses to the approved account mapping. Retain separate timing adjustments for invoices earned but not collected and costs incurred but unpaid.

The cash identity must also hold. For the plan, 100,000 + 310,000 − 240,000 = $170,000. A worksheet check in B19 is:

=B18-B11-B14+B15

It must return zero. This simplified example has no financing draws, owner distributions or reserve transfers. Add those as separate signed cash rows when present, then reconcile unrestricted and restricted bank balances separately. A positive retained-cash figure is not permission to distribute it.

The project controller owns the ledger ties. Operations owns generation explanations, and treasury owns the debt schedule and reserve restrictions. Review renewable energy financial ratios separately when the question extends beyond this cash bridge.

Where it goes wrong

• Gross output earns the contract price. Use the billable settlement quantity and disclose any delivery adjustments.
• Annual coverage hides a cash shortage. Repeat the bridge by payment period when collections and debt payments arrive at different times.
• A reserve transfer becomes an expense twice. Identify whether the agreement deducts it before coverage or restricts cash afterward.
• Every cost scales with generation. Fixed leases and staffing should move only when the underlying assumption changes.

Compare your project workbook in Covirage

Upload the planning workbook and actual project export, or bring a Google Sheet with matching project and period columns. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See forecast analysis for the supporting workflow.