If it didn't cost over 30K to pull power to the house, it'd be impossible to make the math work for solar. If you don't count the climate externalities I doubt there's one city on Earth where the payback period (before incentives) is less than 10 years.
So there's no point in making a spreadsheet at this point, really. You're either buying solar out of need, a desire to "green" your life further, or you're being paid by the government to do it, or buying at a loss.
It also ignores the possibility that energy costs will go up over those 10 years. Essentially you are fixing your energy costs indefinitely.
Of course I'm not-quite normal kind of guy regardless. I paid too much for a very efficient house. I own my house. I own my cars. To me, the idea of turning unknown future costs into known present costs is fantastic. Not a lot of people agree with that concept.
Also worth it to add in this context that the 5 or 6 solar-dependent/off-grid homes I've seen built and lived in have been anything but reliable. It seems to take a while to fine tune the system to the point of not having a blackout every 3 months.
When you are talking about a purchase which you live with day to day for 10+ years, "Return on Investment" is never going to be a straight financial calculation.
People don't buy a house based on straight ROI, nor are most home improvements based purely on ROI. I don't see why solar should be the exception.
In real terms, the S&P 500 price return was about 3.2% p.a. since the peak in 1968, 5.2% since 1988, and less than 3% since 2000.
Real total (ie with dividends) return p.a. over a decade has been between -4% and 17%, with an average of around 7%.
As things stand currently, I'd not plan on more than 6% total return in real terms over the next two decades.
Obviously you sell the entire house and all improvements are reflected in increased value of the house.
So no, the value of solar is not zero at the end of 10 years.
Don't bet or estimate, we have mountains of data on this: https://www.nrel.gov/docs/fy12osti/51664.pdf
There is a massive assumption in there that you can have a non-risky investment with a 10% rate of return idefinately.
Given that we can barely go 10 years from crisis to crisis (2008 and covid) this assumption cannot possibly be justified.
Solar panels generate cashflow in the form of electricity but they depreciate over time. So the payback period (in the form of cashflow) has to be much shorter than for an apartment or home.
Moreover, people should not buy a house with the expectation that it will inevitably be worth more in 20 years than it is today. Appreciation of land values is far from a universal law of nature.
We have birthrates of 1.6 in most of Europe, and the global population is about to peak in every contry except in African countries*
Here's a more detail approach.
1. Compute your electricity usage. Look at 12 months of electric bill. E.g 800kWh per month (9600kWh per year).
2. Get quotes from the solar vendors. They usually quote in term of 5kW system, 6kW system, or 10kW system. The kW number is the instantaneous electricity the panels generated. Multiply that by hours to get the kWh number. The number of panels doesn't matter because some panels generate more some less. You want the total system output number in kW.
3. Figure out how many hours of useful sunlight a day your house can have. Google Sunroof and other calculators on the web would do it for you. E.g. 5 hours of useful sunlight per day.
4. E.g. with a 6kW system, 6kW x 5 hours/day = 30kWh per day = 900kWh per month = 10800kWh per year. Remember you need 9600kWh/year from 1? This just about covers it, accounting for some loss of efficiency.
5. A 6kW system costs about $14,460–$19,260 in CA. See [1]. Let's say it costs $18,000. Let's say your electric bill is $250/month or $3000/year. $18,000/$3,000 = 6 years to recoup (very simplistic view).
Battery is an additional cost, $6000~$10000.
[1] https://news.energysage.com/6kw-solar-system-compare-prices-...
You need to know if your local utility will even pay you for the power you generate that you don't use.
If you are out of the house for most of the day, you probably don't use much power then. When you get home at night you turn all your devices on and start cooking and cleaning.
Now I wonder how to compute the best time for investing if you consider both the diminishing rate of panel prices, and the electricity you'll need to pay while you don't have those. Is it always worth it to invest ASAP, or is there a panel improvement rate at which it is worth waiting a bit?
The other side of it is how big your roof and if it faces south without much occlusion. If your roof doesn't face south or is occluded but trees then it makes it much less attractive.
If the net metering rules are favorable, skip the battery, forget entirely about your own consumption patterns, and just install as much as you can. The job is almost half fixed costs, so a bigger array pays back much faster.
The feed-in tariffs here in my state are effectively nothing.
I'd like to wait for battery prices to come down so I can go completely off grid. (though this may not happen with cars gobbling up all the batteries for a long time to come)
I think as electricity gets cheaper and cheaper, connection costs will get more and more expensive, so being able to disconnect will be a significant saving.
Right now we are working to remove all gas appliances here at home so we can disconnect from the Gas entirely.
Then you need to store the excess power to use throughout the rest of the day. If you're off grid, this means a lot of battery. If you're on grid (grid tie) you can generally put your excess power on the grid, then draw it back out throughout the day and your utility company will "net meter" periodically so you only pay for the difference you used, or they pay you for the excess you didn't use.
What utility companies pay for excess residential has evolved and is evolving. A few years ago you could get the full domestic rate (~ $.12 per kw/h) and that is a fantastic rate. Now utilities are pushing for a lower rate to take into account for delivery costs solar does not require [1].
[1] https://insideclimatenews.org/news/11062019/rooftop-solar-ne...
So while I can get 100% renewable from the grid, I'll stick with that, at least until an installation can pay for itself in just a few years.
There is nothing wrong with it, but i dont see how your expectation of a 98%?safe investment paying for itself in 5 years is justified.
Once that happens, it’s also safe to buy it regardless of whether it takes 15 years or more so I sell the house. The buyer will pay more for my house.
That’s not the case yet. Solar doesn’t add a value equivalent to the investment to the house, so unless I plan on staying until it’s paid off - it’s not worth it. But I think this will change.
I just got my first utility bill with a community solar monetary credit. I wrote the following piece attempting to figure out the energy flows -- as opposed to the dollar flows.
-- cut here --
OK. I have a(n energetic) head scratcher with my latest unbundled electricity bill. It's the first one that includes a community solar subscription. For geeks, this is almost a thermodynamics question about systems and surroundings -- but it's camouflaged as a monetary problem in disguise...
1) My utility company (NYSEG) charges me a per kW-hr fee for "transmitting" electricity and servicing their infrastructure. Fine and dandy. I understand that perfectly.
2) There is a separate per kW-hr fee from a different supplier of electricity with whom I have contracted for power. Again, I understand that perfectly.
3) Now the head scratcher. My "community solar" account just started contributing PV energy to the grid from a recently completed solar farm. My fraction of energy generated from their deployment just showed up as a monetary credit to my total bill. They will invoice me of 90% of that credit, and claim that I "saved 10%" on my electricity cost. There is no statement whatsoever of the amount of electrical energy corresponding to that monetary credit.
That's the monetary accounting. Now let's examine the energy accounting.
Let's call the amount of energy from 2) above "N" for my "normal" source of electrical power. Similarly, let us call the (unknown) amount of energy from 3) above "S" for my solar PV power. (In principle, once I knew the fee per kW-hr I was being charged for the PV energy, I could convert the monetary charge to the numerical value for S. Let's leave that as an exercise to be dealt with later after I receive an invoice from the community solar provider -- which hopefully will tell me their cost-per-unit of energy.)
Clearly, I paid my normal provider for producing N units of energy. However, I actually consumed (N-S) units of their energy, because I (notionally) also received S units of solar energy. I understand perfectly that electricity on a transmission line is fungible, hence I don't actually receive "electrons" (so to speak) from either of them. The community solar project will also get paid (at their claimed "discounted" rate) for producing S units of energy and delivering it to me via NYSEG.
My conundrum: It seems to me that (N+S) units of electrical energy have been produced and paid for, but only N units have been consumed. Hence there are (N+S) - N = S units of electrical energy "somewhere" that are generated but not consumed via this accounting system.
Where are those S units? Who owns them? Are they simply going towards heating up the transmission lines, or is somebody benefiting from them?
Is it simply the case that NYSEG no longer has to pay for the energy consumed in heating up their transmission lines, but are still charging me the same transmission fees???
I don't know the answer to this problem.
Discuss.
I still argue that (N+S) units of energy are actually generated. The original generator of N units has no knowledge of the community solar arrangement, and is producing the N units of energy. Unless the community solar is lying about producing S units of energy -- remember, they are never disclosing S, only the associated monetary amount -- they too are selling S units to somebody else at a wholesale rate but getting their cash flow augmented by invoicing me. What a tangled web of cashflows!
I think that a PV array on the roof is preferable in situations where a purchaser is able to do that. Less financial engineering, and more physics! YMMV.
I want to see a spreadsheet to help me plan out energy use, peak need, whether batteries are worth buying, amount I could sell back, number of panels needed, amortized cost against savings etc. Extra points for thinking tax benefits and estimating the depreciating cost of panels vs the increasing cost of electricity and where the intersection is (or was, if passed) to pull the trigger on a capital expenditure, etc
My initial foray so far has been vendors see this as a qualitative decision rather than a quantitative decision with little support for this approach. For me it's purely a numbers game.
Anyway, I'm sure HN'ers are most likely to be thinking similarly - any pointers or resources to help others?
The more I think about it, there's probably a startup here...