Hàm Google Sheets

MIRR

Calculates the modified internal rate of return for a series of periodic cash flows.

Tạo công thức bằng AI Cùng hàm trong Excel

Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.

Cú pháp

MIRR(values, finance_rate, reinvest_rate)

MIRR improves upon the standard IRR function by accounting for both the cost of investment and the interest received on reinvested cash. It assumes that positive cash flows are reinvested at the reinvestment rate and negative cash flows are financed at the finance rate.

Đối số

valuesbắt buộcAn array or reference to cells that contain numbers representing a series of payments and income.
finance_ratebắt buộcThe interest rate you pay on the money used in the cash flows.
reinvest_ratebắt buộcThe interest rate you receive on the cash flows as you reinvest them.

Ví dụ

=MIRR({-1000, 300, 400, 500}, 0.1, 0.12)

Kết quả: 0.1261

Calculates the MIRR for an initial investment of 1000 followed by returns of 300, 400, and 500, with a 10% finance rate and 12% reinvestment rate.

Câu hỏi thường gặp

Why use MIRR instead of IRR?

MIRR is more realistic because it assumes reinvested cash flows earn the reinvestment rate rather than the internal rate of return itself.

Hàm liên quan

IRR XIRR NPV