Solar Rooftop Excel Model
Originally published: 24/04/2018 10:18
Last version published: 16/10/2018 09:20
Publication number: ELQ-51682-2
View all versions & Certificate

Solar Rooftop Excel Model

Detailed an in-depth model for tracking your solar rooftop finances

This is a great tool for tracking the expenses and finances of your solar rooftop venture.

This tool is split into 9 functional tabs which will help you to keep a close track of your finances for your solar rooftop investments. These tabs are:

- Assumptions
- Scenario Page
- Cash Balance Chart
- Debt Balance Chart
- Monthly Consolidated Model
- Annual Consolidated Model
- Degradation Example
- Data Sheet
- Simple Function

The assumptions page allows you to input vast amounts of financial data, covering a range of areas. These include the portfolio assumptions, system operation assumptions, capital expenditures, revenue calculation, operating costs, development company costs and financing assumptions. As such, this model allows for an incredibly in depth analysis of your solar rooftop investments.

This information is then broken down in the scenario page, which gives you the opportunity to analysis different scenarios for your investments.

Furthermore, the cash balance chart and debt balance chart uses the inputted data to provide a visual representation of your cash balance and debt balance.

This data is also shown in a monthly format within the "Monthly consolidated model" tab, and in an annual format within the "Annual consolidated model" tab.

The degradation tab will also allow you to see the potential degradation of your solar rooftop installations on a year-on-year basis.

Ultimately, this is a great tool for modelling your solar rooftop finances and keep track of all of your solar rooftop installations.

This Best Practice includes
1 Excel Spreadsheet

Acquire business license for $50.00

Add to cart

Add to bookmarks


4.7 / 5 (57 votes)

please wait...