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.
Download Our FREE Ebook!
Available only for first 100 people today
New here? Create an account