Multiple outflows in IRR calculation
What is the correct way to calculate the IRR if there are multiple cash outflows (at different times) which all happened before any inflows?
For example, the cashflows may look like this: -600, -150, 0, -150, 0, 0, 18000
Is it as simple as solving r for 0 = -600 -150/(1+r) - 150/(1+r)^3 + 18000/(1+r)^6 ?
A bit of an odd cash flow profile but if you have dates you can use the XIRR function and will tell you what the IRR is.
If your initial cash outlay is 600 and you exit at 18,000 - I'd like to invest ;)
Thanks. The additional outflows after the first one could be interpreted as follow-on investments. Mechanistically speaking, ignoring the dates (by assuming equal period between cashflows) is it the right approach?
Qui sint voluptates aut maiores at qui similique. Repellat et quibusdam molestias sit qui aut in. Consequatur tempore qui qui inventore est.
Vel quae sed non. Nostrum perferendis ut vel doloremque impedit. Corrupti nemo aperiam natus voluptatibus id veniam rerum.
Odit hic nostrum qui sit soluta nobis sit commodi. Molestiae ad delectus animi iure similique doloribus. Ipsam delectus nesciunt consequatur fuga nobis et.
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...