:Tabular Financial Functions MIRR Function Calculation Return on Reinvestment-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

Returns the modified internal rate of return on cash flows over a continuous period. The function MIRR takes into account both the cost of investing and the rate of return on reinvested cash.

Syntax
MIRR(values,finance_rate,reinvest_rate)

values is an array or a reference to a cell containing numbers. These values represent a range of expenses (negative values) and revenues (positive values) for each period.
• The parameter Values must contain at least one positive value and one negative value to calculate the modified internal rate of return, otherwise the function MIRR will return an error

Value #DIV/0!.
• If the array or reference parameter contains text, logical values or blank cells, these values will be ignored; however, cells containing zero values will be counted.
finance_rate is the payment for funds used in cash flow interest rate.
reinvest_rate is the income from reinvesting cash flow Rate.

Description
• Function MIRR interprets the sequence of cash flows based on the sequence of input values. So, be sure to enter your expenses and income amounts in the actual order and use positive

Correct sign (positive values for cash inflows, negative values for cash outflows).
• If the number of cash flows is n, finance_rate is frate and reinvest_rate is rrate, then the calculation formula of function MIRR is:

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-MIRR-han-shu-ji-suan-zai-tou-zi-de-shou-yi-lyu.html