Real World Problem 1: Analyzing Financial Statements
body preview (0 words)
file1.xlsx preview (379 words)
Vertical
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Apple xxxxxxxxx Inc. (AAPL)
xxxxxx xxxxxxxxx
xxxxxxxx Common Size
xxxx 2014
Sales xxxxxxx xxxxxxxxxxxx 100.00% xxxxxxxxxxxx 100.00%
Cost xx goods xxxx x 140,089,000 59.94% * xxxxxxxxxxx 61.41%
xxxxx xxxxxx * xxxxxxxxxx 40.06% x 70,537,000 xxxxxx
xxxxxxxxx
Research and xxxxxxxxxxx * xxxxxxxxx 3.45% * xxxxxxxxx 3.30%
Selling, general and administration x 14,329,000 xxxxx x 11,993,000 6.56%
Executive bonus 0.00% xxx xxxxx
Restructuring costs 0.00% xxx xxxxx
In-process xxxxxxxx and xxxxxxxxxxx 0.00% 0.00%
xxxxx xxxxxxxxx xxxxxxxx x xxxxxxxxxx xxxxx * 18,034,000 9.87%
xxxxxxxxx xxxxxx * 71,230,000 xxxxxx x xxxxxxxxxx xxxxxx
xxxxx income xxx (expenses) * xxxxxxxxx xxxxx * xxxxxxx xxxxx
xxxxxxxx xxxxxx xxxxxxxx xxx xxxxx x 72,515,000 xxxxxx * 53,483,000 xxxxxx
Interest Expense
Income Before xxx
Income xxx xxxxxxx x 19,121,000 xxxxx x 13,973,000 7.64%
Minority Interest
Net Income xxxx Continuing Ops $53,394,000 xxxxxx $39,510,000 xxxxxx
Non-recurring Events
Discontinued xxxxxxxxxx 0.0 0.00% 0.0 0.00%
Extraordinary xxxxx 0.0 0.00% 0.0 xxxxx
xxxxxx of xxxxxxxxxx xxxxxxx 0.0 0.00% 0.0 0.00%
xxxxx Items xxx xxxxx 0.0 0.00%
xxx Income xxxxxxxxxxx xxxxxx xxxxxxxxxxx 56.01%
Amazon.com Inc xxxxxx
xxxxxx xxxxxxxxx
xxxxxxxx Common Size
xxxx xxxx
xxxxx Revenue $107,006,000 xxxxxxx $88,988,000 100.00%
xxxx xx goods xxxx * xxxxxxxxxx xxxxxx x xxxxxxxxxx xxxxxx
Gross profit * xxxxxxxxxx 33.04% x 26,236,000 29.48%
Expenses:
Research xxx xxxxxxxxxxx 0.0 xxxxx xxx xxxxx
Selling, xxxxxxx xxx administration * 33,122,000 30.95% x 26,058,000 xxxxxx
xxxxxxxxx bonus xxxxx xxx xxxxx
xxxxxxxxxxxxx costs 0.00% xxx xxxxx
In-process research xxx xxxxxxxxxxx xxxxx 0.00%
Total xxxxxxxxx expenses * 33,122,000 30.95% x xxxxxxxxxx xxxxxx
Operating xxxxxx * xxxxxxxxx xxxxx x xxxxxxx 0.20%
xxxxx income and (expenses) x (206,000) xxxxxx x xxxxxxxx xxxxxx
xxxxxxxx Before xxxxxxxx and Taxes * xxxxxxxxx 1.89% x 99,000 0.11%
xxxxxxxx xxxxxxx *
