Digit
headset_mic account_circle
mail
Sign In
  • Products

    Motor

    • Car Insurance
    • Two Wheeler/Bike Insurance
    • Commercial Vehicle Insurance
    • Taxi/Cab Insurance
    • Auto Rickshaw Insurance
    • Truck Insurance

    Health

    • Health Insurance
    • Super Top-up Health Insurance
    • Arogya Sanjeevani Policy
    • Corporate Health Insurance

    Other

    • International Travel Insurance
    • Flight Delay
    • Shop Insurance
    • Home Insurance
  • Claims

    • File a Claim
    • File Health Claim
    • File Motor Claim for Garages
    • COVID-19 Assistance
    • Claim Status
  • Renewals
  • Become an Agent
  • Digit Products

    Motor Insurance

    • Car Insurance 25% OFF
    • Two Wheeler/Bike Insurance
    • Commercial Vehicle Insurance
    • Taxi/Cab Insurance 15% OFF
    • Auto Rickshaw Insurance
    • Truck Insurance

    Health Insurance

    • Health Insurance
    • Super Top-Up Health Insurance
    • OPD Health Insurance
    • Arogya Sanjeevani Policy
    • Personal Accident Insurance
    • Corporate Health Insurance

    Other Insurance

    • International Travel Insurance
    • Flight Delay
    • Shop Insurance
    • Home Insurance
  • Claims

    File a Claim

    File Health Claim

    File Motor Claim for Garages

    COVID-19 Assistance

    Claim Status

  • Renewals

    Become an Agent

  • Support
    Sign In
    • edit Edit Policy
    • download Download Policy
    • person_pin My Service Requests
    • check Check Policy Status
    call 1800-258-5956 mail_outline hello@godigit.com whatsapp 70260 61234

    Our WhatsApp number cannot be used for calls. This is a chat only number.

  • My Account
    account_circle
    • autorenew Renew My Policy
    • download Download My Policy
    logout SIGN OUT
    call 1800-258-5956 mail_outline hello@godigit.com whatsapp 70260 61234

    Our WhatsApp number cannot be used for calls. This is a chat only number.

  • login
  • about
  • contact
  • careers
More Products

Motor

  • Car Insurance
  • Two Wheeler/Bike Insurance
  • Commercial Vehicle Insurance
  • Taxi/Cab Insurance
  • Auto Rickshaw Insurance
  • Truck Insurance

Health

  • Health Insurance
  • Super Top-up Health Insurance
  • Arogya Sanjeevani Policy
  • Corporate Health Insurance

Other

  • International Travel Insurance
  • Flight Delay
  • Shop Insurance
  • Home Insurance

Support

close
account_circle
  • edit Edit Policy
  • download Download Policy
  • person_pin My Service Requests
  • check Check Policy Status
  • autorenew Renew My Policy
  • download Download My Policy
logout SIGN OUT
call 1800-258-5956 mail_outline hello@godigit.com whatsapp 70260 61234

Our WhatsApp number cannot be used for calls. This is a chat only number.

Do the Digit Insurance

Trusted by 3 Crore+ Indians

  • Health
    Health
  • Pay as you Drive
    Car Side View
    Car
  • trending icon

    Third-party premium has changed from 1st June. Renew now

    Motorcycle Side View
    Bike
  • auto rikshaw
    Commercial
  • Covers COVID-19
    Travel Airplane
    Travel
  • More products
    More
ENTER YOUR CAR NUMBER
keyboard_arrow_right
DON'T KNOW YOUR CAR NUMBER?
keyboard_arrow_right
renew digit policy keyboard_arrow_right

I agree to the  Terms & Conditions

{{(!carWheelerCtrl.registrationNumberCardShow || carWheelerCtrl.localStorageValues.vehicle.isVehicleNew) ? 'I know my Reg num' : 'Don’t have Reg num?'}}
keyboard_arrow_right
It’s a brand new Car
keyboard_arrow_right
renew digit policy keyboard_arrow_right

I agree to the  Terms & Conditions

