Excel Online Structured Actlvity? Free Cash Flowi The data for Rhodes Corporation's has been collected in the Microsoft Excel Ontine file beiow, Open the spreadsheet and perform the required analysis to answer the questions below. a. What is the net operating profit after taxes (NOPAT) for 2018? Enter your answer in millions. For example, an answer of 31.2 million should be entered as 1.2, not 1,200,000. Do not round intermedlate calculations. Round your answer to one decimal place. 5 million b. What are the amounts of net operating working capital for both years? Enter your answers in millions. For example, an answer of 51.2 milion should be entered as 1.2 , not 1,200,000. Do not round intermediate calculations. Raund your answers to one decimal place. c. What are the amounts of total net operating capital for both years? Enter your answers in milions. 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. d. What is the free cash flow for 2018? Enter your answer in millions. For example, an answer of 51.2 milion sthould be entered as 1,2, not 1,200,000. Do not round intermediate calculations. Pound your answer to one decimal place. $ million e. What is the ROIC for 2018 ? Round your answer to one decimal place. e. What is the ROIC for 2018 ? Round your answer to one decimal place. 1. 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 mullions. For exampie, 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. Free Cash Flows (Ali dollar values are provided in milions) i21 22. Inoome Stetements: 21. Sales 24 Qeerating coste excluding depreciation 25. Depreciation and amortization 26: Earnings before interest and taxes 27 Less interest. 28 Pre-tax incorte tr Tares 30 Net income avalable to common stockholders 31. Common dividends 33 Balance Sheeta. 34. Assets 35 Cash 36 Short term investwents 32 Accounte recelivatle 38 triectocien 39 Tolal current assets 40 Net piant and egulpment 41 Total assets \begin{tabular}{|r|r|} \hline 2018 & \multicolumn{1}{|c|}{2017} \\ \hline 5158.9 & 599.0 \\ \hline 51.8 & 45.0 \\ \hline 1,588.0 & 1.0600 \\ \hline 2.2680 & 1.890 .0 \\ \hline 13.696 .7 & $3,114.0 \\ \hline 2.358 .3 & 1.690 .0 \\ \hline 55.979 .2 & 35.0040 \\ \hline \end{tabular} 42. 43 Libustes and Equity i4 Accounts paryable 45 Accruals 46 Notes payable 4?. Total currect liabliles 45 Long-tem debl. 47. Total liabilfies 10 Common ibocki -51 Retained ebinirgs. 3. Total commen topury 3) Total iatiltes and ecijty 34 36. hopht mo: 14. Nowichin 34 HGWC mit Excel Online Structured Actlvity? Free Cash Flowi The data for Rhodes Corporation's has been collected in the Microsoft Excel Ontine file beiow, Open the spreadsheet and perform the required analysis to answer the questions below. a. What is the net operating profit after taxes (NOPAT) for 2018? Enter your answer in millions. For example, an answer of 31.2 million should be entered as 1.2, not 1,200,000. Do not round intermedlate calculations. Round your answer to one decimal place. 5 million b. What are the amounts of net operating working capital for both years? Enter your answers in millions. For example, an answer of 51.2 milion should be entered as 1.2 , not 1,200,000. Do not round intermediate calculations. Raund your answers to one decimal place. c. What are the amounts of total net operating capital for both years? Enter your answers in milions. 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. d. What is the free cash flow for 2018? Enter your answer in millions. For example, an answer of 51.2 milion sthould be entered as 1,2, not 1,200,000. Do not round intermediate calculations. Pound your answer to one decimal place. $ million e. What is the ROIC for 2018 ? Round your answer to one decimal place. e. What is the ROIC for 2018 ? Round your answer to one decimal place. 1. 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 mullions. For exampie, 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. Free Cash Flows (Ali dollar values are provided in milions) i21 22. Inoome Stetements: 21. Sales 24 Qeerating coste excluding depreciation 25. Depreciation and amortization 26: Earnings before interest and taxes 27 Less interest. 28 Pre-tax incorte tr Tares 30 Net income avalable to common stockholders 31. Common dividends 33 Balance Sheeta. 34. Assets 35 Cash 36 Short term investwents 32 Accounte recelivatle 38 triectocien 39 Tolal current assets 40 Net piant and egulpment 41 Total assets \begin{tabular}{|r|r|} \hline 2018 & \multicolumn{1}{|c|}{2017} \\ \hline 5158.9 & 599.0 \\ \hline 51.8 & 45.0 \\ \hline 1,588.0 & 1.0600 \\ \hline 2.2680 & 1.890 .0 \\ \hline 13.696 .7 & $3,114.0 \\ \hline 2.358 .3 & 1.690 .0 \\ \hline 55.979 .2 & 35.0040 \\ \hline \end{tabular} 42. 43 Libustes and Equity i4 Accounts paryable 45 Accruals 46 Notes payable 4?. Total currect liabliles 45 Long-tem debl. 47. Total liabilfies 10 Common ibocki -51 Retained ebinirgs. 3. Total commen topury 3) Total iatiltes and ecijty 34 36. hopht mo: 14. Nowichin 34 HGWC mit
