HomeNewsMC MinisWhat is XIRR on investment?

What is XIRR on investment?

March 03, 2023 / 16:14 IST
Story continues below Advertisement

XIRR refers to the extended internal rate of return. XIRR usually calculates returns on investment where there are multiple transactions taking place in different times. In simple terms, XIRR can be used to calculate consolidated returns when you buy units in mutual funds or may sell. You can calculate the XIRR in mutual funds or investment through formula in excel, which is “=XIRR (values, dates, guess). The XIRR method of calculating returns simplifies the process in case of irregular investment. The XIRR formula will modify the internal rate of interest (IRR) and enable you to allocate separate dates to individual cash flows.

Story continues below Advertisement
first published: Mar 3, 2023 04:14 pm

Discover the latest Business News, Sensex, and Nifty updates. Obtain Personal Finance insights, tax queries, and expert opinions on Moneycontrol or download the Moneycontrol App to stay updated!