Business Finance - Accounting ACC-370 Data Analytics Assignment 2

Sheyla1993

Kieso18e_Ch4_DA4.2_AIA_data_and_student_submission_template.xlsx

Home >Business & Finance homework help >Accounting homework help >Business Finance - Accounting ACC-370 Data Analytics Assignment 2

Data

Company	Symbol	Year	Industry	ECI Key	Net Sales	Net Income	Non-Controlling	Net Income - Controlling	COGS	Total Assets	Last Year Total Assets	Total Liabilities	Last Year Total Liabilities	Total Equity	Last Year Total Equity	Total Current Assets	NonCurrent Assets	Current Liabilities	Last Year Current Liabilities	NonCurrent Liabilities	Accounts Receivable Net	Last Year Accounts Receivable Net	Cash	Short Term Investments	Current Inventory	Last Year Inventory	Net Cash Provided by Operating Activities	Cash Dividends	Preferred Dividends	Preferred Stockholders' Equity	Last Year Preferred Stockholders' Equity	Common Stockholders' Equity	Last Year Common Stockholders' Equity	Market Price (1/2/2018 Open)	Interest Expense	Income Tax Expense	CapEx	Shares Outstanding	Shares Outstanding/1000000	Weighted Average Common Shares Outstanding	Goodwill
3M Co	MMM	2017	Diversified Industrials	66740	$ 31,657	$ 4,869	$ 11	$ 4,858	$ 16,001	$ 37,987	$ 32,906	$ 26,365	$ 22,563	$ 11,622	$ 10,343	$ 14,277	$ 23,710	$ 7,687	$ 6,219	$ 18,678	$ 4,911	$ 4,392	$ 3,053	$ 1,076	$ 4,034	$ 3,385	$ 6,240	$ (2,803)	$ - 0	$ - 0	$ - 0	$ 11,622	$ 10,343	$ 235.78	$ 322	$ 2,679	$ (1,373)	$ 595,500,000	$ 595.50	$ 597.50	$ 10,513
Apple Inc	AAPL	2017	Consumer Electronics	320193	$ 229,234	$ 48,351	$ - 0	$ 48,351	$ 141,048	$ 375,319	$ 321,686	$ 241,272	$ 193,437	$ 134,047	$ 128,249	$ 128,645	$ 246,674	$ 100,814	$ 79,006	$ 140,458	$ 17,874	$ 15,754	$ 20,289	$ 53,892	$ 4,855	$ 2,132	$ 63,598	$ (12,769)	$ - 0	$ - 0	$ - 0	$ 134,047	$ 128,249	$ 170.16	$ (2,323)	$ 15,738	$ (12,451)	$ 5,134,312,000	$ 5,134.31	$ 5,217.24	$ 5,717
Boeing Co	BA	2017	Aerospace & Defense	12927	$ 93,392	$ 8,197		$ 8,197	$ 76,066	$ 92,333	$ 89,997	$ 91,921	$ 89,120	$ 412	$ 877	$ 65,161	$ 27,172	$ 56,269	$ 50,134	$ 35,652	$ 10,516	$ 8,832	$ 8,813	$ 1,179	$ 44,344	$ 43,199	$ 13,344	$ (3,417)	$ - 0	$ - 0	$ - 0	$ 412	$ 877	$ 295.75	$ (360)	$ (1,850)	$ (1,739)	$ 588,490,313	$ 588.49	$ 602.50	$ 5,559
Caterpillar Inc	CAT	2017	Farm & Construction Equipment	18234	$ 45,462	$ 759	$ 5	$ 754	$ 31,049	$ 76,962	$ 74,704	$ 63,196	$ 61,491	$ 13,766	$ 13,213	$ 36,244	$ 40,718	$ 26,931	$ 26,132	$ 36,265	$ 7,436	$ 5,981	$ 8,261		$ 10,018	$ 8,614	$ 5,702	$ (1,831)	$ - 0	$ - 0	$ - 0	$ 13,766	$ 13,213	$ 158.30	$ 646	$ 3,339	$ (898)	$ 597,625,772	$ 597.63	$ 591.80	$ 6,200
Chevron	CVX	2017	Oil and Gas Integrated	93414	$ 134,674	$ 9,269		$ 9,269	$ 75,765	$ 253,806	$ 260,078	$ 104,487	$ 113,356	$ 149,319	$ 146,722	$ 28,560	$ 225,246	$ 27,737	$ 31,785	$ 76,750	$ 15,353	$ 14,092	$ 4,813	$ 9	$ 5,585	$ 5,419	$ 20,515	$ (8,132)	$ - 0	$ - 0	$ - 0	$ 149,319	$ 146,722	$ 125.71	$ 307	$ (48)	$ (13,404)	$ 1,910,253,256	$ 1,910.25	$ 1,897.00	$ 4,531
Cisco	CSCO	2017	Communication Equipment	858877	$ 48,005	$ 9,609		$ 9,609	$ 17,781	$ 129,818	$ 129,818	$ 63,681	$ 58,067	$ 66,137	$ 63,585	$ 83,703	$ 46,115	$ 27,583	$ 24,911	$ 36,098	$ 5,146	$ 5,874	$ 11,708	$ 58,784	$ 1,616	$ 1,217	$ 13,876	$ (5,511)	$ - 0	$ - 0	$ - 0	$ 66,137	$ 63,585	$ 38.67	$ (861)	$ 2,678	$ (964)	$ 4,951,955,851	$ 4,951.96	$ 4,837.00	$ 29,766
Coca-Cola	KO	2017	Beverages - Soft Drinks	21344	$ 35,410	$ 1,283	$ 35	$ 1,248	$ 13,256	$ 87,896	$ 87,896	$ 68,919	$ 64,676	$ 18,977	$ 23,220	$ 36,545	$ 51,351	$ 27,194	$ 26,532	$ 41,725	$ 3,667	$ 3,865	$ 6,006	$ 9,352	$ 2,655	$ 2,675	$ 6,995	$ (6,320)	$ - 0	$ - 0	$ - 0	$ 18,977	$ 23,220	$ 45.91	$ 841	$ 5,560	$ (1,675)	$ 4,265,906,533	$ 4,265.91	$ 4,272.00	$ 9,401
Disney	DIS	2017	Media - Diversified	1001039	$ 55,137	$ 9,366		$ 9,366	$ 30,306	$ 95,789	$ 92,033	$ 50,785	$ 44,710	$ 45,004	$ 47,323	$ 15,889	$ 79,900	$ 19,595	$ 16,842	$ 31,190	$ 8,633	$ 9,065	$ 4,017		$ 1,373	$ 1,390	$ 12,343	$ (2,445)	$ - 0	$ - 0	$ - 0	$ 45,004	$ 47,323	$ 108.95	$ (507)	$ (4,422)	$ (3,623)	$ 1,510,312,194	$ 1,510.31	$ 1,499.00	$ 31,426
Home Depot	HD	2017	Home Improvement Stores	354950	$ 100,904	$ 8,630		$ 8,630	$ 66,548	$ 44,529	$ 42,966	$ 43,075	$ 38,633	$ 1,454	$ 4,333	$ 18,933	$ 25,596	$ 16,194	$ 14,133	$ 26,881	$ 1,952	$ 2,029	$ 3,595		$ 12,748	$ 12,549	$ 12,031	$ (4,212)	$ - 0	$ - 0	$ - 0	$ 1,454	$ 4,333	$ 190.21	$ 1,057	$ 5,068	$ (1,897)	$ 1,157,269,522	$ 1,157.27	$ 1,178.00	$ 2,275
IBM	IBM	2017	Information Technology Services	51143	$ 79,139	$ 5,753		$ 5,753	$ 42,913	$ 125,356	$ 117,470	$ 107,631	$ 99,078	$ 17,725	$ 18,392	$ 49,735	$ 75,621	$ 37,363	$ 36,275	$ 70,268	$ 31,630	$ 29,245	$ 11,972	$ 608	$ 1,583	$ 1,553	$ 16,724	$ (5,506)	$ - 0	$ - 0	$ - 0	$ 17,725	$ 18,392	$ 154.50	$ 615	$ 5,642	$ (3,229)	$ 921,167,894	$ 921.17	$ 932.83	$ 36,788
Intel	INTC	2017	Semiconductors	50863	$ 62,761	$ 9,601		$ 9,601	$ 23,692	$ 123,249	$ 113,327	$ 54,230	$ 47,101	$ 69,019	$ 66,226	$ 29,500	$ 93,749	$ 17,421	$ 20,302	$ 36,809	$ 5,607	$ 4,690	$ 3,433	$ 1,814	$ 6,983	$ 5,553	$ 22,110	$ (5,072)	$ - 0	$ - 0	$ - 0	$ 69,019	$ 66,226	$ 46.38	$ (646)	$ 10,751	$ (11,778)	$ 4,668,000,000	$ 4,668.00	$ 4,959.00	$ 24,389
Johnson & Johnson	JNJ	2017	Drug Manufacturers - Major	200406	$ 76,450	$ 1,300		$ 1,300	$ 25,354	$ 157,303	$ 141,208	$ 97,143	$ 70,790	$ 60,160	$ 70,418	$ 43,088	$ 114,215	$ 30,537	$ 26,287	$ 66,606	$ 13,490	$ 11,699	$ 17,824	$ 472	$ 8,765	$ 8,144	$ 21,056	$ (8,943)	$ - 0	$ - 0	$ - 0	$ 60,160	$ 70,418	$ 139.66	$ 934	$ 16,373	$ (3,279)	$ 2,682,901,553	$ 2,682.90	$ 2,692.00	$ 31,906
McDonalds	MCD	2017	Restaurants	63908	$ 22,820	$ 5,192		$ 5,192	$ 12,200	$ 33,804	$ 31,024	$ 37,072	$ 33,228	$ (3,268)	$ (2,204)	$ 5,327	$ 28,476	$ 2,891	$ 3,468	$ 34,181	$ 1,976	$ 1,474	$ 2,464		$ 59	$ 59	$ 5,551	$ (3,089)	$ - 0	$ - 0	$ - 0	$ (3,268)	$ (2,204)	$ 173.73	921.3	$ 3,381	$ (1,854)	$ 794,497,880	$ 794.50	$ 807.40	$ 2,380
Merck	MRK	2017	Drug Manufacturers - Major	310158	$ 40,122	$ 2,418		$ 2,418	$ 12,775	$ 87,872	$ 95,377	$ 53,303	$ 55,069	$ 34,569	$ 40,308	$ 24,766	$ 63,106	$ 18,614	$ 17,204	$ 34,689	$ 6,873	$ 7,018	$ 6,092	$ 2,406	$ 5,096	$ 4,866	$ 6,447	$ (5,167)	$ - 0	$ - 0	$ - 0	$ 34,569	$ 40,308	$ 56.59	$ (754)	$ 4,103	$ (1,888)	$ 2,696,190,502	$ 2,696.19	$ 2,720.45	$ 18,284
Microsoft	MSFT	2017	Software - Infrastructure	789019	$ 89,950	$ 21,204		$ 21,204	$ 34,261	$ 241,086	$ 193,468	$ 168,692	$ 121,471	$ 72,394	$ 71,997	$ 159,851	$ 81,235	$ 64,527	$ 59,357	$ 104,165	$ 19,792	$ 18,277	$ 7,663	$ 125,318	$ 2,181	$ 2,251	$ 39,507	$ (11,845)	$ - 0	$ - 0	$ - 0	$ 72,394	$ 71,997	$ 86.13	$ (2,222)	$ 1,945	$ (8,129)	$ 7,702,243,979	$ 7,702.24	$ 7,746.00	$ 35,122
Nike	NKE	2017	Footwear & Accessories	320187	$ 34,350	$ 4,240		$ 4,240	$ 19,038	$ 23,259	$ 21,379	$ 10,852	$ 9,121	$ 12,407	$ 12,258	$ 16,061	$ 7,198	$ 5,474	$ 5,358	$ 5,378	$ 3,677	$ 3,241	$ 3,808	$ 2,371	$ 5,055	$ 4,838	$ 3,640	$ (1,133)	$ - 0	$ - 0	$ - 0	$ 12,407	$ 12,258	$ 62.85	$ (86)	$ 646	$ (1,105)	$ 1,643,195,065	$ 1,643.20	$ 1,657.80	$ 139
Pfizer	PFE	2017	Drug Manufacturers - Major	78003	$ 52,546	$ 21,355	$ 47	$ 21,308	$ 11,240	$ 171,797	$ 171,797	$ 100,141	$ 111,957	$ 71,656	$ 59,840	$ 41,141	$ 130,656	$ 30,427	$ 31,115	$ 69,714	$ 8,221	$ 8,225	$ 1,342	$ 18,650	$ 7,578	$ 6,783	$ 16,470	$ (7,659)		$ 21	$ 24	$ 71,656	$ 59,816	$ 36.38	$ 1,270	$ (9,049)	$ (1,956)	$ 5,952,864,751	$ 5,952.86	$ 5,970.00	$ 55,952
Procter & Gamble	PG	2017	Household & Personal Products	80424	$ 65,058	$ 15,411		$ 15,411	$ 32,535	$ 120,406	$ 127,136	$ 64,628	$ 69,153	$ 55,778	$ 57,983	$ 26,494	$ 93,912	$ 30,210	$ 30,770	$ 34,418	$ 4,594	$ 4,373	$ 5,569	$ 9,568	$ 4,624	$ 4,716	$ 12,753	$ (7,236)	$ (247)	$ 1,006	$ 1,038	$ 56,025	$ 56,945	$ 91.92	$ 465	$ 3,063	$ (3,384)	$ 2,550,014,230	$ 2,550.01	$ 2,598.10	$ 44,699
United Technologies	UTX	2017	Aerospace & Defense	101829	$ 59,837	$ 4,920	$ 368	$ 4,552	$ 43,953	$ 96,920	$ 89,706	$ 65,499	$ 60,537	$ 31,421	$ 29,169	$ 32,858	$ 64,062	$ 24,391	$ 21,906	$ 41,108	$ 12,595	$ 11,481	$ 8,985		$ 9,881	$ 8,704	$ 5,631	$ (2,074)	$ - 0	$ - 0	$ - 0	$ 31,421	$ 29,169	$ 127.90	$ 909	$ 2,843	$ (2,014)	$ 799,778,295	$ 799.78	$ 790.00	$ 27,910
United Health	UNH	2017	Health Care Plans	731766	$ 201,159	$ 10,823		$ 10,823	$ 24,112	$ 139,058	$ 122,810	$ 89,225	$ 84,633	$ 49,833	$ 38,177	$ 37,084	$ 101,974	$ 50,463	$ 49,252	$ 38,762	$ 15,830	$ 16,304	$ 11,981	$ 3,509	$ 3,101	$ 3,105	$ 13,596	$ (2,773)	$ - 0	$ - 0	$ - 0	$ 49,833	$ 38,177	$ 221.02	$ (1,186)	$ (3,200)	$ (14,588)	$ 967,662,919	$ 967.66	$ 964.00	$ 54,556
Verizon	VZ	2017	Telecom Services	732712	$ 126,034	$ 30,550		$ 30,550	$ 29,409	$ 257,143	$ 244,180	$ 212,456	$ 220,148	$ 44,687	$ 24,032	$ 29,913	$ 227,230	$ 33,037	$ 30,340	$ 179,419	$ 23,493	$ 17,513	$ 2,079	$ - 0	$ 1,034	$ 1,202	$ 25,305	$ (9,472)	$ - 0	$ - 0	$ - 0	$ 44,687	$ 24,032	$ 53.16	$ (4,733)	$ 9,956	$ (17,247)	$ 4,079,486,153	$ 4,079.49	$ 4,084.00	$ 29,172
Walmart	WMT	2017	Discount Stores	104169	$ 500,343	$ 10,523	$ 661	$ 9,862	$ 373,396	$ 204,522	$ 198,825	$ 123,700	$ 118,290	$ 80,822	$ 80,535	$ 59,664	$ 144,858	$ 78,521	$ 66,928	$ 45,179	$ 5,614	$ 5,835	$ 6,756		$ 43,783	$ 43,046	$ 28,337	$ (6,124)	$ - 0	$ - 0	$ - 0	$ 80,822	$ 80,535	$ 99.30	$ 1,978	$ 4,600	$ (10,051)	$ 2,950,696,818	$ 2,950.70	$ 2,995.00	$ 18,242

Ratios- Student Submission

Graphs & Short Answer Responses

3. Which types of companies tend to have higher rates of asset turnover? 4. What do you notice? Which company doesn’t seem to fit with the others? 5. What trends do you notice among related industries? Does anything surprise you?