Well, you need to take your interest rate, divide it by 12 to get the monthly interest rate, then make a spreadsheet that lists the principal balance, the amount of the payment, the amount of interest off that payment (by multiplying the principal times the monthly interest), which leaves the amount of principal you are paying that month. The next month take your original principal balance and deduct the principal you paid the month before, that gives you the opening principal balance again, then follow all the steps as described to determine the interest and principal payment. It will be easy to make a graph from within the program.
|
10-25-2008, 02:22 PM
Linear Mode
