Use the extended DuPont equation to provide a summary and overview of your firm’s financial condition.Be sure to do all calculations for 3 years, using Excel. Use real numbers from the financials, not reported ratios provided by online and other sources. Show the source of the numbers. Include the balance sheet and income statement and as many exhibits as you wishALPHABET INC CLASS C CAPITAL STOCK
(GOOG) CashFlowFlag INCOME STATEMENT
Fiscal year ends in December. USD in millions except per share data.
2010-12 2011-12
2012
2013
2014 TTM
Revenue
29321
37905
50175
59825
66001 71763
Cost of revenue
10417
13188
20634
25858
25691 26897
Gross pro±t
18904
24717
29541
33967
40310 44866
Opera²ng expenses
Research and development
3762
5162
6793
7952
9832 11585
Sales, General and administra²ve
4761
7313
9988
12049
13982 14902
Other opera²ng expenses
500
Total opera²ng expenses
8523
12975
16781
20001
23814 26487
Opera²ng income
10381
11742
12760
13966
16496 18379
Interest Expense
58
84
83
101
103
Other income (expense)
415
642
710
613
864
702
Income before taxes
10796
12326
13386
14496
17259 18978
Provision for income taxes
2291
2589
2598
2282
3331
3537
Net income from con²nuing opera²ons
8505
9737
10788
12214
13928 15441
Net income from discon²nuing ops
-51
706
516
967
Net income
8505
9737
10737
12920
14444 16408
Preferred dividend
522
Net income available to common shareholders
8505
9737
10737
12920
14444 15886
Earnings per share
Basic
13.36
15.1
16.42
19.43
21.37
23.28
Diluted
13.17
14.89
16.17
19.08
21.02
23.08
Weighted average shares outstanding
Basic
637
645
645
665
676
682
Diluted
646
654
645
677
687
688
EBITDA
11777
14235
16432
18518
22339 24007
This question was answered on: Sep 21, 2023
Solution~00021147635897.zip (25.37 KB)
This attachment is locked
Our expert Writers have done this assignment before, you can reorder for a fresh, original and plagiarism-free copy and it will be redone much faster (Deadline assured. Flexible pricing. TurnItIn Report provided)
Answered
QUALITYApproved
DATE ANSWEREDSep 21, 2023
EXPERTTutor
ANSWER RATING
We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.
You can also use these solutions:
