How to use the XNPV function in Excel office 365?
Tags: tousethexnpvfunction, excel, excelfunctions
Published: 2021-09-03 03:24:44

---
title: How to use the XNPV function in Excel office 365?
published: true
date: 2021-09-03 01:35:24 UTC
tags: ToUseTheXNPVFunction,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-xnpv-function-in-excel-office-365/
---

Have you ever tried to use these functions In your Excel Spreadsheet? In this tutorial, we will guide you on **how to use the XNPV Function In Excel Office 365**. Let’s get them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## XNPV Function

This function returns the **net present value for a schedule of cash flows** that is not necessarily periodic.

## XNPV Function Syntax

```
=XNPV (rate, values, dates)
```

**Syntax Explanation:**

- **Rate:** discount rate.
- **Values:** Cash flows.
- **Dates:** Dates that corresponds to cash flows.

## Example1

- Firstly, you have to create a list of **Cash flows with corresponding dates** and **Discount rate is 9%**.

![](https://geekexcel.com/wp-content/uploads/2021/09/Sample-data-6-1024x377.png)<figcaption>Sample data</figcaption>

- Then, you need to calculate the **XNPV Function**  **value**.
- Now, you have to use the **formula** given below.

```
=XNPV(E2, B2:B7, A2:A7)
```

**E2:** Discount rate.  
**B2:B7:** Cash flows.  
**A2:A7:** Dates that corresponds to cash flows.

![](https://geekexcel.com/wp-content/uploads/2021/09/XNPV-Function-1024x414.png)<figcaption>XNPV Function</figcaption>

- Finally, the function returns the **net present value for the Cash flow data**.

## Example2

- Firstly, you have to create a list of **Cash flows with corresponding dates** and **Discount rate is 9%**.

![](https://geekexcel.com/wp-content/uploads/2021/09/Ex-2-Sample-data-7-1024x382.png)<figcaption>Sample data</figcaption>

- Then, you need to calculate the **XNPV Function**  **value**.
- Now, you have to use the **formula** given below.

```
=XNPV(E2, B2:B7, A2:A7)
```

**E2:** Discount rate.  
**B2:B7:** Cash flows.  
**A2:A7:** Dates that corresponds to cash flows.

![](https://geekexcel.com/wp-content/uploads/2021/09/Ex-2-XNPV-Function-1024x376.png)<figcaption>XNPV Function</figcaption>

- Finally, the function returns the **net present value for the Cash flow data**.

**NOTES:**

- Dates should be valid date in Excel.
- Dates and Cash flows must be in order.
- The function doesn’t count the initial cash flow.
- To calculate the net present value for a series of cash flows that is periodic, use the NPV function.

**Check this too:**

- [MIRR function](https://geekexcel.com/how-to-use-the-mirr-function-in-excel-office-365-quick-steps/)
- [NPER Function](https://geekexcel.com/how-to-use-the-nper-function-in-excel-office-365/)

## End of Era

We hope that this tutorial gives you guidelines on **how to use the XNPV Function In Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Next:**

- **[Excel Formulas to Calculate Net Present Value (NPV) ~ Simple Guide!!](https://geekexcel.com/excel-formulas-to-calculate-net-present-value-npv/)**
- **[Calculate the Present Value of Annuity ~ Useful Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-the-present-value-of-annuity/)**
- **[Excel Formulas to Get the Percentage Discount ~ Useful Tricks!!](https://geekexcel.com/excel-formulas-to-get-the-percentage-discount/)**
- **[use the MIRR function in Excel office 365? ~ {Quick Steps}](https://geekexcel.com/how-to-use-the-mirr-function-in-excel-office-365-quick-steps/)**
- **[Excel Formulas to Find Original Price from Percentage Discount!!](https://geekexcel.com/excel-formulas-to-find-original-price-from-percentage-discount/)**