Transcript

Instructions

  1. Calculate the total payment (monthly payment * monthly loan term).
  2. Use an absolute cell reference ($) for the number of payments cell.
  3. Calculate the amount you will pay in interest (total payments - loan amount).
  4. Copy these formulas to the rest of your loan amount table.
  5. Experiment changing the APR and loan terms.
Attributions
  • "BMW for sale" by JOHN LLOYD (https://www.flickr.com/photos/hugo90/4566994618) -- Licensed by CC BY 2.0 (https://creativecommons.org/licenses/by/2.0/) -- Image scaled up, cropping edges
  • "Money" by Ervins Strauhmanis (https://www.flickr.com/photos/ervins_strauhmanis/9547663730) -- Licensed by CC BY 2.0 (https://creativecommons.org/licenses/by/2.0/) -- Image scaled up, cropping edges
namespaces/google.engedu.apski/contents/Activity-148486065859258068956710857437103473942en-uk