Question

In: Finance

A young executive deposits $300 at the end of each month for 6 years into an...

A young executive deposits $300 at the end of each month for 6 years into an account that earns 6% compounded monthly. How much is in the account after the 6 years? (Round your answer to the nearest cent).
$
The executive then changes the deposits in order to have a total of $400,000 after 25 total years. What should be the revised monthly payment in order to meet the $400,000 goal? (Round your answer to the nearest cent).
$
How much interest is earned during the 25 years?

Solutions

Expert Solution

a). Periodic deposit at the end of each month by Young executive for 6 years is $300

Calculating the Future Value in account after 6 years:-

Where, C= Periodic Payments = $300

r = Periodic Interest rate = 6%/12 = 0.5%

n= no of periods = 6 years*12 = 72

Future Value = $25,922.66

So, amount in the account after the 6 years is $25,922.66

b). Exceutive wanst to accumulate a Future Value of $400,000 after 25 years.

Calculating the revised monthly payment to meet goal:-

Where, C= Periodic Payments

r = Periodic Interest rate = 6%/12 = 0.5%

n= no of periods = 25 years*12 = 300

C = $577.21

So, the revised monthly payment in order to meet the $400,000 goal is $577.21

- Total Interest earned during 25 years = Future Value - Total monthly deposit made during the period

= $400,000 - ($577.21*300)

Total Interest earned during 25 years = $226,837

If you need any clarification, you can ask in comments.    

If you like my answer, then please up-vote as it will be motivating       


Related Solutions

A young executive deposits $100 at the end of each month for 5 years into an...
A young executive deposits $100 at the end of each month for 5 years into an account that earns 6% compounded monthly. How much is in the account after the 5 years? (Round your answer to the nearest cent). $   The executive then changes the deposits in order to have a total of $400,000 after 25 total years. What should be the revised monthly payment in order to meet the $400,000 goal? (Round your answer to the nearest cent). $  ...
Q. Currently Nathan deposits $300 at the end of each month into an IRA and his...
Q. Currently Nathan deposits $300 at the end of each month into an IRA and his company will match 40% of his deposit amount. He will retire in 45 years. Assuming his account will earn 8.5% interest rate (APR), how much he can withdraw monthly after his retirement after-tax basis? (Assume he will live for another 25 years after retirement, his average tax rate will be 20%, and his deposit amount will remain constant). Q. The Purple Pillow is a...
Currently Nathan deposits $300 at the end of each month into an IRA and his company...
Currently Nathan deposits $300 at the end of each month into an IRA and his company will match 40% of his deposit amount. He will retire in 45 years. Assuming his account will earn 8.5% interest rate (APR), how much he can withdraw monthly after his retirement after-tax basis? (Assume he will live for another 25 years after retirement, his average tax rate will be 20%, and his deposit amount will remain constant).
Raj deposits 50 into a fund at the end of each month for 5 years. The...
Raj deposits 50 into a fund at the end of each month for 5 years. The fund pays interest at an annual effective rate of i. The total amount of interest earned during the last month of year 5 is 13. Calculate the accumulated amount in Raj's account at the end of year 5 A) 3325 B) 3350 C) 3375 D) 3400 E) 3425
3. Jose deposits $150 at the end of each month into an account that pays 6%...
3. Jose deposits $150 at the end of each month into an account that pays 6% interest compounded monthly . After 8 years of deposits, what is the account balance?
Linda will make month-end deposits of 2,000 for 6 years staring in one month. She earns...
Linda will make month-end deposits of 2,000 for 6 years staring in one month. She earns an interest rate of 4.4% p.a. compounded monthly for the first 2 years and 8.1% p.a. compounded monthly thereafter. How much will she have in 6 years? Correct your answer to the nearest cent without any units. (Do not use "$" or "," in your answer. e.g. 12345.67)  
An individual is 48 years old. At the end of each​ month, hedeposits ​$300 in...
An individual is 48 years old. At the end of each month, he deposits $300 in a retirement account that pays 4.82% interest compounded monthly. (a) After 12 years, what is the value of the account? (b) If no further deposits or withdrawals are made to the account, what is the value of the account when the individual reaches age 65?After 12 years, the value of the account will be $
Suppose a young couple deposits $600 at the end of each quarter in an account that...
Suppose a young couple deposits $600 at the end of each quarter in an account that earns 6.8%, compounded quarterly, for a period of 2 years. After the 2 years, they start a family and find they can contribute only $200 per quarter. If they leave the money from the first 2 years in the account and continue to contribute $200 at the end of each quarter for the next 18 1/2 years, how much will they have in the...
Suppose you invest $150 at the end of each month for 6 years into an account...
Suppose you invest $150 at the end of each month for 6 years into an account earning 6% annual interest compounded monthly. After 6 years, you leave the money, without making additional deposits, in the account for another 26 years. How much will you have in the end? How would I solve this using the "TI-84 plus Tvm solver"?
You make deposits at the end of each month into an account earning interest at a...
You make deposits at the end of each month into an account earning interest at a rate of 6%/year compounded monthly. Your deposits will be $2000/month in the first year, $2200/month in the second year, $2420/month in the third year, $2662 in the fourth year, and so on. How much will be in your account at the end of 40 years? No Excel answers please.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT