Finish the part 3 and 4 combain with part 1 &2. Separate the part 3 and part 4. The Part 4 needs 9 pages. Part 3 needs about 1000 words ( 3 pages).

profileMichelle_Michy
20200802192936part_2.xlsx
Home>Business & Finance homework help>Management homework help>Finish the part 3 and 4 combain with part 1 &2. Separate the part 3 and part 4. The Part 4 needs 9 pages. Part 3 needs about 1000 words ( 3 pages).

AAPL IS

Apple Inc.
CONSOLIDATED STATEMENTS OF OPERATIONS
(In millions, except number of shares which are reflected in thousands and per share amounts)
Years ended
September 28, September 29, September 30,
2019 2018 2017
Net sales:
   Products 213,883 225,847 196,534
   Services 46,291 39,748 32,700
Total net sales 260,174 265,595 229,234
Cost of sales:
   Products 144,996 148,164 126,337
   Services 16,786 15,592 14,711
Total cost of sales 161,782 163,756 141,048
Gross margin 98,392 101,839 88,186
Operating expenses:
Research and development 16,217 14,236 11,581
Selling, general and administrative 18,245 16,705 15,261
Total operating expenses 34,462 30,941 26,842
Operating income 63,930 70,898 61,344
Other income/(expense), net 1,807 2,005 2,745
Income before provision for income taxes 65,737 72,903 64,089
Provision for income taxes 10,481 13,372 15,738
Net income 55,256 59,531 48,351
Earnings per share:
Basic 11.97 12.01 9.27
Diluted 11.89 11.91 9.21
Shares used in computing earnings per share:
Basic 4,617,834 4,955,377 5,217,242
Diluted 4,648,913 5,000,109 5,251,692

AAPL BS

Apple Inc.
CONSOLIDATED BALANCE SHEETS
(In millions, except number of shares which are reflected in thousands and par value)
September 28, September 29,
2019 2018
ASSETS:
Current assets:
Cash and cash equivalents 48,844 25,913
Marketable securities 51,713 40,388
Accounts receivable, net 22,926 23,186
Inventories 4,106 3,956
Vendor non-trade receivables 22,878 25,809
Other current assets 12,352 12,087
Total current assets 162,819 131,339
Non-current assets:
Marketable securities 105,341 170,799
Property, plant and equipment, net 37,378 41,304
Other non-current assets 32,978 22,283
Total non-current assets 175,697 234,386
Total assets 338,516 365,725
LIABILITIES AND SHAREHOLDERS’ EQUITY:
Current liabilities:
Accounts payable 46,236 55,888
Other current liabilities 37,720 33,327
Deferred revenue 5,522 5,966
Commercial paper 5,980 11,964
Term debt 10,260 8,784
Total current liabilities 105,718 115,929
Non-current liabilities:
Term debt 91,807 93,735
Other non-current liabilities 50,503 48,914
Total non-current liabilities 142,310 142,649
Total liabilities 248,028 258,578
Commitments and contingencies
Shareholders’ equity:
Common stock and additional paid-in capital, $0.00001 par value: 12,600,000 shares authorized; 4,443,236 and 4,754,986 shares issued and outstanding, respectively 45,174 40,201
Retained earnings 45,898 70,400
Accumulated other comprehensive income/(loss) -584 -3,454
Total shareholders’ equity 90,488 107,147
Total liabilities and shareholders’ equity 338,516 365,725

AAPL Ratio

Inventory Turnover 2019 2018 Current ratio 2019 2018
COGS 161,782 163,756 Current assets 162,819 131,339
Inventory 4,106 3,956 Current liability 105,718 115,929
Inventory Turnover 39.40 41.39 Ratio 1.54 1.13
Days of inventory Quick ratio
Days 360 360 Current assets 158,713 127,383
Inventory turnover 39.4013638578 41.3943377149 Current liability 105,718 115,929
Days of inventory 9 9 Ratio 1.50 1.10
Accounts receivable Turnover 2019 2018
Sales 260,174 265,595
Account receivable 22,926 23,186
Turnover 11.35 11.45
Days of inventory
Days 360 360
Inventory turnover 11.35 11.45
Days of inventory 32 31
Debt to equity Return on equity 2019 2018
Debt 102,067 102,519 Net income 55,256 59,531
Equity 90,488 107,147 Equity 90,488 107,147
Debt to equity ratio 1.13 0.96 Debt to equity ratio 0.61 0.56
Debt to total assets Net profit margin
Debt 102,067 102519 Net profit 55,256 59531
Total assets 338,516 365,725 Sales 260,174 265,595
Ratio 0.30 0.28 Ratio 0.21 0.22

