XIRR at 360 day

[Guest]

I am trying to compare an XIRR to an APR. The APR model uses a 360 day Federal Calender. Is there a way to force XIRR to use 360 as the denominator in its iteration formula

The dates I am using for activity in the cash flow are all spaced 30 days apart. Normally IRR would suffice but there is a delay between the first cash flow activity (a loan issued to a borrower) and the first payment from the loan. This delay is 24 months. I then have 240 months of equally spaced payments. I do not believe IRR is recognizing this delay in the cash flow cycle

 

[Norman Harker]

Hi Mike!

There's no option of changing the days in year used by XIRR; it's 365.

With the delay in of 24 months in your cash flow, you could use
initial price paid followed by 24 months of 0 payments (not blanks!!)
followed by 240 months of your periodic payments. IRR will recognise
that delay.