Rock on, I haven't checked all your numbers, but I believe they are correct. I did my own IRR calculations and got similar results.
For example, for an SPIA with no COLA, the Fidelity annuity calculator says $632 per month payout for a 61 year old male in CA, with $100,000 initial payment. Doing the IRR calculation (which is the same as mortgage payout) for a payout period of 300 months, the IRR comes out at 0.48% per month, or 5.76% annually.
If the payout goes to 360 months, the IRR is 6.48%. For 200 months (early death) it is 2.88%.
Nothing really new here. If you live longer than average, you get a good deal; shorter, you lose out.
Can't understand why this topic arouses such ire with certain people ...
Peter