In cell B$44,$ calculate the net working capital for $2017.$

In cell B$45,$ calculate the debt ratio for $2017.$

Copy cell B$44$:B$45$ and paste onto cells C$44$:C$45.$

To prepare the common$-$sized income statement, find the ratio between each account in the income statement and the sales amount.

In cell B$49,$ divide the sales amount by the sales datum in cell E$30$ and make an absolute cell reference to the sales datum for copying and pasting purposes.

Copy cell B$49$ and paste onto the cell ranges B$50$:B$51$ and B$54$:B$58.$

In cell B$52,$ divide the selling, general, and administrative expense by the sales datum in cell E$30$ and make an absolute cell reference to the sales datum for copying and pasting purposes.

Copy cell B$52$ and paste onto the cell B$53.$

To prepare the common$-$sized balance sheet, find the ratio between each account in the balance sheet and the total of the balance sheet.

In cell B$62,$ divide the accounts receivable amount by the total assets datum in cell C$16$ and make an absolute cell reference to the total assets datum for copying and pasting purposes.

Copy cell B$62$ and paste onto the cells B$63$:B$69.$

In cell B$71,$ divide the accounts payable amount by the total liabilities and owners' equity datum in cell C$26$ and make an absolute cell reference to the total liabilities and owners' equity datum for copying and pasting purposes.

Copy cell B$71$ and paste onto the cell ranges B$72$:B$74$ and B$76$:B$79.$

In cell C$83,$ input the net income amount.

Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.

In cell B$84,$ input the depreciation expense.

Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.

In cell B$85,$ calculate the decrease in accounts receivable.

Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.

In cell B$86,$ calculate the increase in inventory.

Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.

In cell B$87,$ calculate the decrease in account payable.

Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.

In cell C$88,$ input the function SUM to calculate the net cash provided by operating activities.

Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.

In cell C$90,$ calculate the increase in plant and equipment.

Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.

In cell B$92,$ calculate the increase in notes payable.

Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.

In cell B$93,$ calculate the dividends amount.

Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.

In cell C$94,$ input the function SUM to calculate the net cash provided by financing activities.

Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.

In cell C$95,$ calculate the net decrease in cash.

Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.

In cell C$96,$ input the beginning cash amount.

In cell C$97,$ calculate the ending cash amount.