Valuing the S&P BSE SENSEX

	A	B	C	D	Z	AA
1	Valuing the S&P BSE SENSEX			32561.47	3-Year	3-Year
2	Key Inputs		Assumptions	Overvalued	5-Year	5-Year
3	Date	6/24/2018	7/23/2026	Overvalued	10-Year	7-Year
4	Current SENSEX Level	35689.60	35689.60	The Market-implied Fair Value of the S&P BSE SENSEX is 32562. The S&P BSE SENSEX is trading at 35690. A 8.76% correction is expected at this level.	15-Year	10-Year
5	Total Yield	20-Year	1.26%		20-Year
6	Expected Growth	10-Year	12.31%		Latest
7	Risk-free Rate	Latest	7.82%
8	Equity Risk Premium	Latest	2.01%
9	Year	Expected Dividends and Buybacks	Cumulative PV Factor (Risk-free Rate + Equity Risk Premium)	Present Value of Expected Dividends and Buybacks
10	2019	₹ 505.04	0.9105	₹ 459.84
11	2020	₹ 567.22	0.8290	₹ 470.24
12	2021	₹ 637.06	0.7548	₹ 480.87
13	2022	₹ 715.50	0.6873	₹ 491.75
14	2023	₹ 803.60	0.6258	₹ 502.87
15	2024	₹ 902.54	0.5698	₹ 514.24
16	2025	₹ 1,013.67	0.5188	₹ 525.87
17	2026	₹ 1,138.47	0.4723	₹ 537.76
18	2027	₹ 1,278.65	0.4301	₹ 549.92
19	2028	₹ 1,436.08	0.3916	₹ 562.35
20	2023 - ∞	₹ 77,033.36	0.3565	₹ 27,465.76
21
22	"Valuing the S&P BSE SENSEX" is a simple Discounted Cash Flow model built and improvised by Dinesh Sairam, inspired by Prof. Aswath Damodaran (Dean of Valuation, NYU Stern School of Business), who made the original "Valuing the S&P 500" blog post. For more Valuation-related content, visit www.valuationinmotion.blogspot.in or write to dineshssairam@gmail.com for queries.
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