Solar Panel Installation Scaling Model (Excel XLSX)

VIDEO DEMO

BENEFITS OF THIS EXCEL DOCUMENT

1. Plan out various levels of scale in the solar panel installation business.

SOLAR ENERGY EXCEL DESCRIPTION

This product (Solar Panel Installation Scaling Model) is an Excel template (XLSX), which you can download immediately upon purchase.

First, this is a business model that involves installing solar panels for free to commercial and/or residential properties. Then, the energy created and used by the customers from the installed panels is paid for by the customer to the company. Pricing is in kWh and there are assumptions for how pricing and costs change over time.

Another big component of this model is seasonality. There is a dynamic schedule the user can configure that defines how much of the expected yearly production of kWh is utilized for each month of the year. This is because it can be sunnier in certain months and less sunny in others. That will affect cash flow for the company.

I've built a deployment framework in this model where the user can define up to 200 tranches. Each tranche has its own assumptions for the installation cost, financing variables (debt), ongoing monthly costs to maintain, kWh pricing, and the month # the deployment happens as well as the number of months it takes to complete the installation and start selling the energy to the customer.

Additionally, I've included a corporate overheads section to account for general and administrative costs such as salespeople, managers, executives, and what have you. Each has their own start month and cost assumptions. I made half of these costs automatically increase at a defined percentage each year and the other half you can manually change the expected costs each year.

The model extends for a maximum of 120 months with the option of an exit value at the end month based on EBITDA multiple. On the DCF Analysis tab I also put the inputs for exit month, exit multiple, and a few sensitivity tables that show how the IRR and NPV of the project change based on varying discount rates, exit year, and exit multiples.

Instructional video included in the file.

Source: Best Practices in Solar Energy Excel: Solar Panel Installation Scaling Model Excel (XLSX) Spreadsheet, Jason Varner | SmartHelping