Financial Statement Analysis Project

Part 1 Select a company you are interested in learning more about, then research and find the annual financial statements of the company (this will show two years worth of information). These financial statements are found as part of a bigger report called the 10-K (hint: do a search for the company name 10K). Submit a copy of the balance sheet and income statement.

Part 2 Now that you have the balance sheet and income statement for the company you chose, use those financial statements to compute the following ratios and answer the following analysis question:

Compute for 2 years (the most recent year and year before):Current Ratio; Debt to Assets Ratio; Gross profit rate; Profit Margin

Compute just for the most recent year: Inventory Turnover; Days in Inventory

Show your work for the calculations

Analysis: Describe in ONE paragraph what these ratios tell you about the liquidity, profitability, and solvency of your company

Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, (Amounts in millions, except per share data) 2018 2017

	2018	2017
Revenues: Net sales	$495,761	481,317
Membership and other income	4,582	4,556
otal revenues	500,343	485,573
Costs and expenses: Cost of sales	373,396	361,256
Operating, selling, general and administrative expenses	106,510	101,853
Operating income	20,437	22,764
Interest: Debt	1,978	2,044
Capital lease and financing obligations	352	323
Interest income	(152)	(100)
Loss on extinguishment of debt	3,136	0
Income before income taxes	15,123	20,497
Provision for income taxes	4,600	6,204
Consolidated net income	10,523	14,293
Consolidated net income attributable to noncontrolling interest	(661)	(650)
Consolidated net income attributable to Walmart	9,862	13,643
Net income per common share:
Basic net income per common share attributable to Walmart	3.29	4.40
Diluted net income per common share attributable to Walmart	3.28	4.38
Weighted-average common shares outstanding:
Basic	2,995	3,101
Diluted	3,010	3,112
Dividends declared per common share	2.04	2

Walmart Inc. Consolidated Balance Sheets

ASSETS
Current assets:
Cash and cash equivalents	6,756	6,867
Receivables, net	5,614	5,835
Inventories	43,783	43,046
Prepaid expenses and other	3,511	1,941
Total current assets	59,664	57,689
Property and equipment:	185,154	179,492
Less accumulated depreciation	(77,479)	(71,782)
Property and equipment, net	107,675	107,710
Property under capital lease and financing obligations	12,703	11,637
Less accumulated amortization	(5,560)	(5,169)
Property under capital lease and financing obligations, net	7,143	6,468
Goodwill	18,242	17,037
Other assets and deferred charges	11,798	9,921
Total assets	204,522	198,825
LIABILITIES AND EQUITY Current liabilities:
Short-term borrowings	5,257	1,099
Accounts payable	46,092	41,433
Accrued liabilities	22,122	20,654
Accrued income taxes	645	921
Long-term debt due within one year	3,738	2,256
Capital lease and financing obligations due within one year	667	565
Total current liabilities	78,521	66,928
Long-term debt	30,045	36,015
Long-term capital lease and financing obligations	6,780	6,003
Deferred income taxes and othe	8,354	9,344
Common stock	295	305
Capital in excess of par value	2,648	2,371

Retained earnings 85,107 89,354 Accumulated other comprehensive loss (10,181) (14232) Total Walmart shareholders' equity 77,869 77,798 Noncontrolling interest 2,953 2,737 Total equity 80,822 80,535 Total liabilities and equity $ 204,522 $ 198,825