Mayes 8e CH01 Solutions

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 18

Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017

ORCL 50.14 45.39 44.96 44.61 42.59 40.11


MSFT 68.93 69.84 68.46 65.86 63.98 64.65
NVDA 144.56 144.35 104.3 108.93 101.48 109.18
Return 160
ORCL 10.46% 0.96% 0.78% 4.74% 6.18% 140
MSFT -1.30% 2.02% 3.95% 2.94% -1.04% 120
NVDA 0.15% 38.40% -4.25% 7.34% -7.05% 100

Price in $
Relative Return 80
ORCL 110.46% 100.96% 100.78% 104.74% 106.18% 60
MSFT 98.70% 102.02% 103.95% 102.94% 98.96% 40
NVDA 100.15% 138.40% 95.75% 107.34% 92.95% 20
Total Return Compound Annual Return 0
ORCL 25.01% ORCL 4.56%
MSFT 6.62% MSFT 1.29%
NVDA 32.41% NVDA 5.77%
Average Return (geometric) Average Return (arithmetic)
ORCL 4.56% ORCL 4.63% or 4.63%
MSFT 1.29% MSFT 1.31% or 1.31%
NVDA 5.77% NVDA 6.92% or 6.92%
Oracle, Microsoft, and Nvidia
Closing Prices
160
140
120
ORCL
100
MSFT
Price in $

80
NVDA
60
40
20
0
42766 42794 42825 42855 42886 6/30/2017
Months
Intel Corporation
(Financial Data in U.S. $Million)
Dec-16 Dec-15 Dec-14 Dec-13 Dec-12
Sales 59,387 55,355 55,870 52,708 53,341
Cost of Goods Sold (COGS) incl. D&A 23,425 20,651 20,522 21,418 20,507
Gross Income 35,962 34,704 35,348 31,290 32,834
SG&A Expense 21,149 19,835 19,693 18,729 18,117
EBIT (Operating Income) 14,813 14,869 15,655 12,561 14,717
Nonoperating Income - Net 533 -51 224 595 463
Interest Expense 733 337 192 244 90
Unusual Expense - Net 1,677 269 -114 301 217
Pretax Income 12,936 14,212 15,801 12,611 14,873
Income Taxes 2,620 2,792 4,097 2,991 3,868
Net Income 10,316 11,420 11,704 9,620 11,005

Average Tax Rate 20.25% 19.65% 25.93% 23.72% 26.01%


Gross Profit Margin 60.56% 62.69% 63.27% 59.36% 61.55%
Net Profit Margin 17.37% 20.63% 20.95% 18.25% 20.63%

Intel Corporation
(Financial Data in U.S. $Million)
Dec-16 Dec-15 Dec-14 Dec-13 Dec-12
Sales 100.00% 100.00% 100.00% 100.00% 100.00%
Cost of Goods Sold (COGS) incl. D&A 39.44% 37.31% 36.73% 40.64% 38.45%
Gross Income 60.56% 62.69% 63.27% 59.36% 61.55%
SG&A Expense 35.61% 35.83% 35.25% 35.53% 33.96%
EBIT (Operating Income) 24.94% 26.86% 28.02% 23.83% 27.59%
Nonoperating Income - Net 0.90% -0.09% 0.40% 1.13% 0.87%
Interest Expense 1.23% 0.61% 0.34% 0.46% 0.17%
Unusual Expense - Net 2.82% 0.49% -0.20% 0.57% 0.41%
Pretax Income 21.78% 25.67% 28.28% 23.93% 27.88%
Income Taxes 4.41% 5.04% 7.33% 5.67% 7.25%
Net Income 17.37% 20.63% 20.95% 18.25% 20.63%
Intel Corporation
70%
60%
50%
Percentage

