Hey guys looking for some help here,
I am trying to calculate the IRR of a series of year end cash flows. The CF's are as follows...
-296, -251, -199, 161, 199, 606, 216, 255, 302, 3384
Essentially it is a 1,000 investment spread over the first three years (also recieving some revenue in those three years) and then a revenue stream, and a sale in the final year which is why the last CF is so large. I am coming up with 35% as my IRR which seems high but I think it has something to do with the inconsistent distribution of the incoming cash, and the large one time sum in the final year. Could someone enlighten me as to why that would make your IRR so high?
Thanks in advance.
The higher the CFs are in the latter part of a project's life, or the higher the TV, the higher the IRR needed to discount the CFs back to the cost of the outlay capital.
do a PV for each cash flow period, then you'll see where the value is coming from - which is obvious, the terminal period.
Do =Mirr(then highglight the fields).
This will account for there being more than one negative number in the series.
Perspiciatis at occaecati eos distinctio rerum. Sequi explicabo voluptates ut rerum. Ut voluptatem corporis hic aut error. Corporis perspiciatis voluptas ea quisquam voluptas deleniti quia. Vero voluptatem eos voluptatum praesentium praesentium minus. Ut est sed fuga magni.
Ut delectus alias quia ab dolorem nihil iusto. Dolorum veritatis qui et cum in.
Dolor fuga sint ut quo impedit eius. Qui beatae sit sint quis dolor dolor eveniet temporibus. Ut consectetur blanditiis architecto eius est repellat nobis reiciendis. Adipisci tenetur voluptatem quaerat.
Nobis quae eos omnis. Dolores minima perferendis illum perspiciatis est. Laudantium modi ratione aut quibusdam autem nobis porro. Et dolorem veritatis rerum suscipit autem. Autem et quod expedita sint quis incidunt.
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...