answer in excel format please

BANK 3009 CVRM Continuous Assessment Questions 13 Please submit your answers to the following questions in Excel file format (Le... as an Excel file). You have the following initial information on Financeur Co. on which to base your calculations and discussion for questions 1) and 2): 2) Current long-term and target debt-equity ratio (D:E) = 1:3 Corporate tax rate (Tc) = 30% Expected Inflation = 1.55% Equity beta (3:) = 1.6345 Debt beta ([30) = 0.15 Expected market premium [rM- rr) = 6.00% Risk-free rate (rs) =2% The CEO of Financeur Co., for which you are CFO, has requested that you evaluate a potential investment in a new project. The proposed project requires an initial outlay of $7.26 billion. Once completed (1 year from initial outiay) it will provide a real net cash flow of $555 million in perpetuity following its completion. It has the same business risk as Financeur Cofs existing activities and will be funded using the firm's current target D:E ratio. a) What is the nominal weighted-average cost of capital [WACC) for this project? {1 marks) b) As CFO, do you recommend investment in this project? Justify your answer (numerically). [2 marks) Assume now a firm that is an existing customer of Financeur Co. is considering a buyout of Financeur Co. to allow them to integrate production activities. The potential acquiring firm's management has approached an investment bank for advice. The bank believes that the firm can gear Financeur Co. to a higher level, given that its existing management has been highiy conservative in its use of debt. It also notes that the customer's firm has the same cost of debt as that of Financeur Co. Thus, it has suggested use of a target debt- equity ratio of 2:3 when undertaking valuation calculations. a) What would the required rate of return for Financeur Co.'s equity become if the proposed gearing structure were adopted following acquisition by the customer? {5 marks) b) Would the above project described in 1) be viable for the new owner of Financeur Co.? Justify your answer (numerically). [2 marks)