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
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
Thread
Thread Starter
Forum
Replies
Last Post
QuattroGT74
Off Topic
6
Jan 5, 2006 03:22 AM




