VMG Company is considering investing in Project R, which will require an outlay of $800 million. The project will have a five-year life and at the end of that time, the equipment will be scrapped. The following information about two mutually exclusive projects R and T is relevant for requirements 1(a) to 1 (c) only. The Project R is expected to generate the following annual cash flows: The company has a required rate of return of 14.61%. The company normally has three-year discounted payback criteria. The alternative Project-T offers the following net cash flows: Year-0 (\$800m); Year-1 \$191m; Year-2 \$254m; Year-3 \$326m; Year-4 \$364m; and Year-5 $364m. (a) Calculate the (i) NPV, (ii) IRR, (iii) PVI, (iv) Payback period, (v) Discounted payback period for projects R and T. (b) Calculate the crossover rate (between projects R and T ) based on the above cash flow data. Show the range of required rates for which either Project-R or Project-T would be preferred. (c) Based on your findings in requirements a and b above, what would be the decision of selection of project (when the required rate of return is 14.61 percent)? Use Excel Spreadsheet to answer|