- Picture and text skills
- Case
Returns the net present value of a set of cash flows that do not necessarily occur regularly. To calculate the net present value of a set of periodic cash flows, use the function NPV.
Grammar
XNPV(rate, values, dates)
XNPV function syntax has the following parameters:
￭ Rate: required. The discount rate applied to cash flows.
￭ Value: required. A series of cash flows corresponding to the timing of payments in dates. The down payment is optional and is consistent with the initial cost or payment of the investment
Close. If the first value is a cost or payment, it must be negative. All subsequent payments are based on 365 days/year discounted value series must contain at least
One positive number and one negative number.
￭ Date: required. A schedule of payment dates corresponding to cash flow payments. The first pay date represents the start date of the pay schedule. All other dates should be later than
The date, but in any order.
Description
￭ WPS tables store dates as serial numbers that can be used for calculations. By default, the serial number for January 1, 1900 is 1, and January 1, 2008
's serial number is 39448 because it is 39448 days from January 1, 1900.
￭ The values in Dates will be truncated.
￭ If any parameter is non-numeric, XNPV returns a #VALUE! error value.
￭ If any number in the date is not a valid date, XNPV returns the #VALUE! error value.
￭ If any number in the date is before the start date, XNPV returns the #NUM! error value.
￭ If the value and date contain different numbers of values, XNPV returns a #NUM! error value.
￭ Among them:
di = i-th or last payment date.
d1 = 0th payment date.
Pi = i-th or last payment amount.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-cai-wu-han-shu-XNPV-han-shu-ji-suan-bu-ding-qi-shou-yi-xiang-mu-jing-xian-zhi.html
支付宝扫一扫 
评论列表（196条）
测试