TIR con flujos positivos y negativos

Question

buenos días a todos. Estoy teniendo dificultad al resolver un sencillo ejercicio de TIR. Se trata del siguiente flujo de caja en 7 meses con desembolso negativo y cuyo resultado me parece totalmente incorrecto:

Mes 0 : -5220 (egreso)

Mes 1 : + 46500 (ingreso)

Mes 2: - 8000 (egreso)

Mes 3: -7000(egreso)

Mes 4: 0

Mes 5: 0

Mes 6: - 39000 (egreso)

Mes 7: + 46500 (ingreso)

He tratado de resolver con la formula de excel =TIR() pero no se si esta sea la manera correcta.

agradezco mucho su ayuda!

Vanessa

Answer 1

I think this is the right formula for it. Hope it can be of help to you.

  = IRR(values, guess)

Values : An array or references to cells containing the data needed for the actual yield calculation.

- Values must contain at least 1 negative value and 1 positive value.

- IRR() uses the order of values as the cash flow order. Care should therefore be taken to ensure that payment or income orders are always entered correctly.

- IRR() only calculates numeric values inside arrays or references of values; and empty cells, logical values, text or error values will be ignored.

Guess : An estimated % close to the result of IRR(). If omitted, guess = 10% by default.

- Excel uses the loop function in IRR calculations. Starting with guess, the IRR iterates until the result is correct within 0.00001%. If the IRR cannot produce a result after 20 iterations, the IRR will return the #NUM!

- In case the IRR returns the #NUM! error value, or if the result does not approximate the expected value, try again with a different guess value.

eggy car