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...