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 P&L and Taxes - Tax Timing

  • Notes
  • Questions
  • Transcript
  • 05:30

This video splits the tax bill into two years.

Downloads

P&L and Taxes - Tax Timing EmptyP&L and Taxes - Tax Timing Full

Glossary

modeling modelling Project finance Renewables Tax
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

It's quite easy to get confused here between taxable profits and actual profits.

So we just need to be really careful.

The profit before tax will be the taxable profits in a simple world.

So we'll go and fetch that.

But we are modeling to adjustments to taxable profits being the thin cap, which we're not ready to do, and the NOL adjustment. And the NOL adjustment we can sum up the two things we did in the table earlier and the product of that will be what the tax authority considers to be taxable.

And again, just careful with the summing there.

Now if we pull that to the right, but we should see, so we've seen the divergence between the accounting profit, which so far is minus a million or so there.

And then the taxable profit, which the tax authority has deemed to be zero there because we're able to take that taxable loss and put it away until the next year.

And again, there's a divergence in the next year as we are making taxable profits in a simple world.

But then we have our know adjustment and that will get even more complex when we add thin cap into the mix.

And again, just be careful because in these models it can be very, very easy to get confused between accounting, profit, taxable profit, and effectively set them equal to each other and they're not.

And the tax expense is effectively the meeting point between those two worlds.

What we'll find is that we're going to be charged 25% on our taxable profits.

You can see what the NOL is doing effectively, or the NOL rules.

They're avoiding effectively a rebate in tax as well.

So the tax authority is not in the habit of handing money to projects or companies.

And what they'll do to avoid that is let you put away losses and then bring them out in subsequent years.

So although there's a reduction in tax, you're never getting a tax rebate, as in the tax expense isn't negative there.

It can be negative, but it isn't here.

Now we're ready to reunify those two worlds then, which is the tax authority world and the accounting world.

So we grab profit before tax again, and we've grabbed it several times now.

Now the tax expense, we're ready to do that.

Now I know it's colored yellow, but it shouldn't be.

And so the tax expense, now that should be a negative figure, so I'm gonna make that negative.

Probably should have done that earlier. And then I'm going to sum those two.

And we've now got our accounting net income.

And again, just as a reminder, remember we put away the NOL as in the net operating loss.

And it can be tempting to think that there is no profit or loss in that year because you can get tax and accounting mixed up.

That's not the case. The tax authority has kind of put away that loss. So from Their point of view, there's no loss, there's no profit.

But from an accounting point of view, the loss still exists.

It's just we didn't pay or receive any tax on it.

Now, if you are very details driven person or if you know a lot about the accounting, you might start thinking, Hey, how about deferred taxes? We've simplified deferred taxes for this model. Okay? So in reality there would be an interplay between the expense, the accrual and deferred taxes, but we've simplified that away.

Okay? So what I'm going to do next is take that tax expense and analyze it into what we're gonna pay this year and what we're going to pay next year.

Lots of tax authorities end up splitting the tax bill 50 50 this year and next year.

And so given this model is trying to create some detail and show you how that might work, that's what we're gonna do here as well.

We're going to take the proportion and multiply it by the tax expense.

So that's what we're paying within the year.

And given that's described as paid, so a cashflow, I'm gonna leave that as a negative.

Now the next one, I'm going to take this proportion, which is the same proportion, but that might be subject to change.

And we're gonna take the tax expense and we're gonna split it the other way.

Now this line is destined to be in the balance sheet.

And so I would be happier if that's positive presentation.

And so I'm going to flip the sign from the tax expense.

I'll pull that to the right and we end up with the same number, but that's because it was 50 50 in the assumptions.

It's now time to analyze that into cash flows.

Now the first one is simple.

We just say the stuff we're paying in the year is what we're paying in the year.

The second one is a little trickier.

We're paying last year's payable, which is a slightly uncomfortable start within column E there, but we need a blank space to start with.

And we also need to flip the sign because we're taking it from balance sheet, positive presentation to cashflow, negative presentation.

We've then got our total tax cashflow, which will be helpful for our debt schedule.

And you can see that what we've got is as the project starts to make money and it runs out of NOLs, it ends up paying tax 50 50.

And you can see that kind of triangular and what you're seeing there is the hangover of the payable from last year.

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.