considering the investment of two independent projects, X and Y, which are described below. Please do not assume anything. Use a WACC of 15% to evaluate the projects. Cost of Capital>> PROJECT X PROJECT Y A. Calculate Payback Period for both projects Year Cash Inflows B. Calculate NPV for both projects Initial Investment ($11,050,000) ($11,250,000) C. Calculate IRR for both projects 1 $3,500,000 $5,500,000 1 D. Calculate MIRR for both projects 2 $3,500,000 $5,800,000 2 E. Which project should the firm accept? Why? 3 $5,800,000 $2,900,000 4 $5,800,000 $1,950,000 Year For the Payback Period Calculation Cash End of Year Balances PROJECT X PROJECT Y ($7,550,000) ($5,750,000) ($4,050,000) $50,000 $1,750,000 1 3 1.004 Please enter your formulas in the blue cells: A. Payback 2.16 B. NPV 1,769,744.07 C. IRR 21.9% D. MIRR 13.90% E. Accept projects>>> Yes or No 939,957.87 0.20 9.46% Yes or No Why?: End of