3.1 - Car loan analysis

• We will use a template - a worksheet that has been set up for us by Microsoft.
• PMT command
  • PMT(Interest Rate/Period, Periods, Amount of loan)
  • A $7,000 car at 7% interest for 5 years
  • =PMT(.07/12,5*12,-7000)
  • Better yet- Put them in cells.
• Goal Seek - let the spreadsheet find the value to put into a cell.