1. In cell B9, calculate the estimated monthly payment for the LCD television.

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

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

  5. Save the workbook as HDTVs in the Practice Calc Files folder.
  6. Close the workbook.