Calculates the modified internal rate of return for a series of periodic cash flows.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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.
=MIRR({-1000, 300, 400, 500}, 0.1, 0.12)결과: 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.
MIRR is more realistic because it assumes reinvested cash flows earn the reinvestment rate rather than the internal rate of return itself.