Re: Creating an Amortization Schedule

[Asher613Smith@xxxxxxx]

As I said before, look in EXCEL. All the formulas are there. (Financial  
functions). Click on "Help on this function" for the formula.
 
e.g., for  
IPMT
Returns the interest payment for a given period for an investment  based on 
periodic, constant payments and a constant interest rate. For a more  complete 
description of the arguments in IPMT and for more information about  annuity 
functions, see _PV_ 
(mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\Office10\1033\xlmain10.chm::/html/xlfctPV.htm) .
    Formula Description (Result)  =IPMT(A2/12, A3*3, A4, A5) Interest due in 
the first month for a loan with the terms above  (-22.41)  =IPMT(A2, 3, A4, 
A5)  
Interest due in the last year for a loan with the terms above, where  
payments are made yearly (-292.45)
 

 
In a message dated 12/5/2008 8:50:37 A.M. Jerusalem Standard Time,  
koldark@xxxxxxxxx writes:

I am not  exactly a student, but in my searches I found the formula mentioned
in the  wikipedia post, but it didn't divulge into how to get the various
parts of  the payments. That is what I am focusing on. This will help me out
thank  you.