Answer:
Questions 43-50. Each question is worth point each Calculate the following NPV, IRR. MIRR and hackered...
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
Please show all work. Must be completed using financial formulas, NO EXCEL. a. Calculate the NPV, IRR, MIRR, and traditional payback period for each project, assuming a required rate of return of 8%. b. If the projects are independent, which project(s) should be selected? If they are mutually exclusive, which project should be selected? Project P costs $10,400 and is expected to produce cash flows of $3,650 per year for five years. Project Q costs $30,000 and is expected to...
Calculate payback periods. Please show calculations so I can duplicate it in excel. 7 Your division is considering two projects. Its wACC is 10%, and the projects, after-tax cash flows (in millions 8 of dollars) would be as follows: Expected Cash Flows Project A Project B 10 Time (S30) S5 s10 S15 S20 (S30) S20 S10 S8 S6 12 13 14 15 16 17 18 a. Calculate the projects' NPVs, IRRs, MIRRs, regular paybacks, and discounted payback Use Excel's NPV...