Order 1247404: Final Project Part 3!

tutorthammy
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!