AT&T IS

Consolidated Statements of Income
2019 2018 2017
Operating Revenues
Service $ 163,499 152,345 145,597
Equipment 17,694 18,411 14,949
Total operating revenues 181,193 170,756 160,546
Operating Expenses
Cost of revenues
Equipment 18,653 19,786 18,709
Broadcast, programming and operations 31,132 26,727 21,159
Other cost of revenues (exclusive of depreciation
and amortization shown separately below) 34,356 32,906 37,942
Selling, general and administrative 39,422 36,765 35,465
Asset abandonments and impairments 1,458 46 2,914
Depreciation and amortization 28,217 28,430 24,387
Total operating expenses 153,238 144,660 140,576
Operating Income 27,955 26,096 19,970
Other Income (Expense)
Interest expense -8,422 -7,957 -6,300
Equity in net income (loss) of affiliates 6 -48 -128
Other income (expense) – net -1,071 6,782 1,597
Total other income (expense) -9,487 -1,223 -4,831
Income Before Income Taxes 18,468 24,873 15,139
Income tax (benefit) expense 3,493 4,920 -14,708
Net Income 14,975 19,953 29,847
Less: Net Income Attributable to Noncontrolling Interest -1,072 -583 -397
Net Income Attributable to AT&T $ 13,903 19,370 29,450
Less: Preferred Stock Dividends -3 - -
Net Income Attributable to Common Stock $ 13,900 19,370 29,450
Basic Earnings Per Share Attributable to Common Stock $ 1.9 2.85 4.77
Diluted Earnings Per Share Attributable to Common Stock $ 1.89 2.85 4.76
The accompanying notes are an integral part of the consolidated financial statements.

AT&T BS

Consolidated Balance Sheets
December 31,
2019 2018
Assets
Current Assets
Cash and cash equivalents 12,130 5,204
Accounts receivable - net of allowances for doubtful accounts of $1,235 and $907 22,636 26,472
Prepaid expenses 1,631 2,047
Other current assets 18,364 17,704
Total current assets 54,761 51,427
Noncurrent inventories and theatrical film and television production costs 12,434 7,713
Property, Plant and Equipment – Net 130,128 131,473
Goodwill 146,241 146,370
Licenses – Net 97,907 96,144
Trademarks and Trade Names – Net 23,567 24,345
Distribution Networks – Net 15,345 17,069
Other Intangible Assets – Net 20,798 26,269
Investments in and Advances to Equity Affiliates 3,695 6,245
Operating lease right-of-use assets 24,039 -
Other Assets 22,754 24,809
Total Assets 551,669 531,864
Liabilities and Stockholders’ Equity
Current Liabilities
Debt maturing within one year 11,838 10,255
Accounts payable and accrued liabilities 45,956 43,184
Advanced billings and customer deposits 6,124 5,948
Accrued taxes 1,212 1,179
Dividends payable 3,781 3,854
Total current liabilities 68,911 64,420
Long-Term Debt 151,309 166,250
Deferred Credits and Other Noncurrent Liabilities
Deferred income taxes 59,502 57,859
Postemployment benefit obligation 18,788 19,218
Operating lease liabilities 21,804 -
Other noncurrent liabilities 29,421 30,233
Total deferred credits and other noncurrent liabilities 129,515 107,310
Stockholders’ Equity
Preferred stock ($1 par value, 5% cumulative, 10,000,000 authorized, 48,000 shares issued
and outstanding at December 31, 2019 and 0 issued and outstanding at December 31, 2018) - -
Common stock ($1 par value, 14,000,000,000 authorized at December 31, 2019 and
December 31, 2018: issued 7,620,748,598 at December 31, 2019 and at December 31, 2018) 7,621 7,621
Additional paid-in capital 126,279 125,525
Retained earnings 57,936 58,753
Treasury stock (366,193,458 at December 31, 2019 and 339,120,073 at December 31, 2018,
at cost) -13,085 -12,059
Accumulated other comprehensive income 5,470 4,249
Noncontrolling interest 17,713 9,795
Total stockholders’ equity 201,934 193,884
Total Liabilities and Stockholders’ Equity 551,669 531,864
The accompanying notes are an integral part of the consolidated financial statements.

