% per annum fixed interest

[dpotta]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Loan amount
[/TD]
[TD]£400.00
[/TD]
[/TR]
[TR]
[TD]Term in months
[/TD]
[TD]9
[/TD]
[/TR]
[TR]
[TD]Total payable
[/TD]
[TD]£446.02
[/TD]
[/TR]
[TR]
[TD]APR
[/TD]
[TD]26.8242%
[/TD]
[/TR]
[TR]
[TD]Amount of repayments (9 monthly payments)
[/TD]
[TD]£49.56
[/TD]
[/TR]
[TR]
[TD]Annual fixed rate of interest
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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%