Manuals/calci/MIRR
Jump to navigation
Jump to search
MIRR(CashFlows,FinanceRate,ReinvestRate)
where,
CashFlows - is the set of payments and income.
FinanceRate - is the interest rate pay on the money used in the cash flows.
ReinvestRate - the interest rate received on the cash flows.
Returns the modified internal rate of returns for set of periodic cash flows.It also consider cost of investment and the interest received on reinvestment of cash.
CashFlows must contain atleast one positive and one negative value, otherwise returns the #ERROR.
MIRR
Lets see an example in (Column1, Row5)
=MIRR(R1C1:R6C1,R7C1, R8C1)
MIRR returns (-16%).
Consider an another example
=MIRR([50000,20000,56000,41000,85000],3%,4%)
MIRR returns #ERROR
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | -850000 | |||
| Row2 | 45000 | |||
| Row3 | 96000 | |||
| Row4 | 50000 | |||
| Row5 | 23000 | |||
| Row6 | 68000 | |||
| Row7 | 8% | |||
| Row8 | 12% | |||
| Row9 | -16 | |||
| Row10 |