40%
Gross Profit Margin
30%
Net Profit Margin
20%
10%
0%
Dec-16 Dec-15 Dec-14 Dec-13 Dec-12
Years
Intel Corporation
Balance Sheet ($ millions)
Dec-16 Dec-15 Dec-14 Dec-13
Assets
Cash & Short-Term Investments 17,099 25,313 14,054 20,087
Short-Term Receivables 5,074 5,530 4,427 3,647
Inventories 5,553 5,167 4,273 4,172
Other Current Assets 7,782 4,346 4,976 4,178
Total Current Assets 35,508 40,356 27,730 32,084
Net Fixed Assets 77,819 62,709 64,226 60,274
Total Assets 113,327 103,065 91,956 92,358
Liabilities & Shareholders' Equity
ST Debt & Curr. Portion LT Debt 4,634 2,634 1,604 281
Accounts Payable 2,475 2,063 2,748 2,969
Income Tax Payable 329 272 443 542
Other Current Liabilities 12,864 10,698 11,224 9,776
Total Current Liabilities 20,302 15,667 16,019 13,568
Long-Term Debt 20,649 20,036 12,107 13,165
Deferred Tax Liabilities 1,730 2,539 3,775 4,397
Other Liabilities 3,538 2,841 3,278 2,972
Total Liabilities 46,219 41,083 35,179 34,102
Preferred Stock (Carrying Value) 882 897 912 0
Common Equity 66,226 61,085 55,865 58,256
Total Shareholders' Equity 67,108 61,982 56,777 58,256
Total Liabilities & Shareholders' Equity 113,327 103,065 91,956 92,358

Debt 40.78% 39.86% 38.26% 36.92%


Equity 59.22% 60.14% 61.74% 63.08%

Intel Corporation
Balance Sheet ($ millions)
Dec-16 Dec-15 Dec-14 Dec-13
Assets
Cash & Short-Term Investments 15.09% 24.56% 15.28% 21.75%
Short-Term Receivables 4.48% 5.37% 4.81% 3.95%
Inventories 4.90% 5.01% 4.65% 4.52%
Other Current Assets 6.87% 4.22% 5.41% 4.52%
Total Current Assets 31.33% 39.16% 30.16% 34.74%
Net Fixed Assets 68.67% 60.84% 69.84% 65.26%
Total Assets 100.00% 100.00% 100.00% 100.00%
Liabilities & Shareholders' Equity
ST Debt & Curr. Portion LT Debt 4.09% 2.56% 1.74% 0.30%
Accounts Payable 2.18% 2.00% 2.99% 3.21%
Income Tax Payable 0.29% 0.26% 0.48% 0.59%
Other Current Liabilities 11.35% 10.38% 12.21% 10.58%
Total Current Liabilities 17.91% 15.20% 17.42% 14.69%
Long-Term Debt 18.22% 19.44% 13.17% 14.25%
Deferred Tax Liabilities 1.53% 2.46% 4.11% 4.76%
Other Liabilities 3.12% 2.76% 3.56% 3.22%
Total Liabilities 40.78% 39.86% 38.26% 36.92%
Preferred Stock (Carrying Value) 0.78% 0.87% 0.99% 0.00%
Common Equity 58.44% 59.27% 60.75% 63.08%
Total Shareholders' Equity 59.22% 60.14% 61.74% 63.08%
Total Liabilities & Shareholders' Equity 100.00% 100.00% 100.00% 100.00%
Intel Corporation (2016 Capital Structure)
Dec-12

18,162
4,699
4,734 Debt
40.78% Equity
3,763
31,358 59.22%
52,993
84,351

312
3,023
711
8,852 Intel Corporation
12,898
Capital Structure over Time
13,136 70.00%

3,412 60.00%
3,702 50.00%
33,148
Percentage

40.00% Debt
0 Equity
30.00%
51,203
20.00%
51,203
10.00%
84,351
0.00%
Dec-12 Dec-13 Dec-14 Dec-15 Dec-16
39.30% Date
60.70%

Intel Corporation
Dec-12 Balance Sheet Items as a % of Total Assets
80.00%
21.53%
70.00%
5.57%
5.61% 60.00%

4.46% 50.00%
37.18%
40.00%
62.82%
100.00% 30.00%

20.00%
0.37%
10.00%

0.00%
Dec-12 Dec-13 Dec-14 Dec-15 Dec-16
30.00%

20.00%

3.58% 10.00%

0.84% 0.00%
Dec-12 Dec-13 Dec-14 Dec-15 Dec-16
10.49%
15.29% Total Current Assets Net Fixed Assets
15.57% Total Current Liabilities Long-Term Debt
4.05%
4.39%
39.30%
0.00%
60.70%
60.70%
100.00%
ure)

Debt
Equity

Debt
Equity

ec-16

ets

