Project Finance Modeling for Renewable Energy

Explore the basics of power generation and the renewable wind and solar development process, from feasibility studies and permits to PPA negotiations, financial close, financing, construction, and commercial operations date.

Discover how wind energy becomes electricity via a wind turbine’s rotor, blades, gearbox, generator, controller, anemometer, yaw drive, wind vane, and tower, alongside solar photovoltaic systems with inverters.

Differentiate power from energy and compare wind and solar generation using watts to gigawatt hours, then forecast annual energy with nameplate capacity and net capacity factor.

Assess wind and solar resources by prospecting data, measuring site wind speed and solar radiation, and modeling future production with Monte Carlo simulations to yield P50 and P90 profiles.

Model wind energy production with a normal distribution, linking p values and probabilities. Use Excel to compute mean, standard deviation, z-scores, and p values to derive generation profiles.

Explain how renewable projects monetize energy under take-or-pay PPAs for wind and solar, detailing price, committed output, curtailment, penalties, and potential merchant sales and carbon credits.

Explore how the PPA allocates price, volume, and construction risks between the off taker and energy seller, and how milestones, guarantees, and credit enhancements manage project risk.

Examine PPA terms, including default, cure periods 30–90 days, lender step-in rights, transfer, force majeure termination, and post-termination obligations, plus tenor and risk considerations for bankability.

Examine construction contracts for renewable energy projects, comparing the APC turnkey approach with balance of plant arrangements, and highlight fixed price, fixed date, and minimum performance standards.

Examine construction risks under the PPA and APC contracts, including cost overruns, delays, liquidated damages, liability caps, and performance security across TSA and BRP frameworks.

Examine operating costs for wind and solar projects, including O and M, leases, insurance, and salaries, and how O and M contracts with OEMs deliver cost certainty and performance guarantees.

Learn how project finance uses a ring-fenced special purpose vehicle with nonrecourse debt to fund renewable energy infrastructure, relying on project cash flows rather than sponsor collateral.

Shows how a nonrecourse, ring-fenced SPV enables high leverage, shields sponsors, and secures long-term revenue from a PPA.

Explore the major sources of financing for renewable projects, including sponsor equity (industrial, financial, tax equity) and debt from banks, bonds, export agencies, and multilateral lenders.

Explore the construction loan framework for renewable energy projects, covering conditions precedent, use of proceeds, drawdowns, interest and fees, representations, covenants, defaults and remedies, plus security and sponsor support agreements.

Size debt for renewable energy projects by linking cash flows to debt service, using the debt service coverage ratio and interest rate spread, while accounting for project risk and tenure.

Learn how to size project debt using debt service and the debt service coverage ratio, applying present value of debt service at the debt interest rate, and exploring tenor effects.

Explore how project finance uses control accounts to monitor cash and regulate allocation, with a cash flow waterfall guiding proceeds from loan draws to debt service and reserves.

Explore covenants in project finance, including information, financial, and general covenants; learn ratios like DSCR and project life coverage ratio, cash lockup and cash sweep, and how covenants trigger defaults.

Break down complex financial models into calculation blocks, convert vertical base rates to horizontal, use lookup and if error, and compute quarterly all-in rates for term loan interest.

Explore linking inputs across worksheets in financial models by pasting links from the timing worksheet, then use F4 to toggle absolute and row anchoring to preserve links when moving rows.

Learn how to avoid daisy chains in financial models by using anchored links and paste link techniques, improve navigation, and color-code exported and imported links to streamline project finance modeling.

Use placeholders to store temporary inputs in calculation sheets, replacing hard-coded values with linked inputs from the input worksheet, enabling modeling when data is not yet available.

Master essential Excel shortcut keys for financial modeling in renewable energy projects, including navigation across worksheets, copy and paste operations, linking, paste special, deletion, charting, and cell anchoring.

Learn how to anchor cells in Excel for financial modeling by using absolute references and relative references, using F4 to toggle dollar signs, enabling correct formulas across rows and columns.

