Order 1247404: Final Project Part 3!

FinalProject2.xlsx

Home >Business & Finance homework help >Economics homework help > Order 1247404: Final Project Part 3!

2017 Balance Sheet

APPLE Inc (AAPL)
Exchange rate used is that of the Year End reported date
As Reported Annual Balance Sheet
Report Date	12/31/2017	12/31/2016	12/31/2015
Currency	USD	USD	USD
Audit Status	Not Qualified	Not Qualified	Not Qualified
Consolidated	Yes	Yes	Yes
Scale	Thousands	Thousands	Thousands
Cash	1347155	1126496	1480452
Money market funds	-	330	1602
Cash & cash equivalents	1347155	1126826	1482054
Marketable securities	607991	703454	509032
Accounts receivable trade, gross	266687	500631	142542
Allowance for doubtful accounts	-	2	7108
Accounts receivable trade, net	266687	500629	135434
Accounts receivable, unbilled & retainage	205530	59171	76971
Raw materials	148222	159078	157468
Work in process	13204	19736	20829
Finished goods	302305	309369	442408
Less noncurrent inventories	-100512	-107759	-115617
Inventories	363219	380424	505088
Balance of systems parts	62776	136889	125083
Deferred project costs	701105	187940	29354
Deferred tax assets, net	-	-	91565
Assets held for sale	-	-	20728
Note receivable, affiliate	15000	1276	12487
Prepaid expenses	42007	74990	42193
Prepaid income taxes	35336	-	-
Restricted cash	37154	72526	74695
Value added tax receivables	22308	-	-
Derivative instruments	6078	2691	9791
Other current assets	74274	98770	75991
Total prepaid expenses & other current assets	217157	248977	202670
Total current assets	3786620	3345586	3190466
Land	7839	12063	12378
Buildings & improvements	378981	410898	381925
Machinery & equipment	1444442	1824717	1646841
Office equipment & furniture	147833	144773	134268
Leasehold improvements	53552	50546	50096
Construction in progress	93164	37734	154497
Stored assets	17995	138954	155389
Gross depreciable property, plant & equipment	2143806	2619685	2535394
Less: accumulated depreciation	1514664	1335549	1133090
Property, plant & equipment, net	629142	1284136	1402304
PV solar power systems, net	448601	93741	46393
Project assets & deferred project costs	800770	1111137	810348
Deferred tax assets, net	252655	357693	222326
Restricted cash & investments	371307	333878	407053
Investments in unconsolidated affiliates & joint ventures	242361	399805	255029
Goodwill	14462	84985	84985
Other intangibles, net	87970	110002	119236
Inventories	100512	107759	115617
Note receivable, affiliate	54737	17887	9127
Other assets	78076	69722	61555
Total assets	6867213	7316331	6724439
Accounts payable	148730	337668	214656
Income taxes payable	5288	1330	1727
Accrued compensation & benefits	47877	63699	43072
Accrued property, plant & equipment	14828	7808	30723
Accrued inventory & balance of systems parts	13085	53542	36233
Accrued project assets & deferred project costs	71164	145695	113012
Product warranty liability	40079	38468	69656
Accrued expenses in excess of normal product warranty liability & related expenses	-	5040	7800
Other accrued expenses	75944	95200	87660
Accrued expenses	262977	409452	388156
Current portion of long-term debt	27966	38090	51918
Billings in excess of costs & estimated earnings	115623	87942	195346
Payments & billings for deferred project costs	284440	28580	60591
Deferred revenue	7742	17957	21879
Derivative instruments	6642	16450	7657
Contingent consideration	19620	9233	36817
Financing liability	5219	5277	-
Other current liabilities	15460	8821	22349
Total other current liabilities	54683	57738	88702
Total current liabilities	899707	960800	1001096
Accrued solar module collection & recycling liabilities	166277	163407	246307
Project construction credit facilities	196691	218183	75418
Malaysian Ringgit facility agreement	-	54175	88606
Malaysian Euro facility agreement	-	21869	34112
Malaysian facility agreement	-	5100	25818
Capital lease obligations	562	1065	1558
Long-term debt principal	197253	300392	225512
Less unamortized discount & issuance costs	-8865	-10977	-8591
Total long-term debt	188388	289415	216921
Less: current portion	27966	38090	51918
Long-term debt	160422	251325	165003
Product warranty liability	212329	-	-
Other taxes payable	24099	-	-
Contingent consideration	10472	-	-
Financing liability	33314	-	-
Other liabilities	147906	-	-
Other liabilities	428120	392312	284546
Total liabilities	1654526	1767844	1696952
Common stock	1040000	1020000	1000000
Additional paid-in capital	2759211	2742795	2697558
Retained earnings (accumulated deficit)	2463279	2790110	2279689
Foreign currency translation adjustments	-77178	-69769	-53337
Unrealized gain on marketable securities, net	65171	86884	102299
Unrealized gain (loss) on derivative instruments, net	2100	-1635	1178
Accumulated other comprehensive income (loss)	-9907	15480	50140
Total stockholders' equity	5212687	5548487	5027487
total shares outstanding	5222490	5532905	4977247
References:
AAPL Balance Sheet. (2017, December 31). Retrieved September 15, 2018, from
https://finance.yahoo.com/quote/AAPL/balance-sheet?p=AAPL				industrial average
net income	-357964	546421	396918
debt to equity ratio	1.5908903846	1.7331803922	1.696952	0.53
return on equity= net income/shareholders equity	-0.0686716851	0.0984810814	0.0789495826	0.31	https://www.investing.com/equities/apple-computer-inc-ratios
earnings per share= net income/average shares outstanding	-0.0685427832	0.098758428	0.0797464944	0.25

