Skip to content
Felix
  • Topics
    • My List
    • Felix Guide
    • Asset Management
    • Coding and Data Analysis
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
  • Pathways
    • Investment Banking
    • Asset Management
    • Equity Research
    • Sales and Trading
    • Commercial Banking
    • Engineering
    • Operations
    • Private Equity
    • Credit Analysis
    • Restructuring
    • Venture Capital
    • CFA Institute
  • Certified Courses
  • Ask An Instructor
  • Support
  • Log in
  • Topics
    • My List
    • Felix Guide
    • Asset Management
    • Coding and Data Analysis
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
  • Pathways
    • Investment Banking
    • Asset Management
    • Equity Research
    • Sales and Trading
    • Commercial Banking
    • Engineering
    • Operations
    • Private Equity
    • Credit Analysis
    • Restructuring
    • Venture Capital
    • CFA Institute
  • Certified Courses
Felix
  • Data
    • Company Analytics
    • My Filing Annotations
    • Market & Industry Data
    • United States
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
    • Europe
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
  • Models
  • Account
    • Edit my profile
    • My List
    • Restart Homepage Tour
    • Restart Company Analytics Tour
    • Restart Filings Tour
  • Log in
  • Ask An Instructor
    • Email Our Experts
    • Felix User Guide
    • Contact Support

Renewable Energy Project Finance Model

Build a full renewables model. A first pass through the model will be performed, building up the mostly non-circular elements. The second pass will connect the circular elements and complete the model. Key outputs such as debt ratios and IRR are discussed.

Unlock Your Certificate   
 
0% Complete

35 Lessons (165m)

Show lesson playlist
  • Description & Objectives

  • 1. Case Study Model Intro

    05:21
  • 2. Case Study Assumptions

    06:17
  • 3. Case Study Operations - Flags and Inflation

    03:27
  • 4. Case Study Operations - Capacity

    03:42
  • 5. Case Study Operations - Revenue

    03:10
  • 6. Case Study Operations - EBITDA

    05:01
  • 7. Case Study Sources and Uses - Intro

    02:26
  • 8. Case Study Sources and Uses - Flags and Installed Capacity

    04:42
  • 9. Case Study Sources and Uses - Funding Need

    03:37
  • 10. Case Study Sources and Uses 4 - PPE and Equity

    05:19
  • 11. Case Study Sources and Uses - IDC

    06:28
  • 12. Case Study P&L and Taxes - Basic P&L and NOLs

    06:31
  • 13. Case Study P&L and Taxes - Tax Timing

    05:30
  • 14. Case Study Balance Sheet

    05:59
  • 15. Case Study Cashflow Statement

    04:29
  • 16. Case Study Modeling Debt - Flags

    02:59
  • 17. Case Study Modeling Debt - CFADS

    04:35
  • 18. Case Study Modeling Debt - Senior Debt Service

    04:15
  • 19. Case Study Modeling Debt - Junior Debt and Equity

    03:38
  • 20. Case Study Modeling Debt - DSRA

    03:02
  • 21. Case Study Modeling Debt - Dividends and Ending Cash

    05:29
  • 22. Case Study Modeling Debt - Total DSCR

    05:18
  • 23. Case Study Modeling Debt - Individual DSCRs

    04:47
  • 24. Case Study Modeling Debt - LLCR

    05:42
  • 25. Case Study Modeling Debt - Interest Cover and Breaches

    02:32
  • 26. Case Study Looping Back - Dividends

    05:13
  • 27. Case Study Looping Back - Debt Service Capacity Charge

    02:33
  • 28. Case Study Looping Back - DSRA in Sources and Uses

    05:43
  • 29. Case Study Looping Back - Errors in Complex Circular Models

    05:28
  • 30. Case Study Looping Back - P&L Interest

    02:08
  • 31. Case Study Looping Back - P&L Thin Capitalisation

    09:53
  • 32. Case Study Looping Back - Balance Sheet and Cashflow Statement

    07:38
  • 33. Case Study The Whole Life of the Project

    02:16
  • 34. Case Study Outputs - Setup

    04:42
  • 35. Case Study Outputs - Conclusions

    05:29

Case Study Operations - EBITDA

  • Notes
  • Questions
  • Transcript
  • 05:01

This video builds up the operations of the windfarm.

Downloads

Operations - EBITDA EmptyOperations - EBITDA Full

Glossary

modeling modelling Project finance Renewables
Back to top
Financial Edge Training

© Financial Edge Training 2025

Topics
Introduction to Finance Accounting Financial Modeling Valuation M&A and Divestitures Private Equity
Venture Capital Project Finance Credit Analysis Transaction Banking Restructuring Capital Markets
Asset Management Risk Management Economics Data Science and System
Request New Content
System Account User Guide Privacy Policy Terms & Conditions Log in
Transcript

We're moving on to costs now, and you can see the variable costs are as a percentage of electricity revenue.

That does make sense because it wouldn't make any sense to attach costs to the offtaker revenue because that's money coming from the offtaker as part of the PPA, and that's not something that we are going to have to spend money on that there's no expenses attached to that really.

So it makes more sense to attach the variable costs just to the electricity revenue, and that's what we're going to do.

So if we take the 15% and then we attach it to the electricity revenue, having locked that 15%, now I'm a big fan of negative presentation, and so that means that whenever I have a kind of expense that would go into the P&L or a cashflow that would go into the cashflow, if it's negative, I like to show it as negative.

That can cause problems down the line.

But I do think on the whole, it's clearer.

And you can see we haven't got any costs in years one and two, and that's because we haven't got any revenue and that's because we don't have a wind farm yet.

Fixed costs is going to be a little more challenging.

