The interest rate you pay on the money used in the cash flows. If an array or reference argument contains text, logical values, or empty cells, those values are ignored however, cells with the value zero are included.įinance_rate Required. Otherwise, MIRR returns the #DIV/0! error value. Values must contain at least one positive value and one negative value to calculate the modified internal rate of return. These numbers represent a series of payments (negative values) and income (positive values) occurring at regular periods. ![]() An array or a reference to cells that contain numbers. The MIRR function syntax has the following arguments: MIRR(values, finance_rate, reinvest_rate) MIRR considers both the cost of the investment and the interest received on reinvestment of cash. ![]() Returns the modified internal rate of return for a series of periodic cash flows. This article describes the formula syntax and usage of the MIRR function in Microsoft Excel.
0 Comments
Leave a Reply. |