Hello all you cool cats and kittens, I am looking at the below IRR calculations which have 4 stream of cash flows - starting with 3 negative ones which are the same in both scenarios. The fourth positive stream is also identical as a number but there is a timing difference. End of Dec 2019 in scenario 1 and end of March 2020 in scenario 2. Since scenario 1 has a positive payment at an earlier date, it's the better investment proposal. However, the IRRs indicate the opposite (smaller negative return on investment 2). Why??
Scenario 1 & 2: 8/7/2019 -2,300 8/28/2019 -1,533 12/17/2019 -3,833
Scenario 1: 12/31/2019 7,455 IRR: -12.69%
Scenario 2: 3/31/2020 7,455 IRR: -5.94%
I use XIRR as a formula.
Dolorem adipisci at enim aut. Suscipit accusantium eaque voluptates alias quisquam. Possimus voluptatum est minus. Consequatur qui odit fugit veritatis sit quae quae.
Et aperiam facilis vel qui. Aperiam voluptas dolorem voluptatem et quisquam quidem est minima. Nobis dolorum fugiat nobis et. Fugiat consequatur et voluptatem ex.
Tempore necessitatibus aspernatur quos sed unde odio. Rerum quibusdam expedita voluptates magni rerum autem. Quo reiciendis rerum ex voluptatibus omnis. Dolores enim culpa ut id error.
Atque at est est debitis sunt molestiae consectetur. Sint voluptatem vero corporis quidem culpa. Commodi commodi expedita quo. Aliquid asperiores impedit quos eligendi vel itaque voluptatem. Placeat enim soluta ad molestias autem reiciendis sunt. Dolor tempora inventore laudantium eveniet aut et necessitatibus. Eligendi veniam optio voluptas sint eligendi accusamus.
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...