vijaygawde

23-04-2009, 10:18 AM

How to calculate return on SIP of any MF? Any Idea?

View Full Version : Calculation of SIP

vijaygawde

23-04-2009, 10:18 AM

How to calculate return on SIP of any MF? Any Idea?

CONFUSED

25-04-2009, 10:03 AM

Vijay,

Very good question. :cool:

There is no simple formula for calculating Returns of SIP. You have to do long calculations with calculator or use a computer program written for this purpose.

SIP returns may be calculated as below -

(Assuming SIP is monthly and take 30 days per months)

Final Value of Investment = Monthly investment * ([(1+ R)**N - 1]/R) * [(1+ R)**M]

whrere -

N - No of monthly Installments paid

M - Remaining days after date of payment of last installment / 30

R - Monthly Rate of return

R can be found out only by trial and error either manulaly or by a program.

Single Star - Multiply

Double Star - Raise to the power of

e.g 4 ** 2 = 16 and 25 ** 1/2 = 5

Very good question. :cool:

There is no simple formula for calculating Returns of SIP. You have to do long calculations with calculator or use a computer program written for this purpose.

SIP returns may be calculated as below -

(Assuming SIP is monthly and take 30 days per months)

Final Value of Investment = Monthly investment * ([(1+ R)**N - 1]/R) * [(1+ R)**M]

whrere -

N - No of monthly Installments paid

M - Remaining days after date of payment of last installment / 30

R - Monthly Rate of return

R can be found out only by trial and error either manulaly or by a program.

Single Star - Multiply

Double Star - Raise to the power of

e.g 4 ** 2 = 16 and 25 ** 1/2 = 5

Matrix

04-09-2009, 04:05 PM

You can calculate final value of your investment using FV function in excel where you have to put -

fx=FV(A1,B1,C1) or FV(rate,nper,pmt)

Where-

1. A1 = Rate is the interest rate per period (Or Expected Rate of interest)

2. B1 = Nper is the total number of payment periods in an annuity (Or Period for which SIP is done)

3. C1 = Pmt is the payment made each period; it cannot change over the life of the annuity.Typically, pmt contains principal and interest but no other fees or taxes (Or Monthly SIP amount)

This wil give you rough estimate of what your investment will be like after "X" yrs which is nothing but SIP period.

fx=FV(A1,B1,C1) or FV(rate,nper,pmt)

Where-

1. A1 = Rate is the interest rate per period (Or Expected Rate of interest)

2. B1 = Nper is the total number of payment periods in an annuity (Or Period for which SIP is done)

3. C1 = Pmt is the payment made each period; it cannot change over the life of the annuity.Typically, pmt contains principal and interest but no other fees or taxes (Or Monthly SIP amount)

This wil give you rough estimate of what your investment will be like after "X" yrs which is nothing but SIP period.

Matrix

16-09-2009, 06:28 PM

Annualised rate of return = (1+R)**12 - 1

geethu

20-04-2015, 11:04 AM

Vijay,

Very good question. :cool:

There is no simple formula for calculating Returns of SIP. You have to do long calculations with calculator or use a computer program written for this purpose.

SIP returns may be calculated as below -

(Assuming SIP is monthly and take 30 days per months)

Final Value of Investment = Monthly investment * ([(1+ R)**N - 1]/R) * [(1+ R)**M]

whrere -

N - No of monthly Installments paid

M - Remaining days after date of payment of last installment / 30

R - Monthly Rate of return

R can be found out only by trial and error either manulaly or by a program.

Single Star - Multiply

Double Star - Raise to the power of

e.g 4 ** 2 = 16 and 25 ** 1/2 = 5

Hi,

I want to calculate SIP with Inflation similar to the below link. Can you please help me out to calculate it?

dspblackrock.com/resources/tools-and-calculators/future-value-of-SIP.aspx

Very good question. :cool:

There is no simple formula for calculating Returns of SIP. You have to do long calculations with calculator or use a computer program written for this purpose.

SIP returns may be calculated as below -

(Assuming SIP is monthly and take 30 days per months)

Final Value of Investment = Monthly investment * ([(1+ R)**N - 1]/R) * [(1+ R)**M]

whrere -

N - No of monthly Installments paid

M - Remaining days after date of payment of last installment / 30

R - Monthly Rate of return

R can be found out only by trial and error either manulaly or by a program.

Single Star - Multiply

Double Star - Raise to the power of

e.g 4 ** 2 = 16 and 25 ** 1/2 = 5

Hi,

I want to calculate SIP with Inflation similar to the below link. Can you please help me out to calculate it?

dspblackrock.com/resources/tools-and-calculators/future-value-of-SIP.aspx

>take

20-04-2015, 01:52 PM

Hi,

I want to calculate SIP with Inflation similar to the below link. Can you please help me out to calculate it?

www.dspblackrock.com/resources/tools-and-calculators/future-value-of-SIP.aspx

The calculator is present in the above link..just put your values.

I want to calculate SIP with Inflation similar to the below link. Can you please help me out to calculate it?

www.dspblackrock.com/resources/tools-and-calculators/future-value-of-SIP.aspx

The calculator is present in the above link..just put your values.

geethu

20-04-2015, 04:24 PM

The calculator is present in the above link..just put your values.

I want to implement in my site similar to the above link, so i wants the formula to do it.

I want to implement in my site similar to the above link, so i wants the formula to do it.

STARiNSURED

12-05-2016, 02:48 PM

Are your shared assets giving you great returns? The Returns Calculator gives you an answer by figuring reserve returns for the period picked by you. It additionally shows returns and execution rank of the asset inside its companion bunch for various time periods.

Powered by vBulletin® Version 4.2.5 Copyright © 2020 vBulletin Solutions Inc. All rights reserved.