XNPV
Returns the net present value for a schedule of cash flows that is not necessarily periodic
Syntax
XNPV(rate, values, dates)
Arguments
| Argument |
Description |
Required |
rate |
The discount rate to apply to the cash flows |
Required |
values |
A series of cash flows that corresponds to a schedule of payments in dates |
Required |
dates |
A schedule of payment dates that corresponds to the cash flow payments |
Required |
Examples
NPV for irregular cash flows
=XNPV(A1, A2:A5, B2:B5)
Result ⇒
-21.8669
| 0.1 |
| -10000 |
1/1/2024 |
| 2500 |
6/1/2024 |
| 3500 |
12/1/2024 |
| 5000 |
6/1/2025 |
Real estate investment NPV
=XNPV(A1, A2:A4, B2:B4)
Result ⇒
1192.0254
| 0.08 |
| -100000 |
1/1/2023 |
| 15000 |
1/1/2024 |
| 110000 |
1/1/2026 |
Project cash flow analysis
=XNPV(A1, A2:A5, B2:B5)
Result ⇒
16956.3362
| 0.12 |
| -50000 |
1/1/2023 |
| 20000 |
6/1/2023 |
| 25000 |
1/1/2024 |
| 30000 |
6/1/2024 |
Related Functions
Other Financial functions:
- CUMIPMT - Returns the cumulative interest paid between start_period and end_period
- CUMPRINC - Returns the cumulative principal paid on a loan between start_period and end_period
- DB - Returns the depreciation of an asset for a specified period using the fixed-declining balance method
- DISC - Returns the discount rate for a security
- EFFECT - Returns the effective annual interest rate
- FV - Returns the future value of an investment.
- FVSCHEDULE - Returns the future value of an initial principal after applying a series of compound interest rates
- IPMT - Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
- IRR - Returns the internal rate of return for a series of cash flows
- NOMINAL - Returns the annual nominal interest rate
- NPER - Returns the number of periods for an investment
- NPV - Calculates the net present value of a series of cash flows at a given discount rate
- PMT - Calculates the payment for a loan based on constant payments and a constant interest rate.
- PPMT - Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
- PV - Returns the present value of an investment.
- RATE - Returns the interest rate per period of a loan or investment.
- SLN - Returns the straight-line depreciation of an asset for one period
- XIRR - Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
← Back to Formula Reference