1. You need to take into account depreciation of the value of the panels. They degrade in performance and eventually will be worthless after about 30 years.
2. You need to take into account inflation against the CD roi (or conversely the /appreciating/ value of the dollar value of the energy produced by the panels). The post-inflation value of the bank CD is going to be about 2% per year. Inflation does not need to be corrected for the solar power option because it produces energy instead of dollars.
(1000/y-8000/30y)/$8000 = 733/8000 = 9.1% depreciation-adjusted ROI from solar panels
5.5% - 3.3% inflation = 2.2% inflation-adjusted ROI from bank CDs.
So solar panels are about a 4x better investment than bank CDs, contrary to your comment where they are somewhat comparable.
bank cds do not pay a reasonable discount rate, it's true, but there are investments that do. maybe a nice index fund balanced with a money market fund?
you should also take into account the precipitous drop in electricity prices starting 10 years from now
Just comparing expected value is fine as a stopping point in your thought process if you are risk neutral — in that case, you should buy leveraged stock funds to maximize your expected value.
If you are like most people and assign some internal cost to risk, then covering your innate short position on power while also getting 9% return on investment after inflation is a no-brainer.
> Still might be worth it to you, but also might not.
Are you trying to be intentionally obtuse?
With your numbers you're talking about putting $580 a year into my bank account for 14 years, and then me having free electricity for at a minimum another decade.
In what possible world could that be "not worth it" ?