Transcript

Instructions

  1. Add a prospective car buyer and estimated price range to your spreadsheet.
  2. Create columns for "Loan Amount" and "Monthly Payment" to create a table below the frozen rows.
  3. Enter a range of potential loans, increasing incrementally.
  4. Calculate the monthly payment for each loan amount using the PMT function.
  5. Make the monthly APR and loan term references absolute instead of relative cell references.
  6. Copy the function to the rest of your spreadsheet.
Attributions
  • "New Car" by Caitlin Regan (https://www.flickr.com/photos/caitlinator/3673390863) -- Licensed by CC BY 2.0 (https://creativecommons.org/licenses/by/2.0/) -- Image scaled up, cropping edges
  • "File:Wrapped Porsche 918 Spyder.jpg" by Axion23 (https://commons.wikimedia.org/wiki/File:Wrapped_Porsche_918_Spyder.jpg) -- Licensed by CC BY 2.0 (https://creativecommons.org/licenses/by/2.0/deed.en) -- Image scaled up, cropping edges
namespaces/google.engedu.apski/contents/Activity-74265891230407816693157650910170544914en-uk