Excel Ratio File Spreadsheet

Using the SEC Financial Statements Ratios and Calculations, prepare a ratio analysis of your SEC corporations current and prior years financial statements. In addition to presenting the year to year profit and loss balance sheet variances, calculate inventory turnover, operating margin, working capital and operating margin. Explain the value of understanding why inventory balances, inventory turnover, cost of goods sold, operating margin and working capital are important metrics for Cost Accounting.

HP Inc

Consolidated Balance Sheets - USD ($) $ in Millions	Oct. 31, 2018	Oct. 31, 2017
Current assets:
Cash and cash equivalents	$ 5,166	$ 6,997
Accounts receivable, net	5,113	4,414
Inventory	6,062	5,786
Other current assets	5,046	5,121
Total current assets	21,387	22,318
Property, plant and equipment, net	2,198	1,878
Goodwill	5,968	5,622
Other non-current assets	5,069	3,095
Total assets	34,622	32,913
Current liabilities:
Notes payable and short-term borrowings	1,463	1,072
Accounts payable	14,816	13,279
Employee compensation and benefits	1,136	894
Taxes on earnings	340	214
Other accrued liabilities	7,376	6,953
Total current liabilities	25,131	22,412
Long-term debt	4,524	6,747
Other non-current liabilities	5,606	7,162
Commitments and contingencies
Stockholders deficit:
Preferred stock, $0.01 par value (300 shares authorized; none issued)	0	0
Common stock, $0.01 par value (9,600 shares authorized; 1,560 and 1,650 shares issued and outstanding at October 31, 2018, and 2017 respectively)	16	16
Additional paid-in capital	663	380
Accumulated deficit	(473)	(2,386)
Accumulated other comprehensive loss	(845)	(1,418)
Total stockholders deficit	(639)	(3,408)
Total liabilities and stockholders deficit	$ 34,622	$ 32,913