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 - Financing and Loans

In a project, we spend money on capital assets before any revenue is earned, so we need to secure funding to bridge the gap between when we are investing in capital assets and when the project begins earning revenue. Projects are usually funded by a combination of equity and debt. In this module, we will explore the concepts of interest during construction (or IDC), circular references, debt amortization, refinancing, and Debt Service Reserve Accounts (or DRSA) in the context of renewable energy projects.

Unlock Your Certificate   
 
0% Complete

26 Lessons (91m)

Show lesson playlist
  • Description & Objectives

  • 1. Equity & Debt Financing

    04:32
  • 2. Interest

    03:16
  • 3. Grace Period

    02:12
  • 4. Interest During Construction Workout Part 1

    05:21
  • 5. Interest During Construction Workout Part 2

    04:02
  • 6. Interest During Construction Workout Part 3

    03:55
  • 7. Interest Rate Ratchets

    02:11
  • 8. Circular References

    02:22
  • 9. Circular References Workout Part 1

    03:11
  • 10. Circular References Workout Part 2

    02:12
  • 11. Circular References Workout Part 3

    02:05
  • 12. Circular References Workout Part 4

    03:34
  • 13. Circular References Workout Part 5

    05:02
  • 14. Circular References Macro Workout

    03:43
  • 15. Debt Amortization Schedule

    04:46
  • 16. Debt Amortization Workout Part 1

    03:46
  • 17. Debt Amortization Workout Part 2

    04:55
  • 18. Refinancing

    05:31
  • 19. DSRA

    03:30
  • 20. Case Study Modeling Debt - Flags

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

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

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

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

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

    05:29
  • 26. Renewable Energy - Financing and Loans Tryout


Prev: Renewable Energy - Capex Next: Renewable Energy - Tax and Dividends

Case Study Modeling Debt - CFADS

  • Notes
  • Questions
  • Transcript
  • 04:35

This video builds a debt waterfall from EBITDA to ending cash.

Downloads

Modeling Debt - CFADS EmptyModeling Debt - CFADS Full

Glossary

Debt 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

This area of the model is quite uncomfortable at times. And the reason is we need to flip between cash flows, cash and different types of cash flows. And so we'll find ourselves doing some quite error prone stuff. And so it's a good idea to slow down a little bit and think about what we're doing.

What we're going to happen now is we're going to create the debt waterfall. We're gonna say, what are the cash flows available for debt service? And we're gonna start that with EBITDA because if we start it with net income, there will be interest in there. And CFADs should be debt service. And so it should be servicing the debts, including paying the interest. So this waterfall will look different to some of the other waterfalls you may have seen in our materials. What we'll find is that when we do our running total down here in the waterfall, we will bring in interest into our cash flows as we move from one to the other, which in other models you will not have done.

As we go down here, we're going to have to worry for the first time about the debt service reserve account.

And then we're going to try and marry up this cashflow statement with our other cashflow statement. And we're gonna make sure that they meet each other. And it's one of the big checks in this model is to make sure that the balance sheet balances and that the two cashflow statements are in agreement with each other.

The starting point for CFADs then is EBITDA, which we can go and grab from the bottom of operations.

We've effectively calculated cash taxes within our cash flow statement with the combination of net income, which included the expense and the change in the payable. But we can do it in a more direct way because we've calculated cash taxes over here in the P&L on tax at the bottom. You've now effectively seen two ways of looking at tax. One from an expense point of view, two from a cash point of view, and that's useful to see the interplay.

Some of this stuff we can go and grab from the cash flow statement direct, because the receivables, payables, if we just check that's pointing at the right thing, so that should be trade payables and is.

And then the investing cash flows, these will all make up the cash flow available for debt servicing. And if we copy that to the right, see if it's sensible. What we're starting to build up is a picture where initially the CFADs doesn't seem to make any sense. You could argue that CapEx and in the investing cash flow should be missing.

Really it should just be the topping up or maintenance CapEx that's in years to come, not the great big, we are putting the wind farm in place here. Now we are not gonna make any attempt to try and analyze the CapEx or include some of it and exclude some of it, which you may end up doing in the real world. What we are going to eventually do is say in these initial years, this is all not something we're gonna worry about. And this flag will govern that. And lots of the metrics that we do later will be on CFADs. But if we're gonna put together a waterfall, we do need to take into account that we might have some cash that's not reserved for other purposes, especially if we end up not paying out everything as dividends.

So we need to make a grand base account.

And so if we unify this with the last ending cash, add together, the cash balance and the flow within the year, that brings us to the start of the waterfall ready to service our senior debt. Again, in initial years that won't work, but then again, there's nothing to service and initially that will be fulfilled by equity and then by borrowing. And then in subsequent years, once the grace period has expired, we'll have to use our flows and any remaining cash to both pay the principal and pay the interest. And if we can't or if we start to break our rules, then we'll have breaches.

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.