Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
FireCalc Excel Numbers are waaaay off
Old 06-25-2018, 06:52 PM   #1
Confused about dryer sheets
 
Join Date: Jun 2018
Posts: 6
FireCalc Excel Numbers are waaaay off

When you select the 'spreadsheet' option on FIRECalc the number on the sheet are consistently way off from the graphed values and the values in the narrative discussion paragraph. I searched the threads but found nothing. Surely others are aware of this very obvious problem. Any insight?
__________________

bgyt 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!

Old 06-25-2018, 07:24 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
audreyh1's Avatar
 
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 22,487
Quote:
Originally Posted by bgyt View Post
When you select the 'spreadsheet' option on FIRECalc the number on the sheet are consistently way off from the graphed values and the values in the narrative discussion paragraph. I searched the threads but found nothing. Surely others are aware of this very obvious problem. Any insight?
I've used the spreadsheet numbers. They aren't way off. Although sometimes there seems to be a year discrepancy in counting from the start which confuses me, but I get it straight.

One issue may be that the graphs are inflation adjusted whereas a lot of the spreadsheet data is not inflation adjusted and is instead nominal data. But you have all the info there to get to the real numbers.
__________________

__________________
Retired since summer 1999.
audreyh1 is offline   Reply With Quote
Old 06-25-2018, 07:35 PM   #3
Confused about dryer sheets
 
Join Date: Jun 2018
Posts: 6
Quote:
Originally Posted by audreyh1 View Post
I've used the spreadsheet numbers. They aren't way off. Although sometimes there seems to be a year discrepancy in counting from the start which confuses me, but I get it straight.

One issue may be that the graphs are inflation adjusted whereas a lot of the spreadsheet data is not inflation adjusted and is instead nominal data. But you have all the info there to get to the real numbers.
The graph is stated to be in start year dollars. The spreadsheet says...

"Open an (unformatted) "multi-year" Excel spreadsheet showing the NON-inflation-adjusted end-of-year portfolio balances for every year in each of the cycles tested by FIRECalc."

My ending portfolio numbers in the spreadsheet are at least twice as much as the graph. This is disconcerting as I'm trying to plan retirement.
bgyt is offline   Reply With Quote
Old 06-25-2018, 07:43 PM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
audreyh1's Avatar
 
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 22,487
Well, I wasn't getting those discrepancies. So I don't know what to tell you.

At most I was having issues with being a year off - but you can get that from confusion about end of year numbers versus start of the next year numbers.

I was only working with the data, as my Numbers program couldn't import the formulas. I had to jump through some hoops - renamed the file .htm, opening in Safari, and then copying the data and pasting it in my spreadsheet.

I was mostly working with the spreadsheets generated from a given starting year, not the entire data set. And those matched the graphs displayed for the %remaining portfolio scenarios.
__________________
Retired since summer 1999.
audreyh1 is offline   Reply With Quote
Old 06-28-2018, 10:15 AM   #5
Thinks s/he gets paid by the post
 
Join Date: Oct 2006
Posts: 4,469
Quote:
Originally Posted by bgyt View Post
The graph is stated to be in start year dollars. The spreadsheet says...

"Open an (unformatted) "multi-year" Excel spreadsheet showing the NON-inflation-adjusted end-of-year portfolio balances for every year in each of the cycles tested by FIRECalc."

My ending portfolio numbers in the spreadsheet are at least twice as much as the graph. This is disconcerting as I'm trying to plan retirement.
Maybe the wording is a problem?

Suppose I start with $1 million portfolio in 2018 dollars. By the end of my projection period, my portfolio is $3 million in 2048 dollars. During that 30 year period, the CPI doubled.

The graph will show that I end with $1.5 million in 2018 dollars.
The spreadsheet will show that I end with $3 million of non-inflation-adjusted-dollars.
Independent is offline   Reply With Quote
Old 06-28-2018, 10:56 AM   #6
Confused about dryer sheets
 
Join Date: Jun 2018
Posts: 6
I think you are right, this is a wording issue, but aren't 2048 dollars = 2018 dollars inflated by the CPI? If so I don't understand what is meant by:

"NON-inflation-adjusted end-of-year portfolio balances"

If it's not inflated then I don't understand the difference. Note that the FIRECalc author was adamant enough that he CAPITALIZED the term "NON". Maybe he was trying to resolve this very confusion...which isn't working for me.
__________________

bgyt is offline   Reply With Quote
Reply


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
Here is the fix for Firecalc Excel spreadsheet error PontGuy FIRECalc support 10 05-09-2017 06:22 AM
firecalc excel export does not match chart mrWinter FIRECalc support 0 03-27-2017 11:40 AM
How does Pension and Off-Chart Spending Impact Numbers? ace_club FIRECalc support 2 01-22-2016 04:26 PM
But, I was only two numbers off... redduck FIRE and Money 11 11-08-2012 08:52 PM

» Quick Links

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