You are trying to decide how much to save for retirement Astume you plan to 35,000 per year with the first nivethet made your from now You think you can can 65% per year on your investment and you plan to ere in 33 years inmediately after making your last 56.000 inwestent . How much will you have in your rent account on the day you retire? b. Instead of Investing 56,000 per year you wanted to make one lump-sum investment today for your seramat will result in the same rotroment how much of that poum need to be c. If you hope to for 17 years is retirement how much can you with every year in retirement acting one year alter tremend that you will exhaust yours with the 17th withdrawal set your savings will Doneca 6% in ment? d. Instead you decide to withdraw 5129.000 per you in retirement again with the first withdrawal one year the ring how many years will take until you that your savings? Use trial and tror a financial calculator se for No Excel funcion NPER) forming the most you can afford to set 200 per year but you want to win 1.000.000 in your investment account how high of a cetum de you need on your homens? US--ame a financial calcular solve for at ox Excel function RATE) 2. How much you have in your rorement account on the day you? The amount in me retirement account in 33 years would be 3. Round to the center cent bir instead of investing 55 000 per year you wanted to makelump summer day for you what the wing how that som det You will need to make te komp sum investment today of Round in the recent cityshin e for years in the much can you withdraw every year in een starting one year to the waves with the way or an wil.coring to maintain Then you wery year in moments Round the we The man with every year in remonts Round to the nearestent d. tad you decides w129.000 per year it again with the first withdrawal one year after retiring how many years wit take unt you what your savings? (Use tratand error a financial Calculator school function NPER You want your en un total) Asuming the most you can loo 51200 per year but you want to retire with 1.000.000 in your intaccount,how Night at do you need to your investments? Use landen a financial woordivelthew Excel function RATE) You will stop decimal places