|
Excel file or suggestion?
07-07-2016, 09:55 AM
|
#1
|
Recycles dryer sheets
Join Date: Mar 2016
Posts: 81
|
Excel file or suggestion?
I have my retirement schedule in excel with an investment tab, SS/pension details, Budget by time (I retire, He retires, full retirement with all income) and misc. items. I would like to have software or an excel file that will extrapolate based on withdrawal percentages and do more detail for budgeting. Does anyone have a suggestion or file template to share? I am using Personal Capital and have data in FireCalc (and a few others), but neither have given me just the right detail.
|
|
|
|
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!
|
07-07-2016, 10:55 AM
|
#2
|
Thinks s/he gets paid by the post
Join Date: Jan 2008
Posts: 1,495
|
Lawrence Kotlikoff's ESPlanner is pretty robust and will probably meet your needs. I didn't renew it after my computer crashed and I lost the software because ***** and FIDO coupled with spreadsheets are good enough for me.
|
|
|
07-07-2016, 12:56 PM
|
#3
|
Moderator
Join Date: Oct 2010
Posts: 10,622
|
I just made a real simple spreadsheet today. One column for each month (only going out a few years since the real long-term stuff is handled elsewhere). The only money in this spreadsheet is after-tax. The first data row is cash on hand, then several rows, one row for normal expenses, another one for a bond that's going to mature, another one for IRA withdrawals, another one for non reoccurring expenses (I make a comment on the cell). The starting cash and net cash flows for the month become the starting cash for the next month.
That being said, if someone has a more sophisticated sheet, I'd be interested. But with others' spreadsheets, unless it's documented very well, and their situation is similar to yours, it becomes more work to adopt the spreadsheet than to design your own.
|
|
|
07-07-2016, 01:59 PM
|
#4
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2011
Posts: 8,332
|
I created an excel file that lists each month.
It is tied to my excel check register and all/any expenses are listed as a total for each month, with an average multiplied by 12.
I update it at the end of each month and move to the next month.
I exclude exceptional expenses (like a new roof or something) in order to get an accurate "normal" set of annual expenses.
__________________
Living well is the best revenge!
Retired @ 52 in 2005
|
|
|
07-07-2016, 04:06 PM
|
#5
|
Thinks s/he gets paid by the post
Join Date: Jul 2012
Location: Texas
Posts: 3,024
|
I use Fidelity Full View to accumulate transactions and balances (similar to Personal Capital). I periodically transfer monthly totals from Full View into my retirement spreadsheet. It has tabs similar to OP... portfolio, budget, taxes/Roth, SS, and withdrawal strategy. There's also a tab to keep track of my rentals. A couple times per year, I refresh the assumptions and run some long-range projections in Excel, and then stress-test the results against FIRECalc, Fidelity RIP, and sometimes i-ORP.
I've experimented with lots of software, but could never get it to do everything I wanted with the right balance of detail for our situation. Excel was the answer for me. Fidelity Full View still does the hard stuff like collecting transactions, categorizing, and summarizing. I just move whatever summary data I need into Excel for purposes of retirement planning, tracking, and analysis. Too many of the online tools are like "black boxes." I can't fully see what's happening inside the box. Excel can be error prone if you're not careful. But the flexibility to structure the analysis according to your specific situation is why I'll stick to this method.
__________________
Retired at 52 in July 2013. On to better things...
AA: 85/15 WR: 2.7% SI: 2 pensions, SS later
|
|
|
07-07-2016, 04:09 PM
|
#6
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,204
|
You can sort of do what you are looking for in Quicken... use the budget tool for your retirement budget and the Lifetime Planner tool for your retirement plan. You can also do a What-If to see how changes in assumptions impact your plan. Unfortunately, the retirement budget does not link to the retirement plan... you need to input the total from the retirement budget as your retirement plan expenses.
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.
Retired Jan 2012 at age 56
|
|
|
07-07-2016, 04:40 PM
|
#7
|
Recycles dryer sheets
Join Date: Jun 2005
Posts: 304
|
This might be of interest, it is more geared to "when am I FI" but is pretty detailed, worth a glance anyway:
One sheet to rule them all...
|
|
|
07-07-2016, 07:57 PM
|
#8
|
Thinks s/he gets paid by the post
Join Date: Jul 2007
Posts: 3,221
|
I've also used Lifetime Planner that comes in Quicken and thought it was helpful and easy to use. It does allow you to create separate entries for both you and your spouse and and you can go in and change any assumptions (inflation, expenses, income, etc.) you've made and see the impact of those changes.
|
|
|
07-07-2016, 08:25 PM
|
#9
|
Recycles dryer sheets
Join Date: Nov 2013
Posts: 222
|
Quote:
Originally Posted by pb4uski
You can sort of do what you are looking for in Quicken.
|
+1
I track all expenses and investments in Quicken by auto-importing banking data and quotes regularly. The reports allow me to see any time period and month-over-month or year-over-year comparisons for spending, net worth, cash flow and asset allocation. The spending categorization is not exactly automatic, so it does take ongoing effort to keep the data updated and correct.
I don't use the budgeting feature but it does exist. The included Lifetime Planner is not bad but I prefer to report my income/expense numbers and then enter those into Fidelity RIP for its simulations. You can also export Quicken data to Excel if you want to run additional analysis. I bring a cash flow report along when I meet my Fido advisor so we can review along with the portfolio.
|
|
|
07-08-2016, 09:08 AM
|
#10
|
Moderator
Join Date: Oct 2010
Posts: 10,622
|
Quote:
Originally Posted by runchman
|
Interesting sheet. To use an airplane landing metaphor, the sheet seems tuned to more of a "downwind leg" (farther from retirement/landing), whereas the OP might get more out of something tuned to "base" or "final approach".
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|