edhtml59781337910224&snapshotdE22219148 Id=10749337608 Google SMS Southwest @ Shih Chih) a Amazoncom Onli Search Results C Explain Several Z SEE Checkout - Americ My Cart NDTAP Free Cash Flows Wisat is the net operating profit after taxes (NOPAT) for 2018? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1.200,000. Do not round intermediate calculations. Round your answer to one dedmal place. s x million b. What are the amounts of net operating working capital for both years? Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2. not 1,200,000. Do not round intermediate calculations, Round your answers to one decimal place. 2018$ x million 20175 x million c. What are the amounts of total net operating capital for both years? Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2. not 1,200,000. Do not round intermediate calculations Round your answer to one decimal place. 2018$ 8 million 2017 5 82 million d. What is the free cash flow for 2018? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2. not 1.200,000. Do not round intermediate calculations. Round your answer to one decimal place. 5 million e. What is the ROIC for 20187 Round your answer to one decimal place f. How much of the FCF did Rhodes use for each of the following purposes: after-tax interest, net debt repayments, dividends, net stock repurchases, and net purchases of short-term investments? (Hint: Remember that a net use can be negative.) Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round Intermediate calculations. Round your answers to one decimal place After tax interest payment $ 2 million Reduction increase) in debt $ x million Payment of dividends $ x million D Repurchase (Issue) stock $ million Purchase (Sale) of short-term 5 1x million Investments CO about:blank ex M Gmail o YouTube EEG EN - Google 20 SMSU | Southwest - Shih Chil Excel Review Tell me what you want to do File Formulas Insert View Help Home Data Cut Calibri 11 A A = Paste Le Copy Format Painter B LU Dab A Alignment Undo Font Clipboard M28 Free Cash Flows 2 Kall dollar values are provided in millions 2018 Sales, ST Invest, Notes Pay LT Debt factor increase 5. Operating costs as % of sales 6 Cash factor increase 7 Accts. Rec factor increase & Inventory factor increase 9 Net Plant & Equip factor increase 10 Accts Pay factor increase 11 Accruals factor increase 12 13 Depreciation as % of Net Plant & Equip 14 Interest rate 15 Tax rate 16 Payout rate 1.25 75.00% 1.10 1.15 1.10 1.15 1.20 1.25 2017 Sales Cash as % of sales Accts Rec as % of sales Inventory as % of sales Net Plant & Equip as % of sales Accts Pay as % of sales Accruals as % of Sales $2.000 120% 14.009 21.00% 26.00% 7.00% 6.00% 10.00% 10.00% 40.00% 90.00% Operating cost as % of sales 85009 Depreciation as % of Net Plant & Equip 10.00% Interest rate 10.0096 Tax rate ex fate 40.00% Payout rate 80.00% % Short-term investments as % of sales 0.50% Notes payable as % of sales 2.00% Long-term debt as % of sales 20.00% Retained earnings multiple factor 1.50 21 22 Income Statements 2B Sales 24 Operating costs excluding depreciation 25 Depreciation and amortization 26 Earnings before interest and faces Less interest 28 Pre-tax income Taxes 30 Net Income available to common stockholders 31. Common dividends 2018 52 500.0 1.875.0 598 55652 53.8 S5115 2017 $2.000.0 1,700.0 520 $2480 430 $2050 820 $1230 $98.4 204.6 5306 9 52762 2018 2017 35 Balance Sheets 34 Assets Cash Short-term investments Accounts receivable inventores Total current assets $26.4 125 3220 462.0 58229 5240 100 280.0 420.0 S7340 A Sheet1 + Calculation Mode: Automatic Workbook Statistics Help Tell me what you want to do 29 W [b Copy ab Alignment $ Excel e Home Insert Formulas Data Review View X Cut Calibri 11 A " Paste B Format Painter UD So Clipboard Font 8 C D inventories 4520 420.0 Total current assets 5822.9 $734,0 Net plant and equipment 5980 520.0 Total assets 51.420.9 $1,2540 Liabilities and Equity Accounts payable $140.0 $ 5 Accruals 150 0 120.0 Notes payable 50.0 40.0 Total cutrent liabilities $3000 6 Long-term debt 500.0 400.0 19 Total liabilities S868,0 S7000 so common stock 4853 517.1 51 Retained earnings 67.6 36.9 52 Total common equity 55529 55540 53 Total liabilities and equity $1.420 9 $12540 54 55 FORMULAS 55 NOPAT 51680 #NIA 58 NOW 59 NOW NA ENIA Total net operating capital 52 Total net operating capital NA ANIA #NA 54 Free cash flow 65 55ROIC NA E6 Uses of free cash flow After-tax interest payment 10 Reduction (increase in debt 21 Payment of dividends 72- Repurchase issue) stock Purchase (sale) of short-term investments Total ANA NA UA A ONA SNA Sheet1 + Calculation Mode: Automatic Workbook Statistics edhtml59781337910224&snapshotdE22219148 Id=10749337608 Google SMS Southwest @ Shih Chih) a Amazoncom Onli Search Results C Explain Several Z SEE Checkout - Americ My Cart NDTAP Free Cash Flows Wisat is the net operating profit after taxes (NOPAT) for 2018? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1.200,000. Do not round intermediate calculations. Round your answer to one dedmal place. s x million b. What are the amounts of net operating working capital for both years? Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2. not 1,200,000. Do not round intermediate calculations, Round your answers to one decimal place. 2018$ x million 20175 x million c. What are the amounts of total net operating capital for both years? Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2. not 1,200,000. Do not round intermediate calculations Round your answer to one decimal place. 2018$ 8 million 2017 5 82 million d. What is the free cash flow for 2018? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2. not 1.200,000. Do not round intermediate calculations. Round your answer to one decimal place. 5 million e. What is the ROIC for 20187 Round your answer to one decimal place f. How much of the FCF did Rhodes use for each of the following purposes: after-tax interest, net debt repayments, dividends, net stock repurchases, and net purchases of short-term investments? (Hint: Remember that a net use can be negative.) Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round Intermediate calculations. Round your answers to one decimal place After tax interest payment $ 2 million Reduction increase) in debt $ x million Payment of dividends $ x million D Repurchase (Issue) stock $ million Purchase (Sale) of short-term 5 1x million Investments CO about:blank ex M Gmail o YouTube EEG EN - Google 20 SMSU | Southwest - Shih Chil Excel Review Tell me what you want to do File Formulas Insert View Help Home Data Cut Calibri 11 A A = Paste Le Copy Format Painter B LU Dab A Alignment Undo Font Clipboard M28 Free Cash Flows 2 Kall dollar values are provided in millions 2018 Sales, ST Invest, Notes Pay LT Debt factor increase 5. Operating costs as % of sales 6 Cash factor increase 7 Accts. Rec factor increase & Inventory factor increase 9 Net Plant & Equip factor increase 10 Accts Pay factor increase 11 Accruals factor increase 12 13 Depreciation as % of Net Plant & Equip 14 Interest rate 15 Tax rate 16 Payout rate 1.25 75.00% 1.10 1.15 1.10 1.15 1.20 1.25 2017 Sales Cash as % of sales Accts Rec as % of sales Inventory as % of sales Net Plant & Equip as % of sales Accts Pay as % of sales Accruals as % of Sales $2.000 120% 14.009 21.00% 26.00% 7.00% 6.00% 10.00% 10.00% 40.00% 90.00% Operating cost as % of sales 85009 Depreciation as % of Net Plant & Equip 10.00% Interest rate 10.0096 Tax rate ex fate 40.00% Payout rate 80.00% % Short-term investments as % of sales 0.50% Notes payable as % of sales 2.00% Long-term debt as % of sales 20.00% Retained earnings multiple factor 1.50 21 22 Income Statements 2B Sales 24 Operating costs excluding depreciation 25 Depreciation and amortization 26 Earnings before interest and faces Less interest 28 Pre-tax income Taxes 30 Net Income available to common stockholders 31. Common dividends 2018 52 500.0 1.875.0 598 55652 53.8 S5115 2017 $2.000.0 1,700.0 520 $2480 430 $2050 820 $1230 $98.4 204.6 5306 9 52762 2018 2017 35 Balance Sheets 34 Assets Cash Short-term investments Accounts receivable inventores Total current assets $26.4 125 3220 462.0 58229 5240 100 280.0 420.0 S7340 A Sheet1 + Calculation Mode: Automatic Workbook Statistics Help Tell me what you want to do 29 W [b Copy ab Alignment $ Excel e Home Insert Formulas Data Review View X Cut Calibri 11 A " Paste B Format Painter UD So Clipboard Font 8 C D inventories 4520 420.0 Total current assets 5822.9 $734,0 Net plant and equipment 5980 520.0 Total assets 51.420.9 $1,2540 Liabilities and Equity Accounts payable $140.0 $ 5 Accruals 150 0 120.0 Notes payable 50.0 40.0 Total cutrent liabilities $3000 6 Long-term debt 500.0 400.0 19 Total liabilities S868,0 S7000 so common stock 4853 517.1 51 Retained earnings 67.6 36.9 52 Total common equity 55529 55540 53 Total liabilities and equity $1.420 9 $12540 54 55 FORMULAS 55 NOPAT 51680 #NIA 58 NOW 59 NOW NA ENIA Total net operating capital 52 Total net operating capital NA ANIA #NA 54 Free cash flow 65 55ROIC NA E6 Uses of free cash flow After-tax interest payment 10 Reduction (increase in debt 21 Payment of dividends 72- Repurchase issue) stock Purchase (sale) of short-term investments Total ANA NA UA A ONA SNA Sheet1 + Calculation Mode: Automatic Workbook Statistics