8. Calculate how much you would need to borrow for each purchase. a. In cell C16, enter a formula to calculate the price of the vehide minus your available cash (from cell A3 in the Data worksheet). Use absolute references where appropriate you will be copying'this formula across the row. b. Copy the formula to the appropriate cells for the other vehicles. 9. Calculate the monthly payment amount for each loan. a. In cell C2O, enter a formula using the PMI function to calculate the monthly loan payment for the first vehicle.Hint: Divide the interest rate by 12 in the Rote argument to reflect monthly payments. b. Hint Multiply the number of years by 12 in the Nper argument to reflect the number of monthly payments during the life of the loan Hint: Use a negative value for the loan amount in the Pv argument so the payment amount is expressed as a positive number. c. Copy the formula to the appropriate cells for the other vehicles