Dec-16
Dec-16
Intel Corporation
Balance Sheet Growth Rates
Dec-16 Dec-15 Dec-14 Dec-13
Assets
Cash & Short-Term Investments -32.45% 80.11% -30.03% 10.60%
Short-Term Receivables -8.25% 24.92% 21.39% -22.39%
Inventories 7.47% 20.92% 2.42% -11.87%
Other Current Assets 79.06% -12.66% 19.10% 11.03%
Total Current Assets -12.01% 45.53% -13.57% 2.32%
Net Fixed Assets 24.10% -2.36% 6.56% 13.74%
Total Assets 9.96% 12.08% -0.44% 9.49%
Liabilities & Shareholders' Equity
ST Debt & Curr. Portion LT Debt 75.93% 64.21% 470.82% -9.94%
Accounts Payable 19.97% -24.93% -7.44% -1.79%
Income Tax Payable 20.96% -38.60% -18.27% -23.77%
Other Current Liabilities 20.25% -4.69% 14.81% 10.44%
Total Current Liabilities 29.58% -2.20% 18.06% 5.19%
Long-Term Debt 3.06% 65.49% -8.04% 0.22%
Deferred Tax Liabilities -31.86% -32.74% -14.15% 28.87%
Other Liabilities 24.53% -13.33% 10.30% -19.72%
Total Liabilities 12.50% 16.78% 3.16% 2.88%
Preferred Stock (Carrying Value) -1.67% -1.64% #DIV/0! #DIV/0!
Common Equity 8.42% 9.34% -4.10% 13.77%
Total Shareholders' Equity 8.27% 9.17% -2.54% 13.77%
Total Liabilities & Shareholders' Equity 9.96% 12.08% -0.44% 9.49%
CAGR Avg Growth Rate

-1.50% 7.06%
1.94% 3.92%
4.07% 4.74%
19.92% 24.13%
3.16% 5.57%
10.08% 10.51%
7.66% 7.77%

96.31% 150.26%
-4.88% -3.55%
-17.52% -14.92%
9.80% 10.20%
12.01% 12.66%
11.97% 15.18%
-15.62% -12.47%
-1.13% 0.44%
8.67% 8.83%
#DIV/0! #DIV/0!
6.64% 6.86%
7.00% 7.17%
7.66% 7.77%
Chevron Corporation
(Data is US$ Million) Chevron Cor
2013 2014 2015 2016 (Data in US$
Total Revenue 228,848 211,970 138,477 114,472
Net Income 21,423 19,241 4,587 (497) 14%
Total Assets 253,753 266,026 264,540 260,078 10%
Total Equity 149,113 155,028 152,716 145,556

Return
6%
Net Profit Margin 9.36% 9.08% 3.31% -0.43%
2%
Return on Assets 8.44% 7.23% 1.73% -0.19%
Return on Equity 14.37% 12.41% 3.00% -0.34% -2%
2013 2014 2015
Years
Chevron Corporation
(Data in US$ Million)

Net Profit Margin


Return on Assets
Return on Equity

2013 2014 2015 2016


Years
Variable 1 25 Variable 1 5 Cash & Sho 17,099
Variable 2 10 Variable 2 3 Short-Term 5,074
Variable 3 7 Variable 3 7 Inventories 5,553
=B2-B1/B3+B2 =E2^2-E1*E2+E3 Other Curre 7,782

Total Current L 20,302


Total Current A 1.75

Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017


ORCL 50.14 45.39 44.96 44.61 42.59 40.11
Total Return 25.01%

Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017


ORCL 50.14 45.39 44.96 44.61 42.59 40.11
CAGR 4.56%

Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017


ORCL 50.14 45.39 44.96 44.61 42.59 40.11
Relative Retu 110.46% 100.96% 100.78% 104.74% 106.18%
Geometric M 4.56%

Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017


ORCL 50.14 45.39 44.96 44.61 42.59 40.11
Relative Retu 10.46% 0.96% 0.78% 4.74% 6.18%
Average Retu 4.63%

Variable 1 5
Variable 2 3
Variable 3 7
(2,163.60)

Variable 1 5
Variable 2 3
Variable 3 7
123.70

Variable 1 5
Variable 2 3
Variable 3 7
11.67
Note: Insert a single quote
in front of a formula to show
the formula, or delete the
single quote to display the
result. You can also use the
FormulaText formula to
display a formula.
Variable 1 25 Note: To get the result of the formula in B4, delete
Variable 2 10 the apostrophe before the equals sign.
Variable 3 7
=B2-B1/B3+B2
B4, delete

You might also like