5. Now that you've calculated mortgage and rental options, let's look at savings. Go to the Savings worksheet. a. You want to save at least $10,000 for a down payment on a new car. In cell B6, enter a formula to calculate how much you will have saved by putting away $400 per month for 24 months at a 1.75% annual interest rate. Use the appropriate cell references. Remember to use a negative value for the Pw/ argument. There is no money in the account yet and payments are applied at the end of every month, so omit both the Py and Type arguments. (Hint: Use the FV function.) b. You also want to save for retirement. In cell B12, enter a formula to calculate how much you will have saved by putting away that same $400 per month for 25 years at 4%. Use the appropriate cell references. Remember to use a negative value for the Pw argument and to adjust the Rate and Nper arguments to reflect monthly payments. There is no money in the account yet and payments are applied at the end of every month, so omit both the Py and Type arguments. (Hint: Use the FV function.) c. Once you've saved 25 years for retirement, how much can you draw from the retirement account over the next 30 years? In cell B14, enter a formula to calculate how much you can pay yourself from the retirement account every month. Assume that the account will continue to earn the same interest rate. At the end of the 30 years, the account balance will be zero. Payments to you will be made at the beginning of every month. Use the appropriate cell references. (Hint: Use the PMT function to calculate the payments to yourself. Enter a negative sign before the formula so the result appears as a positive number.)