Welcome! | Ask A Question

 
 
 
 
Question

Asked 4/7/2007

How do I calculate earned interest for each month for a 401k retirement plan?

This is for a project for my Economics class, and I've used as many resources as I can to find this... and I'm stuck.

The hypothetical situation below explains what I'm supposed to do:

After initially picking a 401k plan (upon research I chose a Bond Mutual Fund for this), I'm supposed to "keep track of my earned interest for my mutual fund" per month.

My monthly income is $2500 and I plan to contribute 8% of that to the 401k, which would be $200/month.

How do I figure out the earned interest per month? I have no idea what the interest rate is or how to find that. I've researched online and got 5.25%, in which I have no idea is correct.

Thanks in advance for any help you can provide.

 
 
 
 
 
 
Answers

Answer 1/5 - Submitted 4/7/2007

You need the start date, end date and the future value of the investment at the time of maturity to get the answer. You don't have enough information.

In the real world, btw, the interest rate or calculated return of the fund would be given to you in a prospectus.

I never drink..... wine.

 
 

Answer 2/5 - Submitted 4/7/2007

Mutual fund investing interest rates are based on the risk factor of the fund - a bond fund has some risk. To make it easier to find a published interest rate maybe you should just pick a money market fund and be done with it. A 401K is not going to typically be all mutual find - there will be a fair proportiomn of fixed-income asset invested. Since it is hypothetical, it doesn't matter if it's correct how is someone going to prove you are wrong?

Go on a site like TD Ameritrade - it may help you find a product you can use for your model.

 
 

Answer 3/5 - Submitted 4/7/2007

Well, how long do you have for this project? I use Fidelity.com. And actually, there is a program that you can put in your info and it tells you what could happen in the future. I think you should try that!!!

http://personal.fidelity.com/research/funds/?bar=c

 
 

Answer 4/5 - Submitted 4/7/2007

Are you more looking for a way to calculate how the money grows? Or how to get the interest rate in the first place? Sounds like a bit of both.

For the math, you might try the bottom calculator at this site:

http://home.ubalt.edu/ntsbarsh/zero/CompoundCalI.h tm

with whatever values you come up with, for example:

"Present value" = 0
"Payment per period" = -200
"Annual interest rate" = .0525
"Periods per year" = 12
"Number of years" seems to allow fractions if you need partial years

 
 

Answer 5/5 - Submitted 4/7/2007

It appears that rather than projecting future gains what is being asked for is the previous month's gain. Thus, on the first day you deposit $200. One month later, before you make your next deposit, you calculate your gain for that month.

Example:
Start of month $200
End of month value $201

Gain (earned interest):
$201-$200 = $1

Rate of Return:

$10/$200 = 0.005 per month
0.005 x 12 = .06 (6%) on a yearly basis.
____________

Next month the starting value is $401 (Last month's ending value ($201) plus your contribution ($200)).

Do this for each month. The result for each month will likely be different and some months may even show a loss.

Realistic results might look like this:


Month #: 1 , 2 , 3 , 4 , 5 , 6
Interest %: 6 , 4.3 , 11 , -9.2 , 0.2 , 4.3

 
 
 
 

Related Questions (Ask a New Question)

 
Help

Tim paid $250 per month into his 401k retirement plan. after 30 years, he had accumulated $500,000. what average annual rate of interest had he earned over the 30 years? answer: 9.42% here is the answer the professor gave, however, we have to figure out how he got the answer in excel formula...

See Answers

 
Need assistance not sure how to do these problems

I need help and it has to bve in excel formula and reason for the answer you deposit $5,000 in an account that pays 8% interest per annum. how long will it take to double your money? the johnsons have $60,000 to use as a down-payment on a house, and they want to borrow $240,000 from...

See Answers

 
Need assistance with getting the excel formula to questions

I need the formula and the reason why i came up with the answer. tim paid $250 per month into his 401k retirement plan. after 30 years, he had accumulated $500,000. what average annual rate of interest had he earned over the 30 years? you deposit $5,000 in an account that pays 8% interest...

See Answers

 
Related Questions

Help


Tim paid $250 per month into his 401k retirement plan. after 30 years, he had accumulated...

 

Need assistance not sure how to do these problems


I need help and it has to bve in excel formula and reason for the answer you deposit...

 

Need assistance with getting the excel formula to questions


I need the formula and the reason why i came up with the answer. tim paid $250 per month...

 

Can my employer force me into a 401k plan using my health and welfare benefits


Hello im a contracted armed guard for the federal goverment and im in a union i didn't...

 

If i have a hardship and need to get money from my 401k, can i be denied because i only have (cash) interest left in my plan?


I need a hardship and my plan administrator says i cannot withdraw (although i have $50,000...

 

Retirement plan (401k) distribution during divorce


Hi, i have filed for divorce in california. my husband has 401k plan which he has had before...

 
 

See more 401k questions

 
 
 
 
 

Ask A Question

Ask a new question about
401k: