Enter and Format the Data

2. Try it: Enter the Data

Select Cell B1 and type: 20000

Go to Home->Number and select Accounting.

This is the Present Value of the car. (Pv)

 

Select Cell B2 and type: 36

This is the number of payment periods. (Nper)


Select Cell B3 and type: .04

Go to Home->Number and select Percent.

This is the Interest Rate for the loan. (Rate)

 

Keep going...

Home->Number

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.4. Apply functions in formulas: FINANCIAL Functions PMT