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 *
Subscribe to FREE Video Course + FREE Ebook + Future Email Updates
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Join 1,60,000 email subscribers
FREE Video Lessons directly in your email daily
144 page PDF ebook with best articles from Jagoinvestor
Get future articles directly on your mailbox + updates
6 PART VIDEO COURSE
You are subscribed for FREE Course now, Check your Email
New here? Create an account