1. Freeze 7 rows at the top of your spreadsheet to create a summary table.
  2. Record an annual percentage rate and loan term in years.
  3. Multiply the loan term by 12 to calculate the loan term in months.
  4. Divide the APR by 12 to calculate the monthly percentage rate for your loan.
  • "FICO Credit Score Range" by CafeCredit ( -- Licensed by CC BY 2.0 ( -- Image scaled up, cropping edges
  • "1994 or 1995 Oldsmobile Intrigue TV Commercial.mp4" by Underground Raw ( -- Licensed by CC Attribution 3.0 Unported ( -- Audio is removed from video, Clipped to fit video length needs