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.
you need to provide a guess (the last parameter). Enter 0.11 and your rate should converge.
=Rate(100,0,-125,36000000,0,0.11)
Thanks so much for your help it worked for me!!! Now It brings me to another question how do I know what number to use for the guess for future references?
- 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.