immediately after making your last \$6,500 investment. a. How much will you have in your retirement account on the day you retire? in retirement)? function NPER) 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 cent.) You will need to make one lump sum investment today of $. (Round to the nearest cent.) in retirement)? The amount you can withdraw every year in retirement is (Round to the nearest cent.) function NPER) You will exhaust your savings in years. (Round to two decimal places.) interest rate, or Excel: function RATE) You will need a return of 6. (Round to two decimal places.)