https://finance.yahoo.com/quote/AAPL/balance-sheet?p=AAPL

2017 Income Statement

APPLE Inc. (AAPL)
Exchange rate used is that of the Year End reported date
As Reported Annual Income Statement
Report Date	12/31/2017	12/31/2016	12/31/20145
Currency	USD	USD	USD
Audit Status	Not Qualified	Not Qualified	Not Qualified
Consolidated	Yes	Yes	Yes
Scale	Thousands	Thousands	Thousands
Net sales	2951328	3578995	3391814
Cost of sales	2247349	2659728	2564709
Gross profit (loss)	703979	919267	827105
Research & development expenses	124762	130593	143969
Selling, general & administrative expenses	261994	255192	253827
Production start-up	1021	16818	5146
Restructuring & asset impairments	818792	-	-
Total operating expenses	1206569	402603	402942
Operating income (loss)	-502590	516664	424163
Foreign currency gain (loss)	-14007	-6868	-3017
Interest income	25193	22516	18030
Interest cost incurred	26157	19367	9997
Interest cost capitalized - property, plant & equipment	1878	1335	2324
Interest cost capitalized - project assets	3741	11057	-
Interest cost capitalized - project assets & deferred project costs	-	-	5691
Interest expense, net	20538	6975	1982
Other income (expenses), net	40252	-5502	-5203
Income (loss) before income taxes - U.S.	-361231	126958	139026
Income (loss) before income taxes - non-U.S.	-110459	392877	292965
Income (loss) before income taxes	-471690	519835	431991
Current federal income tax expense	-7689	20208	15616
Current state income tax expense	1877	4172	1717
Current foreign income tax expense	-29009	23215	6917
Total current income tax expense	-34821	47595	24250
Deferred federal income tax expense (benefit)	115905	-716	2926
Deferred state income tax expense (benefit)	-7343	3118	5133
Deferred foreign income tax expense (benefit)	-15522	-56153	-2185
Total deferred income tax expense (benefit)	93040	-53751	5874
Income tax expense (benefit)	58219	-6156	30124
Equity in earnings of unconsolidated affiliates, net of tax	171945	20430	-4949
Net income (loss)	-357964	546421	396918
Weighted average shares outstanding - basic	102866	100886	100048
Weighted average shares outstanding - diluted	102866	101815	101643
Year end shares outstanding	104034.731	101766.797	100288.942
Net income (loss) per share - basic	-3.48	5.42	3.97
Net income (loss) per share - diluted	-3.48	5.37	3.91
Total number of employees	5400	6350	6060
Number of common stockholders	49	51	20
Investment tax credit	57400	-	-
Foreign currency translation adjustments	-7409	-16432	-
References:
AAPL Income Sheet. (2017, December 31). Retrieved September 15, 2018, from:
https://finance.yahoo.com/quote/AAPL/financials?p=AAPL
profit margin	-0.1212891281	0.152674424	0.1170223367

2017 Cash Flows

APPLE Inc (AAPL)
Exchange rate used is that of the Year End reported date
As Reported Annual Cash Flow
Report Date	12/31/2017	12/31/2016	12/31/2015
Currency	USD	USD	USD
Audit Status	Not Qualified	Not Qualified	Not Qualified
Consolidated	Yes	Yes	Yes
Scale	Thousands	Thousands	Thousands
Cash received from customers	-	-	3366839
Cash paid to suppliers & employees	-	-	-2642306
Interest received	-	-	12966
Interest paid	-	-	-7601
Income tax refunds (payments), net	-	-	-17045
Excess tax benefit from share-based compensation arrangements	-	-	-31166
Other cash flows from operating activities	-	-	-698
Net cash flows from operating activities	-	-	680989
Net income (loss)	-357964	546421	396918
Depreciation, amortization & accretion	230940	257825	245798
Impairment of assets & liabilities	-	-	5228
Impairment & net loss on disposal of long-lived assets	838467	14593	-
Impairment of project assets	-	-	433
Share-based compensation	28712	44899	43810
Equity in earnings of unconsolidated affiliates, net of tax	-171945	-20430	-
Distributions received from equity method investments	18562	-	-
Remeasurement of monetary assets & liabilities	5442	-4043	8772
Deferred income taxes	123864	-17534	14068
Gain on sales of marketable securities & restricted investments	-41632	-	-
Excess tax benefits from share-based compensation arrangements	-	-17707	-31166
Other operating activities	13863	520	6296
Accounts receivable, trade, unbilled & retainage	92747	-340292	453826
Prepaid expenses & other current assets	9574	-38635	-19947
Inventories & balance of systems parts	95785	113537	-99870
Project assets & deferred project costs	-592204	-857529	141908
Other assets	-19423	-8484	-5371
Income taxes receivable & payable	-59640	-13281	-989
Accounts payable	-191642	143872	-52339
Accrued expenses & other liabilities	179610	-85425	-452438
Accrued solar module collection & recycling liability	3637	-79226	26052
Total adjustments	-	-	284071
Net cash flows from operating activities	206753	-360919	680989
Purchases of property, plant & equipment	-229452	-166438	-257549
Proceeds from sale of property, plant & equipment	-	77	1532
Purchase of marketable securities	-422609	-556479	-305396
Proceeds from sales & maturities of marketable securities	525515	353359	227900
Proceeds from sales of equity & cost method investments	291502	-	-
Purchase of equity & cost method investments	-	-27475	-24967
Distributions received from equity method investments	1502	238980	-
Investment in notes receivable, affiliate	-4760	-55163	-72692
Payments received on notes receivable, affiliate	3053	57866	49517
Change in restricted cash	-	44037	-124061
Acquisitions, net of cash acquired	-10272	-	-4306
Other investing activities	-9959	-904	-1857
Net cash flows from investing activities	144520	-112140	-511879
Repayment of borrowings under revolving credit facility	-550000	-	-
Proceeds from borrowings under revolving credit facility	550000	-	-
Repayment of long-term debt	-137367	-47078	-60063
Proceeds from borrowings under long-term debt, net of discount & issuance costs	26816	146027	65563
Repayment of sale-leaseback financing	-5276	-3702	-
Proceeds from sale-leaseback financing	-	44718	-
Excess tax benefit from share-based compensation arrangements	-	17707	31166
Payments of tax withholdings for restricted shares	-20407	-	-
Contingent consideration payments & other financing activities	-159	-20569	-
Other financing activities	-	-	-29307
Net cash flows from financing activities	-136393	137103	7359
Effect of exchange rate changes on cash & cash equivalents	-6306	-19272	-19487
Net increase (decrease) in cash & cash equivalents	208574	-355228	156982
Cash & cash equivalents, beginning of year	1207116	1482054	1325072
Cash & cash equivalents, end of year	1415690	1126826	1482054
References:
AAPL Cash Flows. (2017, December 31). Retrieved September 15, 2018, from https://finance.yahoo.com/quote/AAPL/cash-flow?p=AAPL
free cash flow (operating cash flow-capital expenditure)	(22,699.00)	(527,357.00)	423,440.00

Stock Prices

