Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Mixed Portfolio - what am I doing wrong?
Old 11-11-2015, 06:29 AM   #1
Confused about dryer sheets
Join Date: Nov 2015
Posts: 3
Mixed Portfolio - what am I doing wrong?

First, a great program. Been looking for a long time for something like this!

Everything seems to work fine except when running using the “mixed portfolio option” the maximum number of cycles comes up at 49; this seems about 9 or 10 years too short.

1927 + 49cycles = 1976 + 30years = 2006. Why not 57 cycles to 2014?

I’m using $1m and 30 year retirement, and a mixed portfolio of 50% LT Corp Bonds and 50% SP500. Any ideas?


Japple55 is offline   Reply With Quote
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 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!

Old 11-11-2015, 07:04 AM   #2
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
Join Date: Jun 2002
Location: Texas Hill Country
Posts: 45,328
You aren't doing anything wrong, it is a data availability issue.

I was unsuccessful in my attempt to find a link to an explanation by Dory 36 (creator of FIRECalc), but here is my recollection of why you aren't seeing the number of cycles you expected.

From "How it Works"
FIRECalc's standard model uses the overall US stock market performance.
Dory 36 found this data going back to 1872 and included it in the default calculator. Unlike data on the overall performance of the market, history on the individual components in the mixed portfolio option aren't available back that far. Net result - fewer cycles available for your calculation.

EDIT: Realized I answered a question not asked. Never mind.

Numbers is hard

Charter resident of the lumpen slums of cyberspace

Retired in 2005 at age 58, no pension
REWahoo is offline   Reply With Quote
Old 11-11-2015, 07:23 AM   #3
Thinks s/he gets paid by the post
Senator's Avatar
Join Date: Feb 2014
Location: Eagan, MN
Posts: 3,530
If you want to experiment more, use half as much money and go half as long. That will give more cycles, and maybe the same result or more conservative. Actually a longer term horizon should be better in regards to market returns.
FIRE no later than 7/5/2016 at 56 (done), securing '16 401K match (done), getting '15 401K match (done), LTI Bonus (done), Perf bonus (done), maxing out 401K (done), picking up 1,000 hours to get another year of pension (done), July 1st benefits (vacation day, healthcare) (done), July 4th holiday. 0 days left. (done) OFFICIALLY RETIRED 7/5/2016!!
Senator is offline   Reply With Quote
Old 11-11-2015, 09:38 AM   #4
Confused about dryer sheets
Join Date: Nov 2015
Posts: 3
Thanks REWahoo and Senator. I was thinking it may have been related to data. However, the disclosure "(based on performance since 1927)" implies that data begins in 1927 for all asset classes. I would have thought the disclosure would show the most recent year for which data existed for the entire set.

I just tested using 100% allocation for each asset class individually and only got 49 cycles for each one, so apparently it only computes for a maximum of 49 cycles regardless of allocation. There's no way to tell what the data limitations are.

I then tested (separately) 100% allocations to SP500 and 1 month Tbills, and the spreadsheet showing performance for each from 1927 appeared to closely match actual performance for those asset classes. I would think if data was missing, it would be early in the data stream, so now I'm not so sure the problem is missing data.

All that leads me to believe that a setting telling Firecalc how many years to compute is incorrect. (IMHO)
Japple55 is offline   Reply With Quote
Old 11-11-2015, 02:58 PM   #5
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Join Date: Sep 2005
Location: Northern IL
Posts: 21,496
I'll make a guess, but the support staff here will need to validate this:

The original author has not been involved for some time ( ~ 2006? coincides with your data observation)

Good catch!!! OK, here's the answer:

FIRECalc updated for Q4 2008

By the way... the only updated data I have is the "standard" market and interest data. So the "mixed portfolio" will not include the new data. ...
So if the current support staff cannot obtain/enter this data, it would be nice to at least add a note on that selection to avoid these surprises. That doesn't fully explain the 2006-2008 gap, but I'd bet it's related.

ERD50 is online now   Reply With Quote
Old 11-11-2015, 04:46 PM   #6
Confused about dryer sheets
Join Date: Nov 2015
Posts: 3
Thanks ERD50, that explains it. Lacking the most current data is the last thing I would have thought of, but then I just discovered Firecalc, and know nothing of the history. Since that data is readily available, I hope whoever is supporting the site will be able to get it updated or, as you suggested, at least add a note indicating same.

Japple55 is offline   Reply With Quote

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

Advanced Search
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Confused about the Mixed Portfolio nuke_diver FIRECalc support 3 07-16-2014 09:40 AM
mixed portfolio volatility assumptions? Bongleur FIRECalc support 4 12-07-2010 12:15 AM
Best Mixed Portfolio? Sam FIRECalc support 35 08-12-2007 10:22 AM
Best Mixed Portfolio? Sam FIRE and Money 32 08-10-2007 05:46 PM
Mixed portfolio data set - allow change of starting year? wasdana FIRECalc support 0 08-12-2006 03:10 PM

» Quick Links

All times are GMT -6. The time now is 08:38 PM.
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2019, vBulletin Solutions, Inc.