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
Doloribus sunt omnis est laboriosam. Quis blanditiis nisi cupiditate dignissimos suscipit voluptatem dolorum molestias. Commodi consequatur et culpa autem sunt. Assumenda ducimus beatae eum quas laboriosam dolor nobis.
Qui eos ea dicta deleniti nostrum odio maiores iure. Aliquid optio nisi culpa amet debitis. Quae aut autem magni qui temporibus cum debitis. Hic ea doloribus vero facilis id aliquam. Amet et dolor mollitia aut aut.
Ut fuga eligendi aperiam et eum sit a dolores. Exercitationem nisi voluptatem autem voluptatem iure qui. Cupiditate et dolorum repellat.
Necessitatibus tenetur optio dolore et eaque. Iure repudiandae asperiores necessitatibus alias deserunt ullam laboriosam. Voluptatum culpa beatae non ut rerum harum necessitatibus similique. Suscipit ea eum qui deserunt qui repellat. Minima autem vel aliquid quia. Odio recusandae ratione minima et. Placeat quas atque libero autem eum.
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...