Forum Discussion
Solved
Rate issue in excel
Hello I am trying to figure out why the RATE function is excel is not working properly for me. I am trying to solve the problem =Rate(100,0,-125,36000000) 100=n, 125=PV, 0=PMT, FV=36 Million, but whe...
- https://support.microsoft.com/en-us/office/rate-function-9f665657-4a7e-4bb7-a030-83fc59e748ce
guess defaults to 0.10 if it's omitted. The recommendation is to try small increments between 0.11 and 0.99 until you land on a value that converges.
FYI, RATE will always give you only an approximate result; sometimes good, sometimes not.
But when pmt=0, the periodic rate can be calculated exactly by:
=(fv/pv)^(1/nper) - 1
formatted as Percentage. The formula assumes that both fv and pv are positive.
For example, (36000000/125)^(1/100) - 1 results in 13.3950050991972%.