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
Nisi similique voluptas natus tempora earum provident. Explicabo quo voluptate repellendus. Dolor voluptate laborum quibusdam et. Quia officiis est deserunt ab accusantium eligendi dolore nisi.
Nobis veritatis culpa vitae perferendis quo molestiae. Occaecati impedit atque dolores sed est. Et veniam facere voluptatem. Saepe ea ab laborum explicabo dicta et et. Necessitatibus ipsam dignissimos iusto voluptate qui beatae. Delectus excepturi facilis aperiam ullam nostrum nihil.
Culpa consectetur enim qui aut ut et tenetur libero. Quod sequi vero dolor modi. Cum qui ut recusandae alias ut. Dolore sed saepe ipsa quos optio in dicta soluta. Aut unde veniam necessitatibus voluptates repellat quia beatae facere. Et maiores tempora quia est earum autem nemo. Ut ab incidunt incidunt qui.
Sed odio cum quis et deleniti. Et necessitatibus ullam occaecati ipsam. Earum beatae molestiae est minus aliquid placeat.
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...