Welcome! | Ask A Question

 
 
 
 
Question

Asked 12/28/2007

Retirement

I make 50,000 yr-current

I will need 25% after retirement to use

I have 15yrs to work

average annual interest rate for the investment 12%

I plan on living at least 25 yrs after retirement

What are my figures and show how you came to them

 
 
 
 
 
Answers

Answer 1/1 - Submitted 5/26/2009

If I understand right you only need $12,500 per year after Retirements (0.25*50000)
All these values are in today dollars.
I used two functions in Excel. One is the PV function the other is the PMT function.
First at year 15 you need to use the PV function with the Rate=12%, Pmt =-12500, FV =0, Nper =25
This will give you what you need to have saved by the time you retire.
Next you will use the PMT function to calculate what you need to save each year.
Use Rate = 12%, PV=0 FV=Amount at year 15, Nper = 25.
Good luck

 
 
 
 
Answer This Question Now

Type your Answer in the box below and post your answer.

Learn more about how this works

 
 
 

Related Questions (Ask a New Question)

 
Additional retirement programs

If i participate in a 401k program where i work, am i allowed to invest in other form of retirement funding.such as a retirement ira?

See Answers

 
I need contact informatin for my retirement

I would like to get information regarding my retirement amount i was with cna from 1996 to 2003

See Answers

 
How much tax is taken from my 401k if i take it out in a lump sum upon retirement?

I am in the fers retirement system. i wish to withdraw my 401k in a lump sum upon retirement. i was wondering what percentage of tax the government will take from it.

See Answers

 
Related Questions

Additional retirement programs


If i participate in a 401k program where i work, am i allowed to invest in other form of retirement...

 

I need contact informatin for my retirement


I would like to get information regarding my retirement amount i was with cna from 1996 to...

 

How much tax is taken from my 401k if i take it out in a lump sum upon retirement?


I am in the fers retirement system. i wish to withdraw my 401k in a lump sum upon retirement....

 

Retirement inheritence


I have recenty inherited my fathers retirement. part is 401k and the rest in invested in...

 

Early retirement withdrawal


I'm not sure if my plan is a 401k. my employer contributes money each year, not me. i...

 

Voluntary contributions to state retirement plans


Voluntary contributions to state retirement plans--what does this means. if i put in my...

 
 

See more 401k questions

 
 
 
 
 

Ask A Question

Ask a new question about
401k: