Question

Questions 43-50. Each question is worth poteh Calculate the following NPV, IRR, MIRR. and pashack period using the data below. Also out the MS Excel formula to calculate the followine NPY IRR, MIRR, and payback perc referencing the below MS Excel screenshot 1 Q 43-50 data: Year Dates Cash Flows in '000) -280 Initial Investment 185 11 Finance rate (WACC) 12 Reinvestment rate 0.0600 0.0150 Numerical Answer MS Excel language 43. NPV 45. IRR 47. MIRR 49. Payback period

Answer 1

Year (n) Cash Flows Cumulative Cash Flow [(1+r)^n PV (cash flows / (1+r)^n) $ 6 -280.00 $ 75.00 $ 125.00 $ 155.00 $ 185.00 $ 185.00 $ 185.00 -280.00 $-205.00 $ -80.00 $ 75.00 $ 260.00 $ 445.00 $ 630.00 1.06 1.12 1.19 1.26 1.34 1.42 $ 70.75 $ 111.25 $ 130.14 $ 146.54 $ 138.24 $ 130.42 6% WACC (r) Reinvestment Rate Reinvestment Rate 1.5% 1.5% 0.06 0.015 0.015 tumeric Answer $ 422.02 MS Excel Language NPV =NPV(D8,C3:13) IRR 4096 EIRR(C3:13) MIRR 22% =MIRR(C3:13,08,09) 12=E1 Payback Period Years Before Full Recovery Unrecovered Cost at the begining of the year Discounted Cash Inflow during the year Payback Period 0.61 = 7 months Payback Period 80 --E3 $ 130 =F5 2.61 =E18+(E19/E20) 7 =12*0.61 2 Years 7 months -