• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About

XNPV Function in Excel

The Excel XNPV function returns the net present value of an investment based on a series of cash flows, the dates of the cash flows and a discount rate.

The syntax for the XNPV function is:

=XNPV(rate, values, dates)
ArgumentPurpose
rateDiscount rate to apply to the cash flows of the investment
valuesSeries of cash flows that correspond to a schedule of payments. The series of payments must contain atleast one negative and one positive value
datesThe schedule of payment dates that correspond to the cash flow payments. The first payment date occurs at the beginning and all other must be later than this date

The example below shows the XNPV function being used to return the net present value for an investment with a discount rate of 6%, a series of payments in range B3:B21 and a schedule of dates in range A3:A21.

XNPV function in Excel returning the net present value

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • IF Function in Power Query Including Nested IFS
  • How to Hyperlink to a Hidden Worksheet in Excel
  • Conditional Formatting Multiple Columns – 3 Examples

Recent Posts

  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
  • Display Negative Time in Excel
  • Lookup Multiple Values in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·