Re: Mortgage ammortization schedule/interest payment calculation

[EMAIL PROTECTED] (Jim) wrote in message news:<[EMAIL PROTECTED]>...

> 
> PPMT allows me to calculate how much principle is being paid each
> month for the 360 month mortgage.  As best I can tell, this is
> accurate on my spreadsheet.
> 
> I am looking for the function wizard or calculation which tells me how
> much interest is owed each month.

If you can calculate PPMT, then the interest payment is PMT-PPMT.
There's got to be a function in Excel to do this.