% per annum fixed interest

[dpotta]

Loan amount	£400.00
Term in months	9
Total payable	£446.02
APR	26.8242%
Amount of repayments (9 monthly payments)	£49.56
Annual fixed rate of interest

<tbody>
</tbody>

Hello

I have attached an excel sheet with the information I have about a loan. Excuse my ignorance, but what calculation formula will return the annual interest rate? It is fixed rate.
Many thanks
Dave

---

 

[MickG]

Is this what you are after ??
(1.268242^(1/12)-1)*12= 0.24 = 24%