How do I get the Modified IRR (MIRR)? Please complete this worksheet.

1 2 B DE F H EXAMPLE IRR DISCOUNT RATE CASH FLOWS IRR NOW YEAR O 1 2 3 4 5 CF -100000 10000 12,500 14,000 18,550 181250 pv factor pvcf NPV 9 VERSUS MIRR 10 11 12 13 DISCOUNT RATE WACC 20.00% MIRRI 14 EXAMPLE IRR CASH FLOWS IRR NOW YEAR O 1 1 2 3 4 CF -100000 10000 12,500 14,000 18,550 pv factor 5 181250 16 pvcf NPV