Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Old 08-18-2007, 09:09 AM   #21
Thinks s/he gets paid by the post
maddythebeagle's Avatar
Join Date: Jun 2005
Posts: 2,450
I like excel since I can play with it while at work and doesnt cost anything...

I mostly have end of year projections based on a rate of return and another column what I actually hit in my various portfolios....I started with my taxable port (since I need to track dividends and costs)...and worked in several worksheets around...including budget (before and after FIRE), taxes, a mortgage schedule, etc.

- Hurry! to the cliffs of insanity!
maddythebeagle 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 08-18-2007, 10:20 AM   #22
Dryer sheet wannabe
Join Date: May 2007
Posts: 14
I use a 4 workbook system that meets my needs as a 24 year old with no reason to estimate a precise retirement age or portfolio draw down ability at this time. Each workbook is fairly complex in its own right, but as others have said, it was developed by me so I know exactly what is going on. I think the key is to find something that is simple to update going forward and provides you with useful information for decision making - while I spend countless hours analyzing and tweaking my spreadsheets, the actual "required" time to update each is about 1 hour at the end of each quarter.

1) Net Worth Spreadsheet (my "scoreboard") - this is updated quarterly with the balances of all asset and liability accounts and tracks changes to NW quarterly and yearly

2) Asset Allocation Spreadsheet ("benchmarking") - this gets into the detail of all my holdings, from the checking account, to funds within the 401(K). Within this workbook I have my holdings dissected in pretty much every way imaginable: Taxable vs. Tax-Favored Holdings; Total Asset Allocation across and within accounts; Large vs. Mid vs. Small; US vs Int'l, etc, etc. I also update this spreadsheet quarterly.

3) Cash Flow Statement - Here I track my money coming in and my money going out (to expenses and savings). This allows be to forecast how I will handle different scenarios (e.g. raises, debt-paydown, increases to savings, etc.).

4) Budget - pretty standard here, I try to track all expenses by category by month. I am not a huge fan of tracking every single penny, but the DW likes to and I figure in our early years it will give us a good baseline for estimates going forward.

TDCumm16 is offline   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
Who pays more income taxes in retirement? LOL! FIRE and Money 19 12-17-2006 03:16 PM
Vanguard Adding More Target Retirement Funds Lusitan FIRE and Money 23 03-21-2006 06:17 PM
Scott Burns: Stay safe on retirement spending PL FIRE and Money 49 12-22-2004 10:59 AM
Tax Policy Promotes "Early" Retirement REWahoo FIRE and Money 10 12-19-2004 07:25 PM


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