You are trying to decide how much to save for rotirement Anume you plan to ve 36.00 per year with the listen made one year from you think you can composer and you inventa How much wit you have in your refrent count on the day you retire? b. it instead of investing 55,500 per year you wanted to make one lumourninvestment today for your retirement that will result in the set sana, how much would take me to c. If you hope to ve for 27 your retirement, how much can you withdraw every year in romantting on your root so that you will textos with them with your savings will continue tocat 11,5% recent d. I had you decide to withdraw 270.000 per year in retirement again with the first wild one year wertingi, now marw you will take your sma calculator ove for "No Excel function NPER) e. Aming the most you can fford to savo in 51.100 per you, but you want to rate with 5.000.000 in your investment account how high on co con so your needs. financial corso for the interest, Excel funcion RATE) 1. How much will you have in your root account on the day you retro? This round the retired count in 3 years would be found to the westcott You are trying to decide how much to save for retirement. Assume you plan to save $5,500 per year with the first investment made one year from now You think you can earn 11.5% per year on your investments and you plan to retire in 31 years, immediately after making your last $5,500 investment a. How much will you have in your retirement account on the day you retire? b. If, instead of investing $5,500 per year, you wanted to make one lump-sum investment today for your retirement that will result in the same retroment saving how much would that lump sum need to be? c. If you hope to live for 27 years in retirement, how much can you withdraw every year in retirement (starting one year after retirement) so that you will just exhaust your savings with the 27th withdrawal (assume your savings will continue to earn 11.5% in retirement? d. If, instead, you decide to withdraw $270,000 per year in retirement (again with the first withdrawal one year after retiring, how many years will take until you exhaust your savings? (Use trial-and-error, a financial calculator: solve for "N" or Excel function NPER) e. Assuming the most you can afford to save is $1,100 per year, but you want to retire with $1,000,000 in your investment account, how high of a return do you roed to earn on your investments? (Use trial-and-error, a financial calculator solve for the interest rate, or Excel function RATE) a. How much will you have in your retirement account on the day you retire? The amount in the retirement account in 31 years would be $ (Round to the nearest cont.)