Go Back   AudiForums.com > General > Off Topic




Reply
 
Thread Tools
  #1  
Old 12-11-2004, 02:21 PM
CRAZYHAWK CRAZYHAWK is offline
Senior Member
 
Join Date: May 2004
Location: Northern NJ USA
Posts: 3,570
Default CALCULATING LOAN PAYMENT

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
__________________
2001 A4 1.8T Q Casablanca White, Tip, ESP, Xenon and Premium
Reply With Quote
Sponsored Links
This ad is not displayed to registered members.
Register your free account today and become a member on Audi Forums!
  #2  
Old 12-11-2004, 08:19 PM
sxates sxates is offline
 
Join Date: Dec 2004
Location:
Posts: 22
Default RE: CALCULATING LOAN PAYMENT

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"
Reply With Quote
  #3  
Old 12-12-2004, 01:12 AM
lmolaS4 lmolaS4 is offline
 
Join Date: Dec 2004
Location:
Posts: 30
Default RE: CALCULATING LOAN PAYMENT

Why are we calculating loan payments?
__________________

Either lead, follow, or get out of the way...
Audis don't get out of the way and they never follow.
Reply With Quote
  #4  
Old 12-12-2004, 12:29 PM
CRAZYHAWK CRAZYHAWK is offline
Senior Member
 
Join Date: May 2004
Location: Northern NJ USA
Posts: 3,570
Default RE: CALCULATING LOAN PAYMENT

awol brought it up in the A4 Forum.
__________________
2001 A4 1.8T Q Casablanca White, Tip, ESP, Xenon and Premium
Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Advertising

Featured Sponsors


New Sponsors
AMSOIL - Performance Oil Technology
K&N Engineering

All times are GMT -4. The time now is 08:33 PM.

© Internet Brands, Inc.
Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.