- Graphic and Text Skills
- Case
Returns the internal rate of return for a set of cash flows represented by a number. These cash flows do not have to be balanced, but as an annuity they must be generated at regular intervals, such as monthly or yearly. The internal rate of return is the rate of return on an investment, which includes periodic payments (negative value) and periodic income (positive value).
SyntaxIRR(values,guess) values are references to arrays or cells that contain the numbers used to calculate the returned internal rate of return. Values must contain at least one positive value and one negative value to calculate the returned internal rate of return. The function IRR interprets the sequence of cash flows based on the sequence of values. Therefore, be sure to enter the payment and income values in the required order. If the array or reference contains text, logical values, or blank cells, these values are ignored. guess is an estimate of the function's IRR calculation result. The WPS table uses an iterative method to calculate the function IRR. Starting from guess, the function IRR loops until the accuracy of the result reaches 0.00001%. If function IRR has not found a result after 20 iterations, it returns the #NUM! error value. In most cases, it is not necessary to provide a guess value for the function IRR calculation. If guess is omitted, it is assumed to be 0.1 (10%). If the function IRR returns the #NUM! error value, or the result is not close to the expected value, try again with another guess value.
Explanation Function IRR is closely related to function NPV (net present value function). The rate of return calculated by the function IRR is the interest rate when the net present value is 0. The following formula shows the relationship between the function NPV and the function IRR: NPV(IRR(B1:B6),B1:B6) is equal to 3.60E-08 (among the accuracy requirements of the function IRR calculation, the value 3.60E-08 can be regarded as as a valid value of 0).
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/jing-tong-cai-wu-fen-xi-li-yong-IRR-han-shu-ji-suan-nei-bu-shou-yi-lv-de-ji-qiao.html
评论列表(196条)
测试