If you put $300 per month in an account that gets 3.9% interest,
how much will be in there by the time you retire in 30 years if
your initial deposit is $1000?
Use and show excel and formulas please, thank you
Value of deposit in 30 years | =fv(rate,nper,pmt,pv) | |||
=$207,759.20 | ||||
Where, | ||||
rate | = | 3.9%/12 | = | 0.00325 |
nper | = | 30*12 | = | 360 |
pmt | = | -$300 | ||
pv | = | -$1,000 |
The above formula used to find future value of money.
If you put $300 per month in an account that gets 3.9% interest, how much will...
You deposit $300 each month into an account earning 4% interest compounded monthly. a) How much will you have in the account in 30 years? $ b) How much total money will you put into the account? $ c) How much total interest will you earn? $
You deposit $175 semi-monthly (that's twice per month) into an account earning 5% interest. You play to continue the same deposit until your retirement, in 30 years. a) How much will you have in the account after 30 years? b) How much total money will you put in the account? Answer: 126000 c) How much total interest will you earn?
How much should you deposit at the end of each month into an investment account that pays 6% compounded monthly to have $3 million when you retire in 40 years? How much of the $3 million comes from interest? In order to have $3 million in 40 years, you should deposit how much each month? ___ round to the nearest dollar. $___ of the $3 million comes from interest. use the answer from part a to find this answer round...
You deposit $350 each month into an account earning 4% interest compounded monthly. a) How much will you have in the account in 15 years? b) How much total money will you put into the account? c) How much total interest will you earn? S
(1 point) a) How much will you have in an account after 25 years if you put $1200 per month in the account earns 4% compounded monthly? Answer $ b) How much will you have after 25 years if you put $1200 per month in the account that instead earns 5% compounded monthly? Answer $ (1 point) a) How much will you have in an account after 25 years if you put $1200 per month in the account earns 4%...
For your retirement planning, you are currently depositing $350 per month into an account that earns an 8% return, compounded monthly. In 12 years, you expect to increase that deposit by $250 per month (to a total of $600 per month). You plan to retire in 40 years. After you retire, you will move the money into a safe account that earns a guaranteed 3.5% per year. How much will you have when you retire? If you expect to live...
The good news - saving $10 per month We continue with the same example: you deposit $10 per month into a savings account with an annual interest rate of 30%, compounded monthly. Use your formula f(r) to answer the following questions. (a) Determine the amount in the account after 1 year. How much is interest? (b) Determine the amount in the account after 10 years. How much is interest? (c) Determine the amount in the account after 45 years. How...
1. You deposit $400 each month into an account earning 7% interest compounded monthly. a) How much will you have in the account in 35 years? $ b) How much total money will you put into the account? $ c) How much total interest will you earn? $ 2. Suppose you want to have $300,000 for retirement in 35 years. Your account earns 8% interest. a) How much would you need to deposit in the account each month? $ b)...
You decided to quit smoking today. Now that you are going to save 300 €/month, you decided to save those 300€ per month in a bank account that offers a 5% interest rate compounded monthly, till the day you retire (that is to say, in 20 years). Please answer the following questions: 1. If you do your deposits at the end of every month (so your first deposit will be in one month from today) in a bank account that...
Functions 1. You are presented with two investment strategies for the next ten years. In strategy A, you deposit $300 into an account at the end of each month for the next four years, then allow the account to accumu- late interest for the remaining six years. In strategy B, you do nothing for five years and then deposit $300 at the start of each month for the remaining five years. In both cases, interest is paid at the rate...