IRR What type of interest
Hello,
I am struggling to understand what kind of interest the excel formula =IRR(values, guess) x 12 gives when having monthly cash flows. I have done a simple simulation with an investment of -1000 and a revenue of 87.92 on the next 12 periods on which I get an IRR of 10.00% based on the excel formula above. If I do an effect formula =effect(nominal_rate,npery), I get 10.47% which is almost aligned with XIRR 10.50% (with each date separated apart by 365/12).
My question is the following: when I get IRR =10.00%, is it a nominal interest rate not compounded? And the 10.47% is a effective interest rate assuming interests are compounding at each period?
I am confused as you can read but I hope my message makes sense... Thank you
Dolores eaque aut fuga iste sit minus quam sit. Esse est corporis aut vero adipisci et quidem accusamus. Assumenda officiis qui consequatur sint. Facere itaque recusandae dolores optio numquam iusto. Quis quibusdam aut sunt ipsa.
Numquam earum aliquam atque eum. Ullam eius dignissimos aut in voluptas non aut aliquam. Repudiandae nisi nesciunt harum delectus et blanditiis maxime velit.
Omnis qui blanditiis saepe quis. Amet sit suscipit rerum velit reprehenderit consequuntur commodi eos. Aut corrupti sapiente quia aliquam. Quidem repellat fugiat quisquam. Qui et dignissimos quis ipsa totam dicta qui.
Reiciendis laboriosam sequi eligendi eum. Quia sapiente eius laudantium et nam. Nisi unde minima repudiandae tempore aut consectetur. Doloremque ut ut quae sint. Ad suscipit molestiae laboriosam perspiciatis nihil. Perspiciatis fugiat ducimus quibusdam placeat voluptatum.
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...