Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

XIRR / XNPV Calculations



11 opmerkingen

  • Officiële opmerking
    Mike Davis

    Great news, friends! Support for the XIRR formula is now on the future product roadmap. While I do not have a timeline for when it will be made available, this is step in the right direction. We'll continue to take in new requests and feedback in the interim. Do let us know what questions you have in the meantime. Cheers!

  • Mike Davis

    Thanks for your feedback, Jose!

    Just wanted to let you know that our product team is taking a second look at adding in support for the XIRR formula. We'll keep you updated but do let me know if you have any questions. Cheers!

  • Nitika Rattan

    Hi Mike and workiva team,

    Wanted to check on status for adding XIRR/XNPV formulas. It is required for few reports and workpapers that I have at hand. Absence of XIRR formula is a deal-breaker to consider workiva as a potential solution.

  • Mike Davis

    Thanks for reaching out, Nitika!

    Our product team is considering adding support for these formulas and the good news is they have recently regained some interest. The earliest I might anticipate seeing these picked up to be worked on, however, is Q1 2022. This could be expedited if interest in these continued to increase, as well.

    I've shared your comments and will be keeping you apprised going forward. We definitely encourage others who are interested in these formulas to let us know either in a comment or by voting up this suggestion. Thanks again and give us a holler if you have any questions. Cheers!

  • Cassie Glass

    Not sure how to vote on this but we are interested in having the XNPV formula available for use in Workiva.

  • Mike Davis

    Thanks for contributing, Cassie! I've got your request recorded.

    For reference, the voting mechanism is the up and down arrows to the right of a post or comment. But a comment works even better :)

  • Chauhan, Mehul

    The XIRR function would really solve lot of financial reporting use cases we would like to use Workiva for. Hope this gets expedited.

  • Laura Johnston

    Very much agreed. XIRR formula would be a huge benefit for my team. Consider this an additional vote for time-weighted return/value calc integration!!!

  • Jason Zeman

    This would be an awesome enhancement for us too, tracking the response here too!


  • Ally Felker

    Any update on the XIRR formula - I thought it was mentioned at last year's conference that it would be available by the end of 2022

  • Mike Davis

    Hello and welcome to the community, Ally!

    Thanks for the question. As far as an update, right now this does still remain on the roadmap though no timeline is set for it. It is possible for 2023, but I should know more by early July if it gets earmarked for Q3.

    That said, I'll add you as a requestor and will keep you updated on our side. Give us a holler if you have any questions or need anything else. Cheers!



U moet u aanmelden om een opmerking te plaatsen.