MIRR 函数MIRR function

返回为一系列定期现金流量(付款和收款)指定修改的内部报酬率的 Double 值。Returns a Double specifying the modified internal rate of return for a series of periodic cash flows (payments and receipts).


MIRR(values()、财务_比率reinvest_率)MIRR(values( ), finance_rate, reinvest_rate)

MIRR 函数具有以下命名参数The MIRR function has these named arguments:

PartPart 说明Description
( )values( ) 必需。Required. 用于指定现金流值的双精度数组Array of Double specifying cash flow values. 该数组必须包含至少一个负值(付款)和一个正值(收款)。The array must contain at least one negative value (a payment) and one positive value (a receipt).
财务_费率finance_rate 必需。Required. 将准备金利率指定为财务费用的 Double 值。Double specifying interest rate paid as the cost of financing.
reinvest_速率reinvest_rate 必需。Required. 指定由现金再投资所得收益的利率的 Double 值。Double specifying interest rate received on gains from cash reinvestment.


修改后的内部报酬率是指在用不同的利率计算付款和收款时所得的内部报酬率。The modified internal rate of return is the internal rate of return when payments and receipts are financed at different rates. MIRR函数将考虑投资的成本 (财务_比率) 和在现金 (reinvest_比率) 上收到的利率 (利率)。The MIRR function takes into account both the cost of the investment (finance_rate) and the interest rate received on reinvestment of cash (reinvest_rate).

"财务_费率" 和 " reinvest_rate "参数是以十进制值表示的百分比。The finance_rate and reinvest_rate arguments are percentages expressed as decimal values. 例如,12% 表示为 0.12。For example, 12 percent is expressed as 0.12.

MIRR 函数使用数组中值的顺序解释付款和收款的顺序。The MIRR function uses the order of values within the array to interpret the order of payments and receipts. 请确保按正确的顺序输入付款和收款值。Be sure to enter your payment and receipt values in the correct sequence.


此示例使用 MIRR 函数返回数组 Values() 中包含的一系列现金流的修改后的内部报酬率。This example uses the MIRR function to return the modified internal rate of return for a series of cash flows contained in the array Values(). LoanAPR 表示财务利率, InvAPR 表示由再投资所得收益的的利率。LoanAPR represents the financing interest, and InvAPR represents the interest rate received on reinvestment.

Dim LoanAPR, InvAPR, Fmt, RetRate, Msg
Static Values(5) As Double    ' Set up array.
LoanAPR = .1    ' Loan rate.
InvAPR = .12    ' Reinvestment rate.
Fmt = "#0.00"    ' Define money format.
Values(0) = -70000    ' Business start-up costs.
' Positive cash flows reflecting income for four successive years.
Values(1) = 22000 : Values(2) = 25000
Values(3) = 28000 : Values(4) = 31000
RetRate = MIRR(Values(), LoanAPR, InvAPR)    ' Calculate internal rate.
Msg = "The modified internal rate of return for these five cash flows is"
Msg = Msg & Format(Abs(RetRate) * 100, Fmt) & "%."
MsgBox Msg    ' Display internal return rate.

另请参阅See also

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.