Skip to content

Training course

Effective Finance Modelling in the Power Industry Course

Build a power project investment model with revenue, debt, risk and dashboard modules, for analysts, engineers and commercial staff

Next date
Madrid (Spain)
Duration
One week
Fees
Classroom from £5,200
Course code
FA97

Introduction:

In this 1-week Effective Finance Modelling in the Power Industry Course, you learn to build, test and explain the cash flow models that show whether a power generation asset earns an acceptable return. You leave with a working investment decision model for a power project, complete with revenue, financing, risk and dashboard sheets. You need confident spreadsheet skills and a working grasp of basic finance terms such as NPV and IRR; no earlier energy modelling is assumed. You practise through a modelling build, adding one module each day and testing it against thermal and renewable cases.

Course Objectives:

  • Build a structured spreadsheet template for a power project with inputs, calculations and a KPI summary sheet
  • Forecast generation output, energy prices and operating costs in a revenue and cost module of your own model
  • Size debt on DSCR and calculate WACC in a financing module that drives project and equity returns
  • Run sensitivity tables, Monte Carlo simulation and stress tests on the key drivers of your model
  • Model PPA pricing and ESG factors as switchable inputs within your investment case
  • Present model results through a dynamic decision dashboard built from your own outputs

Target Audience:

  • You build or review financial models for power plants, renewable assets or utility investments
  • You prepare business cases, budgets or valuations for generation projects
  • You are an engineer who supplies output, capex or O&M assumptions and wants to see how they drive returns
  • You negotiate, price or manage power purchase agreements and offtake contracts
  • You analyse funding requests or credit papers for energy projects on the lender or investor side

Course Outline:

Day 1: Laying the Foundations of Power Industry Financial Modelling

  • Mapping Power Market Economics, Merit Order and Price Formation
  • Defining Project KPIs: IRR, NPV, LCOE and DSCR
  • Structuring Flexible Spreadsheet Models With Inputs, Calculations and Outputs
  • Documenting Models Using FAST Standard Layout and Assumption Logs
  • Build: Power Project Model Template With KPI Summary Sheet

Day 2: Modelling Revenue and Costs for Power Projects

  • Forecasting Generation Output Using Capacity Factors and P50/P90 Yields
  • Projecting Energy Prices and Demand With Forward Curve Scenarios
  • Modelling Fixed and Variable O&M Cost Structures by Plant Type
  • Capturing Tariffs, Subsidies and Regulatory Revenue Mechanisms in Cash Flows
  • Build: Revenue and Operating Cost Module Linked to Template

Day 3: Structuring Capital Expenditure and Project Financing

  • Estimating Capex Profiles for Thermal, Solar, Wind and Storage Plants
  • Sizing Senior Debt on DSCR With Sculpted Repayment Schedules
  • Calculating WACC and Cost of Equity for Energy Assets
  • Optimising Gearing to Balance Equity IRR and Lender Covenants
  • Build: Financing Module With Debt Schedule and Returns Waterfall

Day 4: Analysing Risk and Planning Scenarios

  • Running Sensitivity Tables and Tornado Charts on Key Drivers
  • Simulating Output and Price Uncertainty With Monte Carlo Methods
  • Planning Market and Regulatory Change Cases With a Scenario Manager
  • Stress Testing Covenants Against Downside and Breakeven Cases
  • Build: Risk Module With Scenario Switch and Simulation Outputs

Day 5: Integrating PPA, ESG and Dashboards Through a Modelling Build Case Study

  • Modelling PPA Pricing, Indexation and Merchant Tail Revenue
  • Integrating ESG Factors Into Carbon Costs and Discount Rates
  • Designing Dynamic Decision Dashboards From Earlier Model Outputs
  • Working Through a Full Power Project Investment Case Study
  • Build: Final Investment Decision Model With Decision Dashboard

Skills You Will Gain:

  • Power Market Price Formation Analysis
  • FAST Standard Model Layout
  • Capacity Factor and P50/P90 Yield Forecasting
  • DSCR-Based Debt Sculpting
  • WACC Estimation for Energy Assets
  • Monte Carlo Risk Simulation
  • PPA Revenue Modelling
  • Decision Dashboard Design

Why Attend This Course:

  • Build an investment decision model for a power project that you can reuse on your next generation or storage asset
  • Test your own output, price and cost assumptions against lender-style DSCR covenants before a funding meeting
  • Apply a scenario switch so you can answer what-if questions from colleagues in minutes rather than days
  • Turn model outputs into a one-page dashboard that non-specialists can read and question

Conclusion:

On your first day back, load the decision model with the assumptions of a live or planned power project and replace the case study inputs with your own figures. Next, walk your finance lead or project manager through the dashboard, and ask the engineers who own the output and O&M numbers to confirm them. After that first review, check which sensitivities moved the result most, tighten the assumption log for those drivers, and keep the template as the starting point for every new project you appraise.

Frequently Asked Questions (FAQ):

What will you be able to do after the Effective Finance Modelling in the Power Industry Course?

You will be able to build a power project cash flow model from blank sheet to dashboard, size debt on DSCR, calculate WACC and returns, and test the result with sensitivity, scenario and Monte Carlo analysis before an investment decision.

What do you need to know before starting finance modelling in the power industry?

You need confident spreadsheet skills, including lookups and basic formulas, and a working grasp of NPV and IRR. You do not need earlier experience of energy markets or project finance; the first day sets out the power market economics the model relies on.

What do you build during this finance modelling in the power industry course?

You build one investment decision model in five modules: a structured template, a revenue and cost module, a financing module, a risk module, and a final dashboard that brings PPA pricing and ESG factors into the investment case.

How does finance modelling in the power industry differ from a general financial modelling course?

A general course models company accounts and valuations. This one centres on generation assets: capacity factors, energy prices, O&M by plant type, debt sculpting, power purchase agreements and regulatory revenue, so every exercise reflects how power projects earn and repay money.

Dates and locations

1 date
  1. Fee £5,200

    Apply now Enquire PDF

* Blackbird reserves the right to alter dates, content, venue and trainer.

Good to know

How long is the course, and what are the daily hours?

This course lasts one week. A one-week course is 20 hours over 5 days: 4 hours each training day (9am – 1pm). Timing and duration can be customised to your needs.

From the FAQ: What is my daily training agenda?

Can I take this course online?

No online date is scheduled for this course at present. An online course can be requested by email or by phone.

From the FAQ: How can I request an online course?

Which language is the course taught in?

Courses are offered in English and Arabic. The course language is officially English; on request, it can be delivered in Arabic while keeping the English terms.

From the FAQ: In which language do you offer your training courses?

Will I receive a certificate?

Yes. At the end of the course you receive the course certificate issued by BlackBird Training, with an online QR code to verify it.

From the FAQ: Do I receive the certificate at the end of the course?

How do I book, and when do I pay?

Choose Apply now and fill in the form; we guide you through the rest. The acceptance letter is sent within 24 hours of your registration. Payment is due at least 10 days before the course starts, online by credit card or by bank transfer.

From the FAQ: How can I register for a training course in BlackBird?, When do I get my Acceptance Letter?, When do I need to pay?, How can I pay for the course?

Can I cancel or send a colleague instead?

You can send a replacement delegate if you tell us one week before the course starts. Cancellation and refund terms are set out in the cancellation policy.

From the FAQ: Can I send a replacement delegate?

All frequently asked questions Contact us