MIRR
The MIRR function in Google Sheets calculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income.
Function Syntax and Parameters
Syntax: MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)
Parameters:
cashflow_amounts: The array or range of cash flows.financing_rate: The interest rate paid on financing.reinvestment_return_rate: The return rate received on reinvested income.
Step-by-Step Tutorial
Coming Soon...
Use Cases and Scenarios
- Investment Analysis: Evaluate the profitability of an investment based on cash flows and interest rates.
Related Functions
None
Related Articles
None