In 2018, we
installed 14 solar panels on the Northwest roof of our house.
This is a little silly: wouldn’t you want to install them facing the
sun? The problem was the enormous tree to our Southeast, twice the
height of our house, completely shading that area. It was a great
tree, but it was causing problems for our neighbor, so they took it
down a couple years ago. I looked at getting solar at the time and
got as far as signing a contract, but then it fell apart a week before
install when the company said they couldn’t actually install the
sunlight
backup system we had planned.
Since then, electricity has gotten more expensive while panels have
gotten more efficient and cheaper, and I started thinking more after
seeing how heat
pumps don’t work out with our electricity rates. Here’s what
we’re considering:
This is 22 QCell
425W panels initially producing 9,292 kWh/year. That would give
about ~$3.2k/y in electricity savings + credits. I got quotes from
three companies, and the best (after tax credits) was around $20k.
This is pretty good ROI, with payback in 5-6 years. But what I really
care about is how this compares to what else I would do with the
money. This isn’t money we need short term, so I think the
opportunity cost is whatever the stock market would do with $20k. But
these are very different sorts of things: with stocks you put money in
and at some point in the future you take an, ideally larger, quantity
out. With solar you put money in and then each year for the
life of the system you pay less in electricity. I don’t know the right
way to compare them in an open-ended way, but we can analyze the
decision over a specific number of years.
I’m going to model two scenarios. In the first we take $20k from
stocks to put in solar, and then invest returns back into stocks. In
the second, we leave the $20k in stocks. Results here also depend on
what happens to stocks and electricity rates. I’m going to keep
everything in 2024 dollars, and guess a real (inflation-adjusted)
price increases of 7% for stocks and 3% for electricity [1]. It got a
bit too complex for a spreadsheet, so I wrote a script [2]. It
looks like it takes a bit over seven years before solar comes out
ahead:
I’m pretty sure this is the right way to do the analysis, but it’s not
obvious: the version solar installers give you ignores opportunity
cost, and my first attempt missed that you invest your electricity
savings in stocks.
EDIT: It’s actually slightly better for solar than this analysis
suggests because stock gains are taxed at a long-term capital gains
rate when you sell, while electricity you refrain from buying is
untaxed. Unfortunately, this is hard to work into the model because
I’ve done everything in real space but capital gains are assessed in
nominal space.
Overall, this seems pretty worth it, but I’m open to being convinced
it isn’t!
[1] In 2018 we were paying $0.217/kWh ($0.265/kWh in 2024 dollars) for
electric, and now pay $0.316/kWh. This is 3%/y on top of inflation.
Evaluating Solar
Link post
In 2018, we installed 14 solar panels on the Northwest roof of our house. This is a little silly: wouldn’t you want to install them facing the sun? The problem was the enormous tree to our Southeast, twice the height of our house, completely shading that area. It was a great tree, but it was causing problems for our neighbor, so they took it down a couple years ago. I looked at getting solar at the time and got as far as signing a contract, but then it fell apart a week before install when the company said they couldn’t actually install the sunlight backup system we had planned.
Since then, electricity has gotten more expensive while panels have gotten more efficient and cheaper, and I started thinking more after seeing how heat pumps don’t work out with our electricity rates. Here’s what we’re considering:
This is 22 QCell 425W panels initially producing 9,292 kWh/year. That would give about ~$3.2k/y in electricity savings + credits. I got quotes from three companies, and the best (after tax credits) was around $20k.
This is pretty good ROI, with payback in 5-6 years. But what I really care about is how this compares to what else I would do with the money. This isn’t money we need short term, so I think the opportunity cost is whatever the stock market would do with $20k. But these are very different sorts of things: with stocks you put money in and at some point in the future you take an, ideally larger, quantity out. With solar you put money in and then each year for the life of the system you pay less in electricity. I don’t know the right way to compare them in an open-ended way, but we can analyze the decision over a specific number of years.
I’m going to model two scenarios. In the first we take $20k from stocks to put in solar, and then invest returns back into stocks. In the second, we leave the $20k in stocks. Results here also depend on what happens to stocks and electricity rates. I’m going to keep everything in 2024 dollars, and guess a real (inflation-adjusted) price increases of 7% for stocks and 3% for electricity [1]. It got a bit too complex for a spreadsheet, so I wrote a script [2]. It looks like it takes a bit over seven years before solar comes out ahead:
I’m pretty sure this is the right way to do the analysis, but it’s not obvious: the version solar installers give you ignores opportunity cost, and my first attempt missed that you invest your electricity savings in stocks.
EDIT: It’s actually slightly better for solar than this analysis suggests because stock gains are taxed at a long-term capital gains rate when you sell, while electricity you refrain from buying is untaxed. Unfortunately, this is hard to work into the model because I’ve done everything in real space but capital gains are assessed in nominal space.
Overall, this seems pretty worth it, but I’m open to being convinced it isn’t!
[1] In 2018 we were paying $0.217/kWh ($0.265/kWh in 2024 dollars) for electric, and now pay $0.316/kWh. This is 3%/y on top of inflation.
[2] In python:
STOCK_GROWTH_REAL=0.07 ELECTRIC_GROWTH_REAL=0.03 PRODUCTION_DECAY=0.9966 INCENTIVE_DECAY=0.945 INIT_PRODUCTION_kWh=9_292 INIT_ELECTRIC_RATE=0.32 INIT_INCENTIVE_RATE=0.033 SOLAR_COST=20_000 YEARS=20 solar_stocks = 0 non_solar_stocks = SOLAR_COST production = INIT_PRODUCTION_kWh electric_rate = INIT_ELECTRIC_RATE incentive_rate = INIT_INCENTIVE_RATE print(“year”, “solar value”, “no-solar value”, sep=”\t”) for year in range(YEARS): production *= PRODUCTION_DECAY electric_rate *= 1 + ELECTRIC_GROWTH_REAL incentive_rate *= INCENTIVE_DECAY solar_stocks *= (1 + STOCK_GROWTH_REAL) non_solar_stocks *= (1 + STOCK_GROWTH_REAL) solar_stocks += production * (electric_rate + incentive_rate) print(year+1, solar_stocks, non_solar_stocks, sep=”\t”)Comment via: facebook, mastodon