APPLE Inc (AAPL)
three year period: 1/1/2015 to 31/12/2017
Date	Open	High	Low	Close	Adj Close	Volume	stock return	average
1/1/15	111.389999	120	104.629997	117.160004	109.647324	1304643800	-0.0879651355	-1%
2/1/15	118.050003	133.600006	116.080002	128.460007	120.222733	1136535200	0.0283295441	0.0042305407
3/1/15	129.25	130.279999	121.629997	124.43	116.910706	1138642100	-0.0057532277
4/1/15	124.82	134.539993	123.099998	125.150002	117.587212	996135500	-0.039376702
5/1/15	126.099998	132.970001	123.360001	130.279999	122.407204	954152100	0.0343464262
6/1/15	130.279999	131.389999	124.480003	125.43	118.34256	878512600	0.0340478446
7/1/15	126.900002	132.970001	119.220001	121.300003	114.445923	1057507200	0.0742117539
8/1/15	121.5	122.57	92	112.919998	106.539444	1786018000	0.0191402404
9/1/15	110.150002	116.889999	107.360001	110.300003	104.538551	1206547300	-0.0769873257
10/1/15	109.07	121.220001	107.309998	119.5	113.25798	1112323100	0.0101437238
11/1/15	120.800003	123.82	111	118.300003	112.120659	750640600	0.1190933501
12/1/15	118.75	119.860001	104.82	105.260002	100.188835	921529700	0.0813644057
1/1/16	102.610001	105.849998	92.389999	97.339996	92.650391	1271024100	0.0067223342
2/1/16	96.470001	98.889999	92.589996	96.690002	92.031723	810862600	-0.1176420897
3/1/16	97.650002	110.419998	97.419998	108.989998	104.302032	746049600	0.1626839238
4/1/16	108.779999	112.389999	92.510002	93.739998	89.707985	872396200	-0.0612858396
5/1/16	93.970001	100.730003	89.470001	99.860001	95.564751	900318100	0.0382393913
6/1/16	99.019997	101.889999	91.5	95.599998	92.045006	779055700	-0.0826215432
7/1/16	95.489998	104.550003	94.370003	104.209999	100.334824	685779600	-0.0178135178
8/1/16	104.410004	110.230003	104	106.099998	102.154556	630128500	-0.0665339873
9/1/16	106.139999	116.18	102.529999	113.050003	109.435753	968015600	-0.0043155914
10/1/16	112.709999	118.690002	112.279999	113.540001	109.91008	686914300	0.0273252714
11/1/16	113.459999	113.769997	104.080002	110.519997	106.986641	721305500	-0.0506348474
12/1/16	110.370003	118.019997	108.25	115.82	112.692825	608771700	-0.045570693
1/1/17	115.800003	122.440002	114.760002	121.349998	118.073517	563122000	-0.1141689989
2/1/17	127.029999	137.479996	127.010002	136.990005	133.291245	574968600	-0.0505454426
3/1/17	137.889999	144.5	137.050003	143.660004	140.387177	561628400	0.0000697904
4/1/17	143.710007	145.460007	140.059998	143.649994	140.37738	373304100	-0.0596361823
5/1/17	145.100006	156.649994	144.270004	152.759995	149.279861	653981800	0.0563258249
6/1/17	153.169998	155.979996	142.199997	144.020004	141.319901	684178100	-0.0316679673
7/1/17	144.880005	153.990005	142.410004	148.729996	145.941574	422011900	-0.0931097823
8/1/17	149.100006	164.520004	148.410004	164	160.925293	661069000	0.0599436374
9/1/17	164.800003	164.940002	149.160004	154.119995	151.824387	680374100	-0.0882632259
10/1/17	154.259995	169.649994	152.460007	169.039993	166.522171	504291300	-0.0163515424
11/1/17	169.869995	176.240005	165.279999	171.850006	169.290329	600663400	0.0118445108
12/1/17	169.949997	177.199997	166.460007	169.229996	167.30864	530833500	ERROR:#DIV/0!

Microsoft income statement

Microsoft Corporation
	income statement
Revenue	6/30/17	6/30/16	6/30/15
Total Revenue	96,571,000	91,154,000	93,580,000
Cost of Revenue	33,850,000	32,780,000	33,038,000
Gross Profit	62,721,000	58,374,000	60,542,000
Operating Expenses
Research Development	12,292,000	11,988,000	12,046,000
Selling General and Administrative	18,807,000	19,198,000	20,324,000
Non Recurring	-	-	-
Others	-	-	-
Total Operating Expenses	64,949,000	63,966,000	65,408,000
Operating Income or Loss	31,622,000	27,188,000	28,172,000
Income from Continuing Operations
Total Other Income/Expenses Net	-1,721,000	-1,549,000	-9,665,000
Earnings Before Interest and Taxes	31,622,000	27,188,000	28,172,000
Interest Expense	-2,222,000	-1,243,000	-781,000
Income Before Tax	29,901,000	25,639,000	18,507,000
Income Tax Expense	4,412,000	5,100,000	6,314,000
Minority Interest	-	-	-
Net Income From Continuing Ops	25,489,000	20,539,000	12,193,000
Non-recurring Events
Discontinued Operations	-	-	-
Extraordinary Items	-	-	-
Effect Of Accounting Changes	-	-	-
Other Items	-	-	-
Net Income
Net Income	25,489,000	20,539,000	12,193,000
Preferred Stock And Other Adjustments	-	-	-
Net Income Applicable To Common Shares	25,489,000	20,539,000	12,193,000	19407000
https://finance.yahoo.com/quote/MSFT/financials?p=MSFT
profit margin	0.2639405204	0.2253219826	0.1302949348

