Taken from Help in Xl2003:
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.

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"rldoan" wrote in message
...
Hello. Is there a way make an amortization schedule for an interest only
loan? It would compute the schedule from the loan amount, term of the
loan,
interest only period, and interest rate.

Thanks