I have this problem to calculate IRR i have seen different ways of doing it but it does not give the answer that i need the book shows formula

1/(1+r)xCF/r-CF₀₌₀

_{therefore 0=-110.0+1/(1+r) x 32.1/r}

_{I should get 23.61%}

amount are 110.0 millions cash flow 32.1 and rate is 9.5

I try excel and different ways of doing it and It does not give that answer

the IRR is 23.61-9.5= 14.11

but that is just the sample I got several problems where I have to figure out the IRR but it will not turn out to be this answer how did they figure out this one