Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Another spreadsheet bug?
Old 07-18-2007, 06:48 AM   #1
Dryer sheet wannabe
Join Date: Nov 2006
Posts: 15
Another spreadsheet bug?


A few more issues on the spreadsheet (spreadsheet attached I think):

1) Shouldn't cells C3 and C40 be equal - the first year of inflation adjusted withdrawals. Cells C4 and C41 are equal.

2) Shouldn't cells J3 and J40 be equal. None of the corresponding year cells in the J column are equal.

3) I have a sample portfolio of 100% S&P 500 and have selected "A mixed portfolio consisting of the following assets" but the lower section of the spreadsheet show my portfolio in fixed income starting in cell O40. Same for column T.

4) Should withdrawals in the first year of the simulation be adjusted for inflation at all? I had assumed firecalc withdraws the yearly withdrawal at the beginning of the period.

Just trying to make it better for all of us. Thanks for your work.

Attached Files
File Type: zip (6.5 KB, 13 views)
Cadence 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!


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
Portfolio tracking spreadsheet justin FIRE and Money 8 06-28-2010 04:01 AM
Spredsheet bug? Cadence FIRECalc support 1 07-18-2007 05:54 AM
Asset Allocation spreadsheet w/ 35 years data... Cb FIRE and Money 3 05-20-2007 09:01 AM
Spreadsheet for calculating life of retirement assets tlg501 FIRE and Money 2 03-12-2007 12:09 PM
budget spreadsheet change 2 Rustic23 FIRE and Money 4 02-13-2006 05:56 PM


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