Excel XIRR

Topics related to universal accounting principles and best practices, local GAAP, audit, laws and regulations affecting financial reporting, and other financial reporting topics.
This is also the appropriate forum for beginners to ask any questions, even if they pertain to IFRS.
Post Reply
E.Reis
Posts: 22
Joined: 02 Jun 2019, 14:04

Excel XIRR

Post by E.Reis »

Hey
Looking through the excel file examples, on the knowlwdge base, I figured that whenver the XIRR is computed to get the effective interest rate, the interst is calculated using the compound interst formula, rather than simple interest.

This doubt came out when I was computing the interest rate implicit in the lease, to discount my lease payments.

Should I use the compound interest formula to calculate interest whenever I get the effective interest rate throught XIRR?.

Anothr question is when there is only an incremental borrowing rate, is is convenient to use simple interest formula to calculate the interest?
User avatar
Marek Muc
Site Admin
Posts: 3227
Joined: 15 Oct 2018, 17:21
Contact:

Re: Excel XIRR

Post by Marek Muc »

Hi, as far as I know, XIRR uses annual compounding and it’s considered fine in all accounting computations. I’m probably not the best partner in this discussion, as I find all the differences between interest calculation conventions totally immaterial ;)
E.Reis
Posts: 22
Joined: 02 Jun 2019, 14:04

Re: Excel XIRR

Post by E.Reis »

Thank you Marek

There is some difference but not substantial.
Post Reply