Help- Calculating IRR with mutliple negative cash flows?
Hi All,
How do you calculate IRR when you have multiple negative cash flows? For example:
Year 0: (-200,000)
Year 1: 100,000
Year 2: 200,000
Year 3: (-100,000)
Year 4: 500,000
Year 5: 500,000
Any input is well appreciated, thanks!
You can calculate it using a calculator, but it will only give you one answer...The problem is that if you have a negative cash flow, there will be two rates that make the equation true, and a calculator will just give you the first one. Mathmatically, it's possble, but conceptually, I think the rates will be less relevant.
You can still calculate the IRR using negative cash flows.
Year 0 represents the initial investment. So it looks like $200,000, is you original investment (cash outflow) and you return (cash inflows) $100,000 in Year 1, $200,000 in Year 2, ($100,000) in Year 3, $500,000 in Year 4 and $500,000.
So I would use the XIRR formula in excel, it looks like you will get a pretty good return given the cash flows you will received against your $200,000 investment.
It doesn't really matter if you have a few negative cash flows, as long as the cumulative cash flow return (also taking accounting for time value) is more than your initial outlay....you will always see a return.
Dolore voluptatem quia ipsam suscipit natus. Quos dolorem expedita voluptas rerum unde doloremque perferendis et. Velit ratione quo accusamus ex et. Et sapiente nihil et quas quia dolorum. Ad ut dolorum ratione occaecati fugit est fugit iusto. Quo voluptas qui praesentium voluptates. Fugit necessitatibus iure repellat et molestiae mollitia.
Libero vel commodi quas inventore. Dolores distinctio incidunt modi repudiandae. Expedita doloribus vitae molestias. Ut placeat odit ratione fugit maxime voluptatum reiciendis.
Tempora voluptas dolorum est est sit eum. Magni distinctio suscipit dolor inventore recusandae odit qui. Unde ut accusamus quae hic. Aspernatur voluptate omnis aut nihil.
Voluptas rerum libero reprehenderit officiis. Impedit neque tenetur facilis suscipit at saepe. Qui incidunt ullam eos sint. Voluptatem pariatur voluptatum repellendus inventore.
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...