Financial Mathematics - "Itni Shiddat se maine tujhe pane ki koshish ki hai, ki har zarre ne mujhe tumse milane ki saazish ki hai".

Very rightly said that "Journey of thousand miles starts with a single step".Same way to achieve big goals in life the first step is to start with basic i.e.decide your goals/dreams or aspirations in life.

Just list down whatever you think without thinking ki "Yeh kaha se hoga". (Had we ever thought that people would be booking tickets to travel mars).

Many a times investor tells me it doesn't make sense to plan, as I don't have any surplus funds. I ask them forget what you have atleast make a list of goals you want to achieve and as soon as you make that list and refer it on regular basis, your goals themselves finds way for required investment.

You will automatically cut down on discretionary or unnecessary expenses. It will act as an alarm "That if you buy the things which you don't need today, may be tomorrow you will not be able to buy the things you need". It will motivate you to work more efficiently to grow in your career or business.For sure, the passion and better planning will make you reach your goals Like SRK says "Itni Shiddat se maine tujhe pane ki koshish ki hai, ki har zarre ne mujhe tumse milane ki saazish ki hai".

After first step of deciding goals, it requires you to put time left and amount required for it.

Today we will learn how to inflate present goals cost to future value, so that we don't end up receiving the value which do not meet the requirement as briefed in my earlier blog:http://www.rajtalati-abminvestment.blogspot.in/2014/01/calculating-rate-of-returns-before.html#links. 

In addition to that we will also learn how to calculate annual investment required to reach that value :

Let's take an example of Mr.Sapnelal who wish to plan for marriage of her daughter Ms.Dreamgirl 18 year hence. Present exps. according to kind of wedding he wish to plan for is Rs.800000.00. He expects inflation during this period will be around 7%.

First of all open an excel sheet and go on "insert" select "Function" and in "window search for function" type "FV".Following window will open :

Inputs:

Rate - It is the rate of return/inflation considered in our case it would be 7%

NPER is no. of period - In our case it is 18 years.

PMT Payment - It asks for Periodic payments you wish to make for the goal. As we want to learn how to calculate Periodic payment in next step we will keep this as blank.

PV - This is the present value of goal in our case it is Rs.800000.00.As it shows investment (Money going from our pocket) a  -ve sign to put in front of it.

Let's insert the data in above field. The result will reflect at the bottom (above the Blue highlighted line Help on this function") under Formula result as follows :

The amount required after 18 years would be Rs.2703945.82.

Now,let's see how to calculate annual amount required to be invested or periodic investment required to achieve goal of Ms. Dreamgirl's marriage.

Mr.Sapnelal risk profile is aggressive and as the period of investment is also longer he wishes to make this entire annual contribution to equity and he expects equity to give him atleast 15% return on his investment.

So. let's calculate the per annum amount required to be invested.

First of all open an excel sheet and go on "insert" select "Function" and in "window search for function" type "PMT".Following window will open :

As detailed above put the data in fileds as follows :

Rate - As Sapnelal wishes to invest the amount in equity and expects to get a return of 15%. Enter 15% against Rate.

NPER - Enter 18 as maturity is required after 18 years for Dreamgirl's marriage

PV - Enter the lumpsum amount if you wish to invest initially together with the annual amount. In our case its nil so will keep it blank.

FV - From the first calculation we got this amount which we want to achieve i.e. 2703945.82.

Type - If you wish to make contribution at start of the year then put 1 and in case of end put 0.In our case it at the beginning of the year so enter 1.

After inserting all the above details result i.e. annual requirement will reflect as follows :

So the required amount is Rs.31004.35 it is showing as negative because it is going out of our pocket or we need to make this investment.

The best part is just by changing the figures in rate you can see the value of annual investment required. If you wish to achieve your goal by investing in a bank FD and expects to get a return of 9%. Your annual investment required will become Rs.60063..04.

So plan your investment in better way irrespective of what your name means- So being Mr.Sapnelal, enjoy marriage of daughter Dreamgirl the way it was planned.