AT&T Ratio

Inventory Turnover 2019 2018 Current ratio 2019 2018
COGS 49,785 46,513 Current assets 54,761 51,427
Inventory 18,364 17,704 Current liability 68,911 64,420
Inventory Turnover 2.71 2.63 Ratio 0.79 0.80
Days of inventory Quick ratio
Days 360 360 Current assets 36,397 33,723
Inventory turnover 2.7110106731 2.6272593764 Current liability 68,911 64,420
Days of inventory 133 137 Ratio 0.53 0.52
Accounts receivable Turnover 2019 2018
Sales 181,193 170,756
Account receivable 22,636 26,472
Turnover 8.00 6.45
Days of inventory
Days 360 360
Inventory turnover 8.00 6.45
Days of inventory 45 56
Debt to equity 2019 2018 Return on equity 2019 2018
Debt 11,838 10,255 Net income 13,900 19,370
Equity 201,934 193,884 Equity 201,934 193,884
Debt to equity ratio 0.06 0.05 Debt to equity ratio 0.07 0.10
Debt to total assets Net profit margin
Debt 11,838 10255 Net profit 13,900 19,370
Total assets 551,669 531,864 Sales 181,193 170,756
Ratio 0.02 0.02 Ratio 0.08 0.11

Exxon IS

CONSOLIDATED STATEMENT OF INCOME
2019 2018 2017
(millions of dollars)
Revenues and other income
Sales and other operating revenue 255,583 279,332 237,162
Income from equity affiliates 5,441 7,355 5,380
Other income 3,914 3,525 1,821
Total revenues and other income 264,938 290,212 244,363
Costs and other deductions
Crude oil and product purchases 143,801 156,172 128,217
Production and manufacturing expenses 36,826 36,682 32,690
Selling, general and administrative expenses 11,398 11,480 10,649
Depreciation and depletion 18,998 18,745 19,893
Exploration expenses, including dry holes 1,269 1,466 1,790
Non-service pension and postretirement benefit expense 1,235 1,285 1,745
Interest expense 830 766 601
Other taxes and duties 30,525 32,663 30,104
Total costs and other deductions 244,882 259,259 225,689
Income before income taxes 20,056 30,953 18,674
Income taxes 5,282 9,532 -1,174
Net income including noncontrolling interests 14,774 21,421 19,848
Net income attributable to noncontrolling interests 434 581 138
Net income attributable to ExxonMobil 14,340 20,840 19,710
Earnings per common share (dollars) 3.36 4.88 4.63
Earnings per common share - assuming dilution (dollars) 3.36 4.88 4.63

Exxon BS

CONSOLIDATED BALANCE SHEET
Dec. 31 Dec. 31
2019 2018
(millions of dollars)
Assets
Current assets
Cash and cash equivalents 3,089 3,042
Notes and accounts receivable, less estimated doubtful amounts 26,966 24,701
Inventories
Crude oil, products and merchandise 14,010 14,803
Materials and supplies 4,518 4,155
Other current assets 1,469 1,272
Total current assets 50,052 47,973
Investments, advances and long-term receivables 43,164 40,790
Property, plant and equipment, at cost, less accumulated depreciation
and depletion 253,018 247,101
Other assets, including intangibles, net 16,363 10,332
Total assets 362,597 346,196
Liabilities
Current liabilities
Notes and loans payable 20,578 17,258
Accounts payable and accrued liabilities 41,831 37,268
Income taxes payable 1,580 2,612
Total current liabilities 63,989 57,138
Long-term debt 26,342 20,538
Postretirement benefits reserves 22,304 20,272
Deferred income tax liabilities 25,620 27,244
Long-term obligations to equity companies 3,988 4,382
Other long-term obligations 21,416 18,094
Total liabilities 163,659 147,668
Commitments and contingencies - -
Equity
Common stock without par value
(9,000 million shares authorized, 8,019 million shares issued) 15,637 15,258
Earnings reinvested 421,341 421,653
Accumulated other comprehensive income -19,493 -19,564
Common stock held in treasury
(3,785 million shares in 2019 and 3,782 million shares in 2018) -225,835 -225,553
ExxonMobil share of equity 191,650 191,794
Noncontrolling interests 7,288 6,734
Total equity 198,938 198,528
Total liabilities and equity 362,597 346,196

