Welcome! | Ask A 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. |
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
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...
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...
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...
|
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... |
|
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... |

Ask A Question
Ask a new question about
401k: