Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Spreadsheet to track personal finances
Old 02-07-2008, 02:49 PM   #1
Recycles dryer sheets
 
Join Date: Oct 2004
Posts: 198
Spreadsheet to track personal finances

So I found an older version of my spreadsheet I used to track finances, put it into Google Docs, and changed a bunch of numbers (don't want to give too much away

http://spreadsheets.google.com/ccc?k...SuKUVSMQ&hl=en

Let me know if that link doesn't work for people, I've never publicly shared any of my Google docs before.

You'll notice that the top 15 or so rows have less data. That's because I've been slowly adding fields as I've gone along (and didn't try to back-map them). Sometime in 2006/2007 is where it was last updated and is the most current.

If you know spreadsheets, you'll see what I did. I projected growth rates onto each asset / debt class, and also on my projected retirement needs. Then I put in as much data about contributions/etc as I could easily come up with, and put them into the fields as well. As long as I somewhat regularly update fields in the months to their actual values, I should be able to project where my finances will be at any point in time in the future.

So I enjoy being able to scroll down my SWR column for instance, and see where my SWR will be at different times. Or see when I'm projecting my networth will cross $1,000,000, etc. I can change my projected investment return rates and see what that does to our retirement planning.

FYI, I did put in some funny assumptions here & there, just because it made things easier on me (like assuming 401k limits would go up around 3% per year, at least I think that's in there somewhere).

Anyway, I figured people have asked for this kind of thing before, and thought I'd provide it. Let me know if you have any questions. Oh, and let me know if I let out some vital personal finance info that I didn't notice
__________________

__________________
HobbyDave 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 02-07-2008, 05:11 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Lsbcal's Avatar
 
Join Date: May 2006
Location: west coast, hi there!
Posts: 5,681
Clicking on your link brings up a request for your email and password. I don't think that's what you intended.
__________________

__________________
Lsbcal is online now   Reply With Quote
Old 02-07-2008, 05:16 PM   #3
Recycles dryer sheets
 
Join Date: Oct 2004
Posts: 198
Well, taking a look at that, I think it's asking you to log in with your Google account. I think the requirement for viewing a Google spreadsheet is that you have an account with Google. Someone can try with their Google account (or make one), and let me know if I'm right
__________________
HobbyDave is offline   Reply With Quote
Old 02-07-2008, 05:19 PM   #4
Recycles dryer sheets
 
Join Date: Jul 2007
Posts: 192
Quote:
Originally Posted by HobbyDave View Post
Well, taking a look at that, I think it's asking you to log in with your Google account. I think the requirement for viewing a Google spreadsheet is that you have an account with Google. Someone can try with their Google account (or make one), and let me know if I'm right
It works for me Dave...
__________________

NotSoonEnough is offline   Reply With Quote
Old 02-07-2008, 05:25 PM   #5
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Lsbcal's Avatar
 
Join Date: May 2006
Location: west coast, hi there!
Posts: 5,681
Quote:
Originally Posted by NotSoonEnough View Post
It works for me Dave...
D*mn, thought I'd finally found a way to get someone's password .
__________________
Lsbcal 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
Finances and Dementia bbuzzard FIRE and Money 31 01-20-2007 08:05 PM
Personal Umbrella versus Personal Excess Liability policies ? Linney FIRE and Money 25 11-28-2006 08:06 PM
Am I on the right track? Outtahere FIRE and Money 8 10-20-2006 06:43 AM
Tracking finances virginia Young Dreamers 31 07-07-2006 12:17 PM
Posting Your Finances TromboneAl Other topics 5 06-28-2005 06:16 PM

 

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