1. Add a target 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. Change the monthly APR and loan term parameters to absolute instead of relative references.
  6. Copy the function to the rest of your spreadsheet.