I'm trying to calculate the accrued interest using the IPMT function using this example:
$75,000 is the amt. that will be reached in 18 years using the annual interest rate of 6.5%. Present value is 0. I already calculated the total number of payments as being 216 months and the monthly payments as being $186.68. So I need help in trying to calculate the interest in the 1 period(month 1), 2 period, (month 2)...etc.

I keep coming up with some weird answers....Help. Also if there is an easier way to tackle financial functions, I need the advice. Thanks.