For the interest paid in a period, have a look at the IPMT function.
For the interest paid between two periods, have a look at the CUMIPMT
function.

Hope this helps!

In article ,
frustratedwthis wrote:

I would like figure the amount of interest on a loan
The information I have is..
loan amount 97500
Interest rate 6.0%
30 year or 360 months
any suggestions?