Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
firecalc excel export does not match chart
Old 03-27-2017, 11:40 AM   #1
Recycles dryer sheets
 
Join Date: Mar 2017
Posts: 179
firecalc excel export does not match chart

Hi first post here , I've been poking around with firecalc and ******** for a while now and am confused by what I'm seeing in the export of data option from firecalc. When the option is selected form the "Investigate" tab you are presented with a link to a spreadsheet of end of year balances, saying "Open an (unformatted) Excel spreadsheet showing the inflation-adjusted end-of-year portfolio balances". If I open that spreadsheet, the end of year balances do not match what I'm seeing on the chart. For example if I leave the default options of 30k withdrawal on 750k for 30 years (and no other defaults changed), the text on the results page says the ending balances fall between -300,739 and $4,259,606, and the chart visually agrees. However if I click that link to export the data, a simple max and min in excel gives me a min of -1,387,962 and a max of 8,699,183. I would have thought this was a difference in inflation, but the text by the link says clearly "showing the inflation-adjusted end-of-year balances". I am a new to a lot of this so perhaps I don't understand what 'inflation-adjusted' really means? Or is there something else going on?

Perhaps I don't really need to export to do the analysis I intend, and others here can help point me in an easier way to the analysis I'm looking for. I've decided my goal balance for FIRE is 3mil, so I now want to see how much I should aim to save each year to get there ASAP. I was exporting the results of the firecalc sim for time leading up to retirement, but not including any years of post-retirement withdrawals, and then doing some simple excel functions to determine what percentage of the simulations resulted in me being able to retire before 65, before 55, and before 50. My goal is to retire in 20 years at 53 so I want to see how likely I am able to do that with various saving plans. Is there a better way to do this? It seems like neither firecalc or ******** are build to do this particular task well, hence the export for further manipulation of data.

Thanks for any help.
mrWinter 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 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!

Reply

Tags
firecalc


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
Does this chart indicate anything unsettling to you? Markola Stock Picking and Market Strategy 33 03-30-2016 04:58 PM
How does Pension and Off-Chart Spending Impact Numbers? ace_club FIRECalc support 2 01-22-2016 04:26 PM
Firecalc does not figure taxes? bulbar FIRECalc support 9 08-15-2014 01:56 PM
GM suspends 401(k) match for salaried employees Marketneutral FIRE and Money 72 12-16-2005 05:57 PM

» Quick Links

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