You plan to save the following amounts
Assuming you earn a 5.2% rate of return during the entire period, how much will you have at the END of the time horizon? Round answer to the nearest dollar.
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.
You plan to save the following amounts $4,841 today $6,681 per year for the next 8...
You are offered an investment that will pay you the following amounts $9979 today $2655 per year for the next 8 years $3359 per year for the following 2 years $5145 per year for the following 1 years $14572 per year for the final 2 years Assuming you earn a 4.2% rate of return during the entire period, how much is this investment worth TODAY? Round answer to the nearest dollar.
You plan to save $7,300 per year for the next 11 years. After the last deposit, you will keep the money in the account for 3 more years. The account will earn an interest rate of 7.6 percent. How much will there be in the account 14 years from today?
You plan to save $5,700 per year for the next 10 years. After the last deposit, you will keep the money in the account for 4 more years. The account will earn an interest rate of 6 percent. How much will there be in the account 14 years from today?
You plan to save $240 per month starting today for the next 33 years "just to start the month off right." You feel that you can earn an interest rate of 10 percent compounded monthly. How much will there be in the account 33 years from today? Multiple Choice O $747618.00 O $690,761.90 $741.439.34 5640,084.45 $704.092.89
To fund your dream around-the-world vacation, you plan to save $1,250 per year for the next 12 years starting one year from now. If you can earn an interest rate of 5.71 percent, how much will you have saved for your vacation? Multiple Choice o $18,431.38 o $20,018.86 o $19,832.35 o О $20,73382 $20,733.82 o $19,582.60 The value of the following cash flows four years from today is $8,487.54. The interest rate is 5.6 percent. What is the value of...
You plan to retire 30 years from now. You will save $5,000 per year for the next 15 years, and then $7,000 for the 15 years after that. You can earn 9% on your savings. How much will you have 30 years from now? Round your answer tothe nearest whole number,for example 1441. You will save $4,000 per year for the next 30 years. You will earn 10% on your savings. At the end of 30 years, you will retire,...
1. you plan to deposit into your bank account $200 today, $300 next year and $400 at the end of year, and then to withdraw your full balance at the end of year 4, if you can earn 5% per year, how much would you have in your account by the end of year? a. $849 b. $900 c. $1,031 d. $1218 2. a perpetuity of $600 per year will begin 3 years from today. if want to earn an...
DQuestion 4 1 pts You plan to retire 30 years from now. You will save $1,000 per year for the next 15 years, and then $2,000 for the 15 years after that. You can earn 8% on your savings. How much will you have 30 years from now? Round your answer to the nearest whole number, for example 1441 D Question 5 1 pts You will save $11,000 per year for the next 30 years. You will earn 12% on...
You are trying to decide how much to save for retirement. Assume you plan to save $5,000 per year with the first investment made one year from now. You think you can earn 5.0% per year on your investments and you plan to retire in 27 years, immediately after making your last S5,000 investment. a. How much will you have in your retirement account on the day you retire? b. If, instead of investing S5,000 per year, you wanted to...
To fund your dream around-the-world vacation, you plan to save $2,575 per year for the next 13 years starting one year from now. If you can earn an interest rate of 5.41 perce how much will you have saved for your vacation? Multiple Choice Ο $46,818.51 Ο $45,204.08 Ο $44,395.65 Ο $44,782.92 Ο $41,972.78