{"id":12626,"date":"2022-06-21T15:17:27","date_gmt":"2022-06-21T09:47:27","guid":{"rendered":"https:\/\/kuvera.in\/blog\/?p=12626"},"modified":"2023-03-28T16:39:09","modified_gmt":"2023-03-28T11:09:09","slug":"what-is-xirr-in-mutual-funds","status":"publish","type":"post","link":"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/","title":{"rendered":"A detailed guide on what is XIRR in mutual funds?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_40 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" area-label=\"ez-toc-toggle-icon-1\"><label for=\"item-69e6ed1b5b49d\" aria-label=\"Table of Content\"><span style=\"display: flex;align-items: center;width: 35px;height: 30px;justify-content: center;direction:ltr;\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/label><input  type=\"checkbox\" id=\"item-69e6ed1b5b49d\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#What_is_XIRR\" title=\"What is XIRR?\">What is XIRR?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#Why_do_we_use_XIRR_in_mutual_funds_investments\" title=\"Why do we use XIRR in mutual funds investments?\">Why do we use XIRR in mutual funds investments?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#Importance_of_XIRR_in_Mutual_Funds\" title=\"Importance of XIRR in Mutual Funds\">Importance of XIRR in Mutual Funds<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#How_to_calculate_XIRR_in_excel\" title=\"How to calculate XIRR in excel?\">How to calculate XIRR in excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#You_must_follow_these_steps_after_opening_Microsoft_Excel_on_their_devices\" title=\"You must follow these steps after opening Microsoft Excel on their devices:\">You must follow these steps after opening Microsoft Excel on their devices:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#Heres_an_example_of_XIRR_calculation_using_Excel\" title=\"Here&#8217;s an example of XIRR calculation using Excel:\u00a0\">Here&#8217;s an example of XIRR calculation using Excel:\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#Final_Word\" title=\"Final Word\">Final Word<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#Frequently_Asked_Questions\" title=\"Frequently Asked Questions\">Frequently Asked Questions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#What_is_considered_a_good_XIRR\" title=\"What is considered a good XIRR?\">What is considered a good XIRR?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#What_is_the_return_calculation_of_XIRR\" title=\"What is the return calculation of XIRR?\">What is the return calculation of XIRR?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#What_is_CAGR\" title=\"What is CAGR?\">What is CAGR?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#Interested_in_how_we_think_about_the_markets\" title=\"Interested in how we think about the markets?\">Interested in how we think about the markets?<\/a><\/li><\/ul><\/nav><\/div>\n<p><span style=\"font-weight: 400;\">One invests in a mutual fund scheme over a period to achieve their financial or investment objectives. They earn returns from their <a href=\"https:\/\/app.kuvera.in\/explore\/mf\/c\/all\">mutual fund investments<\/a> in the form of capital appreciation. So how does one know what would be their return after a certain duration? It can be found using two methods \u2013 CAGR (compounded annual growth rate) and XIRR.\u00a0 <\/span><span style=\"font-weight: 400;\">XIRR is used in a scheme if there are multiple inflows and outflows<\/span><i><span style=\"font-weight: 400;\">.<\/span><\/i><\/p>\n<p>&nbsp;<\/p>\n<p>In this article, you will learn what XIRR is and how you can calculate mutual fund returns using it!<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/kuvera.in\/fixed-deposit\/all\"><img loading=\"lazy\" class=\"aligncenter wp-image-22082\" src=\"https:\/\/kuvera.in\/blog\/wp-content\/uploads\/2023\/03\/FD-Banner-01-03-300x76.jpg\" alt=\"\" width=\"600\" height=\"151\" srcset=\"https:\/\/kuvera.in\/blog\/wp-content\/uploads\/2023\/03\/FD-Banner-01-03-300x76.jpg 300w, https:\/\/kuvera.in\/blog\/wp-content\/uploads\/2023\/03\/FD-Banner-01-03-150x38.jpg 150w, https:\/\/kuvera.in\/blog\/wp-content\/uploads\/2023\/03\/FD-Banner-01-03.jpg 600w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h4><span class=\"ez-toc-section\" id=\"What_is_XIRR\"><\/span>What is XIRR?<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>&nbsp;<\/p>\n<p>XIRR is a rate of return that you can apply at multiple installments of investment or frequent withdrawals to find out the current NAV of your holdings. The full form of XIRR is &#8211; Extended internal rate of return.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">The extended rate of internal returns is referred to as a single rate of return. Whenever there are multiple investments, withdrawals, or transactions from a mutual fund scheme, it becomes challenging to find the actual value of the investment using CAGR. This is where XIRR comes into the picture and provides the actual return that one may get on their investments.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">XIRR is useful in the case of investments via SIP when there is a regular inflow of some amount in a mutual fund scheme.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Why_do_we_use_XIRR_in_mutual_funds_investments\"><\/span>Why do we use XIRR in mutual funds investments?<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">XIRR is most useful when there are inflows or outflows from a mutual fund scheme at irregular time intervals. If investments and redemptions do not exist over the entire tenure, then one can use the <a href=\"https:\/\/kuvera.in\/blog\/cagr-meaning-formula-and-advantages\/\">CAGR technique<\/a> to find actual returns. However, mutual fund investments do not work like that, especially investments made through SIP.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Suppose you invest in a mutual fund scheme using the SIP method, and you invest an amount of Rs. 5,000 over seven years. At the end of 7 years, you decide to redeem your investments, whose total value is Rs. 7,00,000. Now, in this investment, there would have been cash inflow (investment) or cash outflow (redemption) at different periods. The timing plays an essential part in determining the investment return. To know the return value, you must use XIRR, which takes care of multiple cash flows.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">XIRR becomes important as returns are received on the Rs. 5,000 invested in the first month will be higher than subsequent payments. It becomes difficult for people involved in analyzing these funds&#8217; performance to find the returns using compounded annual growth rate formula. Hence, all monthly CAGRs are cumulatively taken together and adjusted to a particular rate. This adjusted rate of CAGR is XIRR. It gives a consolidated return figure after taking into account multiple transactions.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Importance_of_XIRR_in_Mutual_Funds\"><\/span><b>Importance of XIRR in Mutual Funds<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>&nbsp;<\/p>\n<p>XIRR is an important component of mutual funds structure allowing fund managers to have a detailed analysis of the fund&#8217;s performance. Individuals can use XIRR formula in an Excel sheet to determine the actual return on investment. This formula is a more accurate measure than IRR as it considers cash flows at irregular intervals. IRR or internal return rate considers that all transactions (inflow and outflow) occur at regular time intervals, which is not the case in reality. Hence, XIRR is an upgrade over IRR.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">One needs to put the particular transactions, like SIP instalments and redemptions, along with the corresponding dates to the formula in Excel sheet to find out the returns earned.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h4><span class=\"ez-toc-section\" id=\"How_to_calculate_XIRR_in_excel\"><\/span><b>How to calculate XIRR in excel?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>&nbsp;<\/p>\n<p>You can easily calculate the extended internal rate of return using Microsoft Excel. The formula for XIRR calculation in Excel is = XIRR (value, date, guess), where value is the transaction amount, i.e., investment or redemption. Date is the corresponding date on which the transaction takes place.<\/p>\n<p>&nbsp;<\/p>\n<h4><span class=\"ez-toc-section\" id=\"You_must_follow_these_steps_after_opening_Microsoft_Excel_on_their_devices\"><\/span>You must follow these steps after opening Microsoft Excel on their devices:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>&nbsp;<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">First, you need to enter all transactions that took place in a single column.\u00a0<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">All cash outflows like regular payments for investment must be marked negative, and cash inflows like redemption amounts must be positive.\u00a0<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">You must type transaction dates in the next column. These dates must correspond to transactions occurring.\u00a0<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u00a0In the last row, you must fill in the present value of the investment and the corresponding date of this value.<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">After this, you must use the XIRR formula to calculate the actual return rate.\u00a0<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The next step involves selecting values for the cash series corresponding to payment dates. The date column includes the date on which the first investment was made and when cash flows were received. The IRR rate \u2018guess\u2019 in the formula is not mandatory. If you do not fill any value, Excel takes 0.1 as the default value.\u00a0<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Heres_an_example_of_XIRR_calculation_using_Excel\"><\/span><strong>Here&#8217;s an example of XIRR calculation using Excel:\u00a0<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">SIP amount is Rs. 2,000. The period of investment is six months (01.01.2020 to 01.06.2020). The maturity date is 01.07.2020.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong>The cash flows are as follows:\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<table style=\"width: 732px; height: 242px;\" border=\"1.5\">\n<tbody>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">01.01.2020<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">-2,000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">01.02.2020<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">-2,000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">01.03.2020<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">-2,000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">01.04.2020<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">-2,000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">01.05.2020<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">-2,000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">01.06.2020<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">-2,000<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">01.07.2020<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">12,500<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">XIRR<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">14.91<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">In this example, we have taken dates in one column and SIP payments (in negative) in the next column. In the second last row, we have filled the maturity dates and amount, respectively. We used XIRR formula in the last column, inserted a series of cells exhibiting the cash flow values, and filled in the payment date series regarding transaction values.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<blockquote class=\"blockquote\"><p><b>After using the formula =XIRR (values, dates, guess)<\/b><b>, <\/b><b>we got the XIRR as 14.91%.\u00a0\u00a0<\/b><\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Final_Word\"><\/span><b>Final Word<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>&nbsp;<\/p>\n<p>XIRR is an efficient technique that allows one to calculate the actual return rate in a mutual fund scheme with multiple cash flows. It is more reliable and accurate than CAGR as it considers transactions spread over a period. This detailed guide on XIRR, its importance, and how to calculate it will help investors gain insightful knowledge about it.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><b>Pro tip:<\/b><span style=\"font-weight: 400;\"> Start investing through a platform that brings goal planning and investing to your fingertips. Visit<\/span> <a href=\"http:\/\/kuvera.in\/\"><span style=\"font-weight: 400;\">kuvera.in<\/span><\/a><span style=\"font-weight: 400;\"> t<\/span><span style=\"font-weight: 400;\">o discover Direct Plans and Fixed Deposits and start investing today.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span><b>Frequently Asked Questions<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>&nbsp;<\/p>\n<ul>\n<li aria-level=\"1\">\n<h4><span class=\"ez-toc-section\" id=\"What_is_considered_a_good_XIRR\"><\/span>What is considered a good XIRR?<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">A good XIRR is a subjective figure and differs from individual to individual. However, experts have pointed out that an XIRR of 11-12% is considered good in the case of equity funds and 7-8% in the case of debt mutual funds.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li aria-level=\"1\">\n<h4><span class=\"ez-toc-section\" id=\"What_is_the_return_calculation_of_XIRR\"><\/span>What is the return calculation of XIRR?<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">XIRR measures return in annualized form. It can be used for investments made in regular and irregular time intervals.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li aria-level=\"1\">\n<h4><span class=\"ez-toc-section\" id=\"What_is_CAGR\"><\/span>What is CAGR?<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">CAGR is the annual rate of return of an investment compounded over a period. It uses the compounding process to arrive at the final return value. CAGR helps find returns made through a lump sum investment and not so much through SIPs.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Interested_in_how_we_think_about_the_markets\"><\/span>Interested in how we think about the markets?<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>&nbsp;<\/p>\n<p>Read more: <a href=\"https:\/\/kuvera.in\/blog\/category\/zen-and-the-art-of-investing\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Zen And The Art Of Investing<\/strong><\/a><\/p>\n<p><strong>Watch here:<\/strong> Investing in focussed mutual funds<\/p>\n<div class=\"embed-container\">\n<div class=\"embed-container\">\n<div class=\"embed-container\">\n<div class=\"embed-container\">\n<div class=\"embed-container\">\n<div class=\"embed-container\"><iframe src=\"https:\/\/www.youtube.com\/embed\/haVrdwgbJkc\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><\/iframe><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Start investing through a platform that brings goal planning and investing to your fingertips. Visit <a href=\"http:\/\/app.kuvera.in\"><strong>Kuvera.in<\/strong><\/a> to discover <a href=\"https:\/\/kuvera.in\/blog\/direct-plans-better\/\"><strong>Direct Plans<\/strong><\/a> and <strong><a href=\"https:\/\/app.kuvera.in\/explore\/fixed-deposit\/c\/all\">Fixed Deposits<\/a><\/strong> and <a href=\"https:\/\/kuvera.in\/user\/login\"><strong>start investing today.<\/strong><\/a><br \/>\n#MutualFundSahiHai #KuveraSabseSahiHai<\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n\n<table id=\"tablepress-2103\" class=\"tablepress tablepress-id-2103\">\n<thead>\n<tr class=\"row-1 odd\">\n\t<th class=\"column-1\"><\/th><th class=\"column-2\">Top Asset Management Companies<\/th><th class=\"column-3\"><\/th>\n<\/tr>\n<\/thead>\n<tbody class=\"row-hover\">\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/idfc\">IDFC Mutual Fund<\/a><\/td><td class=\"column-2\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/quant\">Quant Mutual Fund<\/a><\/td><td class=\"column-3\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/canara\">Canara Robeco Mutual Fund<\/a><\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/tata\">Tata Mutual Fund<\/a><\/td><td class=\"column-2\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/dsp\">DSP Mutual Fund<\/a><\/td><td class=\"column-3\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/uti\">UTI Mutual Fund<\/a><\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/whiteoak\">Whiteoak Mutual Fund<\/a><\/td><td class=\"column-2\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/motilal\">Motilal Oswal Mutual Fund<\/a><\/td><td class=\"column-3\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/mirae\">Mirae Asset Mutual Fund<\/a><\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/icici\">ICICI Prudential Mutual Fund<\/a><\/td><td class=\"column-2\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/hdfc\">HDFC Mutual Fund<\/a><\/td><td class=\"column-3\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/absl\">Aditya Birla Sunlife Mutual Fund<\/a><\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/barodabnpparibas\">Baroda BNP Paribas Mutual Fund<\/a><\/td><td class=\"column-2\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/invesco\">Invesco Mutual Funds<\/a><\/td><td class=\"column-3\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/jm\">JM Financial Mutual Funds<\/a><\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/tata\">Tata Mutual Funds<\/a><\/td><td class=\"column-2\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/nippon\">Nippon Mutual Funds<\/a><\/td><td class=\"column-3\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/franklin\">Franklin Templeton Mutual Funds<\/a><\/td>\n<\/tr>\n<tr class=\"row-8 even\">\n\t<td class=\"column-1\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/sundaram\">Sundaram Mutual Fund<\/a><\/td><td class=\"column-2\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/edelweiss\">Edelweiss Mutual Funds<\/a><\/td><td class=\"column-3\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/l_t\">L&amp;T Mutual Funds<\/a><\/td>\n<\/tr>\n<tr class=\"row-9 odd\">\n\t<td class=\"column-1\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/axis\">Axis Mutual Fund<\/a><\/td><td class=\"column-2\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/kotak\">Kotak Mutual Fund<\/a><\/td><td class=\"column-3\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/lic\">LIC Mutual Fund<\/a><\/td>\n<\/tr>\n<tr class=\"row-10 even\">\n\t<td class=\"column-1\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/dsp\">DSP Mutual Fund<\/a><\/td><td class=\"column-2\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/iifl\">IIFL Mutual Fund<\/a><\/td><td class=\"column-3\"><a href=\"https:\/\/kuvera.in\/explore\/funds\/parag\">Parag Parikh Mutual Funds<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<!-- #tablepress-2103 from cache -->\n","protected":false},"excerpt":{"rendered":"<p>One invests in a mutual fund scheme over a period to achieve their financial or investment objectives. They earn returns from their mutual fund investments in the form of capital appreciation. So how does one know what would be their return after a certain duration? It can be found using two methods \u2013 CAGR (compounded [&#8230;]<\/p>\n<p><a class=\"btn btn-secondary understrap-read-more-link\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":11,"featured_media":12627,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[99,822],"tags":[724,415,1006],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is XIRR in mutual funds?<\/title>\n<meta name=\"description\" content=\"XIRR In Mutual funds is to calculate the returns on investment where there are multiple transaction take place in different times.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is XIRR in mutual funds?\" \/>\n<meta property=\"og:description\" content=\"XIRR In Mutual funds is to calculate the returns on investment where there are multiple transaction take place in different times.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/\" \/>\n<meta property=\"og:site_name\" content=\"Kuvera\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/kuvera.in\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-21T09:47:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-28T11:09:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kuvera.in\/blog\/wp-content\/uploads\/2022\/06\/XIRR-in-Mutual-Funds.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2240\" \/>\n\t<meta property=\"og:image:height\" content=\"1260\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Kuvera\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Kuvera_In\" \/>\n<meta name=\"twitter:site\" content=\"@Kuvera_In\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kuvera\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is XIRR in mutual funds?","description":"XIRR In Mutual funds is to calculate the returns on investment where there are multiple transaction take place in different times.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/","og_locale":"en_US","og_type":"article","og_title":"What is XIRR in mutual funds?","og_description":"XIRR In Mutual funds is to calculate the returns on investment where there are multiple transaction take place in different times.","og_url":"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/","og_site_name":"Kuvera","article_publisher":"https:\/\/www.facebook.com\/kuvera.in","article_published_time":"2022-06-21T09:47:27+00:00","article_modified_time":"2023-03-28T11:09:09+00:00","og_image":[{"width":2240,"height":1260,"url":"https:\/\/kuvera.in\/blog\/wp-content\/uploads\/2022\/06\/XIRR-in-Mutual-Funds.png","type":"image\/png"}],"author":"Kuvera","twitter_card":"summary_large_image","twitter_creator":"@Kuvera_In","twitter_site":"@Kuvera_In","twitter_misc":{"Written by":"Kuvera","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#article","isPartOf":{"@id":"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/"},"author":{"name":"Kuvera","@id":"https:\/\/kuvera.in\/blog\/#\/schema\/person\/6b774e7d3516942b9e0242c93d7cb307"},"headline":"A detailed guide on what is XIRR in mutual funds?","datePublished":"2022-06-21T09:47:27+00:00","dateModified":"2023-03-28T11:09:09+00:00","mainEntityOfPage":{"@id":"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/"},"wordCount":1201,"commentCount":0,"publisher":{"@id":"https:\/\/kuvera.in\/blog\/#organization"},"keywords":["mutual funds investment","XIRR","xirr in mutual funds"],"articleSection":["Investing 101","Mutual Funds"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/","url":"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/","name":"What is XIRR in mutual funds?","isPartOf":{"@id":"https:\/\/kuvera.in\/blog\/#website"},"datePublished":"2022-06-21T09:47:27+00:00","dateModified":"2023-03-28T11:09:09+00:00","description":"XIRR In Mutual funds is to calculate the returns on investment where there are multiple transaction take place in different times.","breadcrumb":{"@id":"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kuvera.in\/blog\/what-is-xirr-in-mutual-funds\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kuvera.in\/blog\/"},{"@type":"ListItem","position":2,"name":"A detailed guide on what is XIRR in mutual funds?"}]},{"@type":"WebSite","@id":"https:\/\/kuvera.in\/blog\/#website","url":"https:\/\/kuvera.in\/blog\/","name":"Kuvera","description":"Wealth Management, Simplified","publisher":{"@id":"https:\/\/kuvera.in\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kuvera.in\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kuvera.in\/blog\/#organization","name":"Kuvera","url":"https:\/\/kuvera.in\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kuvera.in\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/kuvera.in\/blog\/wp-content\/uploads\/2022\/07\/cropped-cropped-kuvera-logo-dark-3.png","contentUrl":"https:\/\/kuvera.in\/blog\/wp-content\/uploads\/2022\/07\/cropped-cropped-kuvera-logo-dark-3.png","width":83,"height":13,"caption":"Kuvera"},"image":{"@id":"https:\/\/kuvera.in\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/kuvera.in","https:\/\/twitter.com\/Kuvera_In","https:\/\/www.instagram.com\/kuvera.in","https:\/\/www.linkedin.com\/company-beta\/10456535\/"]},{"@type":"Person","@id":"https:\/\/kuvera.in\/blog\/#\/schema\/person\/6b774e7d3516942b9e0242c93d7cb307","name":"Kuvera","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kuvera.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/kuvera.in\/blog\/wp-content\/uploads\/2019\/07\/social-media-logo-02-alt-v3-150x150.jpg","contentUrl":"https:\/\/kuvera.in\/blog\/wp-content\/uploads\/2019\/07\/social-media-logo-02-alt-v3-150x150.jpg","caption":"Kuvera"},"description":"Kuvera is India's first free Direct Mutual Fund investing platform. We bring you goal-based investing and innovative features like Tax Harvesting, TradeSmart, Family Account and more!","sameAs":["http:\/\/kuvera.in"],"url":"https:\/\/kuvera.in\/blog\/author\/kuvera-research\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kuvera.in\/blog\/wp-json\/wp\/v2\/posts\/12626"}],"collection":[{"href":"https:\/\/kuvera.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kuvera.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kuvera.in\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/kuvera.in\/blog\/wp-json\/wp\/v2\/comments?post=12626"}],"version-history":[{"count":9,"href":"https:\/\/kuvera.in\/blog\/wp-json\/wp\/v2\/posts\/12626\/revisions"}],"predecessor-version":[{"id":22583,"href":"https:\/\/kuvera.in\/blog\/wp-json\/wp\/v2\/posts\/12626\/revisions\/22583"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuvera.in\/blog\/wp-json\/wp\/v2\/media\/12627"}],"wp:attachment":[{"href":"https:\/\/kuvera.in\/blog\/wp-json\/wp\/v2\/media?parent=12626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuvera.in\/blog\/wp-json\/wp\/v2\/categories?post=12626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuvera.in\/blog\/wp-json\/wp\/v2\/tags?post=12626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}