Note: In order to use the spreadsheet examples, you need to download Business Functions
|IRRTX (Dates, Cashflows, [IRRMinOpt], [IRRMaxOpt], [IRRAccOpt], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [PVTOptions], [Dates2], [Cashflows2], [Dates3], [Cashflows3], [Dates4], [Cashflows4])|
|Internal Rate of Return of cashflows at specific times, extended version|
|Returns the IRR (internal rate of return) of the cashflow represented by Dates and the corresponding Amounts This is the extended version, with additional inputs for more control.|
|...T||Data is supplied at specific times|
Whats good or unique about it
Excel"s XIRR function copes with any dates, but how does it calculate how many years a cash flow occurs from the start of the cashflow? The answer is it uses the A/365 DayCount convention, which may not be what you want. This function, IRRT, allows you the full range of BF"s Daycount options to determine this.