Project Finance Modeling: Solar Plant Model

Case study of a 50 mw solar plant, detailing construction in 2021-2022, capex of 2.5 million per mw, a 20-year operation, and debt-and-equity funding with a ppa price per kwh.

Learn to build model timelines for a solar plant project, detailing construction and operation periods, timing flex, and master timeline flags to guide calculations.

Model the construction phase of a 50 megawatt solar plant. Calculate 125 million in capital expenditure spread over 12 months and fund it with an 80/20 debt–equity split.

Explore the operations phase of solar plant project finance by estimating cash flow from operations through revenue, costs, and working capital, to inform debt sizing and repayment planning.

Calculate revenue by multiplying energy generation, from plant capacity and hours with degradation, by the USD per kilowatt hour price escalated from a base price by inflation.

Apply the escalation index to operating and maintenance, insurance, and other costs tied to plant capacity to estimate total operating expenses; construction costs are capex and not included.

Model working capital by building accounts receivable and accounts payable with a control account, linking beginning balances, additions, reductions, and ending balances to the P&L, cash flow, and balance sheet.

Identify decommissioning expenses and establish a reserve using a patrol account approach, spreading 20 years of funding to cover end-of-life cleanup and regulatory requirements.

Model debt and equity by calculating cash flow available for debt service to size the project, then complete construction phase idc, and discuss equity dividends and redemption.

Compute CFADS by revenue minus costs, minus changes in working capital, minus capital expenditures incurred during operations, and minus decommissioning cash flows, focusing on cash components.

Size project debt by applying a 1.3x debt service coverage ratio to determine debt service, then iteratively solve for debt size amid circularity using interest and principal in Excel.

Learn how interest during construction (idc) is calculated in project finance, linking debt draws to total funding and resolving circularity with iterative excel methods.

Explain the dsra as a safety net for creditors, compute the required balance for next year’s debt service, and track transfers and funding.

Calculate cash available for dividends and equity redemption for equity holders in a solar plant project, balancing dividends with retained earnings and debt service.

Create control accounts for fixed assets and IDC, capitalize construction costs on the balance sheet, and apply straight-line depreciation over 20 years to project balances in the integrated financial statement.

Build integrated financial statements by structuring the balance sheet, income statement, and cash flow, then interlink calculations for revenue, costs, depreciation, decommissioning, and taxes across periods with robust controls.

Link revenue to the cash flow and balance sheet to validate interlinking, including dividend and decommissioning costs. Check interlinking across cash flow, balance sheet, debt, tax, and working capital calculations.

Explore project return metrics from sponsors' and creditors' perspectives, and understand debt covenants that constrain cash distributions, set debt capacity, and safeguard repayment based on base case assumptions.

Calculate project and equity returns for a solar plant model by building cash flows from revenue, expenses, depreciation, and taxes. Use xirr to compare equity and project returns.

Explore debt covenants in project finance by calculating debt service coverage ratios and evaluating loan life and project life coverage with historical and forward cash flows.

Master best practices in project finance modeling for solar plants by separating assumptions, calculations, and outputs; ensure consistent formatting and include checks and scenario analysis.