- Picture 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 occur 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).
Syntax
IRR(values,guess)
values is a reference to an array or cell, containing the number used to calculate the returned internal rate of return.
• Values must contain at least one positive value and A negative value to calculate the internal rate of return returned.
• Function IRR is interpreted according to the order of values sequence of cash flows. Therefore, make sure that the payment and income values are entered in the required order.
• If the array or reference contains text, logic values or blank cells, these values will be ignored.
guess is an estimate of the calculation result of the function IRR value.
• WPSThe table uses the 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, not A guess value is required for the calculation of the function IRR. If guess is omitted, it is assumed to be 0.1 (10%).
• If the function IRR returns the error value #NUM !, or the result is not close to the expected value, try again with another guess value.
Description
•The relationship between function IRR and function NPV (net present value function) is very close. 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 (precision requirement for function IRR calculation Among them, the value 3.60E-08 can be regarded 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/biao-ge-cai-wu-han-shu-qiao-yong-IRR-han-shu-suan-nei-bu-shou-yi-lyu.html
评论列表(196条)
测试