Look here, Microsoft has many templates that could help you

http://office.microsoft.com/en-us/te...377171033.aspx

Charlie

"ziak" wrote:

Help! Need to find total interest paid on mortgage per year - out to 5
years. Only way I can seem to do it is to find IPMT per month add the
formulas up for the year. Any other way? Something I'm missing? thanks