IRR Calculation

[manoranjan_d]

i want to how the IRR calculation work

Cashflow:

LOAD 2013 as Year, * inline [

Date|Discount|Payments

2013-01-01|0.1|-10000

2013-03-01|0.1|3000

2013-10-30|0.1|4200

2014-02-01|0.2|6800

] (delimiter is '|');

Cashflow1:

LOAD Year,IRR(Payments) as IRR2013 Resident Cashflow Group By Year;

result:

Year 2013

IRR2013 0.1634

can any explain how the 0.1634 is achieved? what are the calculation steps involved?

[tresesco]

Read it here:Internal Rate Of Return (IRR)

[sunny_talwar]

A good discussion to look at

Order of IRR payments