Calculate the Monthly data usage in India

	A	B	C	D	E	F	G	H	I
1	ASSUMPTIONS
2	The data usage accounts only for Mobile Data Usage across Urban and Rural areas and not Wi-fi or Wired Data Usage.		Calculate the Monthly data usage in India
3	The Usage is accounted for the general public and not Corporate or Government usage.		Step 1: Calculate the total Internet Users
4	The number of Internet Users in Urban will obviously be more than that in rural area as its a luxury and requires disposable income.		Total Indian Population	1,350,000,000.00
5	The classification is based on Disposable Income, so if you are a urban rich person, you definitely have access to the Internet but if you are poor in an urban area you probably are a daily wage worker with a keypad phone.		Population Divide	Urban			Rural
6				40%			60%
7				540,000,000.00			810,000,000.00
8	STRUCTURE		Economy Class	Rich	Middle	Poor	Rich	Middle	Poor
9	Total Indian Population			25%	45%	30%	5%	35%	60%
10	X			135,000,000.00	243,000,000.00	162,000,000.00	40,500,000.00	283,500,000.00	486,000,000.00
11	Urban-Rural Population Divide		Total Internet Users	0.95	0.85	0.75	0.90	0.50	0.25
12	X		Total Internet Users	128,250,000.00	206,550,000.00	121,500,000.00	36,450,000.00	141,750,000.00	121,500,000.00
13	Economy Class		TOTAL	756,000,000.00
14	X		Step 2: Calculate the Average Monthy Internet Used
15	% of Internet Users		Total Users in India	756,000,000.00
16	=		Population Divide	Urban			Rural
17	Total Internet Users		Population Divide	456,300,000.00			299,700,000.00
18	X		Mobile Data Users	60%			85%
19	Mobile Data Users		Mobile Data Users	273,780,000.00			254,745,000.00
20	X		Network Type	2G	3G	4G	2G	3G	4G
21	Divided into Network Type			2%	18%	80%	5%	65%	30%
22	X			5,475,600.00	49,280,400.00	219,024,000.00	12,737,250.00	165,584,250.00	76,423,500.00
23	Average Recharge (in GBs)		Average Recharge (in GBs)	20	30	45	10	30	45
24	X		Average Recharge (in GBs)	109,512,000.00	1,478,412,000.00	9,856,080,000.00	127,372,500.00	4,967,527,500.00	3,439,057,500.00
25	Average Usage (in GBs)		Average Usage (in GBs)	35%	40%	50%	30%	35%	40%
26	=		Average Usage (in GBs)	38,329,200.00	591,364,800.00	4,928,040,000.00	38,211,750.00	1,738,634,625.00	1,375,623,000.00
27	Total Monthly data usage in India		TOTAL (in GBs)	8,710,203,375.00
28
29
30	BROWNIE POINTS
31	Internet users choose different data plans based on their network type
32	The average monthly consumption of data depends on the network type and area.
33
34
35	SANITY CHECK
36	Revenue of jio in FY 22	1000	billion
37	Avg. revenue per month	83.33	billion
38	Percentage revenue from mobile data	45.60%
39	Revenue from mobile data	38.00	billion
40	Market share of jio in mobile data in india	36%
41	Total revenue from mobile data In a month	105.56
42	Avg. cost of 1 GB Data	12
43	Total Number of GBs	8.80	billion
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