Excel Function : MIRR
Category
Financial
Description
Returns the internal rate of return where positive and negative cash flows are financed at different rates
Microsoft Excel Reference Page
https://support.office.com/en-us/article/MIRR-function-b020f038-7492-4fb4-93c1-35c345b53524
Syntax and Description of the MIRR Excel Function
The basic syntax for the MIRR function in Microsoft Excel is:= MIRR (values, finance_rate, reinvestment_rate)values - Required. An array or a reference to cells that contain numbers for which you want to calculate the MIRR. finance_rate - Required. The interest rate you pay on the money used in the project. reinvestment_rate - Required. The interest rate earned on the cash flows from the project that are reinvested.
About MIRR Excel Function
MIRR returns the modified internal rate of return for a series of periodic cash flows. MIRR considers both the cost of the investment and the interest earned on reinvestment of cash flows.
