Results 1 to 9 of 9

Calculating xirr with vlookup

Threaded View

  1. #1
    Registered User
    Join Date
    06-06-2012
    Location
    Kolkata
    MS-Off Ver
    Excel 2007
    Posts
    16

    Calculating xirr with vlookup

    Hello Friends,

    Please refer to the attached Excel Sheet, where I am trying to calculate XIRR, but ending up with error.

    In the workbook working sheets are as follows:
    1. Revised Direct
    2. Revised Regular
    3. XIRR_Data

    I want to do the following
    # Calculate XIRR in "Revised Direct" referring to "XIRR_Data" where Column A of XIRR_Data is Direct
    # Calculate XIRR in "Revised Regular" referring to "XIRR_Data" where Column A of XIRR_Data is Regular.

    For Calculating XIRR,
    - Current Valuation are available in Revised Direct & Revised Regular Respectively.
    - and Dates & Amount of periodic investment are available in XIRR_Data.

    Please help me to solve this issue

    Thanks & Regard
    Vikash Dalmia
    Attached Files Attached Files
    Thanks & Regards
    Vikash Dalmia
    +91 8981274090

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VLOOKUP function to calculate XIRR
    By mlcfexcel in forum Excel General
    Replies: 8
    Last Post: 04-12-2020, 08:46 AM
  2. Calculating IRR using XIRR to calculate interest
    By sgcray in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-26-2019, 02:30 AM
  3. Replies: 5
    Last Post: 07-09-2017, 03:24 AM
  4. VLOOKUP function to calculate XIRR
    By mlcfexcel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-27-2014, 11:45 PM
  5. Calculating XIRR w/ zero's in first few datapoints.
    By supra98x in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-23-2013, 06:52 AM
  6. Calculating XIRR Quarterly (or any time period)?
    By sabunabu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-13-2013, 03:56 AM
  7. Replies: 4
    Last Post: 06-08-2006, 10:35 PM

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