I'd like to start one, but I wouldn't know where to begin. Anyone have suggestions for one they'd be willing to link me to? I'm not exactly Excel savvy, though I can accomplish basic tasks. Any help would be appreciated!
I have one workbook which has close to 20 sheets of various calculations.
page 1 is a list of all accounts, web addresses, login ids and password codes (not the actual passwords, but a code to help me remember it).
page 2 is a list of tax tables (from fairmark) and how to calculate income taxes in USA.
page 3 is an estimate of what it takes to retire based on given investment returns (average) over long term.
Input income
Input current age
Input retirement age
output is age to retire with a given return %. There is a column for 12% returns, 11%, 10%, 9%, 8%, 7% and 6%.
I have this printed and look at it often. When others post "here is what I have saved and this is my age", I look at this chart to see where they are. This chart is the reason why I know I need to be aggressive for retirement (9% returns barely achieves goal right now). 10% achieves goal with room to spare.
I have another "draw down" spread sheet for how the amount saved on previous sheet would get drawn down. An ammortization schedule of draw down.
I have a sheet for the ammortization schedule on our current mortgage.
I have a sheet for the ammortization schedule on our second mortgage.
I have a sheet on CDs, when they mature and their amounts
I have a sheet on compound interest calculations
and I am sure I created more, and just did not remember what they were for (I rarely delete anything).