Where can i find.....

[Bigjones]

Im looking for a spreadsheet or a site or calculator that can help me figure out something like the following.

Im 45 and want to retire in ten years at 55. I will collect SSI at 62 at X amount per month.   

How much in retirement savings will I need for the gap years 55 to 62yrs old.  And for the rest if factoring in my SSI income.

Any suggestions

[BarkyardBQ]

Dig more...

http://www.mrmoneymustache.com/2012/05/29/how-much-do-i-need-for-retirement/

http://www.mrmoneymustache.com/2012/01/13/the-shockingly-simple-math-behind-early-retirement/

[rubybeth]

Totally depends on your income and your spending. Post more details or a case study, or read the links provided above and do a back of the napkin calculation.

[MDM]

Im looking for a spreadsheet or a site or calculator that can help me figure out something like the following.

Im 45 and want to retire in ten years at 55. I will collect SSI at 62 at X amount per month.   

How much in retirement savings will I need for the gap years 55 to 62yrs old.  And for the rest if factoring in my SSI income.

Any suggestions

Quick estimates:
E = annual expenses starting at age 55
i = inflation

For the gap, E * [(1 + i)^7 - 1] / i

For age 62+, 25 * (E - 12*X) * (1 + i)^7

[NaturallyHappier]

My spreadsheet will show you this.  You'll have to study the retirement spreadsheet.  Enter your numbers in the tan fields at the top and then look at the column "post tax savings withdrawl". 

You might also want to download the PC based social security calculator from the social security site.  Remember that if you retire early, you wont get as much SS because the SS estimates online assume you are making the same wage you made last year until you are at full retirement age.

https://docs.google.com/spreadsheets/d/1N_PN1Pa0znhJejkTU8_hmiAu18rjF5UBrggKnhi-W4o/edit?usp=sharing

http://www.ssa.gov/OACT/anypia/download.html