![]() |
|
|
|
#61 | |
|
Full time employment: Posting here.
![]() ![]() ![]() ![]() ![]() Join Date: Jan 2008
Posts: 798
|
Quote:
Don't be closed minded now. ![]() Last edited by RockOn; 05-13-2008 at 04:38 PM. |
|
|
|
|
|
|
#62 |
|
Full time employment: Posting here.
![]() ![]() ![]() ![]() ![]() Join Date: Jan 2008
Posts: 798
|
That's really not accurate because you are also withdrawing principle from the account during that timeframe. The IRR calc is needed to calculate the return. I ran an example where $1,000,000 was put in at a $73,000 payout for 28 yeas without COLA. The IRR on that example is 5.8%. Notice the total payments are about the 2x that rs0460a suggested.
|
|
|
|
|
|
#63 |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: May 2008
Posts: 59
|
If you get $2 million in payments for an original "investment" or premium of $1 million, your "return" is $1 million over the principal/investment/premium of $1 million, no?
I realize I may be oversimplifying but I guess we're trying to describe a withdraw plan in terms of other investments. BTW, that example is single-life only, no guaranteed period, no COLA, no cancellation option? |
|
|
|
|
|
#64 |
|
Give me a museum and I'll fill it. (Picasso)
Give me a forum ... ![]() ![]() ![]() ![]() ![]() ![]() ![]() Join Date: Dec 2003
Location: Hot cross bun
Posts: 21,358
|
I'm not. Its just that I can do math and use reasonable parameters in my calculations.
__________________
Mr. Poopyhead |
|
|
|
|
|
#65 |
|
Thinks s/he gets paid by the post
![]() ![]() ![]() ![]() ![]() ![]() Join Date: Jul 2005
Posts: 2,388
|
its very easy to manipulate the numbers on an annuity to reflect what you want ... if you think about it i can say at a 7% withdrawl rate from an immeadiate annuity at 7% the first 10 years they give you back your own money. thats zero return.... the first hint of a real return would be starting year 11... so if you figure that return for that year its like a fraction of a percent or so...... it dosnt reach anywheres near 7% until like year 18
|
|
|
|
|
|
#66 | |
|
Full time employment: Posting here.
![]() ![]() ![]() ![]() ![]() Join Date: Jan 2008
Posts: 798
|
Quote:
I'm not sure why we cannot accept the IRR calcs. There is no manipulation ntended, it is what it is. |
|
|
|
|
|
|
#67 | |
|
Full time employment: Posting here.
![]() ![]() ![]() ![]() ![]() Join Date: Jan 2008
Posts: 798
|
Quote:
Try this, if you invested $1 million in a Mututal Fund and made 6% annualized; or, in the SPIA (6% IRR) I am talking about, and made the same number of withdrawals for the same amount over the same number of years, the outcome would be the same. Account depleted at age 86.The IRR calculation compares apples to apples. If you don't believe it set up a spreadsheet and work through it year by year, you'll see what I mean. P.S. my example was for a single, COLA plan (assumed 2.8% inflation), no guaranteed period, no cancelation, but any option you choose would likely calculate to be the same IRR if it is from the same company and the inputs on age remain the same. If you want me to calc a specific one for you, let me know the inputs. Last edited by RockOn; 05-13-2008 at 07:00 PM. |
|
|
|
|
|
|
#68 | ||
|
Moderator Emeritus
![]() ![]() ![]() ![]() ![]() ![]() ![]() Join Date: Feb 2004
Location: Oahu
Posts: 15,095
|
Quote:
Quote:
But I care about the quality of the info & discussion on this board, and I think that yours could be better. Look at the statements you're making above. You have many qualifiers on your calculations... and I'm not seeing your calculations because you don't put up numbers or tables or formulae or links to websites that walk everyone through the process for us to check on our own. Perhaps this is why people are skeptical of your numbers and your conclusions-- because others are having a hard time replicating your results. By the way if you give an insurance company a bunch of your money and they eventually give your money back to you, then I don't care what the IRR is. You're no more well off than if you'd kept it at a discount brokerage, and quite possibly worse off. But if you can show where return of principal is included in the standard calculations then we can have a more constructive discussion. Well, sure, if you can't get your position to stand on its own merits then you can always counterattack or make fun of the other posters!
__________________
* * For more info see "About Me" in my profile. |
||
|
|
|
|
|
#69 | |
|
Full time employment: Posting here.
![]() ![]() ![]() ![]() ![]() Join Date: Jan 2008
Posts: 798
|
Quote:
P.S. If I need to run through the exact calcs, I could, but why doesn't someone just come on board and verify my results. It would be easier. Last edited by RockOn; 05-13-2008 at 07:30 PM. |
|
|
|
|
|
|
#70 | |
|
Give me a museum and I'll fill it. (Picasso)
Give me a forum ... ![]() ![]() ![]() ![]() ![]() ![]() ![]() Join Date: Dec 2003
Location: Hot cross bun
Posts: 21,358
|
Theres a reason for that.
Quote:
Sigh. I need to stop pushing that dang shiny, pretty, inviting red button... ![]()
__________________
Mr. Poopyhead |
|
|
|
|
|
|
#71 | |
|
Full time employment: Posting here.
![]() ![]() ![]() ![]() ![]() Join Date: Jan 2008
Posts: 798
|
Quote:
If you need the inputs for the IRR calc, I can come up with them again. I erased them as I did another calc on my calculator. This is unreal. There is no BS going on here. The annuity does have a 6% IRR (Actually 5.94% if I remember right) for my age of 53 living to 86 with a 2.8% COLA and using Vanguards payouts. Is it that hard to believe? |
|
|
|
|
|
|
#72 | |
|
Full time employment: Posting here.
![]() ![]() ![]() ![]() ![]() Join Date: Jan 2008
Posts: 798
|
Quote:
This is what 2B found: "I went on the Vanguard site and put in a Texas male born on Jan 1, 1955 that would start receiving annuity payments annually on Jan 1, 2009. If you assume receiving 35 payments (age 86), I got an IRR of 6.36%. Live to 76 and it falls to 5.14%. Live to 96 and the IRR becomes 6.82%. This is the same story. Live forever and an annuity starts looking pretty good" (2B might have a small error, it is 31 payments, I'm not sure if he really used that or the 35.) 2B's results were slightly better than my calc for age 53. It is a 6% IRR, roughly. I'd say live to 86 and it starts looking pretty good. P.S. my CPI rants are mostly for a little fun. It's beyond anything we can do anything about. I'm not just having a little fun here. Explanade asked some questions, I answered them the best I could. I would not want to mislead him. If I am wrong, please correct me so he/she doesn't make a bad decision. I started the Thread to see what people thought about the question of whether annuities were safe. Last edited by RockOn; 05-13-2008 at 08:36 PM. |
|
|
|
|
|
|
#73 |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: Dec 2003
Posts: 173
|
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 |
|
|
|
|
|
#74 | |
|
Full time employment: Posting here.
![]() ![]() ![]() ![]() ![]() Join Date: Jan 2008
Posts: 798
|
Quote:
My conclusion: SPIA's, at todays payouts, are equivalent to buying a perpetual bond with a rate of 6% if you live about 30 years. If you hold any perpetual bond, the real value (by that I mean inflation adjusted) of that bond decreases toward zero with time. Just like an annuity goes to zero. If you live longer than 30 years, you do better, if you die sooner they were not as good a deal. However the guaranteed income does provide a level of security for a lifetime. The biggest downside is the single company risk of the insurance company, some of that is mitigated by regulation, state guarantees and diversification. To me they make sense for conservative retirees and as an option for the fixed portion of a portfolio for older people. Last edited by RockOn; 05-14-2008 at 10:39 AM. |
|
|
|
|
|
|
#75 |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: Oct 2003
Posts: 427
|
I have run the numbers as provided by RockOn (more or less) and although I have some minor questions about his methodology, the IRR that I get is ~5.96%. This seems within spitting distance of 6% to me.
I couldn't get an instant quote from the Vanguard site for 1 million, so I used 100K figuring on proportionality. I couldn't get a COLA of 2.8%. I used the COLA button with unknown future CPI changes (this run yielded IRR=5.53%) and 2 runs with graduated payments of 2% and 3%. These yielded the 5.96%. A fixed payout with no COLA yielded 5.93%. I used excel w/IRR function starting with an inital payment of 100,000 and annual annuity payments from the various quotes for ages 55 - 86. My HP 12c calculator won't accept more than 20 uneven cash flow entries so I don't know how it can be used for calculations of that many COLAed yrs (and punching in all those numbers would be tedious). Quick and easy w/excel. I have no opinion one way or another on this issue. I have no need for an annuity in addition to our STRS pensions. Others might find some value in it.
__________________
a surfer who hasn't wised up to the importance of hard shoes.... |
|
|
|
|
|
#76 | |
|
Full time employment: Posting here.
![]() ![]() ![]() ![]() ![]() Join Date: Jan 2008
Posts: 798
|
Quote:
I learned something, I didn't know excel had that function. I usually use my HP, don't remember the model, it's the slightly upgraded business model. Excel from now on! |
|
|
|
|
|
|
#77 |
|
Moderator Emeritus
![]() ![]() ![]() ![]() ![]() ![]() ![]() Join Date: Feb 2004
Location: Oahu
Posts: 15,095
|
While I appreciate the apology, it's not "fun" if your defense consists of having it at the expense of another poster.
I'm glad others were able to come to the rescue of your claims.
__________________
* * For more info see "About Me" in my profile. |
|
|
|
|
|
#78 | |
|
Full time employment: Posting here.
![]() ![]() ![]() ![]() ![]() Join Date: Jan 2008
Posts: 798
|
Quote:
You have to remember that today I believe I was forcefully inducted into the mental masturbating tinfoilish hatter group. Maybe that was only ladelfina, wasn't sure on that. ![]() |
|
|
|
|