Exxon Ratio

Inventory Turnover 2019 2018 Current ratio 2019 2018
COGS 180,627 192,854 Current assets 50,052 47,973
Inventory 18,528 18,958 Current liability 63,989 57,138
Inventory Turnover 9.75 10.17 Ratio 0.78 0.84
Days of inventory Quick ratio
Days 360 360 Current assets 31,524 29,015
Inventory turnover 9.7488665803 10.1726975419 Current liability 63,989 57,138
Days of inventory 37 35 Ratio 0.49 0.51
Accounts receivable Turnover 2019 2019
Sales 264,938 290,212
Account receivable 26,966 24,701
Turnover 9.82 11.75
Days of inventory
Days 360 360
Inventory turnover 9.82 11.75
Days of inventory 37 31
Debt to equity 2019 2018 Return on equity 2019 2018
Debt 46,920 37,796 Net income 14,340 20,840
Equity 198,938 198,528 Equity 198,938 198,528
Debt to equity ratio 0.24 0.19 Debt to equity ratio 0.07 0.10
Debt to total assets Net profit margin
Debt 46,920 37,796 Net profit 14,340 20,840
Total assets 362,597 346,196 Sales 264,938 290,212
Ratio 0.13 0.11 Ratio 0.05 0.07

Kellog IS

CONSOLIDATED STATEMENT OF INCOME
(millions, except per share data) 2019 2018 2017
Net sales 13,578 13,547 12,854
Cost of goods sold 9,197 8,821 8,155
Selling, general and administrative expense 2,980 3,020 3,312
Operating profit 1,401 1,706 1,387
Other income (expense), net 188 90 526
Income before income taxes 1,305 1,329 1,657
Income taxes 321 181 410
Earnings (loss) from unconsolidated entities -7 196 7
Net income 977 1,344 1,254
Net income (loss) attributable to noncontrolling interests 17 8 —
Net income attributable to Kellogg Company 960 1,336 1,254
Per share amounts:
Basic 2.81 3.85 3.61
Diluted 2.8 3.83 3.58

Kellog BS

CONSOLIDATED BALANCE SHEET
(millions, except share data) 2019 2018
Current assets
Cash and cash equivalents 397 321
Accounts receivable, net 1,576 1,375
Inventories 1,226 1,330
Other current assets 232 131
Total current assets 3,431 3,157
Property, net 3,612 3,731
Operating lease right-of-use assets 541 —
Goodwill 5,861 6,050
Other intangibles, net 2,576 3,361
Investment in unconsolidated entities 404 413
Other assets 1,139 1,068
Total assets 17,564 17,780
Current liabilities
Current maturities of long-term debt 620 510
Notes payable 107 176
Accounts payable 2,387 2,427
Current operating lease liabilities 114 —
Other current liabilities 1,550 1,416
Total current liabilities 4,778 4,529
Long-term debt 7,195 8,207
Operating lease liabilities 433 —
Deferred income taxes 596 730
Pension liability 705 651
Other liabilities 543 504
Commitments and contingencies
Equity
Common stock, $.25 par value, 1,000,000,000 shares authorized 105 105
Issued: 420,829,201 shares in 2019 and 420,666,780 shares in 2018
Capital in excess of par value 921 895
Retained earnings 7,859 7,652
Treasury stock, at cost -4,690 -4,551
79,286,171 shares in 2019 and 76,801,314 shares in 2018
Accumulated other comprehensive income (loss) -1,448 -1,500
Total Kellogg Company equity 2,747 2,601
Noncontrolling interests 567 558
Total equity 3,314 3,159
Total liabilities and equity 17,564 17,780

