Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 08-15-2004, 02:42 PM
J MacQuarrie
Guest
 
Posts: n/a
Default Re: Lifetime Planner: Inflation Computation

I played with your scenario a bit and believe I found how it is calculated.
It is a rounding error of sorts.

If you change the date the income is received to any month in 2009 you get
the same result ($958), which means that Money isn't calculating by the
month, but rather by the number of years. If you instead make the income
come in January of 2010, you'll see a result of $948 (which is a rounding
error of the expected result of $948.90 but is much closer to your
calculated result).

Money is apparently calculating that 2009 is about 4 years from August 2004
(when you made the calculation) regardless of the month in 2009 that the
income comes in.

If you run your calculation below for 4 years rather than 5, you'll come out
close to the $958 number that money is calculating.

I found your question interesting as a math problem but agree with the other
response from SJCOHEN730 that the Lifetime Planner is a great tool for it's
purpose. Remember that the calculations in the Planner are also limited by
the assumptions that are made and so expecting it to calculate every number
down to the exact day I believe would be wasted effort.

Thanks for pointing this out and enjoy using the Planner. I find it to be
the best tool around to plan for retirement.

Jeff

As with the other response, I believe for it's purpose the way money is
calculating is fine.
"Tom" <anonymous[at]discussions.microsoft.com> wrote in message
news:523701c480ae$2bb5dc20$a501280a[at]phx.gbl...
- quote -

> It is not clear how the Lifetime Planner in Money 2004
> converts current dollars into future dollars. Consider a
> test case of $1,000 of "other income" received just once
> in August, 2009 (i.e., five years from now), growing
> at "inflation minus 1%" (i.e., at 2.5% where inflation is
> set to 3.5%).
> The $1,000 is loosing purchasing value at the rate of 1%
> per annum. Compounded for five years, the percent
> decline should be equal to (1+0.01)^5 - 1 = 5.101%.
> Therefore, the value of the income in current dollars (in
> August, 2009) should be = $1,000 - 5.101% = $949.
> However, the Lifetime Planner reports the inflow income
> amount in the "Yearly Snapshot" in August, 2009 as $958 -
> almost a 1% error. (For longer durations or larger
> amounts, of course, the error is magnified.)
> Having experimented with other test cases, I am confident
> that the issue is NOT "rounding error." How, therefore,
> does the Lifetime Planner compute the impact of inflation
> on a future income amount?
> Your assistance will be appreciated.



 
Old 08-13-2004, 12:23 AM
SJCOHEN730
Guest
 
Posts: n/a
Default Re: Lifetime Planner: Inflation Computation

- quote -

> Subject: Lifetime Planner: Inflation Computation
> From: "Tom" anonymous[at]discussions.microsoft.com
> Date: 8/12/2004 4:51 PM Eastern Daylight Time
> Message-id: <523701c480ae$2bb5dc20$a501280a[at]phx.gbl> It is not clear how the Lifetime Planner in Money 2004
> converts current dollars into future dollars. Consider a
> test case of $1,000 of "other income" received just once
> in August, 2009 (i.e., five years from now), growing
> at "inflation minus 1%" (i.e., at 2.5% where inflation is
> set to 3.5%).
> The $1,000 is loosing purchasing value at the rate of 1%
> per annum. Compounded for five years, the percent
> decline should be equal to (1+0.01)^5 - 1 = 5.101%.
> Therefore, the value of the income in current dollars (in
> August, 2009) should be = $1,000 - 5.101% = $949.
> However, the Lifetime Planner reports the inflow income
> amount in the "Yearly Snapshot" in August, 2009 as $958 -
> almost a 1% error. (For longer durations or larger
> amounts, of course, the error is magnified.)
> Having experimented with other test cases, I am confident
> that the issue is NOT "rounding error." How, therefore,
> does the Lifetime Planner compute the impact of inflation
> on a future income amount?
> Your assistance will be appreciated.


Tom,
Quite seriously, I think you are expecting way too much from the Money program.
The fact that the Lifetime Planner is able to project back future income amazes
me in the first place. This is a program that costs less than $50 and is meant
for general use by people managing their money. If your purpose is to test out
the abilities of the program, I think you have found out it is doing pretty
darn good! Steve
  #-1  
Old 08-12-2004, 08:51 PM
Tom
Guest
 
Posts: n/a
Default Lifetime Planner: Inflation Computation

It is not clear how the Lifetime Planner in Money 2004
converts current dollars into future dollars. Consider a
test case of $1,000 of "other income" received just once
in August, 2009 (i.e., five years from now), growing
at "inflation minus 1%" (i.e., at 2.5% where inflation is
set to 3.5%).

The $1,000 is loosing purchasing value at the rate of 1%
per annum. Compounded for five years, the percent
decline should be equal to (1+0.01)^5 - 1 = 5.101%.
Therefore, the value of the income in current dollars (in
August, 2009) should be = $1,000 - 5.101% = $949.
However, the Lifetime Planner reports the inflow income
amount in the "Yearly Snapshot" in August, 2009 as $958 -
almost a 1% error. (For longer durations or larger
amounts, of course, the error is magnified.)

Having experimented with other test cases, I am confident
that the issue is NOT "rounding error." How, therefore,
does the Lifetime Planner compute the impact of inflation
on a future income amount?

Your assistance will be appreciated.
 

Tags
computation, inflation, lifetime, planner
Similar Threads
Thread Forum Replies Last Post
Lifetime Planner Report
BobA: I printed the 20 pages of the Lifetime Planner and notice that several of the graphs on the later pages show blank. Does anyone know how to view...
Microsoft Money 1 09-23-2003 11:28 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 05:48 PM.