Vertical Horizontal & Ratio Analysis of Financial Statement Presentation create a vertical, horizontal, & ratio analysis of the most recent year and the pr

Vertical Horizontal & Ratio Analysis of Financial Statement Presentation create a vertical, horizontal, & ratio analysis of the most recent
year and the prior year from the most recent 10-k that is available from
your chosen company. I need someone majoring in accounting Apple
Income Statement
Net Sales
Cost of Sales
Gross Margin
Operating Exp
R&D
SGA
Total Operating
Operating Income
Other income(expense)
Income before taxes
Income taxes
Net Income
EPS
Balance Sheet
Assets
Current Assets
Cash
ST Marketable Securities
A/R
Inventories
Vendor non-trade receivables
Other current assets
Total current assets
LT marketable securities
PPE
Other non-current assets
Total assets
Liabilities
Current Liabilities
A/P
Accrued expenses
Deferred revenue
Commercial paper
Current portion of LT debt
Total current liabilities
LT debt
Other LT Liabilities
Total liabilities
Shareholders’ equity
Common stock/APIC
Retained Earnings
Comprehensive Income
Total shareholders equity
Total Liabilities/SE
2019
260174
161782
98392
2018
265595
163756
101839
16217
18245
34462
63930
1807
65737
10481
55256
14236
16705
30941
70898
2005
72903
13372
59531
11.97
12.01
48844
51713
22926
4106
22878
12352
162819
105341
37378
32978
338516
25913
40388
23186
3956
25809
12087
131339
170799
41304
22283
365725
46236
37720
5522
5980
10260
105718
91807
50503
248028
55888
33327
5966
11964
8784
115929
93735
48914
258578
45174
45898
-584
90488
338516
40201
70400
-3454
107147
365725
Apple
Net Sales
Cost of Sales
Gross Margin
Operating Exp
R&D
SGA
Total Operating
Operating Income
Other income(expense)
Income before taxes
Income taxes
Net Income
Balance Sheet
Assets
Current Assets
Cash
ST Marketable Securities
A/R
Inventories
Vendor non-trade receivables
Other current assets
Total current assets
LT marketable securities
PPE
Other non-current assets
Total assets
Liabilities
Current Liabilities
A/P
Accrued expenses
Deferred revenue
Commercial paper
Current portion of LT debt
Total current liabilities
LT debt
Other LT Liabilities
Total liabilities
Shareholders’ equity:
Common stock/APIC
Retained Earnings
Comprehensive Income
Total shareholders equity
Total Liabilities/SE
2019
260174
161782
98392
100%
62%
38%
2018
265595
163756
101839
16217
18245
34462
63930
1807
65737
10481
55256
6%
7%
13%
25%
1%
25%
4%
21%
14236
16705
30941
70898
2005
72903
13372
59531
48844
51713
22926
4106
22878
12352
162819
105341
37378
32978
338516
14%
15%
7%
1%
7%
4%
48%
31%
11%
10%
100%
25913
40388
23186
3956
25809
12087
131339
170799
41304
22283
365725
7%
11%
6%
1%
7%
3%
36%
47%
11%
6%
100%
46236
37720
5522
5980
10260
105718
91807
50503
248028
14%
11%
2%
2%
3%
31%
27%
15%
73%
55888
33327
5966
11964
8784
115929
93735
48914
258578
15%
9%
2%
3%
2%
32%
26%
13%
71%
45174
45898
-584
90488
338516
13%
14%
0%
27%
100%
40201
70400
-3454
107147
365725
11%
19%
-1%
29%
100%
100%
62% COGS Margin
38% Gross Margin
5%
6%
12%
27% Operating Margin
1%
27%
5%
22% Profit Margin
Apple
Net Sales
Cost of Sales
Gross Margin
Operating Exp
R&D
SGA
Total Operating
Operating Income
Other income(expense)
Income before taxes
Income taxes
Net Income
Balance Sheet
Assets
Current Assets
Cash
ST Marketable Securities
A/R
Inventories
Vendor non-trade receivables
Other current assets
Total current assets
LT marketable securities
PPE
Other non-current assets
Total assets
Liabilities
Current Liabilities
A/P
Accrued expenses
Deferred revenue
Commercial paper
Current portion of LT debt
Total current liabilities
LT debt
Other LT Liabilities
Total liabilities
Shareholders’ equity:
Common stock/APIC
Retained Earnings
Comprehensive Income
Total shareholders equity
Total Liabilities/SE
2019
260174
161782
98392
2018
265595
163756
101839
Change % Change
-5421
-2.0%
-1974
-1.2%
-3447
-3.4%
16217
18245
34462
63930
1807
65737
10481
55256
14236
16705
30941
70898
2005
72903
13372
59531
1981
1540
3521
-6968
-198
-7166
-2891
-4275
13.9%
9.2%
11.4%
-9.8%
-9.9%
-9.8%
-21.6%
-7.2%
48844
51713
22926
4106
22878
12352
162819
105341
37378
32978
338516
25913
40388
23186
3956
25809
12087
131339
170799
41304
22283
365725
22931
11325
-260
150
-2931
265
31480
-65458
-3926
10695
-27209
88.5%
28.0%
-1.1%
3.8%
-11.4%
2.2%
24.0%
-38.3%
-9.5%
48.0%
-7.4%
46236
37720
5522
5980
10260
105718
91807
50503
248028
55888
33327
5966
11964
8784
115929
93735
48914
258578
-9652
4393
-444
-5984
1476
-10211
-1928
1589
-10550
-17.3%
13.2%
-7.4%
-50.0%
16.8%
-8.8%
-2.1%
3.2%
-4.1%
45174
45898
-584
90488
338516
40201
70400
-3454
107147
365725
4973
-24502
2870
-16659
-27209
12.4%
-34.8%
-83.1%
-15.5%
-7.4%
2019
Cash Ratio
0.95
Current Ratio
1.54
Quick Ratio
1.17
Working Capital
$ 57,101
A/R Turnover
11.28x
DSO
32.35 days
Inventory Turnover
40.13x
Days
9.09 days
A/P Turnover
3.17x
DPO
115.20 days
Operating Cycle
51.42 days
ROA
16%
ROE
56%
P/E Ratio (last day of fiscal yr)
18.28
Debt/Equity
2.74x
Interest Coverage
35.38x
Debt/Assets
0.73x
(Cash + marketable securities)/CL
CA/CL
(Cash + marketable securities + AR)/CL
CA-CL
Sales/Avg AR
365/AR Turnover
COGS/Avg Inventory
365/Inventory Turnover
COGS/Avg AP
365/AP Turnover
Days sales in AR + Days Sales in inventory
Income/Avg Total Assets
Income/Average Equity
Market Price/EPS
Liab/SE
EBIT/Interest Expense
Liab/Assets
EBIT
EPS
Earnings before Interest/taxes
Earnings per Share Outstanding
Case Study Project:
Please create a vertical, horizontal, & ratio analysis of the most recent year and the prior year from the
most recent 10-k that is available from your chosen company.
Please prepare these ratios below for the most recent year to show how the company is doing. You
must calculate the formulas yourself. You are not allowed to copy off the internet. The numbers are
not always accurate. Some companies may not use every formula, i.e. inventory.
You can present the information in any format you want. Use excel to compute your calculations. You
can present in powerpoints or in excel, whatever conveys the information about your company the best.
You may add graphs or pictures if it enhances your presentation.
Be prepared to present your company for about 5-7 minutes to show how they are doing, and if you
would recommend their stock and why. If you have recent news releases, or additional information that
you can find to enhance your presentation, that is welcomed. Be prepared to answer questions after
your presentation.
You will be graded on your calculation accuracy, presentation,
Cash Ratio
Current Ratio
Quick Ratio
Working Capital ($)
A/R Turnover (times)
DSO-Days Sales Outstanding
Inventory Turnover (times)
Inventory Turnover Days
A/P Turnover (times)
DPO-Days Payable
Outstanding
Operating Cycle
ROA-Return on Assets
ROE-Return on Equity
P/E Ratio (last day of fiscal yr)
Debt/Equity
Interest Coverage
Debt/Assets
(Cash + marketable securities)/CL
CA/CL
(Cash + marketable securities + AR)/CL
CA-CL
Sales/Avg AR
365/AR Turnover
COGS/Avg Inventory
365/Inventory Turnover
COGS/Avg AP
EBIT
EPS
Earnings before Interest/taxes
Earnings per Share Outstanding
365/AP Turnover
Days sales in AR + Days Sales in inventory
Income/Avg Total Assets
Income/Average Equity
Market Price/EPS
Liab/SE
EBIT/Interest Expense
Liab/Assets

Purchase answer to see full
attachment