First off, the fixed costs appear to be fixed, but that's a real cost.

And so the fixed costs will be moving around despite their name.

We need to build those fixed costs up, and so we need to build them up using the inflation rate that we've got over here.

Now you can already see what's going to happen if we stop now, we will have fixed costs in year 50 despite there being no project.

So we've got to use the flag that we have over here to say, okay, only fixed cost please, if the project's operational.

We can now copy to the right, we can find that we've got fixed costs, but you can see I just need to flip the sign there to make it compatible with a negative presentation elsewhere.

We've got total costs then, and then we're ready to do EBITDA.

We can take the total revenue and with negative presentation, you would be adding the total costs.

You can see at the moment we've got a loss, but that's because we haven't modeled all of our revenues yet.

A lot of this model will look quite strange to start with.

There will be a major doubling back and filling in of lots of information down the line.

And what we can do now is double back and fill in the fixed costs.

We are going to charge our offtaker for our fixed costs and that will be income, so we'll need to flip that sign.

What we'll also need to do is take into account that we're not going to be able to charge them the whole lot.

We've negotiated a 60% charge.

You can see that massively de-risks the project already, and it prevents us from making the loss that we predicted earlier, and that's because we've pushed a lot of our fixed costs the way of the offtaker, and we're going to push some more fixed costs their way in the form of the debt service element of the capacity charge.

You can see down here we've got some outputs, and these are really just metrics to analyze what's going on.

This is the first time that we're going to run into errors.

So you can see we've got an average revenue per megawatt hour.

You could interpret this two ways of course, and we're going to interpret it as electricity revenue and electricity revenue per megawatt hour.

And you can see over here we've got the achieved megawatt hours.

If I press enter there, you'll see an error and you might be okay with those errors appearing later on.

When we do tests on metrics such as breaches and DSCR covenants, it's important that we actually get rid of errors because Excel won't be able to deal with them very well.

And so it's a good habit to get into even this early to say, okay, if we've got something like this, let's wrap it in if error, and then if there is an error, just put in an n/a and what will happen is Excel will throw out an n/a.

And that's helpful to us because a lot of things Excel does, such as IFs, will tend to ignore N/As as opposed to errors, which it will interpret in strange ways.

We're going to do the same with EBITDA margin, so we're gonna wrap it in an IF error and we're going to say EBITDA over and we'll do total revenue now and we'll say N/A, pull that to the right.

And what you can see is that really the way it's worked out is this is a weighted average of all of the inflated sales prices.

And then this is a little more complex because there's an interplay between the sales price, the fixed costs, the variable cost, the scale of the project.

And so they're quite useful for analysis.

Content Requests and Questions

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account
Help

You need an account to contact support.

Create a free account or log in to an existing one

Sorry, you don't have access to that yet!

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account

You have reached the limit of annotations (10) under our premium subscription. Upgrade to unlock unlimited annotations.

Find out more about our premium plan

You are trying to access content that requires a free account. Sign up or login in seconds!

Create a free account or log in to an existing one

You are trying to access content that requires a premium plan.

Find out more about our premium plan or log in to your account

Only US listed companies are available under our Free and Boost plans. Upgrade to Pro to access over 7,000 global companies across the US, UK, Canada, France, Italy, Germany, Hong Kong and more.

Find out more about our premium plan or log in to your account

A pro account is required for the Excel Add In

Find out more about our premium plan

Congratulations on completing

This field is hidden when viewing the form
Name(Required)
This field is hidden when viewing the form
Rate this course out of 5, where 5 is excellent and 1 is terrible.
Were the stated learning objectives met?(Required)
Were the stated prerequisite requirements appropriate and sufficient?(Required)
Were the program materials, including the qualified assessment, relevant and did they contribute to the achievement of the learning objectives?(Required)
Was the time allotted to the learning activity appropriate?(Required)
Are you happy for us to use your feedback and details in future marketing?(Required)

Thank you for already submitting feedback for this course.

CPE

What is CPE?

CPE stands for Continuing Professional Education, by completing learning activities you earn CPE credits to retain your professional credentials. CPE is required for Certified Public Accountants (CPAs). Financial Edge Training is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.

What are CPE credits?

For self study programs, 1 CPE credit is awarded for every 50 minutes of elearning content, this includes videos, workouts, tryouts, and exams.

CPE Exams

You must complete the CPE exam within 1 year of accessing a related playlist or course to earn CPE credits. To see how long you have left to complete a CPE exam, hover over the locked CPE credits button.

What if I'm not collecting CPE credits?

CPE exams do not count towards your FE certification. You do not need to complete the CPE exam if you are not collecting CPE credits, but you might find it useful for your own revision.


Further Help
  • Felix How to Guide walks you through the key functions and tools of the learning platform.
  • Playlists & Tryouts: Playlists are a collection of videos that teach you a specific skill and are tested with a tryout at the end. A tryout is a quiz that tests your knowledge and understanding of what you have just learned.
  • Exam: If you are collecting CPE points you must pass the relevant CPE exam within 1 year to receive credits.
  • Glossary: A glossary can be found below each video and provides definitions and explanations for terms and concepts. They are organized alphabetically to make it easy for you to find the term you need.
  • Search function: Use the Felix search function on the homepage to find content related to what you want to learn. Find related video content, lessons, and questions people have asked on the topic.
  • Closed Captions & Transcript: Closed captions and transcripts are available on videos. The video transcript can be found next to the closed captions in the video player. The transcript feature allows you to read the transcript of the video and search for key terms within the transcript.
  • Questions: If you have questions about the course content, you will find a section called Ask a Question underneath each video where you can submit questions to our expert instructor team.