aafmindia logo
 011-45120800
 info@aafmindia.co.in

CWM

CTEP

AFA

CWM


DIFFERENCE BETWEEN CAGR, XIRR AND IRR

Returns have always been the central standard while going for any investments. These indicate how much the fund has lost or gained during the particular investment period. You may come across returns expressed in the variety of nomenclatures. Have you ever wondered what does each kind of return signify ? or why not use single kind of return in all types of investments. What is the need to quote CAGR in lumpsum investment while XIRR in SIP’s. It is the awareness of these subtle yet significant differences that are going to take your investments to new heights. The more you get to know the usefulness and application of these returns, the more good  you are going to feel with your investment reports.

Absolute Return

It helps you to calculate the simple returns on your initial investment. What you need is only the initial and the current or the ending Net Asset value (NAV) of the scheme. In calculating the point to point or absolute return, the holding time does not play a role. So if your initial NAV was, say, Rs. 20 and now after 3 years , it is Rs. 40, the point to point return comes to 100 percent.

Formula to calculate absolute return




This formula is used to calculate returns when the holding period is less than 12 months.

Understanding CAGR

CAGR stands for Compounded Annual Growth Rate

The concept of CAGR is relatively straightforward and requires only three primary inputs: an investment’s beginning value, ending value and the time period. CAGR is superior to average returns because it considers the assumption that the investment is compounded over time.

Advantages of CAGR

·         CAGR isthe best formula for evaluating how different investments have performed over time.

·         Investors can compare the CAGR in order to know how well one stock/mutual fund has performed against other stocks in a peer group or against- market index.

·         The CAGR can also be used to compare the historical returns of stocks to bonds or a savings account.

Disadvantages of CAGR

·         It ignores volatility by assuming steady growth rate over the entire investment tenure, only taking into account an initial and a final value

·         CAGR is also subject to manipulation as the variable for the time period is input by the reason calculating it and is not a part of calculation itself.

·         It shows past performance of the fund  as in you should not expect your investments to grow as per CAGR in future.

·         It does not consider the interim values and relies only on the ending value and the beginning value which may again give a wrong picture if you ignore yearly returns.

CAGR is a way to smoothen out the returns, it determines an annual growth rate on an investment whose value has fluctuated from one period to the next. In that sense, CAGR isn’t the actual return in reality. This is similar to saying that you went on a trip and averaged 60km/hr. The Whole time you did not actually travel 60km/hr. Sometimes you were traveling slower, other times faster.

Let us understand with an example

Suppose a person invested Rs. 15000 in a mutual fund on 1 Jan 12 and redeem it on 1 Jan 18. The value of the investment at the time of redemption was 25000. So here CAGR (Compounded annual growth return turns out to be)

Formula to calculate CAGR


So,

                                             



Here we have assumed that investment is done only at the beginning and also redeemed only once. In between these six years, no investmentis made at nothing is redeemed. So CAGR easily turns out to be 8.88%

But there are sometimes when investment is not made at lumpsum but made periodically. So at that time CAGR turns out to be an irrelevant method to calculate return.

Let us understand with an example

Suppose you started mutual fund investment on Jan 1 2012, with details as follows       

Date

 

(A)

SIP 
Amount

(B)

 

NAV

(C)

Units bought

(D)  (B/C)

NAV on redemption

(E)

Holding period (in years)

(F)

Value on redemption

(G)  (D*E)

01/01/12

15000

44.54

336.72

50.078

6

16862.41

30/01/13

15000

40.44

370.87

50.078

4.92

18572.63

12/05/14

15000

37.19

403.30

50.078

3.63

20196.54

22/07/15

15000

41.02

365.64

50.078

2.47

18310.50

01/11/16

15000

42.98

348.98

50.078

1.16

17476.39

10/10/17

15000

44.89

334.13

50.078

0.22

16732.45

Let us first calculate CAGR we got on our individual investment amount.

So, 

                                               


And so on for the other SIP’S

Date

 

(A)

SIP Amount

(B)

NAV

 

(C)

Units bought

(D)  (B/C)

NAV on redemption

(E)

Holding period (in years)

(F)

Value on redemption

(G)  (D*E)

CAGR on individual

Investment

01/01/12

15000

44.54

336.72

