Excell spreadsheet has a function button fx to help calculate for P, A,
F, n or i. The following is to calculate the respective unknowns:
To find the equivalent P: PV(i, n, A, F, type)
To find the equivalent A: PMT(i, n, P, F, type)
To find the equivalent F: FV(i, n, A, P, type)
To find n : NPER(i, A, P, F, type)
To find i : RATE(n, A, P, F, guess)

Minus sign must be inserted for P,A or F to give the equivalent values.

For this exercise, calculate payments ranging between 36 and 60 months
for a car loan of $18,000 and annual interest rate of 12%, and draw its
graph using Excell spreadsheet.


any idea?..help me