Kellog ratio

Inventory Turnover 2019 2018 Current ratio 2019 2018
COGS 9,197 8,821 Current assets 3,431 3,157
Inventory 1,226 1,330 Current liability 4,778 4,529
Inventory Turnover 7.50 6.63 Ratio 0.72 0.70
Days of inventory Quick ratio
Days 360 360 Current assets 2,205 1,827
Inventory turnover 7.5016313214 6.6323308271 Current liability 4,778 4,529
Days of inventory 48 54 Ratio 0.46 0.40
Accounts receivable Turnover 2019 2019
Sales 13,578 13,547
Account receivable 1,576 1,375
Turnover 8.62 9.85
Days of inventory
Days 360 360
Inventory turnover 8.62 9.85
Days of inventory 42 37
Debt to equity 2019 2018 Return on equity 2019 2018
Debt 7,302 8,383 Net income 960 1,336
Equity 3,314 3,159 Equity 3,314 3,159
Debt to equity ratio 2.20 2.65 Debt to equity ratio 29% 42%
Debt to total assets Net profit margin
Debt 7,302 8,383 Net profit 960 1,336
Total assets 17,564 17,780 Sales 13,578 13,547
Ratio 0.42 0.47 Ratio 7% 10%

Bristol IS

Year Ended December 31,
EARNINGS 2019 2018 2017
Net product sales 25,174 21,581 19,258
Alliance and other revenues 971 980 1,518
Total Revenues 26,145 22,561 20,776
Cost of products sold(a) 8,078 6,467 6,014
Marketing, selling and administrative 4,871 4,551 4,751
Research and development 6,148 6,332 6,468
Amortization of acquired intangible assets 1,135 97 97
Other (income)/expense, net 938 -854 -1,685
Total Expenses 21,170 16,593 15,645
Earnings Before Income Taxes 4,975 5,968 5,131
Provision for Income Taxes 1,515 1,021 4,156
Net Earnings 3,460 4,947 975
Noncontrolling Interest 21 27 -32
Net Earnings Attributable to BMS 3,439 4,920 1,007
Earnings per Common Share
Basic 2.02 3.01 0.61
Diluted 2.01 3.01 0.61

Bristol BS

December 31,
ASSETS 2019 2018
Current Assets:
Cash and cash equivalents 12,346 6,911
Marketable debt securities 3,047 1,848
Receivables 7,685 5,747
Inventories 4,293 1,195
Other current assets 1,983 2,015
Total Current Assets 29,354 17,716
Property, plant and equipment 6,252 5,027
Goodwill 22,488 6,538
Other intangible assets 63,969 1,091
Deferred income taxes 510 815
Marketable debt securities 767 1,775
Other non-current assets 6,604 2,024
Total Assets 129,944 34,986
LIABILITIES
Current Liabilities:
Short-term debt obligations 3,346 1,703
Accounts payable 2,445 1,892
Other current liabilities 12,513 7,059
Total Current Liabilities 18,304 10,654
Deferred income taxes 6,454 19
Long-term debt 43,387 5,646
Other non-current liabilities 10,101 4,540
Total Liabilities 78,246 20,859
Commitments and contingencies
EQUITY
Bristol-Myers Squibb Company Shareholders’ Equity:
Preferred stock, $2 convertible series, par value $1 per share: Authorized 10 million shares; issued and outstanding 3,568 in 2019 and 3,590 in 2018, liquidation value of $50 per share — —
Common stock, par value of $0.10 per share: Authorized 4.5 billion shares; 2.9 billion issued in 2019 and 2.2 billion issued in 2018 292 221
Capital in excess of par value of stock 43,709 2,081
Accumulated other comprehensive loss -1,520 -2,762
Retained earnings 34,474 34,065
Less cost of treasury stock — 672 million common shares in 2019 and 576 million common shares in 2018 -25,357 -19,574
Total Bristol-Myers Squibb Company Shareholders' Equity 51,598 14,031
Noncontrolling interest 100 96
Total Equity 51,698 14,127
Total Liabilities and Equity 129,944

