Formula Generator - MIRR function
The MIRR function calculates the modified internal rate of return on an investment. It takes into account a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income. The function returns the modified internal rate of return as a percentage.How to generate an MIRR formula using AI.
To obtain the MIRR formula for your data, you could ask the AI chatbot the following question: "What is the formula for calculating the Modified Internal Rate of Return (MIRR) in Excel?"
MIRR formula syntax.
The MIRR function in Excel calculates the modified internal rate of return for a series of cash flows. Its syntax is as follows: MIRR(values, finance_rate, reinvestment_rate) - values: This is a required parameter that represents the range of cells containing the cash flows, including both positive and negative values. - finance_rate: This is the required parameter that represents the interest rate paid on the financing used to fund the cash flows. - reinvestment_rate: This is the required parameter that represents the interest rate earned on the reinvestment of cash flows. The MIRR function returns the modified internal rate of return, which is the rate at which the net present value of the cash inflows equals the net present value of the cash outflows, considering both the financing and reinvestment rates.
Investment Analysis
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.
MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)
Loan Comparison
Compares the total cost of two different loans by calculating the modified internal rate of return for each loan based on the cash flows and interest rates.
MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)
Project Evaluation
Evaluates the profitability of a project by calculating the modified internal rate of return based on the cash flows and the financing and reinvestment rates.