Excel Online Activity: Free Cash Flows

Question $1$

O$/20$

Submit

Excel Online Structured Activity: Free Cash Flows

The data for Rhodes Corporation's has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Open spreadsheet Round your answer to one decimal place.

$ $$ 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\mathrm{.}2$ million should be entered as $1\mathrm{.}2,$ not $1,200,000.$ Do not round intermediate calculations. Round your answers to one decimal place.

$2018$$ $$ million

$2017$ $ $$ 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\mathrm{.}2$ million should be entered as $1\mathrm{.}2,$ not $1,200,000.$ Do not round intermediate calculations. Round your answers to one decimal place.

$2018$$ $$ million

$2017$ $ $$ million decimal place. $$

$ million

e$.$ What is the ROIC for $2018?$ Round your answer to one decimal place. $$

$\%$ net use can be negative.$)$ Enter your answers in millions. For example, an answer of $$1\mathrm{.}2$ million should be entered as $1\mathrm{.}2,$ not $1,200,000.$ Do not round intermediate calculations. Round your answers to one decimal place.

After$-$tax interest payment

$ $$ million Reduction $($increase$)$ in debt

$ $$ million

Payment of tlividends

Repurchase $($Issue$)$ stock

$ million $$ million

Purchase $($Sale$)$ of short$-$term investments

$ million