Ratio Analysis

VYdOlINrON6i
Week3RatioAnalysis.xlsx
Home>Business & Finance homework help>Ratio Analysis

Apple Inc Analysis

A. 5-year Trend Analysis
5 Year trend analysis for Microsoft Net Sales
Apple Year end September (various dates) 2019 (28TH) 2018 (29th) 2017 (30th) 2016 (24th) 2015 (26th) Apple Year end September (various dates) 2019 (28TH) 2018 (29th) 2017 (30th) 2016 (24th) 2015 (26th)
Net Sales (in millions) 260,174 265,595 229,234 215,639 233,715 Net Sales (in millions) 260,174 265,595 229,234 215,639 233,715
Net Revenue change 1.11 1.14 0.98 0.92 1.00 Variance Amount 26,459 31,880 (4,481) (18,076) 0
Net Revenue % 111% 114% 98% 92% 100% Net Revenue % 11% 14% -2% -8% 0%
5 Year trend analysis for Net Income
Apple Fiscal Year end September (various dates) 2019 (28TH) 2018 (29th) 2017 (30th) 2016 (24th) 2015 (26th) Apple Fiscal Year end September (various dates) 2019 (28TH) 2018 (29th) 2017 (30th) 2016 (24th) 2015 (26th)
Net Income (in millions) 55,256 59,531 48,351 45,687 53,394 Net Income (in millions) 55,256 59,531 48,351 45,687 53,394
Net Revenue change 1.03 1.11 0.91 0.86 1.00 Net Revenue change 1,862 6,137 (5,043) (7,707) 0
Net Revenue % 103% 111% 91% 86% 100% Net Revenue % 3% 11% -9% -14% 0%
The calculations for Debt to asset ratio for Apple, INC. for 2 years (in millions):
Apple's INC 09/28/19 09/28/18
Financial Data (in millions)
Commercial Paper 5,980 11,964
Current term debt 10,260 8,784
Non-current liabilities Term Debt 91,807 93,735
Total Debt 108,047 114,483
Total Asset 338,516 365,725
Debt to Asset 0.32 0.31
The calculations Profit Margin for Apple Inc. for 2 years (in millions):
Gross Profit Margin Operating Profit Margin
Apple's INC 09/28/19 09/28/18 Apple's INC 09/28/19 09/28/18
Financial Data (in millions) Financial Data (in millions)
Gross Margin 98392 101839 Operating Income 63930 70898
Net Sales 260174 265595 Net Sales 260174 265595
Profit Marin 37.82% 38.34% Operating Profit Margin 24.57% 26.69%
The calculations Asset turnover for Apple Inc. for 2 years (in millions):
Total Asset Turnover Net Fixed Asset Turnover
Apple's INC 09/28/19 09/28/18 Apple's INC 09/28/19 09/28/18
Financial Data (in millions) Financial Data (in millions)
Net Sales 260,174 265,595 Net Sales 260,174 265,595
Total assets Prior Year 365,725 375,319 Property, plant and equipment 37,378 41,304
Total assets current year 338,516 365,725 Net Fixed Asset Turnover 6.96 6.43
Total 2 year asset 704,241 741,044
Average Asset 352,121 370,522
Asset Turnover 0.74 0.72
The calculations Return of Asset for Apple Inc. for 2 years (in millions):
Apple's INC 09/28/19 09/28/18
Financial Data (in millions)
Net income 55,256 59,531
Total assets Prior Year 365,725 375,319
Total assets current year 338,516 365,725
Total 2 year asset 704,241 741,044
Average Asset 352,121 370,522
ROA 15.69% 16.28%

HP Inc

A. 5-year Trend Analysis
5 Year trend analysis for HP, Inc Net Revenue
HP, Inc Year end December 31 2019 2018 2017 2016 2015 HP, Inc Year end December 31 2019 2018 2017 2016 2015
Net Revenue (in millions) 58,756 58,472 92,056 48,238 51,463 Net Revenue (in millions) 58,756 58,472 92,056 48,238 51,463
Net Revenue change 1.14 1.14 1.79 0.94 1.00 Variance Amount 7,293 7,009 40,593 (3,225) 0
Net Revenue % 114% 114% 179% 94% 100% Net Revenue % 14% 14% 79% -6% 0%
5 Year trend analysis for HP, Inc Net Income
HP, Inc Year end December 31 2019 2018 2017 2016 2015 HP, Inc Year end December 31 2019 2018 2017 2016 2015
Net Income (in millions) 3,152 5,327 2,526 2,496 4,554 Net Income (in millions) 3,152 5,327 2,526 2,496 4,554
Net Revenue change 0.69 1.17 0.55 0.55 1.00 Variance Amount -1,402 773 -2,028 -2,058 0
Net Revenue % 69% 117% 55% 55% 100% Net Revenue -31% 17% -45% -45% 0%
The calculations for Debt to asset ratio for HP, Inc for 2 years (in millions):
HP, Inc Inc INC 09/29/19 09/30/18
Financial Data (in millions)
Notes payable and short-term borrowing 357 1,463
Long-term debt 4,780 4,524
Total Debt 5,137 5,987
Total Asset 33,467 34,622
Debt to Asset 0.15 0.17
The calculations Profit Margin for HP, Inc for 2 years (in millions):
Gross Profit Margin Operating Profit Margin
HP, Inc Inc INC 10/31/19 10/31/18 HP, Inc Inc INC 10/31/19 10/31/18
Financial Data (in millions) Financial Data (in millions)
Net Revenue 54,879 54641 Operating Income 3,877 3,831
Cost of Revenue (47,586) (47,803) Net Revenue 58,756 58,472
Earnings from Operations 3,877 3,831 Operating Profit Margin 6.60% 6.55%
Gross Margin 11,170 10,669
Net Revenue 58,756 58,472
Profit Marin 19.01% 18.25%
1Gross Margin = Total cost and expenses -cost of revenue + Earnings from operation
The calculations Asset turnover for HP, Inc for 2 years (in millions):
Total Asset Turnover Net Fixed Asset Turnover
HP, Inc Inc INC 10/31/19 10/31/18 HP, Inc Inc INC 10/31/19 10/31/18
Financial Data (in millions) Financial Data (in millions)
Net Revenue 58,756 58,472 Net Revenue 58,756 58,472
Total assets Prior Year 34,622 32,913 Property, plant and equipment 2,794 2,198
Total assets current year 33,467 34,622 Net fixed asset turnover 21.029 26.602
Total 2 year asset 68,089 67,535
Average Asset 34,045 33,768
Asset Turnover 1.73 1.73
The calculations Return of Asset for HP, Inc for 2 years (in millions):
HP, Inc Inc INC 10/31/19 10/31/18
Financial Data (in millions)
Net income 3,152 5,327
Total assets Prior Year 34,622 32,913
Total assets current year 33,467 34,622
Total 2 year asset 68,089 67,535
Average Asset 34044.5 33767.5
9.3% 15.8%