June 28, 2011 11:33 pm
Can somebody help me with formula for Future value of an SIP@10000 for 40 Months then increased to 20000 for next 80 months @ 15 %. With an initial deposit of 60000.
Go to exel, click, fx ( functions), go to financials in the left side of dialouge box that appears, then go to FV on right side.next there will be a dialouge box.
Rate : 0.15/12= 0.013
PV ; 60000=00
nper : 40
You will see, at the bottom value at the end of 40 months.
Take that as PV and repeat the same , You will find the at the end of next 80 months
It is:4379769=00 🙂
Thx Krishna it worked!
Try out the calculators in this page – https://www.jagoinvestor.com/calculator
@Jagdees Thx but i already tried those!
Your email address will not be published. Required fields are marked *
Please subscribe me to your Email Newsletters
This site uses Akismet to reduce spam. Learn how your comment data is processed.
New here? Create an account