Urgent question on corporate finance (firm valuation/mergers). Details in the file attached, would be grateful if someone can help me with solving this question with detailed steps. Thank you!

RSM 333 (2015) ASSIGNMENT #2 Due Monday, August 10th, 2015 (4:00pm) at the Rotman Commerce Office Problem 3 Firm Valuation and M&A (40 Marks) (Consider using an Excel Spreadsheet to solve this problem.) You are the CFO of GreatFood, a large chain of grocery stores. You are planning to expand your business by acquiring the GoodWine winery that has recently been put up for sale by the owners. You think that this acquisition may turn out to be a good investment so you want to have solid financial background for the deal to present at the upcoming Shareholders Meeting on August 10th, 2015. You have the following information about Some important accounting numbers projected for the next 5 years are as follows (all numbers are before-tax, as of the end of the fiscal year and in $ thousands): 2016 2017 2018 2019 2020 2327.0 2863.0 2984.0 3447.0 3743.0 EBITDA 581.8 715.8 746.0 861.8 935.8 Capital expenditures 500.0 350.0 200.0 180.0 150.0 50.0 60.0 65.0 70.0 75.0 175.0 180.3 185.7 191.2 197.0 Sales Increase in NWC Depreciation After year 5, the winery thousand shares outstanding. The market value of equity is currently $3,500 thousand and the market value of outstanding debt is $450 thousand (assume that the share price, the value of equity, and the value of debt are given at the valuation date, i.e. August 10th, 2015). The firm faces the (marginal) tax rate of 40%. The asset beta of the target (the beta of the same but all-equity firm) is 1.15. GreatFood (Acquirer) The acquirer expects to have the following estimated synergies from the M&A and all figures are before-tax, as of the end of the fiscal year and in $ thousands: Synergies EBITDA 2016 2017 2018 2019 2020 134.0 150.0 171.0 216.0 223.0 After year 5, the free cash flow (FCF) from synergies will grow at an annual rate of 2% into perpetuity. The firm faces the (marginal) tax rate of 40%. The asset beta of the acquirer (the beta of the same but all-equity firm) is 0.8. Note: The fiscal years of both your firm and the target end on August 10 (i.e. all projected numbers are given at the end of the fiscal year starting from exactly one year from the date of valuation). Page 4 of 6 RSM 333 (2015) ASSIGNMENT #2 Due Monday, August 10th, 2015 (4:00pm) at the Rotman Commerce Office Information about the deal/market conditions The target leverage (D/V) after the deal is completed is expected to be 25% (applies to both the target and the synergies). The borrowing rate (cost of capital) is 8% and the Treasury bond rate (risk-free rate) is 5.5%. The market risk premium is 5%. 1.1. What is the maximum price per share that your firm can pay for the target based on DCF and APV methods? You can build your analysis on the following steps in your valuation: a) Estimate the value of the levered target firm: a. Calculate the cost of assets (unlevered equity return, i.e. cost of equity of the same but all-equity firm) for the target using CAPM b. Calculate the cost of equity (levered equity return) for the target c. Calculate the weighted average cost of capital (WACC) for the target d. Estimate free cash flow (FCF) for years 2016-2020 e. Calculate the terminal value in 2020 using the APV method and the WACC method separately f. Calculate the value of the levered target firm using the APV method (Hint: since leverage is expected to change, D*t is not an appropriate way of estimating tax shields derive tax shields from the relation between the levered and unlevered values of the firm) g. Calculate the value of the levered target firm using the WACC method b) Calculate the value of synergies: a. Calculate the cost of assets for the acquirer using CAPM b. Calculate the cost of equity (levered equity return) for the acquirer c. Calculate the weighted average cost of capital (WACC) for the acquirer d. Estimate free cash flow (FCF) from synergies for years 2016-2020 using beta and growth rate of the acquirer e. Calculate the terminal value of synergies in 2020 using the APV method and the WACC method separately f. Calculate the value of the levered synergies using the APV method (do not forget about the tax shields) g. Calculate the value of the levered synergies using the WACC method c) Find a. Calculate the value of the levered target to the acquirer by adding the value of synergies to the value of the levered target firm b. Subtract the amount of outstanding debt to get the value of equity d) Calculate the maximum price per share that the acquirer can pay for the target 1.2. If your firm announces the deal on August 10th, 2015 announcement (based on both DCF and APV methods)? Page 5 of 6 RSM 333 (2015) ASSIGNMENT #2 Due Monday, August 10th, 2015 (4:00pm) at the Rotman Commerce Office Hint: The following relationship will be useful for you in Problem 3. PV (T S ) V L D TC and V L VL VU D TC VL VU D TC VL 1 => PV (T S ) D TC VL => PV (T S ) VU PV (T S ) PV (TS ) => PV (T S ) D TC => 1 VL PV (T S ) D TC VL D D TC PV (T S ) VU TC VL VL Page 6 of 6 VU