[ View Full Version Of This Page ]

CALCULATING LOAN PAYMENT

All Forums » Off Topic » CALCULATING LOAN PAYMENT

CRAZYHAWK
12/11/2004 11:21:58 AM
The following requires a spreadsheet program.
A____________________________________B
1. Principal
2. Annual Interest
3. Years
4. Periods/Year
5. Payment_____________________________@PMT(B1,B7,B8)
6.
7. Periodic Interest_______________________+B2/B4
8. Number of Periods_____________________+B3*B4
sxates
12/11/2004 5:19:23 PM
And if you don't want to program Excel, there are lots of websites that will do this for you too. Just google "auto loan calculator"
lmolaS4
12/11/2004 10:12:29 PM
Why are we calculating loan payments?
CRAZYHAWK
12/12/2004 9:29:56 AM
awol brought it up in the A4 Forum.

[ View Full Version Of This Page ]

Return to the Audi Forums home page - Archive Home