Description
it is your responsibility to construct an investment portfolio that will generate the maximum rate of return within a given risk class. In order to be successful in this, you need to synthesize your knowledge of your company’s industry and its place in the wider financial markets and of the modern portfolio theory, along with utilizing both qualitative and quantitative skills.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Here is the answer. Thank you
Apple (AAPL) Stock
2016
Revenues
Cost of Goods Sold
Selling, General & Administrative Expenses
Research and development
Operating Income
Net Interest Expenditure
Pre-Tax Income
Taxes
Net Income
Earnings Per Share
Shares Outstanding
215639
131376
14194
10045
60024
-1348
61372
15685
45687
2017
2018
2019
224264.56 233235 242565 252267
156985.19 163265 169795 176587
38124.975 39650 41236 41624
0
0
0
0
29154.393 30321 31533.4 34056
0
0
0
0
29154.393 30321 31533.4 34056
8746.3178 9096.2 9460.02 10217
20408.075 21224 22073.4 23839
8.30672727
3.7105591
5500
5500
3.859 4.01334
5500
5500
Apple (AAPL) Bond
Apple
Debt & Coverage Ratios
Debt/Assets
Debt/Equity
Current Assets/Current Liability
EBITDA/Interest
Debt/EBITDA
Cash Flow Ops/Total Debt
0.60
0.68
1.35
43.15
0.32
0.27
2020
Ind Avg
0.5
0.47
24.46
0.28
0.22
4.3344
5500
2021
262358
183650
43289
0
35418
0
35418
10625
24793
4.5078
5500
Growth Profitability and Financial Ratios for Apple Inc
Financials
Revenue USD Mil
Gross Margin %
Operating Income USD Mil
Operating Margin %
Net Income USD Mil
Earnings Per Share USD
Dividends USD
Payout Ratio % *
Shares Mil
Book Value Per Share * USD
Operating Cash Flow USD Mil
Cap Spending USD Mil
Free Cash Flow USD Mil
Free Cash Flow Per Share * USD
Working Capital USD Mil
Key Ratios -> Profitability
Margins % of Sales
Revenue
COGS
Gross Margin
SG&A
R&D
Other
Operating Margin
Net Int Inc & Other
EBT Margin
Profitability
Tax Rate %
Net Margin %
Asset Turnover (Average)
Return on Assets %
Financial Leverage (Average)
Return on Equity %
Return on Invested Capital %
Interest Coverage
2007-09 2008-09 2009-09 2010-09 2011-09
24,578 37,491 42,905 65,225 108,249
33.2
35.2
40.1
39.4
40.5
4,407
8,327 11,740 18,385 33,790
17.9
22.2
27.4
28.2
31.2
3,495
6,119
8,235 14,013 25,922
0.56
0.97
1.3
2.16
3.95
6,225
2.2
5,470
-986
4,484
0.63
12,657
6,315
3.39
9,596
-1,199
8,397
1.33
20,598
6,349
5.02
10,159
-1,213
8,946
1.41
20,049
6,473
7.45
18,595
-2,121
16,474
2.54
20,956
6,557
11.78
37,529
-7,452
30,077
4.59
17,018
2007-09 2008-09 2009-09 2010-09 2011-09
100
100
100
100
100
66.83
64.8
59.86
60.62
59.52
33.17
35.2
40.14
39.38
40.48
12.06
10.03
9.67
8.46
7.02
3.18
2.96
3.11
2.73
2.24
17.93
2.44
20.37
22.21
1.65
23.86
27.36
0.76
28.12
28.19
0.24
28.42
31.22
0.38
31.6
2007-09 2008-09 2009-09 2010-09 2011-09
30.19
29.89
31.75
24.42
24.22
14.56
14.88
19.19
21.48
23.95
1.13
1
0.99
1.06
1.13
16.43
14.89
18.92
22.84
27.07
1.74
1.88
1.5
1.57
1.52
28.52
27.19
31.27
35.28
41.67
24.84
27.19
30.22
34.69
41.04
Key Ratios -> Growth
2007-09 2008-09 2009-09 2010-09 2011-09
Revenue %
Year over Year
3-Year Average
5-Year Average
24.29
42.6
33.12
35.3
32.6
39.23
32.1
30.48
38.97
52.02
39.54
36.17
65.96
49.37
41.16
10-Year Average
Operating Income %
Year over Year
3-Year Average
5-Year Average
10-Year Average
Net Income %
Year over Year
3-Year Average
5-Year Average
10-Year Average
EPS %
Year over Year
3-Year Average
5-Year Average
10-Year Average
Key Ratios -> Cash Flow
Cash Flow Ratios
Operating Cash Flow Growth % YOY
Free Cash Flow Growth % YOY
Cap Ex as a % of Sales
Free Cash Flow/Sales %
Free Cash Flow/Net Income
Key Ratios -> Financial Health
Balance Sheet Items (in %)
Cash & Short-Term Investments
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Net PP&E
Intangibles
Other Long-Term Assets
Total Assets
Accounts Payable
Short-Term Debt
Taxes Payable
Accrued Liabilities
Other Short-Term Liabilities
Total Current Liabilities
Long-Term Debt
Other Long-Term Liabilities
Total Liabilities
Total Stockholders' Equity
Total Liabilities & Equity
12.99
18.52
21.47
23.37
35.05
79.74
138.25
203.93
42.32
56.09
56.6
60.96
61.96
42.78
83.79
75.28
68.97
37.44
87.09
68.52
104.78
41.73
75.77
133.11
121.89
38.27
53.56
133.93
31.65
70.36
60.57
97.22
29.92
70.16
58.85
60.03
33.39
84.99
75.03
67.11
73.13
122.87
112.83
36.39
50.9
124.02
26.15
69.4
58.74
91.24
25.97
66.85
56.8
57.56
30.11
82.71
72.85
64.9
2007-09 2008-09 2009-09 2010-09 2011-09
146.4
75.43
5.87
83.04 101.82
186.88
87.27
6.54
84.15
82.57
4.01
3.2
2.83
3.25
6.88
18.24
22.4
20.85
25.26
27.79
1.28
1.37
1.09
1.18
1.16
2007-09 2008-09 2009-09 2010-09 2011-09
60.7
61.89
49.4
34.08
22.3
15.9
11.89
10.65
13.2
10.07
1.37
1.29
0.96
1.4
0.67
8.66
12.6
5.43
6.76
5.62
86.62
87.66
66.43
55.44
38.66
7.23
6.2
6.22
6.34
6.68
1.66
1.24
1.18
1.44
3.81
4.49
4.89
26.17
36.78
50.85
100
100
100
100
100
19.61
13.95
11.79
15.98
12.57
4.97
12.11
36.69
9.4
12.26
35.61
0.91
7.2
4.32
24.22
0.28
6.45
4.85
27.56
0.98
6.97
3.52
24.04
5.98
42.67
57.33
100
11.25
46.86
53.14
100
9.17
33.39
66.61
100
8.87
36.43
63.57
100
10.13
34.16
65.84
100
Liquidity/Financial Health
Current Ratio
Quick Ratio
Financial Leverage
Debt/Equity
Key Ratios -> Efficiency Ratios
Efficiency
Days Sales Outstanding
Days Inventory
Payables Period
Cash Conversion Cycle
Receivables Turnover
Inventory Turnover
Fixed Assets Turnover
Asset Turnover
2007-09 2008-09 2009-09 2010-09 2011-09
2.36
2.46
2.74
2.01
1.61
2.09
2.07
2.48
1.72
1.35
1.74
1.88
1.5
1.57
1.52
2007-09 2008-09 2009-09 2010-09 2011-09
21.96
22.81
24.6
24.82
18.34
7.09
7.31
6.85
6.95
5.17
96.25
89.74
79.02
81.3
75.48
-67.19 -59.61 -47.58 -49.53 -51.96
16.62
16
14.84
14.71
19.9
51.47
49.9
53.28
52.51
70.53
15.42
15.15
15.86
16.89
17.26
1.13
1
0.99
1.06
1.13
2012-09 2013-09 2014-09 2015-09 2016-09 TTM
156,508 170,910 182,795 233,715 215,639
220,457
43.9
37.6
38.6
40.1
39.1
38.4
55,241 48,999 52,503 71,230 60,024
59,322
35.3
28.7
28.7
30.5
27.8
26.9
41,733 37,037 39,510 53,394 45,687
45,730
6.31
5.68
6.45
9.22
8.31
8.58
0.38
1.63
1.81
1.98
2.18
2.28
27.4
28.5
22.3
24.8
26.6
6,617
6,522
6,123
5,793
5,500
5,364
16.99
19.6
20.62
22.53
23.71
25.72
50,856 53,666 59,713 81,266 65,824
66,339
-9,402 -9,076 -9,813 -11,488 -13,548
-13,378
41,454 44,590 49,900 69,778 52,276
52,961
6.31
6.46
7.73
11.82
8.97
19,111 29,628
5,083
8,768 27,863
2012-09 2013-09 2014-09 2015-09 2016-09 TTM
100
100
100
100
100
100
56.13
62.38
61.41
59.94
60.92
61.59
43.87
37.62
38.59
40.06
39.08
38.41
6.42
6.34
6.56
6.13
6.58
6.62
2.16
2.62
3.3
3.45
4.66
4.89
35.3
0.33
35.63
28.67
0.68
29.35
28.72
0.54
29.26
30.48
0.55
31.03
27.84
0.63
28.46
26.91
1
27.91
2012-09 2013-09 2014-09 2015-09 2016-09 TTM
25.16
26.15
26.13
26.37
25.56
25.67
26.67
21.67
21.61
22.85
21.19
20.74
1.07
0.89
0.83
0.89
0.7
0.69
28.54
19.34
18.01
20.45
14.93
14.29
1.49
1.68
2.08
2.43
2.51
2.5
42.84
30.64
33.61
46.25
36.9
34.57
42.01
26.08
26.2
31.32
21.95
19.75
369.79 140.28
99.93
43.15
33.14
2012-09 2013-09 2014-09 2015-09 2016-09 Latest Qtr
44.58
53.94
45.49
9.2
37.86
39.39
6.95
19.08
33.63
27.86
14.3
29.08
-7.73
8.06
14.78
4.63
39.17
39.31
36.27
32.58
27.29
63.48
67.57
65.8
124.48
-11.3
38.65
50.84
7.15
15.82
34.93
66.23
35.67
8.84
31.11
45.72
-15.73
7
12.18
37.68
60.99
71.77
64.2
90.88
-11.25
38.26
50.27
87.49
6.68
15.08
36.84
64.28
35.14
8.56
30.67
44.61
-14.43
7.25
12
36.81
59.5
69.41
62.22
85.81
-9.97
37.92
49.29
82.88
13.58
17.71
37.82
62.35
42.95
13.49
33.62
45.1
-9.87
13.53
16.01
38.31
0.79
10.53
2012-09 2013-09 2014-09 2015-09 2016-09 TTM
35.51
5.53
11.27
36.09
-19
37.83
7.57
11.91
39.84 -25.08
6.01
5.31
5.37
4.92
6.28
6.07
26.49
26.09
27.3
29.86
24.24
24.02
0.99
1.2
1.26
1.31
1.14
1.16
2012-09 2013-09 2014-09 2015-09 2016-09 Latest Qtr
16.54
19.59
10.82
14.32
20.88
20.06
10.62
9.97
11.74
10.45
9.11
6.16
0.45
0.85
0.91
0.81
0.66
0.87
5.14
4.99
6.09
5.19
2.57
3.4
32.75
35.4
29.56
30.77
33.22
30.49
8.78
8.02
8.9
7.74
8.4
8.12
3.04
2.78
3.78
3.1
2.68
2.42
55.43
53.8
57.77
58.39
55.7
58.97
100
100
100
100
100
100
12.03
10.81
13.02
12.22
11.59
8.54
2.72
3.79
3.61
4.18
0.87
0.58
0.52
4.76
2.52
3.32
8.67
6.85
6.9
4.23
7.19
7.78
3.08
2.51
2.3
21.89
21.09
27.37
27.75
24.56
21.92
8.19
12.5
18.41
23.45
25.27
10.97
11.03
12.02
12.76
12.12
12.73
32.86
40.31
51.89
58.91
60.13
59.92
67.14
59.69
48.11
41.09
39.87
40.08
100
100
100
100
100
100
2012-09 2013-09 2014-09 2015-09 2016-09 Latest Qtr
1.5
1.68
1.08
1.11
1.35
1.39
1.24
1.4
0.82
0.89
1.22
1.2
1.49
1.68
2.08
2.43
2.51
2.5
0.14
0.26
0.45
0.59
0.63
2012-09 2013-09 2014-09 2015-09 2016-09 TTM
19.01
25.66
30.51
26.79
27.59
19.71
3.26
4.37
6.3
5.81
6.22
6.98
74.38
74.54
85.45
85.57 101.11
72.14
-52.13
-44.5 -48.64 -52.97 -67.29
-45.46
19.2
14.22
11.96
13.62
13.23
18.52
112.12
83.45
57.94
62.82
58.64
52.31
13.48
10.67
9.82
10.85
8.71
8.75
1.07
0.89
0.83
0.89
0.7
0.69
APPLE INC (AAPL) CashFlowFlag INCOME STATEMENT
Fiscal year ends in September. USD in millions except per share data.
Revenue
Cost of revenue
Gross profit
Operating expenses
Research and development
Sales, General and administrative
Total operating expenses
Operating income
Interest Expense
Other income (expense)
Income before taxes
Provision for income taxes
Net income from continuing operations
Net income
Net income available to common shareholders
Earnings per share
Basic
Diluted
Weighted average shares outstanding
Basic
Diluted
EBITDA
2012-09 2013-09 2014-09
156508 170910 182795
87846 106606 112258
68662 64304 70537
3381
10040
13421
55241
522
55763
14030
41733
41733
41733
4475
10830
15305
48999
136
1292
50155
13118
37037
37037
37037
6041
11993
18034
52503
384
1364
53483
13973
39510
39510
39510
6.38
6.31
5.72
5.68
6.49
6.45
6544
6617
58518
6477
6522
57048
6086
6123
61813
2015-09 2016-09 TTM
233715 215639 218118
140089 131376 134102
93626 84263 84016
8067
14329
22396
71230
733
2018
72515
19121
53394
53394
53394
10045
14194
24239
60024
1456
2804
61372
15685
45687
45687
45687
10512
14292
24804
59212
1705
3472
60979
15762
45217
45217
45217
9.28
9.22
8.35
8.31
8.43
8.39
5753
5793
84505
5471
5500
73333
5406
5434
73222
APPLE INC (AAPL) CashFlowFlag BALANCE SHEET
Fiscal year ends in September. USD in millions except per share data.
Assets
Current assets
Cash
Cash and cash equivalents
Short-term investments
Total cash
Receivables
Inventories
Deferred income taxes
Other current assets
Total current assets
Non-current assets
Property, plant and equipment
Gross property, plant and equipment
Accumulated Depreciation
Net property, plant and equipment
Equity and other investments
Goodwill
Intangible assets
Other long-term assets
Total non-current assets
Total assets
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt
Accounts payable
Taxes payable
Accrued liabilities
Deferred revenues
Other current liabilities
Total current liabilities
Non-current liabilities
Long-term debt
Deferred taxes liabilities
Deferred revenues
Other long-term liabilities
Total non-current liabilities
Total liabilities
Stockholders' equity
Common stock
Additional paid-in capital
Retained earnings
Accumulated other comprehensive income
Total stockholders' equity
2012-09 2013-09 2014-09
10746
18383
29129
10930
791
2583
14220
57653
14259
26287
40546
13102
1764
3453
14421
73286
13844
11233
25077
17460
2111
4318
19565
68531
21887 28519 39015
-6435 -11922 -18391
15452 16597 20624
92122 106215 130162
1135
1577
4616
4224
4179
4142
5478
5146
3764
118411 133714 163308
176064 207000 231839
6308
30196
1209
7689
9548
8498
63448
21175
1535
8387
5953
1492
38542
22367
1200
5217
7435
7439
43658
2648
16664
19312
57854
16960 28987
16489 20259
2625
3031
3719
4567
39793 56844
83451 120292
23313
16422 19764
101289 104256 87152
499
-471
1082
118210 123549 111547
Total liabilities and stockholders' equity
176064 207000 231839
2015-09 2016-09
21120 20484
20481 46671
41601 67155
16849 15754
2349
2132
5546
23033 21828
89378 106869
49257 61245
-26786 -34235
22471 27010
164065 170430
5116
5414
3893
3206
5556
8757
201101 214817
290479 321686
10999
35490
11605
37294
25181
8940
22027
8080
80610
79006
53463 75427
24062 26019
3624
2930
9365 10055
90514 114431
171124 193437
27416
31251
92284 96364
-345
634
119355 128249
290479 321686
APPLE INC (AAPL) Statement of CASH FLOW
Fiscal year ends in September. USD in millions except per share data.
Cash Flows From Operating Activities
Net income
Depreciation & amortization
Deferred income taxes
Stock based compensation
Accounts receivable
Inventory
Accounts payable
Other working capital
Other non-cash items
Net cash provided by operating activities
Cash Flows From Investing Activities
Investments in property, plant, and equipment
Acquisitions, net
Purchases of investments
Sales/Maturities of investments
Purchases of intangibles
Other investing activities
Net cash used for investing activities
Cash Flows From Financing Activities
Debt issued
Debt repayment
Common stock issued
Common stock repurchased
Dividend paid
Other financing activities
Net cash provided by (used for) financing activities
Net change in cash
Cash at beginning of period
Cash at end of period
Free Cash Flow
Operating cash flow
Capital expenditure
Free cash flow
2012-09 2013-09 2014-09
41733
3277
4405
1740
-5551
-15
4467
800
37037
6757
1141
2253
-2172
-973
2340
7283
39510
7946
2347
2863
-4232
-76
5938
5417
50856
53666
59713
-8295
-8165
-9571
-350
-496
-3765
-151232 -148489 -217128
112805 124447 208111
-1107
-911
-242
-48
-160
16
-48227 -33774 -22579
16896
18266
-2488
125
-1698
931
9815
10746
530
-22860
-10564
-381
-16379
3513
10746
14259
730
-45000
-11126
-419
-37549
-415
14259
13844
50856
-9402
41454
53666
-9076
44590
59713
-9813
49900
665
2015-09 2016-09 TTM
53394
11257
1382
3586
611
-238
5400
5874
45687
10505
4938
4210
1095
217
1791
-2619
81266
65824
45217
10538
4798
4388
-1104
-261
5103
-2878
...