balance sheet

Period Ending	6/30/17	6/30/16	6/30/15
Current Assets				price to earnings ratio= share price/earnings per share
Cash And Cash Equivalents	7,663,000	6,510,000	5,595,000			85.54/0.10	855.4
Short Term Investments	125,238,000	106,531,000	90,796,000	average stock outstanding
Net Receivables	22,431,000	18,277,000	17,908,000	186,402,333.33
Inventory	2,181,000	2,251,000	2,902,000
Other Current Assets	5,183,000	6,091,000	5,596,000	earnings per share=net income/average share outstanding
Total Current Assets	162,696,000	139,660,000	122,797,000
Long Term Investments	6,023,000	10,438,000	12,053,000		0.10
Property Plant and Equipment	30,289,000	18,356,000	14,731,000
Goodwill	35,122,000	17,872,000	16,939,000
Intangible Assets	10,106,000	3,733,000	4,835,000
Accumulated Amortization	-	-	-
Other Assets	6,076,000	3,409,000	3,117,000
Deferred Long Term Asset Charges	248,000	219,000	228,000
Total Assets	250,312,000	193,468,000	174,472,000
Current Liabilities
Accounts Payable	7,390,000	6,898,000	6,591,000
Short/Current Long Term Debt	95,527,000	54,541,000	35,384,000
Other Current Liabilities	30,879,000	33,972,000	30,384,000
Total Current Liabilities	55,745,000	59,357,000	49,647,000
Long Term Debt	81,445,000	40,557,000	27,808,000
Other Liabilities	22,986,000	20,796,000	16,934,000
total debt	160,176,000	120,710,000	94,389,000
Minority Interest	-	-	-
Negative Goodwill	-	-	-
Total Liabilities	162,601,000	121,471,000	94,389,000
Stockholders' Equity
Misc. Stocks Options Warrants	-	-	-
Redeemable Preferred Stock	-	-	-
Preferred Stock	-	-	-
Common Stock	69,315,000	68,178,000	68,465,000
Retained Earnings	17,769,000	2,282,000	9,096,000
Treasury Stock	627,000	1,537,000	2,522,000
Capital Surplus	-	-	-
Other Stockholder Equity	627,000	1,537,000	2,522,000
Total Stockholder Equity	87,711,000	71,997,000	80,083,000
Net Tangible Assets	42,483,000	50,392,000	58,309,000
https://finance.yahoo.com/quote/MSFT/balance-sheet/
				industrial average
net profit	25,489,000	20,539,000	12,193,000			https://www.investing.com/equities/microsoft-corp-ratios
debt to equity ratio	1.8261791565	1.676597636	1.1786396614	0.67
return on equity	0.290602091	0.2852757754	0.1522545359	0.208
earnings per share	0.3677270432	0.301255537	0.1780909954	1.49

cash flow

Microsoft cash flow statement
Period Ending	6/30/17	6/30/16	6/30/15
Net Income	25,489,000	20,539,000	12,193,000
Operating Activities, Cash Flows Provided By or Used In
Depreciation	7,800,000	5,878,000	5,400,000
Adjustments To Net Income	1,287,000	6,229,000	10,483,000
Changes In Accounts Receivables	-1,216,000	562,000	1,456,000
Changes In Liabilities	3,901,000	2,653,000	-1,054,000
Changes In Inventories	50,000	600,000	-272,000
Changes In Other Operating Activities	349,000	-2,907,000	1,383,000
Total Cash Flow From Operating Activities	39,507,000	33,325,000	29,668,000
Investing Activities, Cash Flows Provided By or Used In
Capital Expenditures	-8,129,000	-8,343,000	-5,944,000
Investments	-12,511,000	-14,417,000	-12,868,000
Other Cash flows from Investing Activities	-197,000	203,000	-466,000
Total Cash Flows From Investing Activities	-46,781,000	-23,950,000	-23,001,000
Financing Activities, Cash Flows Provided By or Used In
Dividends Paid	-11,845,000	-11,006,000	-9,882,000
Sale Purchase of Stock	-	-	-
Net Borrowings	31,459,000	18,283,000	13,661,000
Other Cash Flows from Financing Activities	-190,000	-369,000	362,000
Total Cash Flows From Financing Activities	8,408,000	-8,393,000	-9,668,000
Effect Of Exchange Rate Changes	19,000	-67,000	-73,000
Change In Cash and Cash Equivalents	1,153,000	915,000	-3,074,000
https://finance.yahoo.com/quote/MSFT/cash-flow?p=MSFT
free cash flow	31,378,000	24,982,000	23,724,000

