**Even if net cashflows are negative, Excel can produce a positive IRR**. If cashflows don’t occur in the ‘correct’ order, i.e. negative followed by positive, then the IRR produced can be false.

Contents

- Does IRR work with multiple negative cash flows?
- Does Xirr work with negative cash flows?
- Can you have an IRR with a negative NPV?
- Does IRR ignore cash flows?
- When can IRR not be calculated?
- How do you calculate IRR with unconventional cash flow?
- Does IRR have to start with negative number?
- What is difference between Xirr and IRR?

## Does IRR work with multiple negative cash flows?

Another problem with the IRR is that **it can produce multiple results**. Each time your cash flows change from negative to positive, or from positive to negative, the calculation generates an additional solution.

## Does Xirr work with negative cash flows?

Posted bellow are a series of cash flows. In Excel when using =XIRR(B1:B32,A1:A32) the answer is esentially zero or an error (2.98E-09). The sum of these cash flows is -618.43, if you modify the cash flows so the sum is positive, the XIRR function works.

XIRR for cash flows with a negative sum returning an error 2.98E-09.

04/05/15 | -$200.00 |
---|---|

31/12/15 | $9,518.08 |

## Can you have an IRR with a negative NPV?

**If your IRR less than Cost of Capital, you still have positive IRR but negative NPV**. However, if your cost of capital is 15%, then your IRR will be 10% but NPV shall be negative. So, you can have positive IRR in spite of negative NPV.

## Does IRR ignore cash flows?

Limitations Of IRR

It ignores the actual dollar value of comparable investments. It does not compare the holding periods of like investments. **It does not account for eliminating negative cash flows**. It provides no consideration for the reinvestment of positive cash flows.

## When can IRR not be calculated?

Limitations of the IRR

**In the case of positive cash flows followed by negative ones and then by positive ones, the IRR may have multiple values**. Moreover, if all cash flows have the same sign (i.e., the project never turns a profit), then no discount rate will produce a zero NPV.

## How do you calculate IRR with unconventional cash flow?

Quote from video: *So this is non conventional let's just calculate IRR. And see what we get. Remember IRR can take cash flows at time zero. And after. So 14% if our internal rate of return I'm.*

## Does IRR have to start with negative number?

The parameter of the IRR function is: values – a range of cells containing values, including initial investment and incomes. **The investment must have a negative sign, as it is a cost**. **[guess] – an estimated value for the expected IRR**.

## What is difference between Xirr and IRR?

As we’ve explained, the key difference between IRR and XIRR is **the way each formula handles cash flows**. IRR doesn’t take into account when the actual cash flow takes place, so it rolls them up into annual periods. By contrast, the XIRR formula considers the dates when the cash flow actually happens.