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

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%.

Sample data

• 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.

XNPV Function

• 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%.

Sample data

• 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.

XNPV Function

• 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
• NPER Function

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!! *Read more on Excel Formulas *!!

Read Next:

• Excel Formulas to Calculate Net Present Value (NPV) ~ Simple Guide!!
• Calculate the Present Value of Annuity ~ Useful Tricks!!
• Excel Formulas to Get the Percentage Discount ~ Useful Tricks!!
• use the MIRR function in Excel office 365? ~ {Quick Steps}
• Excel Formulas to Find Original Price from Percentage Discount!!