PLEASE SOLVE IT IN 30 MINUTES DON'T TAKE LONG PLEASE THANKS !

Question 10. (10 marks) (a) Value Co (Value) has $200 million in debt, with a before-tax cost of debt of 8%. Value has 15 million shares outstanding, with a market price of $20 per share. Value's cost of equity can be estimated using the CAPM model and data from comparable firms. Alpha Co (Alpha) and Beta Co (Beta) are equally comparable to Value. Alpha has a levered beta of 1.5 and a debt-to-equity ratio of 100%. Beta has a levered beta of 0.8 and a debt-to-equity ratio of 20%. The risk-free rate is 4% and the market risk premium is 7\%. What is Value's WACC? (Show your work in Excel. In Excel, show numbers at the two decimal places. Copy-paste your Excel work to your answer document as an image.) (3 marks) (b) Assume that the information provided about Value in (a) holds here as well. The following are selected items from Value's financial statements from the past three years. The dollar amounts in the financial statements are in millions. Today is the last day of year 100 . Regarding these items, Value's sales growth is expected to decline by 2 percentage points each year. (For example, Value's sales growth in year 101 is expected to be 12%.) This decline in sales growth is expected to continue until sales growth becomes 2%, after which sales growth is expected to stay at 2% in perpetuity. Gross margins and EBIT margins are expected to stay the same in the future. Capital expenditures will stay at 15% of sales, except year 102 and year 103 , where it is expected to be 25% of sales due to scheduled replacement in factory equipment. Depreciation will stay at 15% of sales except year 103 and year 104, where it is expected to be 25% of sales. Value's working capital consists of accounts receivables, inventories, and accounts payables. Value's days sales outstanding, days inventory held, and days payable outstanding is expected to remain constant. The days sales outstanding, days inventory held, and days payable outstanding of a particular year are calculated based only on that year's account receivables, inventories, account payables, sales and cost of goods sold. Value's tax rate is 40%. Using the discounted cash flow model, estimate the value of Value's shares. Should you buy Value shares? (Show your work in Excel. In Excel, show numbers at the two decimal places. Copy-paste your Excel work to your answer document as an image.) ( 7 marks) Question 10. (10 marks) (a) Value Co (Value) has $200 million in debt, with a before-tax cost of debt of 8%. Value has 15 million shares outstanding, with a market price of $20 per share. Value's cost of equity can be estimated using the CAPM model and data from comparable firms. Alpha Co (Alpha) and Beta Co (Beta) are equally comparable to Value. Alpha has a levered beta of 1.5 and a debt-to-equity ratio of 100%. Beta has a levered beta of 0.8 and a debt-to-equity ratio of 20%. The risk-free rate is 4% and the market risk premium is 7\%. What is Value's WACC? (Show your work in Excel. In Excel, show numbers at the two decimal places. Copy-paste your Excel work to your answer document as an image.) (3 marks) (b) Assume that the information provided about Value in (a) holds here as well. The following are selected items from Value's financial statements from the past three years. The dollar amounts in the financial statements are in millions. Today is the last day of year 100 . Regarding these items, Value's sales growth is expected to decline by 2 percentage points each year. (For example, Value's sales growth in year 101 is expected to be 12%.) This decline in sales growth is expected to continue until sales growth becomes 2%, after which sales growth is expected to stay at 2% in perpetuity. Gross margins and EBIT margins are expected to stay the same in the future. Capital expenditures will stay at 15% of sales, except year 102 and year 103 , where it is expected to be 25% of sales due to scheduled replacement in factory equipment. Depreciation will stay at 15% of sales except year 103 and year 104, where it is expected to be 25% of sales. Value's working capital consists of accounts receivables, inventories, and accounts payables. Value's days sales outstanding, days inventory held, and days payable outstanding is expected to remain constant. The days sales outstanding, days inventory held, and days payable outstanding of a particular year are calculated based only on that year's account receivables, inventories, account payables, sales and cost of goods sold. Value's tax rate is 40%. Using the discounted cash flow model, estimate the value of Value's shares. Should you buy Value shares? (Show your work in Excel. In Excel, show numbers at the two decimal places. Copy-paste your Excel work to your answer document as an image.) ( 7 marks)