Suppose (1) re-finance rate remains constant, (2) all cashflows are incurred in the end of the year, (3) re-investment rate increases by 10% a year, and (4) the inflation rate is constant at 2% a year.

For MIRR, please use MIRR formula (not excel function) to calculate MIRR.

year	cashflow
0	-5000
1	2000
2	1000
3	1000
4	1000
5	2000
6	500
7	-100
Refinance rate	5%
reinvestment rate	10%
inflation rate	2%
discount rate	7%

MIRR