Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Here is the fix for Firecalc Excel spreadsheet error
Old 04-04-2017, 10:07 AM   #1
Dryer sheet wannabe
Join Date: Aug 2015
Posts: 10
Here is the fix for Firecalc Excel spreadsheet error

I updated my projections this morning and decided to figure out the Excel Spreadsheets that you can call up from the Firecalc Results page. The second Firecalc Excel spreadsheet has an error that needs to be fixed. This is the spreadsheet that shows the year by year inputs, data, and formulas. The second table in the spreadsheet is supposed to match the one above, but it is incorrect if Social Security or Pension/Off-Chart spending is entered into the Firecalc calculator.

The problem is with the formula in column J "Starting portfolio". It currently takes the "Ending Portfolio" from the previous year and subtracts inflation adjusted annual "Withdrawals", "Social Security" and "Pension/Off-Chart Spending" income. But SS and Pension income should be added since it is money coming in, not going out. And Off Chart Spending income is already loaded as a negative, so it should be added as well. (Complicating things is that the columns marked "Withdrawal Change" actually reflect the Pension/Off-Chart Spending income entered into the calculator.) Anyway, here is the fix that makes everything work correctly:
Change J40 to: =IF(I40<>"",$J$1+I40,$J$1-C40+SUM(D40:H40))

And starting with the next line in column J change to: =IF(I41<>"",T40+I41,T40-C41+SUM(D41:H41)) and so on down column J
Doing this makes the tables match, and then the rest of the formulas make a lot more sense.

With the time I spent resolving this I figured out a couple of other things that might help others make sense of the numbers. The first Excel file shows annual balances before inflation adjustment to today's dollars. So these figures align with those in the second Excel file column T "Ending Portfolio" for a given input year. However the Firecalc graph shows the year-by-year portfolio balances after inflation adjustment to today's dollars. So these match the figures in the second Excel file column U "Infl Adj End".

Moderators, please correct me if I got any of this wrong.... but 99.9% pretty sure I got it right.

PontGuy 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 04-11-2017, 06:49 PM   #2
Dryer sheet wannabe
Join Date: Mar 2017
Location: Fort Mill
Posts: 18
I don't see an Excel download offered on the FIRECalc 3.0 website results page. What am I missing?

Retireatee1 is offline   Reply With Quote
Old 04-12-2017, 07:33 AM   #3
Dryer sheet wannabe
USGrant1962's Avatar
Join Date: Dec 2016
Location: Middletown
Posts: 16
If you go to the "Investigate" tab, there is a checkbox in the "Display results of the retirement plan" paragraph. Then on your results there will be links to get the spreadsheet.
Semi-ER March 24, 2017
USGrant1962 is online now   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
Retirement Excel Spreadsheet OR Website jesa FIRE and Money 11 01-29-2017 08:25 AM
Older car: to fix or not to fix? Sojourner FIRE and Money 47 11-11-2016 01:18 PM
Error: 1) Error No Data Supplied in FIRECalc nico08 FIRECalc support 4 01-07-2015 01:28 PM
Help needed on Excel spreadsheet design peteyperson FIRE and Money 5 05-08-2008 07:56 AM


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