XIRR at 360 day

M

Mike

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
 
N

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top