What is Mirr? how do you find it using excel without using excel
formula?
Below is cash flow. I found IRR is 15.59% and required return is
12%
CF
Y0
Y1
Y2
Y3
Y4
Y5
Y6
Capital spen
$ (30,000,000.00)
$ 15,062,400.00
Opp cost
$ (5,000,000.00)
NWC
$ (1,120,000.00)
$ (150,000.00)
$ (170,000.00)
$ 140,000.00
$ 1,300,000.00
OCF
$ 9,015,600.00
$ 11,392,500.00
$ 12,193,200.00
$ 10,435,800.00
$ (2,640,000.00)
$ (3,960,000.00)
CF
$ (36,120,000.00)
$ 8,865,600.00
$ 11,222,500.00
$ 12,333,200.00
$...