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
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