BasuNivesh now available in it’s own domain www.basunivesh.com from 22nd June 2012.

Today I will show you, how to calculate returns from your investments and will also make you familiar with few financial terminologies which are used in calculating returns.

1) Absolute Return: This is mainly used when the investment period is less than one year. To calculate this, simple formula is:-

Absolute Return=[Dividends (Receivables)±(PE-PB)]/PE

Here PE-Price at the beginning of investments

PB-Price at the end of period.

2) CAGR-This is mainly used calculating your returns when holding period of your investment is more than one year and either you are investing lumpsum one time or investing same amount on same interval (either Mnthly, Qly, Hly or Yly). It is called Compounded Annual Growth Rate.  This is the same compound interest calculation which me and you did during our school day. It can also to be done using Excel. I will show you how to do this.

A)     Open Microsoft Excel

B)      Go to Formulas

C)      Click on “fx” or Insert Function

D)     Popp Up will appear, in that select category “Financial”

E)      From drop down Menu select the option “Rate”

F)      “NPER” means Total number of Payments. It should be of same frequency means, suppose your payment is monthly for around 15 Yrs then it should be 180 not 15. Suppose your investment is quarterly for 15 years then it should be 60 (15*4).

G)     “PMT” means what you are going to pay for each period of investments

H)     “PV” means present value I,e if you have any investments already, then you need to insert that value (current value) here.

I)        “FV” means Future Value of your investment which you can assume or you can calculate by inserting required rate

J)       “TYPE” means- is your payment will be at the beginning of the period or end? Suppose you are investing monthly and if your investment is on the beginning of the month then insert “1” and if it is at the end of the month then”0”

This is very important in calculating Because if you are investing in the beginning of each month interest calculation will start from the beginning only.

K)      “Guess” will give you the result from your investments.

With this function you can calculate any desired value by putting at least three values. Also remember that whatever going out of your pocket will be “-“ value and whatever you will receive will be “+”. Remember that, your all values like Payment, Period and Interest should be in same frequency. Means if your contribution is monthly then period and interest should be in monthly.

3) IRR- It is used to calculate your returns when your contributions are not same payments but with same intervals and also you may be receiving lumpsum in between. Suppose you are investing First month Rs.20,000 and next month Rs.25,000 and you are receiving Rs.2,00,000 in fourth month. For such type of transactions you can use IRR function but period must be same. It can be calculated again by selecting function and IRR. Remember to put outgoing as “-“ and receivable “+”. Here if the investment periods are beginning of the period then directly you can enter the amount. But your payment or receivable at the end of period then you need to enter into next year. Means if you are not investing at the beginning of the month then your first value should be “0” and 2nd value must be your first month contribution. Logic is, it will consider the period from the beginning, suppose your investment is not in the beginning then you need to put “0” and need to put your value to next month.

4) XIRR-This is used when your payments or withdrawals and periods are irregular. It is same as IRR but only difference is you need to key the dates of transactions. For Example-You are investing on 15th March 2011 Rs.30,000, on 24th April 2011 Rs.28,000, on 30th June 2011 Rs.45,000 and receiving Rs.1,30,000 on 25th Dec 2011.

I hope this will make you familiar with few of the Terminologies which are related to returns and also make you to calculate your returns

Advertisements