Data Analysts Assignment | Professional Writing

Data from the most recent OK and analyst estimates questions 5.10 5. Estimate the net operating profit less adjusted INOPLAT) for Tea 6. Estimate the free cash flow FCF) for Year 1, 2, and 7. Compute the weighted average cost of capital (WACC) 8. Estimate conting value the end of years 9. Estimate the total value of the firm 10. Estimate the intrinsic value per share of the stock Unic: Smillion Today 1.292.0 (992.0) (70.0) 230.0 Revenues 9 Operating costs 10 Depreciation 11 Operating profits Year 1 1.390.0 (1,130.0) (72.0) 1880 Year 2 1.572,0 (1.291.0) (790) 2020 Year 3 1,742.0 (1,449.0) (860) Show your answers to Questions 10 by Aling the banks with correct formules and submit your celle trackboard 2070 Yeri Yar Today Year (6.5) Smillion 13 Interest 14 Earnings before taxes (6.5) 181.5 (6.5) 2005 1955 Increase in working capital (469) 176.5 16 Taxes 17 Net income 18 Operating working capital (381) 143.4 (410) 154.4 (42.1) 158.4 Capital expenditures 64.6 258.40 3230 695 278.00 347.5 786 314.40 393.0 87.1 348.40 435 5 20 Property and equipment 21 Invested capital Equity value Times.

How to Use QuickBooks

Don't use plagiarized sources. Get Your Custom Essay on
Data Analysts Assignment | Professional Writing
Just from $13/Page
Order Essay

Share prices Equity value. S million 1020 23 Debt 24 Shareholders’ equity 1020 245.5 1020 291.0 102.0 33.5 2210 WACC Aer Contribution cost ofteweled Market value, of total capital cost of Marginal capital e , 26 Other available data available for the company 27 Operating profit tax rate 21.09 28 Shares outstanding millions 29 Current share prices 38.00 30 Pretax cost of debt 31 Cost of equity 12.0% 32 The growth rate after Year 3 33 Non operating assets 12 unit: 5 million 34 Source of capital Debt Equity Total Capital Unit: million Free cash flow (FCF) Discounted FCF Conting Pof esplicit FCE ——— TPV of continuine value Questions 5-10 Select destination and press ENTER or choose Paste WACC Market value $ million Proportion of total capital ilable for the company 21.ON 49.0 38.00 6.4% 12.0% cost of Marginal capital, i tax rate, Alerta cost of capital, Contribution to welighted vera Source of capital Debt Equity Total Capital 12 unit:$ million) Unit: $ million 993 Free cash flow (FCF) Discounted FCF Continuing value — PV of explicit FCE_— PV of continuing value PV of operations Midyear adjustment PV of nonoperating assets Total value of the firm Debt Equity value Value per share (Unit:$) Compare this with the stock price ENTER or choose Paste

Get Finance homework help today