Guesstimate-Estimate the market size of Maternity clothes in India.xlsx

	A	B	D	E	F	G	H	I	J	K
1	ASSUMPTIONS		Estimate the market size of Maternity clothes in India
2	Time Period of 1 year has been taken while calculating the frequency		Step 1: Calculating the total number of Births in a year
3	A birth rate of 1 birth per 5 second is taken into consideration		Number of days in a year				365
4	Women in the first trimester is assumed to purchase clothes for the further trimesters as well and same for other cases		Total Seconds in a year				31,536,000
5	Post-Pregnancy wear includes Nurse wears		Number of Births in a year				6,307,200
6	Only 30% of the women who are not pregnant for the first time can buy maternity clothes		Step 2: Calculating the number of pregnant women
7	Number of women in each trimester is considered to be 30% of the total, and 10% for the post pregnancy period		Dividing the total births in single child, twins or triplets
8			Type		Single Child		Twins		Triplets
9			Percentage as of total births		80%		19%		1%
10	STRUCTURE		Number		5,045,760		1,198,368		63,072
11	Total Number of Births		Number of Pregnant Women		5,045,760		599,184		21,024
12	X		Total		5,665,968
13	Number of Pregnant Women		Women Pregnant for the First time		90%			5,099,371
14	X		Women not Pregnant for the First time		10%			566,597
15	Division of Women among periods		Total Number of Women who can buy Maternity Clothes				5,269,350
16	X		Step 3: Dividing the Pregnant women on the basis of income & trimester
17	Calculating the Frequency of buying clothes		Income level (annually in lacs)		Low Income (0-3)		Middle Income (3-10)		High Income (10+)
18	X		Percentage		30%		50%		20%
19	Number of Maternal clothes can be purchased		Number		1,580,805		2,634,675		1,053,870
20	=		Number of Women across 3 trimesters
21	Market Size of Maternal Clothes		Stage of Pregnancy	1st Trimester		2nd Trimester		3rd Trimester		Post- Pregnancy
22			Low Income	474,242		474,242		474,242		158,081
23			Middle Income	790,403		790,403		790,403		263,468
24			High Income	316,161		316,161		316,161		105,387
25			Step 4: Frequency of Buying Clothes
26			Current Stage	Further Stages	Low Income		Middle Income		High Income
27			First Trimester	1st	0		1		3
28				2nd	2		4		6
29	SANITY CHECK			3rd	4		7		10
30	Market Size of Maternity Clothes Globally (In crores)	150,876	Second Trimester	2nd	2		4		6
31	India Contribution to total child births in the world	1/6		3rd	4		7		10
32	Therefore, the Market Size can be approximately	25,146		Post Pregnancy	1		4		6
33	However, considering the income distribution in india and the lack of adaptability towards specially designed maternity wears, the market size will be smaller than the above number. Along with this, we have excluded the other maternity products and only included clothes which also contributes to the reason for a smaller number		Third Trimester	3rd	4		7		10
34			Third Trimester	Post Pregnancy	1		4		6
35	Actual Market Size of Maternity Clothes in India (in crores)	14,500	Post Pregnancy		1		4		6
36	As a precentage of Global market	9.61%	Total		19		42		63
37			Step 5: Estimating the number of maternal clothes that can be purchased
38			Income Level		Low Income		Middle Income		High Income
39			Number of Clothes		8,694,428		31,089,166		18,653,500
40			Step 6: Calculation of Market Size of Maternal Clothes
41			Income Level		Low Income		Middle Income		High Income
42			Average Price of clothing (In rupees)		1,000		2,000		4,000
43					8,694,427,896		62,178,332,832		74,613,999,398
44			Total (In rupees)		145,486,760,126
45			Market size of Maternal Clothes (In crores)		14,500
46			Market size of Maternal Clothes (In crores)		14,500
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