50.078

6

16862.41

1.97%

30/01/13

15000

40.44

370.87

50.078

4.92

18572.63

4.44%

12/05/14

15000

37.19

403.30

50.078

3.63

20196.54

8.54%

22/07/15

15000

41.02

365.64

50.078

2.47

18310.50

8.40%

01/11/16

15000

42.98

348.98

50.078

1.16

17476.39

14.07%

10/10/17

15000

44.89

334.13

50.078

0.22

16732.45

64.34%

 

 

 

 

 

 

108150.93

 

In this way, we can calculate CAGR for each of our investment.

But some people might be interested inthe total CAGR got on the total investment made instead of CAGR on the individual investment.

Incorrect Approach

Correct Approach

Total investment made = 90,000

Redemption value = 108150.93

Time period = 6

Return :

{108150.93/90000)^(1/6)}-1  = 3.10%

Calculation of IRR (Internal rate of return) in case of consistent cash flows

 

Calculation of XIRR (Extended Internal rate of return) in case of inconsistent cash flows

Here, taking the same example we can see Investment is made at irregular intervals. So the correct approach to calculate return in this type of situation is XIRR .

Let us try to learn the concept of XIRR in detail.

What is the meaning of XIRR

XIRR stands for Extended internal rate of return

XIRR is a method used to calculate returns on investments where there are multiple transactions happening at different times. It is a good function to calculate returns when your cash flows(investments or redemption)are spread over a period of time. In the case of Mutual funds,if you are investing through SIP or lumpsum or redeeming through SWP or lumpsum , XIRR can take care of all those scenarios and helps you calculate a consolidated return considering timings of your investment and withdrawals.

You can think of XIRR as nothing but an aggregation of multiple CAGR’s. If you make multiple investments in a fund, you can use the XIRR formula to calculate your overall CAGR for all those investments taken together.

XIRR Function Errors

If you get an error from the Excel XIRR function this is likely to be one of the following

Common Errors

#NUM!

Occurs if Either :

 

·         The supplied values and dates arrays have different lengths

 

·         The supplied values array does not contain atleast one negative and at least one positive value

 

·         Any of the supplied dates precedes the first supplied date

 

·         The calculation fails to converge after 100 iterations

#VALUE!

Occurs if any of the supplied dates can’t be recognized as valid excel dates

What is IRR Approach

The IRR approach is a guideline for evaluating whether to proceed with a project or investment. The IRR rule states that if the internal rate of return (IRR) on a project or an investment is greater than the minimum  required rate of return, typically the cost of capital, then the project or investment should be pursued. Conversely, if the IRR on a project or investment is lower than the cost of capital, then the best course of action may be to reject it.

Can CAGR and IRR be Same

CAGR V/S IRR: IRR and CAGR will be same when

1.   You make a lumpsum investment (single investment)and calculate returns for the same.

2.   You make multiple investments but the annual return is constant across years. These investments can be periodic like a SIP or recurring fixed deposit. By the way, returns in a MF SIP are unlikely to be constant.

CAGR V/S IRR: IRR and CAGR will be different when

You make multiple investments and the annual returns are variable. This will be the case with any volatile investment such as equities.

You should not use CAGR when you want to estimate returns for your mutual fund investments.

The Bottom Line

The CAGR Helps frame an investment’s return over a certain period of time. It has its benefits, but there are definite limitations that investors need to be aware of. With multiple cash flows, the IRR or XIRR approach is usually considered to be better than CAGR. Investors should understand how investment returns are calculated and which return to consider for making investment decisions. Awareness and knowledge about calculating the returns from investment is important to be a smart investor.

Short Summary for the Difference between CAGR and XIRR

Particulars

CAGR

XIRR

Description

It is a measure of the compound rate of growth

It is the average rate earned by each and every cash flow invested during the period

Multiple cash flows

It does not consider the multiple cash flows

Yes, it is considered

Absolute / Annualized measure

Absolute return

Only annualized

Timing of cash flow

As cash flow are there, only time matters is the time between the amount invested and amount redeemed. Longer the period of holding the investment, better the CAGR.

It is very important. Timing affects the returns. It gets influenced by the early cash flows. Returns could be amplified or muted based on the timing of cash flows.

Measurement

