Systematic Investment Planning – SIP – Calculators

We started off with a design of simple calculator for knowing a monthly SIP amount that we may have to save in terms of our financial planning to achieve any financial goal. Then I thought of designing online interactive multipurpose SIP calculator for different life goals from financial planning perspective   After trial and error Zoho sheet was found apt for the job which you may view here .

Three goals viz

  1. child’s education expenses in future
    • You need to input the current age, year (age) when higher education begins and estimate of expenses at current levels.
  2. child’s marriage expenses in future
    • You need to input the current age, year (age) when marriage is expected and estimate of expenses at current levels

    and

  3. retirement corpus needed at the time of retirement can be estimated using the same calculator. 
    • You need to input the current age, year (age) when you expect to retire and an estimate of current monthly expenditure for maintaining the life-style preferred.

For all the goals you may have to indicate inflation rate (say 3% to 10%) and investment rate of  interest (say 3% to 20%)

It is sane to expect 8-9% from short term funds, 12% returns from long term debt funds and 14-18% in equity oriented mutual funds.

 

Once these goals are estimated then it is easy to calculate the monthly saving required in the form of SIP investment amount.  A sheet has been added to the cash flows involved in the calculation. 

View the calculator

Excel version of the multi-goals SIP calculator for mutual funds investments is shared here for downloading in your desktop.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s