Bristol ratios

Inventory Turnover 2019 2018 Current ratio 2019 2018
COGS 8,078 6,467 Current assets 29,354 17,716
Inventory 4,293 5,427 Current liability 18,304 10,654
Inventory Turnover 1.88 1.19 Ratio 1.60 1.66
Days of inventory Quick ratio
Days 360 360 Current assets 25,061 12,289
Inventory turnover 1.8816678314 1.1916344205 Current liability 18,304 10,654
Days of inventory 191 302 Ratio 1.37 1.15
Accounts receivable Turnover 2019 2019
Sales 26,145 22,561
Account receivable 7,685 5,747
Turnover 3.40 3.93
Days of inventory
Days 360 360
Inventory turnover 3.40 3.93
Days of inventory 106 92
Debt to equity 2019 2018 Return on equity 2019 2018
Debt 46,733 7,349 Net income 3,439 4,920
Equity 51,698 14,127 Equity 51,698 14,127
Debt to equity ratio 90% 52% ROE 7% 35%
Debt to total assets Net profit margin
Debt 46,733 7,349 Net profit 3,439 4,920
Total assets 129,944 34,986 Sales 26,145 22,561
Ratio 36% 21% Ratio 13% 22%

Valuation

AT&T APPLE INC KELLOGG Exxon Mobil Bristol-Myers Squibb
Date Dividends Growth Dividends Growth Dividends Growth Dividends Growth Dividends Growth
2015 1.88 2.08 2 2.92 1.48
2016 1.92 2.28 2.08 3 1.52
2017 1.96 2.52 2.16 3.08 1.56
2018 2 2.92 2.24 3.28 1.6
2019 2.04 2.00% 3.08 5.48% 2.28 1.79% 3.48 6.10% 1.64 2.50%
AT&T APPLE INC KELLOGG Exxon Mobil Bristol-Myers Squibb
Dividends 2.04 3.08 2.28 3.48 1.64
Rate 8% 8% 8% 8% 8%
Growth 2.00% 5.48% 1.79% 6.10% 2.50%
Value 34 122 37 183 30
AT&T APPLE INC KELLOGG Exxon Mobil Bristol-Myers Squibb
Dividends 2.04 3.08 2.28 3.48 1.64
Rate 12% 12% 12% 12% 12%
Growth 2.00% 5.48% 1.79% 6.10% 2.50%
Value 20.4 47 22 59 17
AT&T APPLE INC KELLOGG Exxon Mobil Bristol-Myers Squibb
MPS 30.08 364 66 44 59
AT&T APPLE INC KELLOGG Exxon Mobil Bristol-Myers Squibb
Date Dividends Date Dividends Date Dividends Date Dividends Date Dividends
7/8/15 0.47 8/6/15 0.52 8/28/15 0.5 8/11/15 0.73 9/30/15 0.37 1.48
10/7/15 0.47 1.88 11/5/15 0.52 11/27/15 0.5 11/9/15 0.73 12/30/15 0.38
1/6/16 0.48 2/4/16 0.52 2.08 2/26/16 0.5 2/9/16 0.73 2.92 3/30/16 0.38
4/6/16 0.48 5/5/16 0.57 5/27/16 0.5 2 5/11/16 0.75 6/29/16 0.38
7/6/16 0.48 8/4/16 0.57 8/30/16 0.52 8/10/16 0.75 10/5/16 0.38 1.52
10/5/16 0.48 1.92 11/3/16 0.57 11/29/16 0.52 11/8/16 0.75 1/4/17 0.39
1/6/17 0.49 2/9/17 0.57 2.28 2/27/17 0.52 2/8/17 0.75 3 4/5/17 0.39
4/6/17 0.49 5/11/17 0.63 5/30/17 0.52 2.08 5/10/17 0.77 7/5/17 0.39
7/6/17 0.49 8/10/17 0.63 8/30/17 0.54 8/10/17 0.77 10/5/17 0.39 1.56
10/6/17 0.49 1.96 11/10/17 0.63 11/30/17 0.54 11/10/17 0.77 1/4/18 0.4
1/9/18 0.5 2/9/18 0.63 2.52 3/2/18 0.54 2/9/18 0.77 3.08 4/5/18 0.4
4/9/18 0.5 5/11/18 0.73 5/31/18 0.54 2.16 5/11/18 0.82 7/5/18 0.4
7/9/18 0.5 8/10/18 0.73 8/31/18 0.56 8/10/18 0.82 10/4/18 0.4 1.6
10/9/18 0.5 2 11/8/18 0.73 11/30/18 0.56 11/9/18 0.82 1/3/19 0.41
1/9/19 0.51 2/8/19 0.73 2.92 3/4/19 0.56 2/8/19 0.82 3.28 4/4/19 0.41
4/9/19 0.51 5/10/19 0.77 5/31/19 0.56 2.24 5/10/19 0.87 7/3/19 0.41
7/9/19 0.51 8/9/19 0.77 8/30/19 0.57 8/12/19 0.87 10/3/19 0.41 1.64
10/9/19 0.51 2.04 11/7/19 0.77 11/29/19 0.57 11/8/19 0.87 1/2/20 0.45
1/9/20 0.52 2/7/20 0.77 3.08 3/2/20 0.57 2/10/20 0.87 3.48 4/2/20 0.45
4/8/20 0.52 5/8/20 0.82 5/29/20 0.57 2.28 5/12/20 0.87 7/2/20 0.45