Measures the performance of the lumpsum amount invested

Measures of the performance of the cash flow

 

....

Social Network


Contact Us


Member Login

Recent Blogs

Check your AAFM Certification Authenticity and Validity

CHECK VALIDITY

Email Updates


If you enjoyed this article,subscribe below to get FREE email updates

Phone is Optional

Your data remains confidentials with us.

Comments..

nando hubber
17-Jun-2020

we sale gold bars.. larydanielo2@gmail.com Commodity : Gold Bars Purity : 97 % pure, 22 + carats Origin : Cameroon 32000$/kg

Simon Federman
12-Jun-2020

Dear Sir, I am a direct Mandate to a genuinely renowned Investment Finance Company offering Cash & Asset Backed Financial Instruments on Lease and Sale at the best rates and with the most feasible procedures. Instruments offered can be put in all forms of trade and can be monetized or discounted for direct funding. For Inquiry contact. Email: longmornprojectfinances@gmail.com Skype: longmornprojectfinance@hotmail.com Whatsapp : +1(661)262-9225 Warm Regards Simon Federman.

John Corridor
02-Jun-2020

Finding a genuine provider of financial instrument is very challenging but we are certified Financial Instrument providers in United Kingdom. Presently, we only focus on BG/SBLC,DTC IPIP, MT103/202 GPI CASH TRANSFER AND MTN. However, our Lease BG/SBLC is 6+2% and Sale at 40+2%. Should you find this interesting and acceptable? Kindly, contact us and we shall review and respond with draft Contract/MOU within 48hrs maximum.(WE MOVE FIRST) Please request for full procedure details if interested. For further inquiry contact: John Corridor Skype: Email:johncorridor1971@gmail.com

nando hubber
17-Jun-2020

Hello I'm Hubber from Cameroon. Please I'm looking for a serious gold buyer who can partner We need a good buyer who can come and buy from us , we have stock in cameroon. Our aim is to create a good and swift business chain that can facilitate fast larydanielo2@gmail.com we have available gold bars and Rough Diamonds for sale, we are ready and willing for a long term contract supply to buyers destination. we sale gold bars.. larydanielo2@gmail.com Commodity : Gold Bars Purity : 97 % pure, 22 + carats Origin : Cameroon 32000$/kg

smith
29-Jan-2020

We specialized in Bank Guarantee {BG}, Standby Letter of Credit {SBLC}, Medium Term Notes {MTN}, Confirm-able Bank Draft {CBD} as well as other financial instruments issued from AAA Rated bank such as HSBC Bank Hong Kong, HSBC Bank London, Deutsche Bank AG Frankfurt, Barclays Bank , Standard Chartered Bank and others on lease at the lowest available rates depending on the face value of the instrument needed.We deliver with time and precision as sethforth in the agreement. Our terms and Conditions are reasonable, below is our instrument description.  The procedure is very simple; the instrument will be reserved on euro clear to be verified by your bank, after verification an arrangement will be made for necessary bank documents and stock testing expenses, the cost of the Bank Guarantee will be paid after the delivery of the MT760.DESCRIPTION OF INSTRUMENT:Instrument: Bank Guarantee (BG/SBLC).  Total Face Value: Minimum of 1M Eur/USD (One Million Eur/USD) to Maximum of 5B Euro/USD(Five Billion Eur/USD).  Issuing Bank: HSBC London, Barclays Bank, Deutsche Bank Frankfurt, Hong Kong, Any AA rated Bank in Europe or any Top 25 WEB.  Age: One Year, One Day  Leasing Price: 4% of Face Value plus 1% commission fees to brokers.  Delivery: Bank to Bank SWIFT.  Payment: MT-760.  Hard Copy: Bonded Courier within 7 banking days.All relevant business information will be provided upon request plus our terms and  procedures.Thank you.Email: globalfinancheritageplc@gmail.com Phone: +447398524236.Best Regards  Management.  smith Larry.

Dimitrij Conradi
20-May-2020

