diy solar

diy solar

Solar Install ROI Calculator Spreadsheet

GregTR

Solar Enthusiast
Joined
Sep 16, 2022
Messages
408
Location
Texas
The question whether "Is solar worth it?" comes up a lot. There is a whole lot that goes into that decision, and while this post focuses strictly on the pure economic ones, and the answer is still a resounding "it depends".

If all you're looking at is an economic viability of PV/battery for your home then you have to consider a whole array of variables to make the determination whether solar makes economic sense for a given situation and with a given known set of parameters.

Just to name the few critical ones:
1) Cost of the install. This is most easily expressed in $/W. It is one of the biggest variables. You also have to take a guess as to PV in the future will be less or more expensive. If PV prices will drop in 2 years time it might even make sense to postpone a purchase even if it was net positive to make that purchase today.

2) Total estimated annual production. It can vary widely by location anywhere between 4 hours to 6 hours of average production per day which can have the same effect on ROI where 6 hours would make sense but 4 hours would not. This variable can also be impacted by your individual situation ie. can you place all panels in an optimal southern facing location with no shading and ideal angle, or are you more limited to put them facing east/west on a less than ideal roof slope.

3) Life expectancy of the system. String inverters may last as little as 10 years, panels may go as long as 30. What is the estimated maintenance cost over the life expectancy of the system? Even if a part is guaranteed for 30 years, cost of repairs can be significant if you have to have someone come and replace microinverters on your roof or panels need swapping. What if you need to replace your roof during that time, did you account for the labor involved in removing and replacing the perfectly fine and working panels?

4) Price of electricity. If the electricity is cheap ROI will be much longer. If electricity is expensive, ROI will be much quicker. Do you anticipate prices going up or down in the future? If you do, by how much? Will it be matching that of inflation or significantly more/less?

5) Tax credits/subsidies? Is there some kind of government incentive on installing solar where you live? If yes, it can change your equation and net cost in a significant way.

6) Do you have Net metering? More than likely you no longer can expect watt for watt return on your solar production and you have to face the possibility that some or most of your production will not be of value to you, certainly not at 100%. If you do not have net metering, what is your estimated self consumption ratio? Do you get anything for power you're loading onto the grid? If you have peak demand pricing you might be coming out better if you put power on the grid when cost is higher rather than self consume/conserve. If you don't have net metering and you want to optimize self consumption you either have to go with a smaller system or you have to add some kind of battery storage for additional cost, also negatively impacting your ROI.

7) What is the opportunity cost of the money you're spending on solar? Could you get better ROI on your money had you invested it than purchasing the solar setup? Could you have avoided interest cost had you not financed it? These are all variables that should be considered from a financial perspective.

As you can see there are a lot of variables, many of you may not have the ability to control or even know making the simple question of whether solar is a wise economic decision far too difficult to answer.

Having said all this there are also other factors that are even harder to put a monetary cost/benefit to:

1) Are you DIY? Is the experience of installing and owning a solar setup a net positive or negative to your life? Is it a hobby that brings you joy, or is it an extra thing you need to worry about going forward?

2) How reliable is your alternate power source ie. generator or grid? Is the cost of having your own system benefits you enough in peace of mind of being partially or wholly independent from another source?

3) Do you feel good/bad about the environment and your own impact on it? Are you willing to bear some of the economic cost of a greener energy production, if there is a cost associated with it ie. your ROI is a net negative in terms of pure financials without accounting f or externalities?

I have created a spreadsheet that should allow everyone to play with their own numbers and see if the financial ROI is even there before they try to answer and put cost/value on the externalities and intangibles.


You should be able to make a local copy of the spreadsheet and play with your own numbers. The numbers in the sheet reflect what I'm expecting out of my system at my location based on my panels, their orientation, and my total cost including batteries. My ROI is about 14.2 years not accounting for inflation and about 10.7 years with a 3% inflation. This also does not account for all the other benefits I receive from having most of my consumption covered via my PV setup and the added resiliency and backup benefits.

Please don't feel compelled to respond to this thread with "I want to be off grid, there is no amount of money too much to make this dream a reality" or the "I never want to freeze to death without power, having my own system is worth everything I poured into it" as these type of responses are largely substantiated with intangible costs/benefits and externalities that the calculator is not meant to account for and absolutely have no bearing on the math.
 
It says I should have 5 years ROI which is close to what I calculated. However it is difficult to have high self consumption, so it will probably be longer than that.

Geography and climate are important: in colder climates with less sun, the same amount of money spent on insulation may have much better ROI than solar.

Here in France our "mostly nuclear" kWh got a price hike to €0,2062 (USD 0.22 at today's exchange rate). Our supreme leaders seem determined to make energy more expensive, they're certainly doing everything in their power to make it happen, like unplugging nuclear powerplants and enacting insane regulations. Thus, I consider solar a speculative investment, a hedge against stupid/evil government policies. Of course this sort of forecast is difficult to put into numbers without a crystal ball, but on the other hand saying socialists create shortages is like saying water is wet, it's the most predictable thing there is, yet everyone is always surprised. So I think solar is a good insurance policy.

I sized the system for 50c/kWh and occasional load shedding, which should probably happen in a few years. If this is the case, it will pay for itself much quicker than 5 years.
 
My estimation process:
  1. Estimate Need
  2. Estimate Cost
    1. Talk to Wife
    2. Decide to bag the whole thing
  3. Re-estimate need
  4. Arrive as original cost
  5. Triple the cost estimate
That is definitely one way of doing business :)
 
1) Are you DIY? Is the experience of installing and owning a solar setup a net positive or negative to your life? Is it a hobby that brings you joy, or is it an extra thing you need to worry about going forward?

7) What is the opportunity cost of the money you're spending on solar? Could you get better ROI on your money had you invested it than purchasing the solar setup? Could you have avoided interest cost had you not financed it? These are all variables that should be considered from a financial perspective.

The one important thing that is often left off (and I keep reminding people of that whenever a thread like this pops up) is the opportunities for income a system generates compared to when you don't build the system - especially a DIY one. Example: I've already made a ROI in three years since I installed my system. Not because it generated that amount of power, but because doing this gave me opportunities to consult in the local industry on these topics where my system serves as an example I can show people. Solar, storage, etc. is still very much an emerging industry - and by getting the experience, the data, etc. building and running a system like this you can generate an income that you would not be able to otherwise.
 
and by getting the experience, the data, etc. building and running a system like this you can generate an income that you would not be able to otherwise.
Sure, I think this falls under the other opportunity cost category that the basic ROI does not, and should not, tackle.

I will also bet that most people with solar will never realize any kind of derived income by virtue of being PV users themselves. Your experience is what you'd call anecdotal evidence of one, an outlier.

Funny part is that everyone I talked to generally walks away with the notion that the strictly basic economics ROI is not worth it here, and they would be mostly correct. I placed a big bet last year that utility cost would go through the roof (no pun) and remain as such going forward. The reality is that as of today I can still buy power for $0.11/kWh for 36 months from half a dozen utility providers. Had I known that I would have postponed the purchase for sure.
 
Nice work, I am not only interested in personal installations, I am also interested in the larger scheme of things as I don't see how we can operate without a grid too far away from the equator.
 
There are also those who like the redundancy afforded by a simple set up. Not trying to reproduce all of the energy needs but providing options especially during power outages.
 
Back
Top