CAPM

CAPM Returns
COMPANY WEIGHT REPORTED BETA PORTFOLIO BETA Market return Risk free rate Rate of return
AT&T 0.40 0.67 0.27 8% 0.66% 2.63%
Bristol-Myers Squibb 0.20 0.72 0.14 8% 0.66% 1.72%
Apple, Inc. 0.07 1.17 0.08 8% 0.66% 1.23%
Exxon Mobil Corp. 0.13 1.36 0.18 8% 0.66% 1.99%
Kellogg Co. 0.20 0.59 0.12 8% 0.66% 1.53%
Total Portfolio Beta 0.79 8% 0.66% 6.45%

References

References
Apple Inc. (AAPL) Stock Historical Prices & Data - Yahoo Finance. (n.d.). Retrieved July 4, 2020, from finance.yahoo.com website: https://finance.yahoo.com/quote/AAPL/history?period1=1435968000&period2=1593820800&interval=div%7Csplit&filter=div&frequency=1d
AT&T Inc. (T) Stock Historical Prices & Data - Yahoo Finance. (n.d.). Retrieved from finance.yahoo.com website: https://finance.yahoo.com/quote/T/history?period1=1435968000&period2=1593820800&interval=div%7Csplit&filter=div&frequency=1d
BMY SEC Filings - Bristol Myers Squibb. (n.d.). Retrieved July 4, 2020, from www.bms.com website: https://www.bms.com/investors/financial-reporting/sec-filings.html
Exxon Mobil Corporation (XOM) Stock Historical Prices & Data - Yahoo Finance. (n.d.). Retrieved July 4, 2020, from finance.yahoo.com website: https://finance.yahoo.com/quote/XOM/history?period1=1435968000&period2=1593820800&interval=div%7Csplit&filter=div&frequency=1d
Kellogg Company (K) Stock Historical Prices & Data - Yahoo Finance. (n.d.). Retrieved July 4, 2020, from finance.yahoo.com website: https://finance.yahoo.com/quote/K/history?period1=1435968000&period2=1593820800&interval=div%7Csplit&filter=div&frequency=1d
SEC Filings. (n.d.). Retrieved July 4, 2020, from investors.att.com website: https://investors.att.com/financial-reports/sec-filings
SEC Filings | Exxon Mobil Corporation. (n.d.). Retrieved July 4, 2020, from ir.exxonmobil.com website: https://ir.exxonmobil.com/sec-filings
SEC Filings - Kellogg Company. (n.d.). Retrieved July 4, 2020, from investor.kelloggs.com website: https://investor.kelloggs.com/financials/sec-filings/default.aspx
What is the CAPM - Capital Asset Pricing Model - Formula, Example. (2015). Retrieved from Corporate Finance Institute website: https://corporatefinanceinstitute.com/resources/knowledge/finance/what-is-capm-formula/
‌