We are Providers of all types of BG and SBLC with the best workable procedures. Our BG/SBLC ranges from MT799, MT760,(Both two way confirmation), MT103/23, MT103 (Both can be one way confirmation and two way confirmation) in USD and EUROS. Issuing Bank ranges from Top world 25 banks with face value ranging from 1M EUROS/USD to 10B EUROS/USD BROKERS ARE WELCOME & 100% PROTECTED!!! Intermediaries/Consultants/Brokers are welcome to bring their clients and cases to our attention and in complete confidence we will work together for the benefits of all parties involve. Our BG/SBLC Financing can help you get your project funded, loan financing, please let me know if you are interested in any of our services, by providing you with yearly renewable leased bank instruments. We work directly with issuing bank lease providers, this Instrument can be monetized on your behalf for 100% funding. We are ready to close leasing with any interested client in few banking days, if interested do not hesitate to contact me direct. [via Contact Form Below] Regards Dimitrij Conradi Email: dimi.conradi1970@gmail.com conradi.dimitrij@bk.ru Skype: conradi.dimitrij@bk.ru WhatsApp: +90 552 674 4696

Dimitrij Conradi
20-May-2020

We are Providers of all types of BG and SBLC with the best workable procedures. Our BG/SBLC ranges from MT799, MT760,(Both two way confirmation), MT103/23, MT103 (Both can be one way confirmation and two way confirmation) in USD and EUROS. Issuing Bank ranges from Top world 25 banks with face value ranging from 1M EUROS/USD to 10B EUROS/USD BROKERS ARE WELCOME & 100% PROTECTED!!! Intermediaries/Consultants/Brokers are welcome to bring their clients and cases to our attention and in complete confidence we will work together for the benefits of all parties involve. Our BG/SBLC Financing can help you get your project funded, loan financing, please let me know if you are interested in any of our services, by providing you with yearly renewable leased bank instruments. We work directly with issuing bank lease providers, this Instrument can be monetized on your behalf for 100% funding. We are ready to close leasing with any interested client in few banking days, if interested do not hesitate to contact me direct. [via Contact Form Below] Regards Dimitrij Conradi Email: dimi.conradi1970@gmail.com conradi.dimitrij@bk.ru Skype: conradi.dimitrij@bk.ru WhatsApp: +90 552 674 4696

WE OFFER LEASE BG,SBLC AND MTN
31-May-2020

We are direct providers of Fresh Cut BG, SBLC, DTC IPIP, MT103/202 GPI CASH TRANSFER and MTN which are specifically for lease, our bank instrument can be engage in PPP Trading, Discounting, signature project (s) such as Aviation, Agriculture, Petroleum, Telecommunication, construction of Dams, Bridges, Real Estate and all kind of projects. We do not have any broker chain in our offer or get involved in chauffer driven offers. We deliver with time and precision as sethforth in the agreement. Our terms and Conditions are reasonable, below is our instrument description. The procedure is very simple; the instrument will be reserved on euro clear to be verified by your bank, after verification an arrangement will be made for necessary bank documents and stock testing expenses, the cost of the Bank Guarantee will be paid after the delivery of the MT760, DESCRIPTION OF INSTRUMENTS: 1. Instrument: Bank Guarantee (BG/SBLC) (Appendix A) 2. Total Face Value: Eur 5M MIN and Eur 10B MAX (Ten Billion USD). 3. Issuing Bank: HSBC Bank London, Credit Suisse and Deutsche Bank Frankfurt. 4. Age: One Year, One Month 5. Leasing Price: 6% of Face Value plus 2% commission fees to brokers. 6. Delivery: Bank to Bank swift. 7. Payment: MT-103 or MT760 8. Hard Copy: Bonded Courier within 7 banking days. We are ready to close leasing with any interested client in few banking days, if interested do not hesitate to contact me direct. Email: wrightjames931@gmail.com Regards, Wright Skype:wrightjames931@gmail.com Email:wrightjames931@gmail.com We Offer Lease and Purchase BG,SBLC,DTC IPIP, MT103/202 GPI CASH TRANSFER AND MTN

W & J O'Shea Roofing
04-Jun-2020

