BENEFITS OF DOCUMENT
DESCRIPTION
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.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Solar Energy Excel: Solar Panel Installation Scaling Model Excel (XLSX) Spreadsheet, Jason Varner | SmartHelping
Solar Energy Renewable Energy Integrated Financial Model Energy Industry Business Case Example Feasibility Study Business Plan Example
![]() |
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more. |