Excel Function : MIRR

Download now!

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.