Complete the requirements using cell references or Excel formulas only $($i$.$e$.$ no hard$-$keyed numbers should be entered, with the exception of $365$ for the average collection and sales period calculations and $2$ for any basic averages$).$

Please provide the cell refrence formulas for each blank. I've provided it down below for easy copy$-$paste into excel.

Excel Case #$3-$ Chapters $13$ and $14$: Statement of Cash Flows and Financial Statement Analysis

A comparative balance sheet and an income statement for Rowan Company are given below:

Rowan Company Rowan Company

Comparative Balance Sheet Income Statement

$($dollars in millions$)$ For the Year Ended December $31$

$($dollars in millions$)$

"Ending

Balance" "Beginning

Balance"

Assets Sales $$4,350$

Current assets: Cost of goods sold $3,470$

Cash and cash equivalents $7091$ Gross margin $880$

Accounts receivable $536572$ Selling and administrative expenses $820$

Inventory $620580$ Net operating income $60$

Total current assets $1,2261,243$ Nonoperating items: Gain on sale of equipment $4$

Property, plant, and equipment $1,7191,656$ Income before taxes $64$

Less accumulated depreciation $640480$ Income taxes $22$

Net property, plant, and equipment $1,0791,176$ Net income $$42$

Total assets $$2,305$ $$2,419$

Liabilities and Stockholders' Equity Additional Information $($dollars in millions$)$:

Current liabilities: $1.$ The company sold equipment:

Accounts payable $205180$ Original cost $$16$

Accrued liabilities $94105$ Accumulated depreciation $$9$

Income taxes payable $7288$ Cash proceeds from the sale $$11$

Total current liabilities $371373$ Gain on the sale $$4$

Bonds payable $180310$

Total liabilities $5516832.$ The company did not issue any new bonds

Stockholders' equity: during the year.

Common stock $8008003.$ The company paid a cash dividend during

Retained earnings $954936$ the year.

Total stockholders' equity $1,7541,7364.$ The company did not complete any common

Total liabilities and stockholders' equity $$2,305$ $$2,419$ stock transactions during the year, but had a

par value per share of: $$10$

Required $1$: Using the indirect method, prepare a statement of cash flows for the year. A $?$ is in each cell you need to enter a formula into.

$*$Check figures you can use: given label for the three activities sections $($cash provided by or used in indicates a positive or negative subtotal$)$;

beginning and ending cash from the balance sheet $($and therefore the change in cash$).*$

Rowan Company Required $2$: Complete the following financial statement ratios.

Statement of Cash Flows Use two decimals where necessary.

$($dollars in millions$)(365$ and $2$ are the only plug numbers you should have!$)$

Operating activities: Free cash flow amount $?$

Net income $?$ Current ratio at the end of the year $?$

Adjustments to convert net income to cash basis: Acid$-$test $($quick$)$ ratio at the end of the year $?$

Depreciation $?$ Accounts receivable turnover $?$

Decrease in accounts receivable $?$ Average collection period $?$ days

Increase in inventory $?($assume all sales are on account$)$

Increase in accounts payable $?$ Inventory turnover $?$

Decrease in accrued liabilities $?$ Average sales period $?$ days

Decrease in income taxes payable $?$ Debt$-$to$-$equity ratio at the end of the year $?$

Gain on sale of equipment $??$ Equity multiplier $?$

Net cash provided by operating activities $?$ Net profit margin percentage $?$

Investing activities: Return on equity percentage $?$

Proceeds from sale of equipment $?$ Average number of common shares outstanding $?$

Additions to property, plant, and equipment $?($leave in thousands$)$

Net cash used in investing activities $?$ Earnings per share $?$

Financing activities: Divided per share $?$

Retired bonds payable $?$ Dividend payout ratio $?$

Cash dividends $?$

Net cash used in financing activites $?$

Net decrease in cash $?$

Beginning cash and cash equivalents $?$

Ending cash and cash equivalents $?$