+ Reply to Thread
Results 1 to 2 of 2

FV and XIRR function

  1. #1
    Registered User
    Join Date
    01-25-2007
    Posts
    11

    FV and XIRR function

    Problem 1:
    Rate of Interest (ROI): 7.50% - Compounded Quarterly
    Annual Rate Compounded: =FV(7.50%/4,4,0,-1)-1 ie 0.0771

    Minimum Investment=Rs. 10 per month
    Term = 5 years

    What will be FV formula to calculate the following:

    Net Return=

    Net Return should be: Rs. 728.9


    Problem 2:

    I would like to know whether the xirr calculation showing correct result.

    First a person invest Rs. 100000 in a MIS (Monthly Income Scheme) for 6 years from which he will get Rs. 666 per month as return. At the end of the scheme the Capital will be refunded to the investor.
    Second the aforesaid Rs. 666 will reinvest into a Recurring Deposit (mentioned above) automatically.
    What will be Internal Rate of Return?
    In my calculation it is showing Less than the First calculation. In my opinion it should be more than First XIRR calculaton

    Example:


    HTML Code: 
    Attached Files Attached Files
    Last edited by rushatiindia; 04-11-2007 at 12:16 AM.

  2. #2
    Registered User
    Join Date
    01-25-2007
    Posts
    11

    Unhappy Help Wanted

    Still awaiting a favourable reply.

    Regards,

    Swarup Modak

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1