Advanced Renewable Energy Financial Modeling

Create and format a checks sheet that summarizes integrity and signal checks, includes a master payment plan, and uses on/off validation and conditional formatting for real-time error detection.

Link availability and degradation inputs to create a quarterly generation profile that captures seasonality, using flex formulas and flags for a dynamic renewable energy financial model.

Configure PPA and merchant inputs to model end-user choices between a PPA and merchant sales, with pricing, hedged volumes, and inflation options.

Compute merchant and PPA revenues using CPI-linked price curves, real vs nominal terms, inflation indexing, generation allocations, and guarantees of origin within a flexible cash flow model.

Model OpEx for renewables: fixed and variable costs in euros per megawatt and per megawatt hour, CPI-indexed land leases, and a 2% revenue share, with PPA and asset lifetime dynamics.

Model a decommissioning reserve account by configuring additions and release flags, calculating contributions from inputs, and linking the reserve to op ex, cash flow, and the balance sheet.

Model the SPV cash reserve during construction to fund operational expenditures as needed, and link it to the cash flow statement and balance sheet.

Model working capital adjustments and link them to cash flow statements and balance sheets by analyzing debtors and creditors, revenue timing, and operating expenditures using day-based assumptions.

Summarize accounting and tax depreciation, link them to the income statement and tax calculations, and propagate book values to the balance sheet.

Set up tax inputs for a renewable energy financial model, including corporate tax rate, trade and local taxes, generation tax, revenue-based taxes, and interest deductibility switches to model debt shields.

Model equity and debt interactions on the balance sheet and income statement, linking shareholder loans, interest, and principal repayments to tax outcomes and free cash flow to equity.

Link cash from the cash flow statement to determine dividends, model debt service and reserves, apply DCR and other breach flags, and perform balance sheet checks to ensure accuracy.

Automate debt sizing in renewable energy financial modeling by building a master macro that runs capital structure, interest, and principal macros to resolve deltas for sculpted or linear repayment structures.

Model taxable income from EBITDA by applying tax depreciation, tax interest, and tax loss reversal, then compute corporate tax payable using the tax rate and reflect tax credits across statements.

This lecture teaches how to correct equity cash flows by adjusting shareholder loan interest with min and max formulas, preventing capital calls and stabilizing NPV through SHL payment adjustments.

Calculate levered net present value (NPV) using a target IRR of 6% with an XNPV, comparing investor and project developer perspectives to reveal the value delta.

Calculate the payback period for an initial equity investment using cumulative euro cash flows and a quarter-based fraction. Apply if and iferror functions to obtain the precise payback date.

Calculate the unlevered project return by deriving revenues and OpEx into unlevered cash flow, applying working capital and reserve adjustments, including capex during construction, and excluding debt service.

Learn to toggle between investors' and developers' perspectives in an advanced renewable energy financial model, calibrating enterprise value to a target levered IRR with a macro-driven solver.

Explore general project info for a renewable energy model, including case inputs, operating lifetime, installed capacity, annual net production, net capacity factor, hours per year, and integrity and signal checks.

Compute levered and unlevered IRRs and NPVs for the valuation summary, using the target IRR as the discount rate, and include enterprise value, debt service reserve, and SPV cash.

Build a debt service coverage ratio chart in the dashboard using a lookup to pull DCR values by year, then format axes and data labels.