Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
FIRECALC : Spreadsheet edition
Old 08-19-2015, 11:56 PM   #1
Dryer sheet aficionado
 
Join Date: Sep 2012
Posts: 26
FIRECALC : Spreadsheet edition

Hey all,

So I've been working on my spreadsheet for the past four years and its really starting to bloom into something nice. However, I would like to have a FIRECALC-like sheet where I can enter variables like rate of return, monthly investments, social security payments, etc and have it yield an age at which I should achieve retirement success (probably defined as a >= $0 remaining balance).

I'll be deployed for a while plus I just like spreadsheets so that is why this would be valuable for me.

Does anyone know if such a thing already exists and/or would someone be willing to contribute to it? Thanks in advance!
__________________

__________________
To ER is human.
navydavey 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 08-22-2015, 09:08 AM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 18,281
Check this thread for a ref to simba's spreadsheet. I have not played with it, so I don't know if it is what you are looking for or not.

looking for Small Cap Value total return historical data back to 1977

Although I think there is near zero value to 'enter variables like rate of return'. These things vary over time. The historical calculators like FireCALC do a much better job of showing the effect of this. Any 'rate of return' you enter will be wrong.

-ERD50
__________________

__________________
ERD50 is offline   Reply With Quote
Old 08-22-2015, 01:36 PM   #3
Dryer sheet aficionado
 
Join Date: Jul 2015
Posts: 36
Quote:
Originally Posted by ERD50 View Post
Check this thread for a ref to simba's spreadsheet. I have not played with it, so I don't know if it is what you are looking for or not.

looking for Small Cap Value total return historical data back to 1977

Although I think there is near zero value to 'enter variables like rate of return'. These things vary over time. The historical calculators like FireCALC do a much better job of showing the effect of this. Any 'rate of return' you enter will be wrong.

-ERD50
I followed that string for a bit an couldn't find the excel sheet. Is there another link, or do you have it and could share?
__________________
turbo89 is offline   Reply With Quote
Old 08-22-2015, 02:57 PM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 18,281
Quote:
Originally Posted by turbo89 View Post
I followed that string for a bit an couldn't find the excel sheet. Is there another link, or do you have it and could share?
No, sorry, I just remembered seeing that reference recently - that's all I got.

-ERD50
__________________
ERD50 is offline   Reply With Quote
Old 08-22-2015, 05:55 PM   #5
Recycles dryer sheets
 
Join Date: Nov 2014
Posts: 381
Start with a Google of "Simba's spreadsheet". That will get you to the bogleheads forum where it's discussed. As for the actual spreadsheet, it's located here:
https://drive.google.com/file/d/0B6r...bWc/view?pli=1

If you use excel, click on the down arrow at the top center of the page to download.

Big-Papa


Sent from my iPad using Early Retirement Forum
__________________
big-papa is offline   Reply With Quote
Old 08-22-2015, 07:47 PM   #6
Dryer sheet aficionado
 
Join Date: Jul 2015
Posts: 36
Thanks for sharing. That spreadsheet is much more comprehensive than I expected.
__________________
turbo89 is offline   Reply With Quote
Old 08-22-2015, 08:03 PM   #7
Recycles dryer sheets
 
Join Date: Nov 2014
Posts: 381
No problem. As I mentioned in the other thread, many of the return series are cobbled together from multiple sources for periods before which the representative mutual funds existed. I also think that the short term bond returns are incorrect and that they used a short term international series instead of a U.S. Govt series. Also tips didn't exist as far back as 1972. A reasonable guess can be made based on regular U.S. bonds and some measure of expected inflation. See the other thread for another source of tips returns besides what's in the spreadsheet - it's fairly easy to replace a return sequence with another.

One thing I like in the spreadsheet is the comparison against fairly well known static portfolios as well as the long term correlations between different asset classes.

As the original author of the spreadsheet has mentioned, this is only a tool - it's not really intended to be used to fine tune a portfolio to the nth degree. As you can see on the tab with well-known portfolios, all roads lead to Dublin - well most roads do, anyway. :-)


Sent from my iPad using Early Retirement Forum
__________________
big-papa is offline   Reply With Quote
Old 08-23-2015, 08:19 AM   #8
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Midpack's Avatar
 
Join Date: Jan 2008
Location: Chicagoland
Posts: 11,974
It's most definitely doable, but it looks easier to recreate FIRECALC in spreadsheet form that it actually is IME. Add Soc Sec and federal tax what ifs, with all the dependent variables it gets orders of magnitude more difficult (I've tried that too).

I also played with the bogleheads spreadsheet, but IMO you have to take the (considerable) time to fully understand his/her assumptions to trust the result.

