Rustic23
Thinks s/he gets paid by the post
I posted this about a year ago, however, I did not get many comments on it.
My attempt was to model 25 years of spending. The main spreadsheet is locked. However there is no unlock password, so you can unlock it.
The green area is where you enter your assumptions. Cells A12 through 036 give you the results. I tax 85% of social security. In cell’s M68 and M69, you can put in a year to begin inflation or saving rates. Savings rates are based on changes in the DOW. The worksheet ‘Monthly Expenses’ was designed to allow you to track your expenses over a year. The ‘Sinking Fund’ spreadsheet is an attempt to come up with a monthly amount necessary to fix thing that go bump in the night.
There are four income columns. Two use inflation rates by year, and the center two use a fixed rate you can input at the bottom of the column.
I make no guarantee that the formulas used in this spreadsheet are right. In fact, it seems to be more pessimistic than FIRECALC. One thing if your Savings or Checking goes negative, you will have to take a bigger percentage out of your Savings, as you can see in the last four years in the sample.
Also I included a ‘Print’ macro, so this is what Excel is warning you about when it starts. Oh, and I know the age is off when one would start Social Security. It is sample data.
My attempt was to model 25 years of spending. The main spreadsheet is locked. However there is no unlock password, so you can unlock it.
The green area is where you enter your assumptions. Cells A12 through 036 give you the results. I tax 85% of social security. In cell’s M68 and M69, you can put in a year to begin inflation or saving rates. Savings rates are based on changes in the DOW. The worksheet ‘Monthly Expenses’ was designed to allow you to track your expenses over a year. The ‘Sinking Fund’ spreadsheet is an attempt to come up with a monthly amount necessary to fix thing that go bump in the night.
There are four income columns. Two use inflation rates by year, and the center two use a fixed rate you can input at the bottom of the column.
I make no guarantee that the formulas used in this spreadsheet are right. In fact, it seems to be more pessimistic than FIRECALC. One thing if your Savings or Checking goes negative, you will have to take a bigger percentage out of your Savings, as you can see in the last four years in the sample.
Also I included a ‘Print’ macro, so this is what Excel is warning you about when it starts. Oh, and I know the age is off when one would start Social Security. It is sample data.