Valuation Model-PG.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)	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	Balance Sheet	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021
3		in million USD	FY '12	FY '13	FY '14	FY '15	FY '16	FY '17	FY '18	FY '19	FY '20	FY '21	Total Assets	132,244	139,263	144,266	129,495	127,136	120,406	118,310	115,095	120,700	119,307
4		Revenue	82,006	80,116	74,401	70,749	65,299	65,058	66,832	67,684	70,950	76,118	Total Liabilities	68,209	70,554	74,290	66,445	69,153	64,628	65,427	67,516	73,822	72,653
5		Operating Income (Loss)	14,611	14,125	13,910	13,077	13,441	13,955	13,711	13,832	15,706	17,986	Total Equity	64,035	68,709	69,976	63,050	57,983	55,778	52,883	47,579	46,878	46,654
6		Pretax Income (Loss)	12,528	14,179	13,509	11,012	13,369	13,257	13,326	6,069	15,834	17,615	Total Liabilities & Equity	132,244	139,263	144,266	129,495	127,136	120,406	118,310	115,095	120,700	119,307
7		Income Tax (Expense) Benefit, net	-3,378	-3,226	-2,851	-2,725	-3,342	-3,063	-3,465	-2,103	-2,731	-3,263
8		Net Income Available to Common Shareholders	10,756	11,312	11,643	7,036	10,508	15,326	9,750	3,897	13,027	14,306
9
10
11
12
13
14
15		in millions	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021
16		Outstanding Shares	3002	2941	2931	2905	2844	2740	2657	2540	2626	2601
17
18			2012	Current
19		Dividend	$ 2.21	$ 3.48
20		Share Price	$ 51.65	$ 145.43
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