"cfspahn24" wrote in message
...
How to get an amortization schedule knowing principle, APR, and payment
amount? I want to know how long it will take to pay off using different
pmt
amoynts.

Given:
C = Principle
P = Payment
i = interest
n = months or quarters or years, etc
(i must be related to n)


P - C i
Log -----------
P
n = ----------------------
1
Log ----------
1 + i

I don't know how/if Excel handles this formula.
For finacial calculations I do normally use
mathematical formulas.

Ciao
Bruno