Help reqd for calculating FV!

POSTED BY avi ON June 28, 2011 11:33 pm COMMENTS (4)

Hi,

 

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.

Thanks,

Avinash

4 replies on this article “Help reqd for calculating FV!”

  1. Krishna Karki says:
    June 29, 2011 at 4:26 pm

    Mr. Avinash,
    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.
    put values.
    Rate : 0.15/12= 0.013
    PV ; 60000=00
    nper : 40
    pmt; 10000=00
    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 🙂

    Reply
    1. Avinash Borse says:
      June 29, 2011 at 10:54 pm

      Thx Krishna it worked!

      Reply
  2. Jagadees says:
    June 29, 2011 at 4:19 am

    Try out the calculators in this page – https://www.jagoinvestor.com/calculator

    Regards
    Jagadees

    Reply
    1. Avinash Borse says:
      June 29, 2011 at 10:54 pm

      @Jagdees Thx but i already tried those!

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.