1. In cell B8, calculate the amount financed.

    TIP: Add the price and the finance charge.
  2. In cell B9, calculate the estimated monthly payment for the Cooper Mini.

    TIP: Divide the amount financed by the number of payments.
  3. In cell F4, calculate the average price of both cars.
  4. In cell G7, calculate the maximum finance charge.
  5. Calculate the finance charge, amount financed, and estimated monthly payment on the Hummer.

    When you're done, the worksheet should look like this:

  6. Save the workbook as Cars in the Practice Excel Files folder.
  7. Close the workbook.