Valuation Model-PEP.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	N	O	P	Q	R	S	T	U	V	W	X
1	Inputs
2		Income Statement (SimFin Standard)	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	Balance Sheet	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020
3		in million USD	FY '11	FY '12	FY '13	FY '14	FY '15	FY '16	FY '17	FY '18	FY '19	FY '20	Total Assets	72,882	74,638	77,478	70,509	69,667	73,490	79,804	77,648	78,547	92,918
4		Revenue	66,504	65,492	66,415	66,683	63,056	62,799	63,525	64,661	67,161	70,372	Total Liabilities	51,983	52,239	53,089	52,961	57,637	62,291	68,823	63,046	63,679	79,366
5		Operating Income (Loss)	9,633	9,112	9,705	9,581	9,712	9,804	10,276	10,110	10,291	10,080	Total Equity	20,899	22,399	24,389	17,548	12,030	11,199	10,981	14,602	14,868	13,552
6		Pretax Income (Loss)	8,834	8,304	8,891	8,757	7,442	8,553	9,602	9,189	9,312	9,069	Total Liabilities & Equity	72,882	74,638	77,478	70,509	69,667	73,490	79,804	77,648	78,547	92,918
7		Income Tax (Expense) Benefit, net	-2,372	-2,090	-2,104	-2,199	-1,941	-2,174	-4,694	3,370	-1,959	-1,894
8		Net Income Available to Common Shareholders	6,443	6,178	6,740	6,513	5,452	6,329	4,857	12,515	7,314	7,120
9
10
11
12
13
14
15		in millions	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020
16		Outstanding Shares	1597	1575	1560	1527	1485	1452	1438	1425	1407	1392
17
18			2011	Current
19		Dividend	$ 2.03	$ 4.30
20		Share Price	$ 49.88	$ 154.00
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100