Calculating average interest rate

[djsquare8]

I am trying to calculate an average interest rate for the life of a 30 year bond issue, where over the life of the loan the principal paid was $1,000,000 and the interest paid was $800,000. I assume the interest is compounded continuously. Can you help?

[shg]

Welcome to the forum.

I think it's =LN(FV/P) / Y =LN(1800000/1000000) / 30 ~ 1.9593%