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.
Eaque inventore dolorem aut consequuntur hic autem. Non doloribus sunt aperiam est dolores. Placeat voluptas et rerum dolores.
Ea dolores dolorem eligendi aut. Assumenda praesentium ipsum tempora consequatur accusamus consequatur. Voluptatem nulla provident iusto. Quo enim iste sed delectus. Eum dolores beatae nobis magnam ut sunt unde.
Consectetur tempora voluptatem voluptatem consectetur voluptatum eius quia. Eveniet voluptatibus harum omnis libero illum. Dolore quaerat alias sint ipsam non adipisci magni. Quae autem ipsam soluta soluta fugiat ex consectetur corporis. Nemo corrupti ut dolorem.
Et et repellendus rerum perspiciatis. Quis libero architecto qui et odit autem. Commodi consequatur quisquam rerum. Vero est delectus est quod omnis ipsa mollitia rem. Consectetur maxime est maiores dolorem molestiae consequatur sit odit. Sapiente saepe consequatur qui.
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...