You set up a savings plan for retirement in 35 years. You will deposit $250 each...

You set up a savings plan for retirement in 35 years. You will deposit $250 each month for 35 years. The account will earn an average of 6.5% compounded monthly.
a. How much will you have in your retirement plan in 35 years?
b. How much interest did you earn.
c. What percent of the balance is interest?

Could you show the formula in Excel? I think it is PV.

Solutions

Expert Solution

Ans:- In this question, we need to find the accumulated amount that will have in 35 years that means we need to find the Future Value. we will use the FV function of excel to find the answer.

Rate=6.5%/12, Nper=35*12 = 420. Pmt=-$250,PV=0,

Note:- Rate is divided by 12 because it is compounded monthly, Nper is the number of periods and Pmt is the periodic or monthly payment.

(a) Therefore, the Future Value after 35 years will be $400,079.05.

(b) Interest earned will be Total Amount earned - Amount Invested = $400,079.05 - $250 * 35 *12 = $295,079.05 (approx)

(c) Interest percentage will be Interest amount / Total amount * 100 = $295.079.05 / $400,079.05 * 100 = 73.76% (approx).

Note:- In this question, we need to find the Future Value not the Present value because it is clearly asking in part (a) how much will you have in your retirement plan in 35 years.

Note:- If this answer helps you pls give thumbs up.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

you plan to retire in 35 years. during each year of retirement, you want to have...

you plan to retire in 35 years. during each year of retirement, you want to have an amount of money with the same prchaning powe that $50,000 has today. inflation is expected to be 3% per year form now. A. how much money do you need in the first year of retiment (35 years from todya)? round to the nearest dollar. B. Ignore your answer to “a” and assume you need $125,000 in the first year of retirement. Call it CF1....

Ella Funt would like to set up her retirement account that willbegin in 35 years....

Ella Funt would like to set up her retirement account that will begin in 35 years. To play it safe, she wants to assume that she will live forever and she will withdraw $150,000 annually. Assuming her account will earn 9% interest during the next 35 years and 4% interest afterwards forever, how much will Ella need to save annually over the next 35 years to fund her retirement account?Group of answer choices$16,212$17,384$18,798$19,454

Assume that you contribute $250 per month to a retirement plan for 25 years. Then you...

Assume that you contribute $250 per month to a retirement plan for 25 years. Then you are able to increase the contribution to $500 per month for another 25 years. Given a 9.0 percent interest rate, what is the value of your retirement plan after the 50 years?

You are planning your retirement in 35 years. You currently have $8,000 and plan to add...

You are planning your retirement in 35 years. You currently have $8,000 and plan to add $3,000 at the end of each of the next 35 years. You expect to earn a return of 8.5% per year from your retirement investment account. When you retire in 35 years, you will transfer your money to an annuity account managed by an insurance company that pays a return of 3.5% per year. This annuity account will allow you to withdraw an equal...

You plan to make a deposit every year into your retirement account for 30 years. Your...

You plan to make a deposit every year into your retirement account for 30 years. Your deposit at the end of the first year will be $2000. Each year you will increase your deposit by $500. What would be the equivalent amount that you would need to deposit each year if the amount you deposited every year never changed. (i.e. instead of your first deposit being $2000 and your second being $2500, etc., your first deposit will be $X and...

You plan to start regular savings for retirement. You have been offered 3 different savings plans...

You plan to start regular savings for retirement. You have been offered 3 different savings plans by a financial institution. Option 1: You will deposit $600 at the end of each month for the next 20 years. The nominal interest rate is 12% per annum compounded monthly. a) Calculate the future value of your savings immediately after the last deposit. (1 mark) b) To help you, your parents will deposit a bonus of $1100 into your savings account at the...

You plan to start regular savings for retirement. You have been offered 3 different savings plans...

Suppose that you deposit $1,000 in a savings account at Wells Fargo and plan to leave...

Suppose that you deposit $1,000 in a savings account at Wells Fargo and plan to leave your principal and any interest in the account for four months. The interest rate in the first month is 2%; in the second month, 2%; in the third month, 1%; and in the fourth month, 2%. What is the future value of your account at the end of the holding period? Do not round at intermediate steps in your calculation. Round your final answer...

You plan to deposit $5,500 into a savings account. There are five great banks in your...

You plan to deposit $5,500 into a savings account. There are five great banks in your town offering terrific interest rates. If your goal is to earn the greatest amount of interest, which bank should you choose? Please explain why. Bank KLM: 3.66% compounded continuously Bank HIJ: 3.71% compounded semi-annually Bank DEF: 3.70%, compounded monthly Bank XYZ; 3.64% compounded quarterly Bank ABC: 3.74%, compounded annually

1. With the company retirement plan, you set aside a 6% of your salary each year...

1. With the company retirement plan, you set aside a 6% of your salary each year to a 401(k) plan, with your employer matching dollar to dollar. You make the first 401(k) contribution on your 29th birthday based on the current salary of $72,000. Assume the contributions are made annually. You expect your salary to increase 3% a year, and the expected return on the retirement account is 8% per annum. How much do you expect to have at your...

Subjects