Portal Forums Links Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read

Future value & weighted average rates of return
 10-13-2012, 01:23 PM #1 Confused about dryer sheets   Join Date: Jan 2011 Posts: 4 Future value & weighted average rates of return Greetings, Why is it that Future Value calculations don't seem to handle weighted average rates of return very well? I notice this both in FireCalc and Excel. For instance: The future value of \$400,000 @ 10% annual rate of return for 30 years is \$6,979,760.91. The future value of \$400,000 @ 5% annual rate of return for 30 years is \$1,728,776.95. The sum of these two future values is \$8,708,537.86. However, if we combine these initial amounts at the get-go and use an average annual rate of return, the result is different. The future value of \$800,000 @ 7.5% annual rate of return for 30 years is \$7,003,964.15! What is funny about this is that if I look at this on a year over year basis, the returns are identical: ........................Year 1...Year 2....Year 3....Year 4....Year 5 \$400000 @ 10% \$ 40,000 \$ 44,000 \$ 48,400 \$ 53,240 \$ 58,564 \$400000 @ 5.0% \$ 20,000 \$ 22,000 \$ 24,200 \$ 26,620 \$ 29,282 ................Total \$ 60,000 \$ 66,000 \$ 72,600 \$ 79,860 \$ 87,846 \$800000 @ 7.5% \$ 60,000 \$ 66,000 \$ 72,600 \$ 79,860 \$ 87,846 As such, in FireCalc, how does one account for the future value of different asset classes that have unique rates of return, without using a weighted average that is seemingly inaccurate? Thank you __________________ __________________
 Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free! Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE! You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more! Join Early-Retirment.org For Free - Click Here
10-13-2012, 08:29 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...

Join Date: Nov 2010
Location: Vermont & Sarasota, FL
Posts: 13,440
Quote:
 Originally Posted by ankos714 Greetings, Why is it that Future Value calculations don't seem to handle weighted average rates of return very well? I notice this both in FireCalc and Excel. For instance: The future value of \$400,000 @ 10% annual rate of return for 30 years is \$6,979,760.91. The future value of \$400,000 @ 5% annual rate of return for 30 years is \$1,728,776.95. The sum of these two future values is \$8,708,537.86. However, if we combine these initial amounts at the get-go and use an average annual rate of return, the result is different. The future value of \$800,000 @ 7.5% annual rate of return for 30 years is \$7,003,964.15! What is funny about this is that if I look at this on a year over year basis, the returns are identical: ..... As such, in FireCalc, how does one account for the future value of different asset classes that have unique rates of return, without using a weighted average that is seemingly inaccurate? Thank you
The difference is the result of compounding. Under the logic you are trying to apply the future value of \$400,000 at 10% would only be twice the future value of \$400,000 @ 5% and as you can see it is much different.

The three actual FV formulas are:

400,000 * (1+10%)^30
400,000 * (1+5%)^30
800,000* (1+7.5%)^30
__________________

__________________

 10-13-2012, 09:40 PM #3 Confused about dryer sheets   Join Date: Jan 2011 Posts: 4 Can you shed light on why: [400,000 * (1+10%)^30] + [400,000 * (1+5%)^30] does not equal [800,000* (1+7.5%)^30] As well as: How do we incorporate different assets, with different annual rates of return, into FireCalc? Any additional insights? Thanks __________________
10-13-2012, 09:46 PM   #4
Give me a museum and I'll fill it. (Picasso) Give me a forum ...

Join Date: Jun 2002
Location: Texas Hill Country
Posts: 39,412
Quote:
 Originally Posted by ankos714 How do we incorporate different assets, with different annual rates of return, into FireCalc?
See options under the "Your Portfolio" tab.

If you haven't done so already I highly recommend you spend some time learning the details of how FIRECalc works.
__________________
Numbers is hard.

Retired in 2005 at age 58, no pension

10-13-2012, 09:51 PM   #5
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...

Join Date: Nov 2010
Location: Vermont & Sarasota, FL
Posts: 13,440
Quote:
 Originally Posted by ankos714 Can you shed light on why: [400,000 * (1+10%)^30] + [400,000 * (1+5%)^30] does not equal [800,000* (1+7.5%)^30]
Due to compounding.

Quote:
 Originally Posted by ankos714 How do we incorporate different assets, with different annual rates of return, into FireCalc?
Have you looked at the options under the Your Portfolio tab? It is fairly flexible albeit not exactly what you are seeking.
__________________

 10-14-2012, 11:00 AM #6 Confused about dryer sheets   Join Date: Jan 2011 Posts: 4 Yes, I have looked there. Actually, that is what drove me to post here. I was trying to incorporate the appreciation of a multi-family real estate investment property alongside my 401k. To do so, I created a weighted average rate of return that I plugged into the last option in that section: "A portfolio with random performance, with a mean total portfolio return of % and variability (standard deviation) of %. Assume an inflation rate of %." This lead to a divergence between the weight average annual rate of return and when I calculated the returns individually for each asset class and added them together. How is real estate appreciate best incorporated into FireCalc? Thanks so much __________________ __________________

 Tags asset classes, firecalc, weight average

 Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)