Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
How can I post an Excel file?
Old 07-09-2006, 07:57 PM   #1
Recycles dryer sheets
 
Join Date: Jan 2006
Posts: 309
How can I post an Excel file?

I spent a bit of today building an Excel file that tracks my expected retirement savings until the age of 100 (I'm 30 now) I think it is fairly accurate as I have diligently tracked my expenses for awhile now and my sources of income are known and predictable. I've basically assumed inflation will increase my expenses 2.5% per year and that I will get salary increments of 3% per year. I've built an 8% return into my investments.

Is there anyway I can post this file? I would like others to take a look at it to critique anything they think is wrong. Also someone could use it as a template if they wished.

There are many retirement calculators online and none of them can really keep track of all the assumptions and inputs inherent in a retirmenet plan, but these can easily be built into a spreadsheet. Plus it's easy to adjust any given number such as rate of return, etc to see how the numbers change.

According to my calcs if I save around $3000 a month I should be able to retire at 45 and live off the interest until I'm 100....

__________________

__________________
accountingsucks 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!

Re: How can I post an Excel file?
Old 07-09-2006, 09:39 PM   #2
Moderator
Alan's Avatar
 
Join Date: Jul 2005
Location: Eee Bah Gum
Posts: 21,079
Re: How can I post an Excel file?

Quote:
Originally Posted by accountingsucks
I think it is fairly accurate as I have diligently tracked my expenses for awhile now and my sources of income are known and predictable.*
You will be lucky indeed for this assumption to remain true for the next 20 years.

However, it got me thinking, and looking back I have used a spreadsheet that I started in 1993 doing similar to what you are doing and tracked target salary and target 401(k) savings against what I predicted for that salary. I assumed contributing the max, a 10% return and salary increases of 7% each year. In 13 years I am only off by a mere 1.5% - amazing really as these days I use all the sophisticated planning tools available to me on line.

The bigger picture had my wife going back to work and earning a good salary, good luck in real estate etc so I am actually far better off in total than I could have imagined, but in tracking that single salary it has remained remarkably close to my optimistic aims.
__________________

__________________
Retired in Jan, 2010 at 55, moved to England in May 2016
Now it's adventure before dementia
Alan is online now   Reply With Quote
Re: How can I post an Excel file?
Old 07-09-2006, 09:42 PM   #3
Recycles dryer sheets
 
Join Date: Jan 2006
Posts: 309
Re: How can I post an Excel file?

Quote:
Originally Posted by Alan
You will be lucky indeed for this assumption to remain true for the next 20 years.

However, it got me thinking, and looking back I have used a spreadsheet that I started in 1993 doing similar to what you are doing and tracked target salary and target 401(k) savings against what I predicted for that salary. I assumed contributing the max, a 10% return and salary increases of 7% each year. In 13 years I am only off by a mere 1.5% - amazing really as these days I use all the sophisticated planning tools available to me on line.

The bigger picture had my wife going back to work and earning a good salary, good luck in real estate etc so I am actually far better off in total than I could have imagined, but in tracking that single salary it has remained remarkably close to my optimistic aims.
No doubt that this has so many assumptions/guesses, but I'd rather plan than not plan at all. As far as my expenses, I don't know how else I could estimate them besides having tracked them and then assuming an inflationary increase each year. I think my estimate will be fairly reasonable.
__________________
accountingsucks is offline   Reply With Quote
Re: How can I post an Excel file?
Old 07-09-2006, 09:49 PM   #4
Moderator
Alan's Avatar
 
Join Date: Jul 2005
Location: Eee Bah Gum
Posts: 21,079
Re: How can I post an Excel file?

I think planning using a spreadsheet as you suggest is going to work well for you. I'm sure you'll look for better tools 10 - 15 years from now. 13 years ago I didn't track my expenses, I just aimed at saving the max in my 401(K), zero debt outside of a reasonable mortgage, and savings accounts for big ticket items such as cars, college funds and vacations. (plus I always had a rainy day fund for the unplanned expenses). 14 years I tracked nothing !!
__________________
Retired in Jan, 2010 at 55, moved to England in May 2016
Now it's adventure before dementia
Alan is online now   Reply With Quote
Re: How can I post an Excel file?
Old 07-10-2006, 09:23 AM   #5
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
TromboneAl's Avatar
 
Join Date: Jun 2006
Posts: 11,196
Re: How can I post an Excel file?

To post it, find some location to which you can upload the file. For example, if your ISP gives you personal web space, you can put it there. Then you can link to it from here.
__________________
Al
TromboneAl is offline   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
"Hi, I am" needs a "Read this first" post? HobbyDave Forum Admin 3 05-17-2007 10:39 AM
Updatable CD post? MooreBonds FIRE and Money 5 10-02-2006 01:09 PM
Can I Post Here or Not? hocus FIRE and Money 40 03-11-2004 09:57 AM

 

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