Dear Sir/Ma, We are genuine certified Financial Instrument providers. Presently, we only focus on BG/SBLC for Lease and purchase purposes. Our Lease BG/SBLC is 4+2% and purchase at 32+2%. * FOR LEASING OF BG/SBLC MINIMUM FACE VALUE OF BG/SBLC = EUR/USD 1M LEASING FEE = 4%+2% * FOR PURCHASE OF FRESH CUT BG/SBLC PRICE = 32%+2% MINIMUM FACE VALUE OF BG/SBLC = EUR/USD 1M Kindly contact us for our procedures and be sure that we shall respond within 48hrs maximum. Intermediaries/Consultants/Brokers are welcome to bring their clients and are 100% protected. In complete confidence, we will work together for the benefits of all parties involved. W & J O'Shea Roofing E-mail :wjoshearoofing@gmail.com Skype id : wjoshearoofing@gmail.com Whatsapp number: +19315765413

Simon Federman
12-Jun-2020

Dear Sir, I am a direct Mandate to a genuinely renowned Investment Finance Company offering Cash & Asset Backed Financial Instruments on Lease and Sale at the best rates and with the most feasible procedures. Instruments offered can be put in all forms of trade and can be monetized or discounted for direct funding. For Inquiry contact. Email: longmornprojectfinances@gmail.com Skype: longmornprojectfinance@hotmail.com Whatsapp : +1(661)262-9225 Warm Regards Simon Federman.

John Tim
17-Jun-2020

We have a direct genuine provider for BG/SBLC specifically for lease, at leasing price of 4+2 of face value, Issuance by HSBC London/Hong Kong or any other AA rated Bank in Europe, Middle East or USA. Contact : Mr. DARREN C CHENG Email: Darrencraig002@gmail.com skype : keatcheng2@gmail.com Intermediaries/Consultants/Brokers are welcome to bring their clients and are 100% protected. In complete confidence, we will work together for the benefits of all parties involved. All inquires to Mr. Darren should include the following minimum information so I can quickly address your needs: Complete contact information: What exactly do you need? How long do you need it for? Are you a principal borrower or a broker? Contact me for more details. Whatsapp: +19733700521

Kevin
26-Jun-2020

Dear Sir/Ma We are broker firm in London-UK, we have direct Provider of BG/SBLC specifically for Lease and purchase, The provider is tested and trusted. We have been dealing with the company for paste 20 years. Interested Agent/Lessee should contact us. Email: globalcapitalasset@gmail.com Skype: Kevinreyes1972@outlook.com WHATAPP NUMBER :+1 650 741 1097 Regards, Kevin Reyes

Kevin
26-Jun-2020

Dear Sir/Ma We are broker firm in London-UK, we have direct Provider of BG/SBLC specifically for Lease and purchase, The provider is tested and trusted. We have been dealing with the company for paste 20 years. Interested Agent/Lessee should contact us. Email: globalcapitalasset@gmail.com Skype: Kevinreyes1972@outlook.com WHATAPP NUMBER :+1 650 741 1097 Regards, Kevin Reyes

Kevin
26-Jun-2020

Dear Sir/Ma We are broker firm in London-UK, we have direct Provider of BG/SBLC specifically for Lease and purchase, The provider is tested and trusted. We have been dealing with the company for paste 20 years. Interested Agent/Lessee should contact us. Email: globalcapitalasset@gmail.com Skype: Kevinreyes1972@outlook.com WHATAPP NUMBER :+1 650 741 1097 Regards, Kevin Reyes

UNITED STATES OF AMERICA
25-Jun-2020

AFFORDABLE/COMFORTABLE LOAN OFFER WITHOUT COST/STRESS CONTACT US VIA Call/Text +1(415)630-7138 Email drbenjaminfinance@gmail.com Do you find yourself in a bit of trouble with unpaid bills and don’t know which way to go or where to turn? What about finding a reputable Debt Consolidation firm that can assist you in reducing monthly installment so that you will have affordable repayment options as well as room to breathe when it comes to the end of the month and bills need to get paid? BENJAMIN LOAN INVESTMENTS FINANCE is the solution to your financial misfortune. We offer all types of loan ranging from $5,000.00 to $533,000,000.00USD with a low interest rate of 2% and loan duration of 1 to 35 years to pay back the loan secure and unsecured. Our loans are well insured for maximum security is our priority, Our leading goal is to help you get the services you deserve, Our program is the quickest way to get what you need in a snap. Kindly reduce your payments to ease the strain on your monthly expenses by Contacting us on the following Call/Text +1(415)630-7138 Email drbenjaminfinance@gmail.com

leave a comment