FIN 320 SNHU Comparisons Between Apple Incs Financial Ratios and The Industry Average Calculation Ratio Calculation use formulas to calculate the following

FIN 320 SNHU Comparisons Between Apple Incs Financial Ratios and The Industry Average Calculation Ratio Calculation use formulas to calculate the following financial indicators for each year of data:
Current ratio , Debt/equity ratio, Free cash flow, Earnings per share, Price/earnings ratio, Return on equity, Net profit margin.Short Written Responses
In a separate Word document, respond to the following:
Describe how and why each of the ratios has changed over the three-year period. For example, did the current ratio increase or decrease? Why?
Describe how three of the ratios you calculated for your company compare to the general industry. Powered by Clearbit
Apple Inc (NMS: AAPL)
Exchange rate used is that of the Year End reported date
As Reported Annual Balance Sheet
Report Date
Currency
Audit Status
Consolidated
Scale
Cash & cash equivalents
Marketable securities
Accounts receivable, gross
Allowances
Accounts receivable, net
Inventories
Vendor non-trade receivables
Other current assets
Total current assets
Marketable securities
Land & buildings
Machinery, equipment, & internal-use software
Leasehold improvements
Gross property, plant & equipment
Accumulated depreciation & amortization
Property, plant & equipment, net
Goodwill
Acquired intangible assets, net
Other non-current assets
Total non-current assets
Total assets
Accounts payable
Accrued expenses
Deferred revenue
Other current liabilities
Commercial paper
Term debt
Current portion of long-term debt
Total current liabilities
Deferred revenue
Floating & fixed-rate notes
Total debt
Unamortized discount
Hedge accounting fair value adjustments
Less: current portion of long-term debt
Term debt
Long-term taxes payable
09/30/2017
USD
Not Qualified
Yes
Thousands
20289000
53892000
17932000
58000
17874000
4855000
17799000
13936000
128645000
194714000
13587000
54210000
7279000
75076000
41293000
33783000
5717000
2298000
10162000
375319000
49049000
25744000
7548000
11977000
6496000
100814000
2836000
104021000
104021000
-225000
-93000
6496000
97207000
–
Deferred tax liabilities
Other non-current liabilities
Other non-current liabilities
Total non-current liabilities
Total liabilities
Common stock
Retained earnings
Cumulative foreign currency translation
Unrecognized gains (losses) on derivative instruments
Unrealized gains (losses) on marketable securities
Accumulated other comprehensive income (loss)
Total shareholders’ equity
31504000
8911000
40415000
241272000
35867000
98330000
-354000
-124000
328000
-150000
134047000
Reference
Mergent Online. (2018). Apple Inc Retrieved July 12, 2020 from:https://www-mergentonline-com.ezproxy.snhu.edu/companyfina
Ratios
2017
Current Ratio
Debt / Equity Ratio
Free Cash Flow (000)
Earnings per Share
Price / earnings ratio
Return on Equity
Net profit margin
Stock Data
Number of Shares Outstanding
Closing Price Last Business Day in December
2018
ezproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=12161&period=Annuals&dataarea=BS&range=3¤cy=
Industry Average (Students: include a reference for this data too)
2019
Powered by Clearbit
Apple Inc (NMS: AAPL)
Exchange rate used is that of the Year End reported date
As Reported Annual Balance Sheet
Report Date
Currency
Audit Status
Consolidated
Scale
Cash & cash equivalents
Marketable securities
Accounts receivable, gross
Allowances
Accounts receivable, net
Inventories
Vendor non-trade receivables
Other current assets
Total current assets
Marketable securities
Land & buildings
Machinery, equipment, & internal-use software
Leasehold improvements
Gross property, plant & equipment
Accumulated depreciation & amortization
Property, plant & equipment, net
Goodwill
Acquired intangible assets, net
Other non-current assets
Total non-current assets
Total assets
Accounts payable
Accrued expenses
Deferred revenue
Other current liabilities
Commercial paper
Term debt
Current portion of long-term debt
Total current liabilities
Deferred revenue
Floating & fixed-rate notes
Total debt
Unamortized discount
Hedge accounting fair value adjustments
Less: current portion of long-term debt
Term debt
Long-term taxes payable
09/29/2018
USD
Not Qualified
Yes
Thousands
25913000
40388000
23186000
3956000
25809000
12087000
131339000
170799000
16216000
65982000
8205000
90403000
49099000
41304000
22283000
234386000
365725000
55888000
7543000
32687000
11964000
8784000
116866000
2797000
104193000
104193000
-218000
-1456000
8784000
93735000
33589000
Deferred tax liabilities
Other non-current liabilities
Other non-current liabilities
Total non-current liabilities
Total liabilities
Common stock
Retained earnings
Cumulative foreign currency translation
Unrecognized gains (losses) on derivative instruments
Unrealized gains (losses) on marketable securities
Accumulated other comprehensive income (loss)
Total shareholders’ equity
426000
11165000
45180000
141712000
258578000
40201000
70400000
-1055000
810000
-3209000
-3454000
107147000
Reference
Mergent Online. (2018). Apple Inc Retrieved July 12, 2020 from:https://www-mergentonline-com.ezproxy.snhu.edu/companyfina
om.ezproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=12161&period=Annuals&dataarea=BS&range=3¤
als&dataarea=BS&range=3¤cy=AsRep&scale=AsRep&Submit=Refresh
Powered by Clearbit
Apple Inc (NMS: AAPL)
Exchange rate used is that of the Year End reported date
As Reported Annual Balance Sheet
Report Date
Currency
Audit Status
Consolidated
Scale
Cash & cash equivalents
Marketable securities
Accounts receivable, gross
Allowances
Accounts receivable, net
Inventories
Vendor non-trade receivables
Other current assets
Total current assets
Marketable securities
Land & buildings
Machinery, equipment, & internal-use software
Leasehold improvements
Gross property, plant & equipment
Accumulated depreciation & amortization
Property, plant & equipment, net
Goodwill
Acquired intangible assets, net
Other non-current assets
Total non-current assets
Total assets
Accounts payable
Accrued expenses
Deferred revenue
Other current liabilities
Commercial paper
Term debt
Current portion of long-term debt
Total current liabilities
Deferred revenue
Floating & fixed-rate notes
Total debt
Unamortized discount
Hedge accounting fair value adjustments
Less: current portion of long-term debt
Term debt
Long-term taxes payable
Deferred tax liabilities
09/28/2019
USD
Not Qualified
Yes
Thousands
48844000
51713000
22926000
4106000
22878000
12352000
162819000
105341000
17085000
69797000
9075000
95957000
58579000
37378000
32978000
175697000
338516000
46236000
5522000
37720000
5980000
10260000
105718000
101679000
101679000
-224000
612000
10260000
91807000
29545000
–
Other non-current liabilities
Other non-current liabilities
Total non-current liabilities
Total liabilities
Common stock
Retained earnings
Cumulative foreign currency translation
Unrecognized gains (losses) on derivative instruments
Unrealized gains (losses) on marketable securities
Accumulated other comprehensive income (loss)
Total shareholders’ equity
20958000
50503000
142310000
248028000
45174000
45898000
-1463000
172000
707000
-584000
90488000
Reference
Mergent Online. (2018). Apple Inc Retrieved July 12, 2020 from:https://www-mergentonline-com.ezproxy.snhu.edu/companyfina
https://www-mergentonline-com
ps://www-mergentonline-com.ezproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=12161&period=Annuals&dataa
ber=12161&period=Annuals&dataarea=BS&range=3¤cy=AsRep&scale=AsRep&Submit=Refresh
Powered by Clearbit
Apple Inc (NMS: AAPL)
Exchange rate used is that of the Year End reported date
As Reported Annual Income Statement
Report Date
Currency
Audit Status
Consolidated
Scale
Products
Services
Net sales
Cost of sales – products
Cost of sales – services
Cost of sales
Gross margin
Research & development expense
Selling, general & administrative expense
Total operating expenses
Operating income (loss)
Interest & dividend income
Interest expense
Other income (expense), net
Other income/(expense), net
Income (loss) before provision for income taxes
Current federal income tax expense (benefit)
Deferred federal income tax expense (benefit)
Total federal income tax expense (benefit)
Current state income tax expense (benefit)
Deferred state income tax expense (benefit)
Total state income tax expense (benefit)
Current foreign income tax expense (benefit)
Deferred foreign income tax expense (benefit)
Total foreign income tax expense (benefit)
Provision for (benefit from) income taxes
Net income (loss)
Weighted average shares outstanding – basic
Weighted average shares outstanding – diluted
Year end shares outstanding
Net earnings (loss) per common share – basic
Net earnings (loss) per common share – diluted
Cash dividends declared per common share
Number of full time employees
Number of common stockholders
Foreign currency translation adjustments
09/30/2017
USD
Not Qualified
Yes
Thousands
229234000
141048000
88186000
11581000
15261000
26842000
61344000
5201000
2323000
-133000
2745000
64089000
7842000
5980000
13822000
259000
2000
261000
1671000
-16000
1655000
15738000
48351000
5217242
5251692
5126201
9,27
9,21
2,4
123000
25333
224000
Reference
Mergent Online. (2018). Apple Inc Retrieved July 12, 2020 from:https://www-mergentonline-com.ezproxy.snhu.edu/companyfina
zproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=12161&period=Annuals&dataarea=PL&range=3¤cy=As
ataarea=PL&range=3¤cy=AsRep&scale=AsRep&Submit=Refresh
Powered by Clearbit
Apple Inc (NMS: AAPL)
Exchange rate used is that of the Year End reported date
As Reported Annual Income Statement
Report Date
Currency
Audit Status
Consolidated
Scale
Products
Services
Net sales
Cost of sales – products
Cost of sales – services
Cost of sales
Gross margin
Research & development expense
Selling, general & administrative expense
Total operating expenses
Operating income (loss)
Interest & dividend income
Interest expense
Other income (expense), net
Other income/(expense), net
Income (loss) before provision for income taxes
Current federal income tax expense (benefit)
Deferred federal income tax expense (benefit)
Total federal income tax expense (benefit)
Current state income tax expense (benefit)
Deferred state income tax expense (benefit)
Total state income tax expense (benefit)
Current foreign income tax expense (benefit)
Deferred foreign income tax expense (benefit)
Total foreign income tax expense (benefit)
Provision for (benefit from) income taxes
Net income (loss)
Weighted average shares outstanding – basic
Weighted average shares outstanding – diluted
Year end shares outstanding
Net earnings (loss) per common share – basic
Net earnings (loss) per common share – diluted
Cash dividends declared per common share
Number of full time employees
Number of common stockholders
Foreign currency translation adjustments
Reference
09/29/2018
USD
Not Qualified
Yes
Thousands
265595000
163756000
101839000
14236000
16705000
30941000
70898000
5686000
3240000
-441000
2005000
72903000
41425000
-33819000
7606000
551000
48000
599000
3986000
1181000
5167000
13372000
59531000
4955377
5000109
4754986
12,01
11,91
2,72
132000
23710
-525000
Mergent Online. (2018). Apple Inc Retrieved July 12, 2020 from:https://www-mergentonline-com.ezproxy.snhu.edu/companyfina
ezproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=12161&period=Annuals&dataarea=PL&range=3¤cy=A
dataarea=PL&range=3¤cy=AsRep&scale=AsRep&Submit=Refresh
Powered by Clearbit
Apple Inc (NMS: AAPL)
Exchange rate used is that of the Year End reported date
As Reported Annual Income Statement
Report Date
Currency
Audit Status
Consolidated
Scale
Products
Services
Net sales
Cost of sales – products
Cost of sales – services
Cost of sales
Gross margin
Research & development expense
Selling, general & administrative expense
Total operating expenses
Operating income (loss)
Interest & dividend income
Interest expense
Other income (expense), net
Other income/(expense), net
Income (loss) before provision for income taxes
Current federal income tax expense (benefit)
Deferred federal income tax expense (benefit)
Total federal income tax expense (benefit)
Current state income tax expense (benefit)
Deferred state income tax expense (benefit)
Total state income tax expense (benefit)
Current foreign income tax expense (benefit)
Deferred foreign income tax expense (benefit)
Total foreign income tax expense (benefit)
Provision for (benefit from) income taxes
Net income (loss)
Weighted average shares outstanding – basic
Weighted average shares outstanding – diluted
Year end shares outstanding
Net earnings (loss) per common share – basic
Net earnings (loss) per common share – diluted
Cash dividends declared per common share
Number of full time employees
Number of common stockholders
Foreign currency translation adjustments
Reference
09/28/2019
USD
Not Qualified
Yes
Thousands
213883000
46291000
260174000
144996000
16786000
161782000
98392000
16217000
18245000
34462000
63930000
4961000
3576000
422000
1807000
65737000
6384000
-2939000
3445000
475000
-67000
408000
3962000
2666000
6628000
10481000
55256000
4617834
4648913
4443236
11,97
11,89
137000
23233
-408000
Mergent Online. (2018). Apple Inc Retrieved July 12, 2020 from:https://www-mergentonline-com.ezproxy.snhu.edu/companyfina
xy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=12161&period=Annuals&dataarea=PL&range=3¤cy=AsRe
rea=PL&range=3¤cy=AsRep&scale=AsRep&Submit=Refresh
Powered by Clearbit
Apple Inc (NMS: AAPL)
Last 7 Business Day Stock Prices
Date
Close
07/10/2020
07/09/2020
07/08/2020
07/07/2020
07/06/2020
07/02/2020
07/01/2020
383,68
382,73
381,37
372,69
373,85
364,11
364,11
Rate Of Return
5,37 The stock had a 5.37 percent return
Mergent Online. (2018). Apple Inc Retrieved July 12, 2020 from:https://www-mergentonline-com.ezproxy.snhu.edu/equitypricing
Mergent Online. (2018). Company A Retrieved January 21, 2018 from:https://www-mergentonline-com.ezproxy.snhu.edu/equity
xy.snhu.edu/equitypricing.php?ddexchange=037833100%7C1%7C0&datetype=fixedrange&timeperiod=3+years&datestartuserdef=&dateend
.ezproxy.snhu.edu/equitypricing.php?ddexchange=037833100%7C1%7C0&datetype=fixedrange&timeperiod=3+years&datestartuserdef=&d
atestartuserdef=&dateenduserdef=&frequency=daily&compnumber=12161&pagetype=report&selectedissue=Apple+Inc%28NMS%3AAAPL%
ars&datestartuserdef=&dateenduserdef=&frequency=daily&compnumber=12161&pagetype=report&selectedissue=Apple+Inc%28NMS%3AA
+Inc%28NMS%3AAAPL%29&refreshequityreport=Refresh
Apple+Inc%28NMS%3AAAPL%29&refreshequityreport=Refresh
Powered by Clearbit
Apple Inc (NMS: AAPL)
Exchange rate used is that of the Year End reported date
As Reported Annual Cash Flow
Report Date
Currency
Audit Status
09/30/2017
USD
Not Qualified
Consolidated
Yes
Scale
Thousands
Net income (loss)
48351000
Depreciation & amortization
10157000
Share-based compensation expense
4840000
Deferred income tax expense (benefit)
5966000
Other adjustments
-166000
Accounts receivable, net
-2093000
Inventories
-2723000
Vendor non-trade receivables
-4254000
Other current & non-current assets
-5318000
Accounts payable
9618000
Deferred revenue
-626000
Other current & non-current liabilities
-154000
Net cash flows from operating activities
63598000
Purchases of marketable securities
-159486000
Proceeds from maturities of marketable securities
31775000
Proceeds from sales of marketable securities
94564000
Payments made in connection with business acquisitions, net
-329000
Purchases of non-marketable securities
Proceeds from non-marketable securities
Payments for acquisition of property, plant & equipment
-12451000
Payment for acquisition of intangible assets
-344000
Payments for strategic investments
-395000
Other cash flow from investing activities
220000
Net cash flows from investing activities
-46446000
Proceeds from issuance of common stock
555000
Excess tax benefits from equity awards
627000
Payments for taxes related to net share settlement of equity awards -1874000
Payments for dividends & dividend equivalents
-12769000
Repurchases of common stock
-32900000
Proceeds from issuance of term debt, net
28662000
Repayments of term debt
-3500000
Proceeds from/(repayments of) commercial paper, net
3852000
Other cash flows from financing activities
Net cash flows from financing activities
-17347000
Net increase (decrease) in cash, cash equivalents & restricted cash
Cash, cash equivalents & restricted cash, beginning balances
Cash, cash equivalents & restricted cash, ending balances
–
Increase (decrease) in cash & cash equivalents
Cash & cash equivalents, beginning of the year
Cash & cash equivalents, end of the year
Cash paid (received) for income taxes, net
Cash paid for interest
-195000
20484000
20289000
11591000
2092000
Reference
Mergent Online. (2018). Apple Inc Retrieved July 12, 2020 from:https://www-mergentonline-com.ezproxy.snhu.edu/companyfina
zproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=12161&period=Annuals&dataarea=CF&range=3¤cy=A
ataarea=CF&range=3¤cy=AsRep&scale=AsRep&Submit=Refresh
Powered by Clearbit
Apple Inc (NMS: AAPL)
Exchange rate used is that of the Year End reported date
As Reported Annual Cash Flow
Report Date
Currency
Audit Status
09/29/2018
USD
Not Qualified
Consolidated
Yes
Scale
Thousands
Net income (loss)
59531000
Depreciation & amortization
10903000
Share-based compensation expense
5340000
Deferred income tax expense (benefit)
-32590000
Other adjustments
-444000
Accounts receivable, net
-5322000
Inventories
828000
Vendor non-trade receivables
-8010000
Other current & non-current assets
-423000
Accounts payable
9175000
Deferred revenue
-44000
Other current & non-current liabilities
38490000
Net cash flows from operating activities
77434000
Purchases of marketable securities
-71356000
Proceeds from maturities of marketable securities
55881000
Proceeds from sales of marketable securities
47838000
Payments made in connection with business acquisitions, net
-721000
Purchases of non-marketable securities
-1871000
Proceeds from non-marketable securities
353000
Payments for acquisition of property, plant & equipment
-13313000
Payment for acquisition of intangible assets
Payments for strategic investments
Other cash flow from investing activities
-745000
Net cash flows from investing activities
16066000
Proceeds from issuance of common stock
669000
Excess tax benefits from equity awards
Payments for taxes related to net share settlement of equity awards -2527000
Payments for dividends & dividend equivalents
-13712000
Repurchases of common stock
-72738000
Proceeds from issuance of term debt, net
6969000
Repayments of term debt
-6500000
Proceeds from/(repayments of) commercial paper, net
-37000
Other cash flows from financing activities
Net cash flows from financing activities
-87876000
Net increase (decrease) in cash, cash equivalents & restricted cash
Cash, cash equivalents & restricted cash, beginning balances
Cash, cash equivalents & restricted cash, ending balances
–
Increase (decrease) in cash & cash equivalents
Cash & cash equivalents, beginning of the year
Cash & cash equivalents, end of the year
Cash paid (received) for income taxes, net
Cash paid for interest
5624000
20289000
25913000
10417000
3022000
Reference
Mergent Online. (2018). Apple Inc Retrieved July 12, 2020 from:https://www-mergentonline-com.ezproxy.snhu.edu/companyfina
proxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=12161&period=Annuals&dataarea=CF&range=3¤cy=As
taarea=CF&range=3¤cy=AsRep&scale=AsRep&Submit=Refresh
Powered by Clearbit
Apple Inc (NMS: AAPL)
Exchange rate used is that of the Year End reported date
As Reported Annual Cash Flow
Report Date
Currency
Audit Status
09/28/2019
USD
Not Qualified
Consolidated
Yes
Scale
Thousands
Net income (loss)
55256000
Depreciation & amortization
12547000
Share-based compensation expense
6068000
Deferred income tax expense (benefit)
-340000
Other adjustments
-652000
Accounts receivable, net
245000
Inventories
-289000
Vendor non-trade receivables
2931000
Other current & non-current assets
873000
Accounts payable
-1923000
Deferred revenue
-625000
Other current & non-current liabilities
-4700000
Net cash flows from operating activities
69391000
Purchases of marketable securities
-39630000
Proceeds from maturities of marketable securities
40102000
Proceeds from sales of marketable securities
56988000
Payments made in connection with business acquisitions, net
-624000
Purchases …
Purchase answer to see full
attachment