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 - Capex

Before we can accrue revenue or incur operating costs in a project, we need to build the underlying equipment that can generate the power. This is what we call capital expenditure or Capex, which we will explore in this module, covering build-up of construction costs for the generating assets, grid connections, and other capital expenditure. Using lookup functions to make capital expenditure timings flexible. Building in sensitivities for potential changes in costs. Calculating depreciation of the resulting capital assets.

Unlock Your Certificate   
 
0% Complete

12 Lessons (44m)

Show lesson playlist
  • Description & Objectives

  • 1. Capex Introduction

    03:51
  • 2. Construction Capex Costs

    01:38
  • 3. Capex Construction Costs Workout

    05:38
  • 4. Capex Inflation

    04:07
  • 5. Inflation Index Example Part 1

    03:24
  • 6. Inflation Index Example Part 2

    02:55
  • 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. Renewable Energy - Capex Tryout


Prev: Renewable Energy - Operating Model Next: Renewable Energy - Financing and Loans

Case Study Sources and Uses 4 - PPE and Equity

  • Notes
  • Questions
  • Transcript
  • 05:19

This video explores the financing needs of the windfarm.

Downloads

Sources and Uses - PPE and Equity EmptySources and Uses - PPE and Equity Full

Glossary

forex 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

The next section isn't strictly speaking sources and uses, but it's very useful to do it now, given that we have all the information we need to do it right here in front of us. What we're going to do is build up the CapEx account as in PP&E, and you might normally see this next to the balance sheet, and we could have put it there. It's just so convenient to do it now. It's very tempting to do it now, and that's why we've put it here. We're going to structure this as a base account. You can see we're gonna end up carrying forward last year's PP&E.

Then we just need to be careful because in terms of CapEx, we will end up spending the CapEx, but we will also spend money on interest that will end up in PP&E as part of the capitalized interest, and so we'll need to add those together.

You can see that we've already pre-populated a line here which pulls all of the CapEx and IDC, and it pulls it for the entire model, and so this is effectively all of the CapEx, including IDC, that will happen during the project.

This is helpful because this is the amount that will need to be depreciated through the life of the project, and you can see that we've got a lifetime of the assets of 20 years. We need two bits of logic attached to the depreciation. The first is that we need a min attached to it, and the reason we need a min is because although we will be depreciating by that amount, which is a 20th of the total CapEx, there's a chance the project will go on longer than the life of the assets for some reason, and so we need to make sure that we don't depreciate through the floor and end up with negative PP&E. So that's what the min is for. If I were to press enter now, I would end up with depreciation, and incidentally, it would be the wrong sign. So let's attach a minus one to that, but if I hit enter, enter now, I would end up with depreciation, but the project hasn't started yet. There's arguably no p&l to charge this stuff, and there's no revenue to match it against, and so I shouldn't really have any depreciation until the project is operational. We're going to go and achieve that using the flag. The project operational flag and the combination of all of the lines we've done so far will build up PP&E account, which if we drag it to the right, you'll see starting to work. You can see I've made a small error in there. You can see the error jump out at you because we're just depreciating immediately, and my error is that I've divided here. Instead of times it's just a conceptual error, which I'll fix now.

If I drag that to the right again, you'll see it starts behaving itself very nicely and it is worth dragging to the right, doing a bit of stress checking, kind of sense checking every time you do something a little complex because it will reveal errors, which if you just work in the first column, can be quite hard to spot, especially for a multi-phase project like this with different phasing, different flags, different kind of parts of the life. Let's go on and do the equity financing.

You can see the total need has been picked up, and again, that's been picked up from the CapEx and the IDC, but also the debt service reserve account. It's quite error prone in a model like this because the inclusion of the IDC, the CapEx and the DSRA can happen at different times and can be quite confusing. Here we're not calculating depreciation and we're only depreciating the capitalized items. We're calculating funding need, and the funding need is driven from all the cash we need.

We've got a little bit of information here to say how much equity we would like to use, and our split is 50 50.

Next, we've got a line that says how much equity finance is remaining. What's going to happen is we're going to say we've got initially that amount, but however much we charged in the previous year, which will turn up in the beginning, will be chopped off that.

We can then build up a miniature base account and we can say we are going to add equity based on the funding need or how much equity we have left in our financing package.

If I pull that all to the right, you can see what's happening is in the initial year we are funding the project with equity, which is great because it doesn't carry any interest, and so it'll be easier on our cash flows.

We then use up our equity package.

Unfortunately, there's an enormous amount of funding that is still needed in that year, and so the debt is gonna have to pick up the slack on that one.

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.