Objectives

• Describe how spreadsheets can assist in decision making.
• Describe the PMT function
• Use the fill handle to copy a range of cells
• Use AVERAGE, MAX, MIN, and COUNT functions.
• Use the If function
• Use the VLOOKUP function

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.

Home Mortgages

• Just like a car loan, but longer and more expensive