Best of luck...
__________________
No one agrees with other people's opinions; they merely agree with their own opinions -- expressed by somebody else. Sydney Tremayne
Retired Jun 2011 at age 57

Target AA: 60% equity funds / 35% bond funds / 5% cash
Target WR: Approx 2.5% Approx 20% SI (secure income, SS only)
Midpack is offline   Reply With Quote
Old 08-23-2015, 09:23 AM   #9
Recycles dryer sheets
 
Join Date: Nov 2014
Posts: 381
Yep - I've attempted the recreation as well but it truly is a lot of work. The bogleheads spreadsheet is pretty good and, as mentioned before, I think some of the historic (pre-mutual fund) data isn't quite right. However, it isn't that tough to find other sources for most of those items and do some cutting-and-pasting into the spreadsheet, which is something I've done. It's still a decent framework.

Also remember the bogleheads spreadsheet is really only set up for the accumulation phase.
__________________
big-papa is offline   Reply With Quote
Old 09-27-2015, 07:34 PM   #10
Confused about dryer sheets
 
Join Date: Jan 2015
Posts: 4
Quote:
Originally Posted by navydavey View Post
Hey all,

So I've been working on my spreadsheet for the past four years and its really starting to bloom into something nice. However, I would like to have a FIRECALC-like sheet where I can enter variables like rate of return, monthly investments, social security payments, etc and have it yield an age at which I should achieve retirement success (probably defined as a >= $0 remaining balance).

I'll be deployed for a while plus I just like spreadsheets so that is why this would be valuable for me.

Does anyone know if such a thing already exists and/or would someone be willing to contribute to it? Thanks in advance!
I have worked on and finally have a file that works quite well that does this. I wanted something that would handle a decent sized inherited IRA as I was faced with that (crappy way to gain wealth) and nothing out there really handles it. It is a simple excel file - it explicitly handles SS, taxable accounts, tax deferred accounts, taxes, inherited IRAs, 4 types of withdrawal schemes, inflation assumptions, CPI assumptions, etc. Two output types - an assumed rate of return (deterministic model) and a historical based rate of return. It tends to be a bit more conservative than Firecalc as I think it handles taxes a bit better.

Link here. I preentered it with some numbers to show the outputs.

Graphics give a very nice view of accounts over time as they get consumed. along with SS influxes, expenses, etc. Hopefully useful to some folks out there.
__________________
Sand101 is offline   Reply With Quote
Old 09-28-2015, 06:30 AM   #11
Recycles dryer sheets
 
Join Date: Apr 2013
Location: Humble
Posts: 188
I did something in Google Sheets a few years ago. I couldn't figure out how to get it to run through all the years (or lost interest before I got there ). I was wanting to compare withdrawal strategies. I ended up with a entry cell for starting year. I just left it at 1929 for all my comparisons. If you can retire then, you can make it just about any time.

The spreadsheet really get complicated when you start adding things like SS, taxes, etc. I really gained a lot of respect for FIRECalc as a result.
__________________
Turn_the_Page is offline   Reply With Quote
Old 09-28-2015, 06:56 AM   #12
Thinks s/he gets paid by the post
 
Join Date: Mar 2011
Posts: 3,702
The day 30 years ago when Lotus 123 spreadsheets first came out turned out to be the worst day of my life. I ended up spending most of my young years building sheets re-creating models that already existed; tide charts, water consumption, etc. only to find that "close enough was good enough"

I view FireCalc, i-Orp and all the others as a guide providing a sort of 'windage'; a ballpark number; a direction more than a single, take-it-to-the-bank number. None of the existing calculators claim to deliver a 100% final number.

Respectfully, I hope your work is more within an academic exercise than trying to nail down a more accurate result. IMHO there's just too many variables.

But I could be wrong...carry on if you're having fun.
__________________

__________________
Living well is the best revenge!
Retired @ 52 in 2005
marko is online now   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
Tracking basis with spreadsheet, how to structure the spreadsheet? bamsphd FIRE and Money 13 08-03-2009 10:31 AM
Diamonds From Dirt, Final Edition hellbender FIRE and Money 5 11-03-2007 11:43 AM
Free TaxCut 2006 Basic Edition wabmester FIRE and Money 30 04-12-2007 07:28 AM
Amazing Race All Star Edition starts tomorrow (Sunday) night on CBS bssc Other topics 5 02-20-2007 08:49 AM
"Book" report: The Adventurer's Guide to Early Retirement, 2nd edition Nords Life after FIRE 16 10-13-2006 11:27 AM

 

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