Pre tax financial model for renewable project (Solar/Waste to Energy, etc.)
  • Pre tax financial model for renewable project (Solar/Waste to Energy, etc.)
  • Pre tax financial model for renewable project (Solar/Waste to Energy, etc.)
  • Pre tax financial model for renewable project (Solar/Waste to Energy, etc.)
  • Pre tax financial model for renewable project (Solar/Waste to Energy, etc.)
  • Pre tax financial model for renewable project (Solar/Waste to Energy, etc.)
  • Pre tax financial model for renewable project (Solar/Waste to Energy, etc.)
  • Pre tax financial model for renewable project (Solar/Waste to Energy, etc.)
  • Pre tax financial model for renewable project (Solar/Waste to Energy, etc.)
  • Pre tax financial model for renewable project (Solar/Waste to Energy, etc.)
  • Pre tax financial model for renewable project (Solar/Waste to Energy, etc.)
Originally published: 23/10/2019 11:20
Publication number: ELQ-37701-1
View all versions & Certificate
certified

Pre tax financial model for renewable project (Solar/Waste to Energy, etc.)

Simple financial model to calculate pre-tax levered and un levered return to investor/developer.

Description
This tool has one excel spreadsheet. However, it can run and provide analysis for different projects. You can run more than 5 or 10 or 15 projects and see the results if individual projects in an individual spreadsheet.

The tool helps you to analyze a solar project or a waste to energy project or any other energy project with as many as 6 different revenue streams. The tool provides you with a pre-tax and post-tax cash flow which will help you evaluate the economics of the projects.

Replicating sheets is very simple. Just enter a new column next to the last project in the input sheet. Then compy all the inputs from the previous project and make the necessary changes to the inputs of the individual projects. Once you have all the inputs, run "CopySheets" Macro to replicate sheet "1" to all the projects. Similarly, copy the "Project 1" sheet and just change the asset number in each of the project sheets to reflect the asset.

Make sure in the input sheet you have different asset numbers identified, if not then the output sheet would not show accurate information.

With regards to project cost, you can forecast the spending schedule based on equal spend across the development and construction period or use an automatic S-Curve.

In order to take care of the IDC circularities, please run the clear circularities macro.

The Holdco sheet will consolidate all the project cashflow in one sheet. You can modify this as required.

In case of any other query, please reach out to me. I will be happy to help you.

This Best Practice includes
1 Excel Spreadsheet

Acquire business license for $49.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • Rate this Downloadable Best Practice

    Write a review

  • Aarav Gupta(last updated: 15/04/2020 14:32)

keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Pre Tax Financial Model For Renewable Project (Solar/Waste To Energy, Etc.)

The user community and author are here to help. Go ahead!

  • mjray87
    Hi - we're looking to do a project in NYS that is a trash to energy/steam project. couldn't see your O&M assumptions. How detailed are they and do you include any grant line items... Great model would love to purchase if we had a little more knowledge of it.
    arrow_drop_uparrow_drop_downReply reply
    • MACH BS
      Hi, if you look at the third picture, you will see Opex assumptions at the top. Of course, you can modify that as per your requirement. Also, in pic 6 at the top you could see Opes line items.
      arrow_drop_uparrow_drop_downReply reply
    • Alvaro Creixell
      Hi! Does this model include Energy Storage revenue streams?? Thank you!
      arrow_drop_uparrow_drop_downReply reply
      • MACH BS
        I have a separate model for that. Depending on what kind of energy storage revenue stream you are looking for. Is it for NY or you just want a capacity payment
        arrow_drop_uparrow_drop_downReply reply


      4.0 / 5 (1 votes)

      please wait...