Excel Online Structured Activity: Cash Flows The data for thodes Corporation's has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analyses to answer the questions below Open-spreadsheet a. What is the net operating profit after taxes (NOPAT) for 20187 Enter your answer in milion. For example, waswer of $1.2 million should be entre as 1.2 not 1,200,000. Do not found intermediate calculations. Round your answer to one deomal place 5 million b. What are the amounts of net operating working capital for both years? Enter your answers in million. For example, on newer of 1.2 million should be entered a 12. not 1.200,000. Do not round intermediate caktion. Round your answers toond decomal poo 2018.5 million 20175 t. What are the arrigunts of total net operating capital for both yean? Enter your answers in million. For example, an answer of 1.2 million should be entered as 1.2. no 1,200,000. Do not round intermediate colorations. Found your answers to one decimal place 2018 5 2017 milinn Neu! Free Cash Flows 0 X 2018 20175 million A- d. What is the free cash flow for 2018 Enter your answer million for men 2 million shoulders 12. no 1.200,000). Dentru termediate calculation Round your toon decimal plan 5 million . What is the ROIC for 2018 Hound your answer to the decimal place How much of the For did hodes for wach of the following purpose, video post purchase a short term investments? Ho Remember that can be giver your mom forcamp should be entered as 12. no 1,200,000. Do not found remediate calculation found you were to be damals million mi S. $ $ After tax interese payment Reduction (increase) detit Payment of dividende Repurchase Chessbock Purchase (Sale) of short investments 5 million 5 man Chock My Work Reset Potem 1156 2017 1.25 1000 1.10 1 Free Cash Flow 2 All done provided in one 2018 1 Sales ST Invest, Notes Pay LT Debit factor increase Operating costs as of saks Cach factor increase Acts Rec factor incre # Inventory factor increase 9 Not Plant & Equin factor increase 10 Acts Pay factor increase 11 Accruals factor increase 12 1 Deprecation as of Net Plant & Equip 14 interest rate 15 Tax rato 16 Payout rate 17 13 19 20 1.20 1 55 1.25 1.20 1.20 Cash of A Rocks Inventory as of sales No Plan & Equiposofos Acchi Pays of Accruals as of Sales $4.500 1 10% 12.00 2000 23.00 700 7004 > 10.00% 1000 40.00% 0000 Oporate costs of Depreciation of Net Phant & Eque Interest rate Tax rate Payout rate Short.com investments of sales Notes payable of ng bit of Sales Rotandaning multiple factor 15001 10 001 1000 10.000 B000 0.50 2006 20.00 1.50 22 Income Statements: 23 Sales 24 Operating costs cacing deprecation 2011 $5,6250 25000 2017 $4,500,0 3.825.0 Sheet1 + B 2017 54500 3050 1005 55715 2018 55.0 45000 1204 $9960 1200 38747 3490 5524 542 22 Income Statem 2 24 Oporating costing depresion 2 Depreciation and on 75 Enmings before and times 27 Lost 25 PM 29 Thes 30. Not income to common stockholders Come dividends 32 33 Balance Sheet 34 Assets Cash Shortman 37 Accounts receive 3 Inventores 19 Total rentals 40 Netplant and 11 Totalsts 54743 1000 5214 52279 > 2015 2011 $545 201 6480 1.100 10203 1 2933 332146 1495 325 5400 1.6.0 1670 100 12.00 43 Lied Equity 46 Accounts $3780 3150 Sheet1 + With Calon Mode Auto P ORI Ari ID BE 959 3 0 and SOOV 53750 OSIES 3150 1125 100 57200 SA espai Totab Long to 45 Total Commons 11 nedos conto 3 Tondeu 54 55 56 NON S 58 NOWO 99 NOW FO 61 Total neid 1,1250 51,0935 3083 1319 $1,22111 532146 0.000 DI GO 351 510620 20 FORMULAS VNI WA 64 ogshow + Sheet CMAWOS
