Please complete spreadsheet. The company data that should be used as input is Comcast. The fields in yellow should need to be updated, on the 4 workbooks attached to the spreadsheet.

Please answer entirely.

INPUTS FOR VALUATION Current Inputs Enter the current revenues of the firm = Enter current capital invested in the firm = Enter the current depreciation = Enter the current capital expenditures for the firm = Enter the change in Working Capital in last year = Enter beginning shareholder's equity Enter the value of current debt outstanding = Enter the number of shares outstanding = $ 12,406 $ 10,000 (Book Value of Equity + Book Value of Debt) $ 233 $ 298 (you might try an average of the prior 3 years) $ 115 (current assets current liabilities for the most recent year) (current assets current liabilities for the prior year) $ 20,000 $ 10,000 1,500.00 High Growth Period Your Inputs Enter the growth rate in revenues for the next 5 years = 25.00% What will all operating expenses be as a % of revenues in the fifth year? 70.00% (Operating expenses include depreciation: This is equal to (1Pretax Operating Margin)) How much debt do you plan to use in financing investments? Enter the growth rate in capital expenditures & depreciation Enter working capital as a percent of revenues Enter the tax rate that you have on corporate income What beta do you want to use to calculate cost of equity = 50% (you might try an average of the prior 3 years) 25.00% (you might try an average of the prior 3 years) 7.50% (current assets current liabilities) / Revenues 36.00% (you might try an average of the prior 3 years) 1.25 Enter the current long term bond rate = 6.50%