Advanced Renewable Energy Financial Modeling

Outline the contractual relations of a project company in project finance, centered on a special purpose vehicle, with investment, EPC, EPCM contracts, financing, and power purchase agreements shaping cash flows.

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.

Select depreciation categories for construction costs using straight-line or reducing-balance methods for accounting and tax. The lesson covers inputs setup, data validation, and quarterly depreciation calculations.

Learn to define power generation inputs, including the in-store capacity of 50 megawatt peak, monthly production profile, plant availability, degradation, and p50, p75, and p90 scenarios.

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.

Compute net power generation by tying P50 and capacity to a life-scenario generation profile via sumproduct, then apply availability and degradation to obtain net production.

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.

Link operational expenditures from inputs to calculations, including fixed and variable costs with inflation indexing, and integrate into the cash flow statement.

Set up the major maintenance reserve and decommissioning reserve accounts, detailing contributions for modules, inverters, cables, and other costs, with releases at ten and twenty years.

Set up decommissioning reserve inputs by calculating net costs from €25,000 per megawatt peak and €10,000 proceeds, inflating with CPI, and scheduling savings ten years before decommissioning.

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.

Learn to calculate accounting and tax depreciation for renewable energy assets, including capitalization of costs into a depreciation base, using straight-line and reducing-balance methods with depreciation categories.

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.

Choose between a sculpted or linear debt repayment structure and set up debt inputs for sizing and scheduling, including DCR targets and covenant considerations.

Model a sculpted debt repayment structure by linking inputs, calculating committed capital, and aligning debt service with cash flow available for debt service using a debt service coverage ratio target.

Build and integrate a debt structure macro within an applied capital structure, choose between linear and sculpted repayments, and break circular references with paste-as-values techniques.

Learn to build debt interest and principal macros in Excel using VBA, including naming ranges, calculating deltas, and wiring buttons to automate copying and pasting values.

Model the debt service coverage ratio using target and actual dscr, with quarterly and last-12-month views, and assess covenant breach triggers.

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.

Explore the capital structure macro to optimize debt sizing, shareholder loan, and equity under gearing ratio and DCR targets. Automate debt sizing with sculpted and linear repayment checks.

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.

Compute unlevered taxes by excluding interest to reveal corporate tax on taxable income, compare levered and unlevered returns, and illustrate the tax effects of gearing.

Learn how to model a debt service reserve account in a project finance framework, funding six months of forward-looking debt service to protect loan repayment.

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.

Explore unlevered equity return modeling with free cash flow to equity, cash balance brought forward, cash available for distribution, and dividend payout logic across construction and operations periods.

Compute unlevered IRR and NPV by adjusting references and anchoring inputs. Compare levered and unlevered scenarios to quantify debt's impact on project value.

Analyze unlevered FCFE and invested equity to determine the payback period under levered and unlevered scenarios, including working capital adjustments and a product formula.

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.

Implement a universal master macro from the developers perspective to drive debt sizing and capital structure, using scenario calculate and scenario valuation to manage cases.

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.

Integrate investment ratios and multiples for renewable energy assets, including enterprise value per megawatt peak and per megawatt hour, and evaluate cash flow, payback, and levered versus unlevered returns.

Set up a charts sheet from the timing sheet and define year flags. Use a sum if function to map merchant revenue, PPA revenue, and other income by year.

Create a dynamic revenue chart using named ranges from the name manager to display merchant, contracted, other, and total revenue on a dashboard that updates with asset lifetime via macro.

Develop and visualize the fcfe chart by linking fcf to equity to levered and unlevered cases on a dashboard, using a clustered column and a cumulative line.

Finish building a cash flow waterfall chart in Excel, naming series for total revenue, opex, interest, principal, and dividends, then map debt and equity cash flows with reserve releases.

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.