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.

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.

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.

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.