- Picture and text skills
- Case
Returns the internal rate of return for a set of cash flows that do not necessarily occur regularly. To calculate the internal rate of return for a set of periodic cash flows, use the function IRR.
Grammar
XIRR(values, dates, [guess])
XIRR function syntax has the following parameters:
￭Value: Required, a series of cash flows corresponding to the payment times 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 discounted on a 365 day/year basis. The value series must contain at least
One positive value and one negative value.
￭Date: Required, a payment date table corresponding to cash flow payments. Dates can be in any order. Dates should be entered using the DATE function or
Dates are entered as the result of other formulas or functions.
For example, use the function DATE(2008,5,23) to enter May 23, 2008. The problem occurs if the date is entered as text.
￭Guess: Optional, an estimate of the calculation result of the function XIRR.
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 for January 1, 2008
The serial number is 39448 because it is 39448 days from January 1, 1900.
￭Numbers in Dates will be truncated.
￭The function XIRR requires at least one positive cash flow and one negative cash flow, otherwise the function XIRR returns the error value #NUM!.
￭If any value in dates is not a valid date, the XIRR function returns the error value #VALUE!.
￭If any number in dates is earlier than the start date, the XIRR function returns the error value #NUM!.
￭If values and dates contain different numbers of values, the XIRR function returns the #NUM! error value.
￭In most cases, it is not necessary to provide a guess value for the calculation of the function XIRR. If omitted, the guess value is assumed to be 0.1 (10%).
￭The function XIRR is closely related to the net present value function XNPV. The rate of return calculated by function XIRR is the interest rate when function XNPV = 0.
￭The WPS table uses the iterative method to calculate the function XIRR.
By changing the yield (starting from guess), the calculation is continuously revised until its accuracy is less than 0.000001%.
If the function XIRR is evaluated 100 times and no result is found, the error value #NUM! is returned. The calculation formula of function XIRR is as follows:
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-XIRR-han-shu-ji-suan-ji-jin-shou-yi-lyu.html
支付宝扫一扫 
评论列表（196条）
测试