share price

Microsoft historic share prices
three year period: 1/1/2015 to 31/12/2017
Date	Open	High	Low	Close	Adj Close	Volume	return	average
1/1/15	46.66	47.91	40.349998	40.400002	36.964733	918681100	-0.0786770839
2/1/15	40.59	44.299999	40.23	43.849998	40.121365	655957100	0.0708345214	-2%
3/1/15	43.669998	44.189999	40.540001	40.66	37.467381	822551400	-0.1640623839	0.0035588103
4/1/15	40.599998	49.540001	40.119999	48.639999	44.820786	873936700	0.0379854561
5/1/15	48.580002	48.91	46.02	46.860001	43.180553	631475800	0.0545284861
6/1/15	47.060001	47.77	43.939999	44.150002	40.947735	664339200	-0.0546040788
7/1/15	44.459999	47.400002	43.32	46.700001	43.31279	725458100	0.073069997
8/1/15	46.98	48.41	39.720001	43.52	40.363434	775228000	-0.0231609265
9/1/15	42.169998	45	41.66	44.259998	41.320454	671417600	-0.1591946166
10/1/15	44.75	54.369999	43.75	52.639999	49.143898	856322800	-0.0314627832
11/1/15	52.849998	54.98	52.529999	54.349998	50.74033	662559200	-0.0269266105
12/1/15	54.41	56.849998	53.68	55.48	52.144402	791895100	0.0070793789
1/1/16	54.32	55.389999	49.099998	55.09	51.777847	927433200	0.0827437575
2/1/16	54.880001	55.09	48.189999	50.880001	47.820961	813425300	-0.0853288413
3/1/16	50.970001	55.639999	50.580002	55.23	52.282135	640548300	0.1074794579
4/1/16	55.049999	56.77	49.349998	49.869999	47.208221	697861300	-0.0590565049
5/1/16	50	53	49.459999	53	50.171154	530284000	0.0285689157
6/1/16	52.439999	52.950001	48.040001	51.169998	48.77763	823351500	-0.0972124051
7/1/16	51.130001	57.290001	50.389999	56.68	54.030018	647351200	-0.0135746902
8/1/16	56.599998	58.700001	56.139999	57.459999	54.773552	466729800	-0.0086096048
9/1/16	57.009998	58.189999	55.610001	57.599998	55.249226	526196300	-0.0387182735
10/1/16	57.41	61.369999	56.32	59.919998	57.474541	614211700	-0.0056421844
11/1/16	59.970001	61.41	57.279999	60.259998	57.800663	612034100	-0.0367613803
12/1/16	60.110001	64.099998	58.799999	62.139999	60.006588	513256500	-0.0388245962
1/1/17	62.790001	65.910004	61.950001	64.650002	62.430424	493283800	0.0104720645
2/1/17	64.360001	65.239998	62.75	63.98	61.783424	440701500	-0.0343992383
3/1/17	64.129997	66.190002	63.619999	65.860001	63.98444	489169700	-0.037978407
4/1/17	65.809998	69.139999	64.849998	68.459999	66.510399	433065900	-0.0197594152
5/1/17	68.68	70.739998	67.139999	69.839996	67.851097	517218500	0.0074272094
6/1/17	70.239998	72.889999	68.089996	68.93	67.350868	629584800	-0.0518569428
7/1/17	69.330002	74.419998	68.019997	72.699997	71.0345	469851200	-0.0276848748
8/1/17	73.099998	74.959999	71.279999	74.769997	73.057076	444041200	-0.0015606671
9/1/17	74.709999	75.970001	72.919998	74.489998	73.171272	375983900	-0.1044723029
10/1/17	74.709999	86.199997	73.709999	83.18	81.707436	449950000	-0.0117619022
11/1/17	83.68	85.059998	82.239998	84.169998	82.679909	421926000	-0.0209328528
12/1/17	83.599998	87.5	80.699997	85.540001	84.447639	466203300	ERROR:#DIV/0!