Week 2 Assignment 3

profileksjmksessions
Week1ApendixA-C.xlsx
Home>Business & Finance homework help>Accounting homework help>Week 2 Assignment 3

Apendix A

Apple .Inc
12 Months Ended
Income statement
Sep. 25, 2021 Sep. 26, 2020 Sep. 26, 2019
Net sales
Cost of sales 365817 274515 260174
Gross margin 212981 169559 161782
Operating expenses:
Research and development 21914 18752 16217
Selling, general and administrative 21973 19916 18245
Total operating expenses 43887 38668 34462
Operating income 108949 66288 63930
Other income/(expense), net 258 803 1807
Income before provision for income taxes 109207 67091 65737
Provision for income taxes 14527 9680 10481
Net income 94680 57411 55256
CONSOLIDATED BALANCE SHEETS - USD ($) $ in Millions Sep. 25, 2021 Sep. 26, 2020 Sep. 26, 2019
Current assets:
Cash and cash equivalents 34940 38016 48844
Marketable securities 27699 52927 51713
Accounts receivable, net 26278 16120 22926
Inventories 6580 4061 4106
Vendor non-trade receivables 25228 21325 22878
Other current assets 14111 11264 12352
Total current assets 134836 143713 162819
Non-current assets:
Marketable securities 127877 100887 105341
Property, plant and equipment, net 39440 36766 37378
Other non-current assets 48849 42522 32978
Total non-current assets 216166 180175 175697
Total assets 351002 323888 338516
Current liabilities:
Accounts payable 54763 42296 46236
Other current liabilities 47493 42684 37720
Deferred revenue 7612 6643 5522
Commercial paper 6000 4996 5980
Term debt 9613 8773 10260
Total current liabilities 125481 105392 105718
Non-current liabilities:
Term debt 109106 98667 91807
Other non-current liabilities 53325 54490 50503
Total non-current liabilities 162431 153157 142310
Total liabilities 287912 258549 248028
Commitments and contingencies
Shareholders’ equity:
Common stock and additional paid-in capital, 57365 50779 45174
$0.00001 par value: 50,400,000 shares
authorized; 16,426,786 and 16,976,763
shares issued and outstanding, respectively
Retained earnings 5562 14966 45898
Accumulated other comprehensive income/(loss) 163 -406 -584
Total shareholders’ equity 63090 65339 90488
Total liabilities and shareholders’ equity $ 351,002 $ 323,888 $ 338,516

Apendix B

Apple .Inc
12 Months Ended
Income statement
Sep. 25, 2021 Sep. 26, 2020 Sep. 28, 2019
Net sales 100% 100% 100%
Cost of sales 58% 62% 62%
Gross margin 42% 38% 38%
Operating expenses:
Research and development 6% 7% 6%
Selling, general and administrative 6% 7% 7%
Total operating expenses 12% 14% 13%
Operating income 30% 24% 25%
Other income/(expense), net 0% 0% 1%
Income before provision for income taxes 30% 24% 25%
Provision for income taxes 4% 4% 4%
Net income 26% 21% 21%
CONSOLIDATED BALANCE SHEETS - USD ($) $ in Millions Sep. 25, 2021 Sep. 26, 2020 Sep. 26, 2019
Current assets:
Cash and cash equivalents 9.95% 11.74% 14.43%
Marketable securities 7.89% 16.34% 15.28%
Accounts receivable, net 7.49% 4.98% 6.77%
Inventories 1.87% 1.25% 1.21%
Vendor non-trade receivables 7.19% 6.58% 6.76%
Other current assets 4.02% 3.48% 365.00%
Total current assets 38.41% 44.37% 48.10%
Non-current assets:
Marketable securities 36.43% 31.15% 31.12%
Property, plant and equipment, net 11.24% 11.35% 11.04%
Other non-current assets 13.92% 13.13% 9.74%
Total non-current assets 61.59% 55.63% 51.90%
Total assets 100.00% 100.00% 100.00%
Current liabilities:
Accounts payable 19.02% 16.36% 18.64%
Other current liabilities 16.50% 16.51% 15.21%
Deferred revenue 2.64% 2.57% 2.23%
Commercial paper 2.08% 1.93% 2.41%
Term debt 3.34% 3.39% 4.14%
Total current liabilities 43.58% 40.76% 42.62%
Non-current liabilities:
Term debt 37.90% 38.16% 37.01%
Other non-current liabilities 18.52% 21.08% 20.36%
Total non-current liabilities 56.42% 59.24% 57.38%
Total liabilities 100.00% 100.00% 100.00%

Apendix C

Apple Inc. Financial ratios
Year 2021 2020 2019
Market Cap Growth 0.2647 0.9419 -0.093
Enterprise Value 2490692 1941766 996377
PE Ratio 25.65 33.45 17.9
PS Ratio 6.64 7 3.8
PB Ratio 38.49 29.39 10.93
P/FCF Ratio 26.13 26.17 16.79
P/OCF Ratio 23.34 23.8 14.25
EV/Sales Ratio 6.88 7.28 4.02
EV/EBITDA Ratio 20.44 24.68 12.79
EV/EBIT Ratio 22.5 28.58 15.1
EV/FCF Ratio 27.07 27.26 17.77
Debt / Equity Ratio 1.98 1.72 1.19
Debt / EBITDA Ratio 1.01 1.39 1.32
Debt / FCF Ratio 1.34 1.53 1.83
Current Ratio 1.08 1.36 1.54
Asset Turnover 1.07 0.84 0.76
Return on Equity (ROE) 1.441 0.752 0.538
Return on Assets (ROA) 0.276 0.176 0.161
Return on Capital (ROIC) 0.362 0.234 0.223
Earnings Yield 0.039 0.0299 0.0559
FCF Yield 0.0383 0.0382 0.0596
Dividend Yield 0.0058 0.0072 0.014
Payout Ratio 0.15 0.24 0.251
Buyback Yield / Dilution 0.0378 0.0574 0.0702
Total Shareholder Return 0.0437 0.0646 0.0843