0% found this document useful (0 votes)
3 views8 pages

Stock Performance and Financial Analysis

Uploaded by

mint chocolate
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
3 views8 pages

Stock Performance and Financial Analysis

Uploaded by

mint chocolate
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

a)

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

b) Rate of return

ORCL 10.46% 0.96% 0.78% 4.74% 6.18%


MSFT -1.30% 2.02% 3.95% 2.94% -1.04%
NVDA 0.15% 38.40% -4.25% 7.34% -7.05%

c) Relative return
ORCL 110.46% 100.96% 100.78% 104.74% 106.18%
MSFT 98.70% 102.02% 103.95% 102.94% 98.96%
NVDA 100.15% 138.40% 95.75% 107.34% 92.95%

d) Total return
ORCL 25.01%
MSFT 6.62%
NVDA 32.41%

e) Compound Annual Return


ORCL 4.56%
MSFT 1.29%
NVDA 5.77%

f) Average return (GEOMETRIC)


ORCL 4.56%
MSFT 1.29%
NVDA 5.77%

g) Average Return (Arithmetic)


ORCL 4.63% or 4.63%
MSFT 1.31% or 1.31%
NVDA 6.92% or 6.92%

h)
Ticker 1/31/2017 2/28/2017 3/31/2017 4/30/2017 5/31/2017
ORCL 40.11 42.59 44.61 44.96 45.39
MSFT 64.65 63.98 65.86 68.46 69.84
NVDA 109.18 101.48 108.93 104.3 144.35

ORCL, MSFT & NVDA Closing Price


160
140
120
100
Price in $ 80
60
40
20
0
1/31/2017 2/28/2017 3/31/2017 4/30/2017 5/31/2017 6/30/2017

Month

ORCL MSFT NVDA


6/30/2017
50.14
68.93
144.56

Price

31/2017 6/30/2017

NVDA
Intel Corporation
Income Statement ($ millions)
Dec-16 Dec-15 Dec-14 Dec-13
Sales 59,387 55,355 55,870 52,708
Cost of Goods Sold (COGS) incl. D&A 23,425 20,651 20,522 21,418
Gross Income 35,962 34,704 35,348 31,290
SG&A Expense 21,149 19,835 19,693 18,729
EBIT (Operating Income) 14,813 14,869 15,655 12,561
Nonoperating Income - Net 533 -51 224 595
Interest Expense 733 337 192 244
Unusual Expense - Net 1,677 269 -114 301
Pretax Income 12,936 14,212 15,801 12,611
Income Taxes 2,620 2,792 4,097 2,991
Net Income 10,316 11,420 11,704 9,620

Average Tax Rate 20.25% 19.65% 25.93% 23.72%


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

Intel Corporation
70.00%

60.00%

50.00%

40.00%

30.00%

20.00%

10.00%

0.00%
1 2 3 4 5

Gross Profit Margin Net Profit Margin

Intel Corporation
Income Statement ($ millions)
Dec-16 Dec-15 Dec-14 Dec-13
Sales 100.00% 100.00% 100.00% 100.00%
Cost of Goods Sold (COGS) incl. D&A 39.44% 37.31% 36.73% 40.64%
Gross Income 60.56% 62.69% 63.27% 59.36%
SG&A Expense 35.61% 35.83% 35.25% 35.53%
EBIT (Operating Income) 24.94% 26.86% 28.02% 23.83%
Nonoperating Income - Net 0.90% -0.09% 0.40% 1.13%
Interest Expense 1.23% 0.61% 0.34% 0.46%
Unusual Expense - Net 2.82% 0.49% -0.20% 0.57%
Pretax Income 21.78% 25.67% 28.28% 23.93%
Income Taxes 4.41% 5.04% 7.33% 5.67%
Net Income 17.37% 20.63% 20.95% 18.25%
Dec-12
53,341
20,507
32,834
18,117
14,717
463
90
217
14,873
3,868
11,005

26.01%
61.55%
20.63%

Dec-12
100.00%
38.45%
61.55%
33.96%
27.59%
0.87%
0.17%
0.41%
27.88%
7.25%
20.63%

You might also like