Terms and conditions

    false false
    Enter valid registration number
    DON'T KNOW REGISTRATION NUMBER?
    keyboard_arrow_right
    I KNOW MY REGISTRATION NUMBER
    keyboard_arrow_right
    IT'S A NEW BIKE
    keyboard_arrow_right
    RENEW DIGIT POLICY
    keyboard_arrow_right

    I agree to the  Terms & Conditions

    Continue with {{bikeCtrl.lastVisitedData.lastVisitedUrl.indexOf('DigitPaymentGateway/payments') !== -1 ? 'payment completion': 'previous choice'}}

    {{bikeCtrl.lastVisitedData.vehicle.makeModel | toTitleCase}} {{bikeCtrl.lastVisitedData.vehicle.variant? (bikeCtrl.lastVisitedData.vehicle.variant|toTitleCase): (bikeCtrl.lastVisitedData.vehicleCharacteristics.vehicleType | toTitleCase)}}

    {{bikeCtrl.lastVisitedData.vehicle.licensePlateNumber}}

    {{bikeCtrl.selectedPlanDisplay[bikeCtrl.lastVisitedData.dropOffSelectedPlan? bikeCtrl.lastVisitedData.dropOffSelectedPlan: bikeCtrl.lastVisitedData.selectedPlan]}}

    -

    ₹{{((bikeCtrl.lastVisitedData.dropOffSelectedPlan ? bikeCtrl.lastVisitedData.dropOffGrossPremium:bikeCtrl.lastVisitedData.chosePlan.grossPremium) .replace('INR ','')).split('.')[0] | rupeeFormatWithComma}} (Incl 18% GST)

    keyboard_arrow_right
    IT'S A NEW BIKE
    keyboard_arrow_right
    RENEW DIGIT POLICY
    keyboard_arrow_right

    I agree to the  Terms & Conditions

    Continue with {{twoWheelerCtrl.lastVisitedData.lastVisitedUrl.indexOf('DigitPaymentGateway/payments') !== -1 ? 'payment completion': 'previous choice'}}

    {{twoWheelerCtrl.lastVisitedData.vehicle.make |toTitleCase}} {{twoWheelerCtrl.lastVisitedData.vehicle.model | toTitleCase}} {{twoWheelerCtrl.lastVisitedData.vehicle.variant? (twoWheelerCtrl.lastVisitedData.vehicle.variant |toTitleCase):''}}

    {{twoWheelerCtrl.lastVisitedData.vehicle.licensePlateNumber}}

    {{twoWheelerCtrl.lastVisitedData.selectedPlan}}

    -

    ₹{{((twoWheelerCtrl.lastVisitedData.quickQuoteResponse.plans[twoWheelerCtrl.lastVisitedData.selectedPlan].resposeBody.grossPremium) .replace('INR ', '')).split('.')[0] | rupeeFormatWithComma}} (Incl 18% GST)

    • Geography
    • Country
    {{geography.name}}

    Popular Countries (You can select more thane one)

    • {{country}}

    DONE
    Please select geography

    I agree to the  Terms & Conditions

    As mandated by Spanish Authorities your travel insurance needs to extend 15 days after your trip ends.
    We will extend your coverage period accordingly.

    false false false false false false false false false false false false

    Port my existing Policy

    keyboard_arrow_right
    or renew digit policy keyboard_arrow_right
    Chat with an expert

    I agree to the  Terms & Conditions

    You can select more than one member

    • -+ Max kids
      (s)
    ENTER YOUR REGISTRATION NUMBER
    keyboard_arrow_right
    DON'T KNOW YOUR REGISTRATION NUMBER
    keyboard_arrow_right
    or renew digit policy keyboard_arrow_right

    I agree to the  Terms & Conditions

    Terms and conditions

    Terms and conditions

    Do the Digit Insurance
    • Health
    • Car
    • Bike
    • Commercial
    • Travel
    • More Products

    What Is XIRR in Mutual Funds: Meaning, Importance & Calculation Process

    xirr mutual funds
    (source: exceldemy)

    However, have you ever wondered what the right method to calculate the return on mutual fund investments is?

    Investors can use two methods, namely (CAGR- Compound Annual Growth Rate) and XIRR (Extended Internal Rate of Return). The CAGR method doesnot allows calculating returns for multiple cash flows. However, by following the XIRR method, one can easily calculate mutual fund returns for multiple cash flows.

    Read on to know what is XIRR in mutual funds, its importance, and the calculation process!

    What Is XIRR in a Mutual Fund?

    XIRR, or Extended Internal Rate of Return, is a single rate of return that is used when investors make multiple investments at different points of time in an investment vehicle such as a mutual fund.

    This single rate of return is applied to all transactions (including investment and redemption) to calculate the current rate of return and the current value of the entire investment.

    XIRR is the real investment return.

    What is the Importance of XIRR in a Mutual Fund?

    XIRR is important in mutual fund investment because investors can use this formula in an excel sheet and put data of uneven cash flow intervals and get correct results.

    XIRR is a modified version of IRR with added flexibility. The formula of XIRR can assign particular dates to each cash flow and calculate returns accurately.

    Why Does XIRR in a Mutual Fund Make Sense?

    While investing in a mutual fund, investors can put a lump sum amount that involves two cash flows. It means they will have a single cash outflow (in the form of investment) and a single cash inflow (in case of redemption). In such cases, calculating the return through the CAGR (which reflects the rate at which a mutual fund grows per year throughout an investment period) method is the correct way.

    However, in cases where investors invest in mutual fund schemes through Systematic Investment Plans (SIP) or wishes to redeem units of mutual funds investment through a Systematic Withdrawal Plan (SWP).

    Due to the multiple cash flow involved, one cannot use CAGR (as stated earlier) to calculate return from a mutual fund. Hence, using XIRR seems correct. Before delving deep into using XIRR, one must know about IRR.

    What Is an IRR?

    IRR (Internal Rate of Return) is a metric to calculate the return of a series of cash flows. Investors can use IRR to calculate returns of SIP, SWP, multiple redemptions, lump-sum investments with additional purchases, etc. However, IRR has certain limitations.

    While calculating the IRR formula in Excel, it automatically assumes the time interval between with cash-flows is the same, which rarely happens throughout the tenure.

    Let’s take an example!

    Suppose an investor puts ₹4,000, ₹9,000, ₹5,000, ₹4,000, and ₹6,500 in SIPs over 5 years and earns ₹53,000 at the end of the tenure. Here, the return on investment is 22% (as per the IRR calculation method).

    In the case of a mutual fund, investment occurs at an irregular interval (even in the case of SIP) due to a different number of days in a month, holidays etc. For uneven cash flow or irregular cash flow intervals, the calculation with IRR in the excel sheet will go on. It is here one can use XIRR and calculate the right value or return on mutual fund investment for multiple cash flows.

    How to Calculate XIRR in Excel?

    Let’s see how this formula works in Excel,

    Take an example of a six-month investment of SIP.

    SIP amount

    ₹5000

    Start date

    01.01.2020

    Cash flow intervals

    1st Month

    01.01.2020

    2nd Month

    03.02.2020

    3rd Month

    01.03.2020

    4th Month

    11.04.2020

    5th Month

    01.05.2020

    6th Month

    25.06.2020

    7th Month

    01.07.2020

    End date

    01.06.2020

    Redemption date

    01.07.2020

    Maturity amount

    ₹31000

    Here is a step-by-step guide on calculating XIRR in excel,

    Step 1 – Prepare a single column (Column A) for all purchases. Mark outflows as market negative (enter SIP figure of 5000) and inflows as a market positive.

    Step 2 – Select the next column for putting the corresponding date of the transaction.

    Step 3 – Enter the prevailing value of all holdings and the date in the last row. (Against redemption date and column A, enter redemption amount column B – i.e. 31000)

    Step 4 – Next, use the XIRR function ‘= XIRR (values, date, Guess)’. XIRR (B1: B7, A1: A7)*100, date, Guess)

    Step 5 - Choose values to a series of cash flow that corresponds to a payment schedule in dates, the column of dates refers to the first date of investment; guess is optional. If investors do not enter any value, excel automatically uses a value of 0.01.

    Step 6 – The excel sheet will show 11.92% as a result.

    Conclude your search for what is XIRR in a mutual fund and get correct results of mutual fund investment returns in case of uneven cash flow intervals.

    Frequently Asked Questions

    Can I enter all cash outflows as positive values while calculating with XIRR in a mutual fund?

    No, you have to enter all cash outflows as negative values while calculating with XIRR in a mutual fund.

    No, you have to enter all cash outflows as negative values while calculating with XIRR in a mutual fund.

    Does XIRR use the concept of compounding?

    Yes, XIRR in mutual funds uses the concept of compounding.

    Yes, XIRR in mutual funds uses the concept of compounding.

    Please try one more time!

    Request URL:
    Status Code:
    Request Payload:
    Response Data:

    Important Articles about Investment Related Topics

    Income Fund

    Unit Linked Insurance Plan ULIP

    ELSS Mutual Funds

    Equity Mutual Funds

    SIP vs Lumpsum Investments in Mutual Funds

    Lumpsum Investment in Mutual Funds

    What is SIP in Mutual Funds

    Hybrid Mutual Funds

    Balanced Mutual Funds

    Money Market Funds

    Debt Funds

    ULIP vs Mutual Funds

    What Are Mutual Funds?

    What Are Index Mutual Funds?

    What Are Growth Mutual Funds?

    Capital Protection Mutual Funds

    Commodity Mutual Funds

    Exchange-Traded Funds

    Difference between ETF vs Mutual Funds

    Difference Between Direct and Regular Mutual Funds

    Statutory Liquidity Ratio (SLR)

    Different Types of Mutual Funds in India

    Leveraged Funds

    International Mutual Funds

    Differences Between ETF and FOF

    What is Lock-in Period in Mutual Funds?

    Interval Mutual Funds

    Types of Mutual Fund Returns

    What is XIRR in Mutual Funds

    What Are Smallcase Funds?

    Difference Between Mutual Fund and Insurance

    Multi Cap Funds

    Show more

    Important Articles related to Finance

    Employee Provident Fund

    EPF Registration Process

    How to Withdraw EPF Online

    Atal Pension Yojana Calculator

    How to Change Details in Atal Pension Yojana Scheme

    How to get Atal Pension Yojana Statement

    How to Close Atal Pension Yojana Account

    Sukanya Samriddhi Yojana

    How to Open Sukanya Samriddhi Yojana Account

    Sukanya Samriddhi Yojana Calculator

    What is Public Provident Fund?

    How to Open PPF Account?

    How to Check PPF Account Balance?

    Eligibility Criteria to Open PPF Account

    Types of PPF Forms

    How to Withdraw PPF Online?

    How to Invest in PPF?

    Financial Planning for Salaried Employees

    Importance of Financial Planning

    Financial Planning Tips for Women

    How to Apply for Atal Pension Yojana?

    What is UAN Number?

    How to check EPF Balance

    KVP Calculator

    Voluntary Provident Fund

    Difference between EPF and EPS

    How to Check Sukanya Samriddhi Account Balance?

    Investment Planning Guides

    Professional Tax in India

    Show more

    Disclaimer: This information is added only for informative purposes and collected from different sources across the Internet. Digit Insurance is not promoting or recommending anything here. Please verify the information before making any decisions.

    Download Digit App

    close
    1. Digit Insurance
    2. Finance
    3. Investment Planning & Other Important Information
    4. XIRR Mutual Funds

    Last updated: 2023-01-30

    Digit
    • about
    • contact
    • career
    Products
    • Car Insurance
    • Bike Insurance
    • Travel Insurance
    • Health Insurance
    • Property Insurance
    • Shop Insurance
    • Group Health Insurance
    • Arogya Sanjeevani Policy
    • Commercial Vehicle Insurance
    • Super Top-up Health Insurance
    • Flight Delay
    Resources
    • Blog
    • Press
    • Download Policy
    • Grievance Redressal Procedure
    • Cancel e-Mandate
    Agent & Partnerships
    • Become an Agent
    • Become Digit POSP
    • Garages claim intimation
    Services
    • Claims
    • Renewals
    • Digit Cashless Garages
    • Digit Cashless Hospitals
    Get our app
    Download man
    App Store Google Play

    Other Products
    • Fire Insurance
    • Burglary Insurance
    • Building Insurance
    • Bus Insurance
    • Tractor Insurance
    • Commercial Van Insurance
    • Passenger Carrying Vehicle Insurance
    • Heavy Vehicle Insurance
    • Goods Carrying Vehicle Insurance
    • Activa Insurance
    • Jupiter Insurance
    • Bullet Insurance
    • Student Travel Insurance
    • Schengen Visa Travel Insurance
    Health Insurance Guides
    • Individual Health Insurance
    • Family Health Insurance
    • Health Insurance for Parents
    • Health Insurance Premium Calculator
    • Compare Health Insurance
    • Health Insurance for Senior Citizens
    • Health Insurance with Maternity Cover
    • Corona Kavach Policy
    • Corona Rakshak Policy
    • हेल्थ इन्शुरन्स
    • फैमिली हेल्थ इन्शुरन्स
    Car Insurance Guides
    • Third Party Car Insurance
    • Comprehensive Car Insurance
    • Zero Depreciation Car Insurance
    • NCB in Car Insurance
    • IDV Calculator for Car
    • Bumper to Bumper Car Insurance
    • Car Insurance Calculator
    • Own Damage Car Insurance
    • Comprehensive vs Third Party Insurance
    • Compare Car Insurance
    • Find Vehicle Registration Details Online
    Bike Insurance Guides
    • Third Party Bike Insurance
    • Comprehensive Bike Insurance
    • Zero Depreciation Bike Insurance
    • NCB in Two Wheeler Insurance
    • IDV Value Calculator for Bike
    • Add-on Cover in Bike Insurance
    • Bike Insurance Calculator
    • Own Damage Bike Insurance
    • Comprehensive vs Third Party Bike Insurance
    • Compare Bike Insurance
    • Royal Enfield Insurance
    • TVS Insurance
    • Hero Bike Insurance
    Other Guides
    • Types of Insurance
    • Types of General Insurance
    • Types of Motor Insurance
    • International Driving License
    • Visa on Arrival for Indians
    • Visa Free Countries for Indians
    • Comprehensive vs Zero Depreciation
    • Coronavirus Health Insurance
    • Coronavirus Symptoms Checker
    • Indian Passport Rank
    • Digit Illness Group Insurance
    • Hero Splendor Insurance
    • Access Insurance
    • Scooty Insurance
    Calculators
    • SME Buddy Calculator
    • Home Loan EMI Calculator
    • Bike Loan EMI Calculator
    • Car Loan EMI Calculator
    • HRA Exemption Calculator
    • Sukanya Samriddhi Yojana Calculator
    • SIP Calculator
    • RD Calculator
    • SWP Calculator
    • GST Calculator
    • PPF Calculator
    • Personal Loan EMI Calculator
    • EMI Calculator
    • Individual Income Tax Slab
    • Tax Saving Options other than 80C
    Finance Guides
    • What is Credit Score
    • Public Provident Fund
    • How to Open PPF Account?
    • How to open Sukanya Samriddhi Account
    • What is GST?
    • GST Registration in India
    • PAN Card
    • Aadhaar Card
    • Property Tax
    • Road Tax
    • Passport Process
    • Income Tax Slabs
    • How to Save Income Tax in India
    • Tax Deductions under Section 80C
    Traffic Rules
    • PUC Certificate
    • Vehicle Registration Certificate
    • New Traffic Fines
    • Fine for Driving without Helmet
    • Types of Driving Licence in India
    • Driving Licence in Delhi
    • Driving Licence in Bangalore
    • Driving Licence in Jaipur
    • Bangalore Traffic Fines
    • Pune RTO Fine
    • Own Damage Insurance
    Business Products
    • Business Insurance
    • Management Liability Insurance
    • General Liability Insurance
    • Workmen Compensation Insurance
    • Fidelity Insurance
    • Professional Liability Insurance
    • Money Insurance Policy
    • Sign Board Insurance
    • Plate Glass Insurance
    • Erection All Risk Insurance
    • Contractors' All Risks Insurance
    • Directors and Officers Liability Insurance
    • Marine Cargo Insurance
    • Contractors Plant and Machinery Insurance
    RTO Offices in India
    • RTO Office
    • RTO Pune
    • RTO Ahmedabad
    • RTO Bangalore
    • RTO Mumbai
    • RTO Delhi
    • RTO Lucknow
    • RTO Thane
    • RTO Chennai
    Important Links
    • Digit Insurance Reviews
    • Car Insurance Reviews
    • Bike Insurance Reviews
    • Commercial Vehicle Insurance Reviews
    • Travel Insurance Reviews
    • Health Insurance Reviews
    • Mobile Insurance Reviews
    • Become a Digit Partner
    • General Insurance Agent
    • Health Insurance Agent
    • Motor Insurance Agent
    Car Brands & Models
    • Maruti Insurance
    • Toyota Car Insurance
    • Tata Car Insurance
    • Hyundai Car Insurance
    • Kia Car Insurance
    • Mahindra Car Insurance
    • Tata Tiago Insurance
    • Tata Nexon Insurance
    • Hyundai i20 Insurance
    • Creta Insurance
    • Baleno Insurance
    Downloads Do Not Disturb (DND) Public Disclosures Investor Relations Stewardship Policy IRDAI Privacy Policy

    CIN: U66010PN2016PLC167410, IRDAI Reg. No. 158.

    Go Digit General Insurance Limited (formerly known as Oben General Insurance Ltd.) - Registered Office Address - 1 to 6 floors, Ananta One (AR One), Pride Hotel Lane, Narveer Tanaji Wadi, City Survey No.1579, Shivaji Nagar, Pune-411005, Maharashtra | Corporate Office Address - Atlantis, 95, 4th B Cross Road, Koramangala Industrial Layout, 5th Block, Bengaluru-560095, Karnataka | Trade logo of Go Digit General Insurance Ltd. displayed above belongs to Go Digit lnfoworks Services Private Limited and is provided and used by Go Digit General Insurance Ltd. under license.