Explore how Excel represents dates as serial numbers from day one, and use date, edate, and eomonth functions to calculate beginnings and ends of periods in a quarterly model.

Learn how to build Excel-based financial models using the IF function, mastering logical tests, nested conditions with AND and OR, and date comparisons for project operations and close dates.

Explore the sumif function in Excel to consolidate semiannual data into annual totals. Use criteria-based lookups to compute yearly revenue and asset depreciation for renewable energy project finance.

Learn to apply vlookup, look-up, and index-match to convert vertical CPI data into horizontal time series and retrieve inflation rates for project finance modeling.

Learn how to use max and min functions in Excel to extract positive and negative cash flow numbers for financial modelling.

Explore the financial model framework for renewable energy projects, including input sheet, monthly construction, quarterly operations, macro sheets, and scenario manager, to enable debt sizing and three-way financial statements.

Project finance modeling for renewable energy uses binary flags and a timeline to model construction and operation phases, debt drawdown, refinance, and revenue under quarterly end dates.

Build model dates for a quarterly renewables project finance model using a column counter and flags. Apply if functions and date formulas to derive financial period beginnings, ends, and years.

Model flags in Excel to mark financial closed date and pre financial closed date. Use if and conditional formatting to display and visualize these flags.

Model flags for construction period, operation start, and completion in a renewable energy finance model. Use financial closed date, 12-month construction, month-end end date, and if logic for quarterly 0/1 flags.

Learn to build and color-code a project finance timeline in excel by modeling operations and post-operations flags, linking start and end dates, and applying conditional formatting.

Recap energy generation modeling for renewable projects by calculating gross generation from capacity, hours, seasonality, and net capacity factor, then apply curtailment and solar degradation to obtain net energy generation.

Model energy generation by calculating gross generation from capacity and P50 capacity factor, applying operation period, days, and hours, then adjust for curtailment and solar degradation to yield net generation.

In this lesson, incorporate the energy generation seasonality factor into the forecast using a time-series look-up, adjust gross generation, and link to net generation for the wind project.

Model energy sales for a 50 MW project over 30 years, with 20 years of ppa revenue at $40/MWh and 10 years of merchant sales at $45/MWh, both escalated 1.5%.

Model renewable energy project revenue by linking net generation to energy sales, covering the PPA period and merchant sales after expiry with an escalation factor.

Model variable costs for renewable projects—including four dollars per MWh, land royalty 2% of revenue, and 1% revenue insurance—and fixed costs of 790k plus 70k admin, escalated 1.5% annually.

Model operating costs for a renewable project, including variable o&m, land royalty, and insurance, plus fixed admin costs, escalated and linked to revenue to compute EBITA.

Explore how working capital drives cash flow in project finance, using accounts receivable and accounts payable timing to illustrate the funding gap and ebitda adjustments.

Model the working capital block by forecasting accounts receivable and accounts payable under a 30-day off taker credit to translate revenue timing into cash flow.

Explore capital expenditures and PPE, and learn how depreciation spreads asset cost over its useful life using straight-line depreciation, including how interest during construction can be capitalized.

Model the property, plant and equipment (PP&E) balance and book depreciation, linking depreciation to the PP&E calculation. Export results to the financial statements and assume construction costs to drive PPD.

Understand how current and deferred tax expenses differ from cash taxes due to temporary differences in depreciation methods, including straight-line versus accelerated (makers), and how this creates deferred tax liabilities.

Explore how net operating losses generate deferred tax assets on the balance sheet, enabling future tax benefits as losses offset taxable income in project finance modeling for renewable energy.

Model tax depreciation with accelerated methods using five-year makers schedule, compare to book depreciation, and build ppe balances while applying quarterly vlookup to project tax paid and deferred taxes.

Model taxes on renewable energy project by calculating earnings before tax for tax purposes, taxable income from net operating losses, depreciation, tax paid, and deferred tax assets and liabilities.