Welcome to City-Data.com Forum!
U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Retirement
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
Reply Start New Thread
 
Old 07-23-2013, 10:59 AM
 
Location: Maryland
1,534 posts, read 4,261,303 times
Reputation: 2326

Advertisements

Quote:
Originally Posted by mathjak107 View Post
pilgrim:
If you are using a reverse amortization calculator it will not work.

it assumes a certain gain and inflation rate year after year as a constant.

the real world order of gains ,losses and years of negative real returns and inflation make for totally different results than straight line.
MJ: I've no clue what you're referring to in the context of ER's post.(Yes, I'm familiar with RA calculators, as well as most other types). I don't use calculators as I've developed my own Excel worksheets/macros/etc. over the years. (I used to teach Excel as part of my job.) We former accountant/financial analysts tend to be relatively conversant with the subject.

And no, I don't use constant inflation rates or any other typical gain or loss assumptions. I've been computing my own, real world inflation factors for decades. Like you, I'm well aware of the real world impacts of the order of gains, losses and inflation rate variables.
Reply With Quote Quick reply to this message

 
Old 07-23-2013, 11:08 AM
 
Location: Central Massachusetts
6,593 posts, read 7,090,056 times
Reputation: 9333
Quote:
Originally Posted by goldengrain View Post
Yes, certainly there should be something in a person's life, when he starts his life of earning, that guides him towards investment. Those early years are the one's that mean the most with compounding, and also when you should be learning things about how to handle risk.

Yes there should be a users manual for life. It would be a huge book and it should be geared towards the sexes, one for women the other for men.
Reply With Quote Quick reply to this message
 
Old 07-23-2013, 11:10 AM
 
106,671 posts, read 108,833,673 times
Reputation: 80164
Quote:
Originally Posted by Pilgrim21784 View Post
MJ: I've no clue what you're referring to in the context of ER's post.(Yes, I'm familiar with RA calculators, as well as most other types). I don't use calculators as I've developed my own Excel worksheets/macros/etc. over the years. (I used to teach Excel as part of my job.) We former accountant/financial analysts tend to be relatively conversant with the subject.

And no, I don't use constant inflation rates or any other typical gain or loss assumptions. I've been computing my own, real world inflation factors for decades. Like you, I'm well aware of the real world impacts of the order of gains, losses and inflation rate variables.
I was just trying to see why your results differed from golfingduo without checking them myself through firecalc
Reply With Quote Quick reply to this message
 
Old 07-23-2013, 11:48 AM
 
31,683 posts, read 41,040,852 times
Reputation: 14434
Everyone with pensions should use FireCalc and then monitor the discussions of folks who use it and don't have pensions. You will realize how blessed you are,
Reply With Quote Quick reply to this message
 
Old 07-23-2013, 11:51 AM
 
Location: Los Angeles area
14,016 posts, read 20,907,290 times
Reputation: 32530
Quote:
Originally Posted by Pilgrim21784 View Post
Amigo, don't mean to be picky, BUT - you are doing something seriously incorrect with the calculator or being very casual with rounding. $40K inflated over 15 years at a 3% factor requires $806,275, and thats assuming 0% return on the yearly declining balance.

The balance from $1M at the EOY 16 (end of year) (age 70-85) would be $193,725. $1M, $40K inflated at 3% per year with 0% earnings would cover 18.93 years. Note that I used a base year + 15, which is the 70 thru 85 number of periods.

I quite understand your basic point but unless you're rounding 800k ish to a M and disregarding almost several 100sK, recheck your calculator. I suspect the vast majority of folks wouldn't disregard the ending balance or the additional almost 4 years of coverage. Yes, we former financial types are anal about accuracy.
Well I personally am not doing anything incorrect at all, because all I did was plug numbers into one of the three links to calculators provided by a post of Golfingduo, and I believe it was the third one listed. You have calculated a different result. Maybe if I had tried all three calculators I might have gotten three different results, I don't know. I did it as a lark, just to see what would happen; the result means absolutely nothing to me and matters to me not one iota. I am set for life. At age 69, I save about $2,000 per month out of my retirement income, which will go down to $1,000 in two more years. I have a paid off townhouse and very substantial reserves in case I would ever need to spend more than my pension income, which is totally inconceivable to me anyway.

As for the rounding it came out to $900,000 plus change, something like $943,000 if memory serves, so I called it "almost a million" in my post, but it's of no interest to me anyway other than idle curiosity.

