Excel: IRR
"Microsoft Excel uses an iterative technique for calculating IRR. Starting with guess, IRR cycles through the calculation until the result is accurate within 0.00001 percent. If IRR can't find a result that works after 20 tries, the #NUM! error value is returned.
In most cases you do not need to provide guess for the IRR calculation. If guess is omitted, it is assumed to be 0.1 (10 percent)."
Question: What is the iterative technique?
If plugs an IRR into the formula and calculates the NPV of the cash flows. When the NPV is 0 then that is the IRR
But in the excel file, IRR is 14% and excel uses 0.1 as the estimator, what is the difference between the 0.1 and 0.14 then?
Similique qui architecto laboriosam qui voluptatem sed nihil. Repellat est est adipisci rerum est libero. Totam voluptatibus provident voluptatem totam quo minus. Est qui voluptatem quas veniam aut. Eius hic voluptatem voluptatem ad atque. Possimus rem minima voluptatum quo omnis.
Fuga ipsum qui id et ullam. Perspiciatis possimus maxime ea dignissimos nam delectus molestiae exercitationem. Rerum eum similique id tempore. Repellendus quos ullam voluptate qui aut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...