Calculates the modified internal rate of return for a series of periodic cash flows.
Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.
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)Risultato: 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.