I did not enter my pension into the calculator because I was curious to see what one calculator would think I needed to live to age 85 spending $40,000 per year. For gains on the unspent funds I plugged in 1% just to be conservative. It's all pretty meaningless anyway in my case. We might as well argue about how many angels can dance on the head of a pin, as far as I am concerned.
Reply With Quote Quick reply to this message
 
Old 07-23-2013, 01:40 PM
 
Location: Great State of Texas
86,052 posts, read 84,481,831 times
Reputation: 27720
Quote:
Originally Posted by TuborgP View Post
Everyone with pensions should use FireCalc and then monitor the discussions of folks who use it and don't have pensions. You will realize how blessed you are,
How true. I just went and tried with and without pension money and what a difference.

I had a 48% chance of not running out of money in 30 years vs a 98% chance of not running out of money.
Reply With Quote Quick reply to this message
 
Old 07-23-2013, 01:51 PM
 
31,683 posts, read 41,040,852 times
Reputation: 14434
Quote:
Originally Posted by HappyTexan View Post
How true. I just went and tried with and without pension money and what a difference.

I had a 48% chance of not running out of money in 30 years vs a 98% chance of not running out of money.
Bada Bing we have. 99 percent plus rate of not running out of money barring a pension or SS disruption. In fact the investment balance becomes truly impressive. We are already in the Permanent accumulation phase. FireCalc is very assuring, however I know for others it reflects real uncertainties and ever changing assumptions. Anyone with a pension who wants to try FireCalc should convert their pension benefit to a lump sum amount necessary to provide that amount at a 3 and 4 percent drawdown rate and watch the possible differences.
Reply With Quote Quick reply to this message
 
Old 07-23-2013, 04:58 PM
 
Location: Maryland
1,534 posts, read 4,261,303 times
Reputation: 2326
ER - no offense was intended, its not a matter of argument, just simple math. Something is flakey with the calculator you used. Any calculator should provide the same answer.


3.00% $1,000,000
1 70 $40,000 $960,000
2 71 $41,200 $918,800
3 72 $42,436 $876,364
4 73 $43,709 $832,655
5 74 $45,020 $787,635
6 75 $46,371 $741,264
7 76 $47,762 $693,502
8 77 $49,195 $644,307
9 78 $50,671 $593,636
10 79 $52,191 $541,445
11 80 $53,757 $487,688
12 81 $55,369 $432,319
13 82 $57,030 $375,288
14 83 $58,741 $316,547
15 84 $60,504 $256,043
16 85 $62,319 $193,725
17 86 $64,188 $129,536
18 87 $66,114 $63,423
19 88 $68,097 -$4,675

18th Year Balance Equals 93.14% of the 19th year value.
Total Coverage = 18.93 years
Reply With Quote Quick reply to this message
 
Old 07-23-2013, 05:27 PM
 
Location: Central Massachusetts
6,593 posts, read 7,090,056 times
Reputation: 9333
Quote:
Originally Posted by Pilgrim21784 View Post
ER - no offense was intended, its not a matter of argument, just simple math. Something is flakey with the calculator you used. Any calculator should provide the same answer.


3.00% $1,000,000
1 70 $40,000 $960,000
2 71 $41,200 $918,800
3 72 $42,436 $876,364
4 73 $43,709 $832,655
5 74 $45,020 $787,635
6 75 $46,371 $741,264
7 76 $47,762 $693,502
8 77 $49,195 $644,307
9 78 $50,671 $593,636
10 79 $52,191 $541,445
11 80 $53,757 $487,688
12 81 $55,369 $432,319
13 82 $57,030 $375,288
14 83 $58,741 $316,547
15 84 $60,504 $256,043
16 85 $62,319 $193,725
17 86 $64,188 $129,536
18 87 $66,114 $63,423
19 88 $68,097 -$4,675

18th Year Balance Equals 93.14% of the 19th year value.
Total Coverage = 18.93 years

Now I am a math scholar .
Reply With Quote Quick reply to this message
 
Old 07-23-2013, 06:59 PM
 
Location: SW MO
23,593 posts, read 37,479,020 times
Reputation: 29337
Quote:
Originally Posted by TuborgP View Post
Everyone with pensions should use FireCalc and then monitor the discussions of folks who use it and don't have pensions. You will realize how blessed you are,
Don't need no freakin' calculator, earth, wind or fire, to tell us how fortunate we are. We managed to figure that out long before we retired just using our wee little brains. Imagine that!
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:


Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Retirement

All times are GMT -6. The time now is 01:45 PM.

© 2005-2024, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Contact Us - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37 - Top