- Practice
- About 14 min
- 5 practice questions
IPO problems: subscription by category, pro rata allotment and book building
Find the subscription of an issue and of each category, work out pro rata allotment and refund, and read a cumulative demand table to find the cut-off price.
If something looks wrong, please tell us.
The foundation lessons described how an IPO works. Practice questions turn the process into numbers: how many times was the issue subscribed, how many shares does an applicant receive, and what price clears the book. Everything is invented ('suppose'); no real issue rule or reservation is stated.
Subscription
Subscription = shares applied for ÷ shares offered. A value above 1 means the issue is oversubscribed. Issues usually set aside parts for different categories of investors, and each category is measured against its own part. The overall figure is total applications ÷ total offered, not the average of the category figures.
Pro rata allotment and refunds
When an issue is oversubscribed, shares are allotted in proportion. If the issue is subscribed n times, an applicant gets about 1 ÷ n of the shares applied for in this classroom model (in real Indian IPOs, proportionate allotment applies to institutional investors, while retail applicants get a minimum lot by lottery). The money paid for the shares not allotted is refunded: refund = unallotted shares x price.
Book building and the cut-off price
In book building investors bid at various prices inside a price band. The bids are collected into a cumulative demand table: demand at a given price includes all bids at that price and higher, because those bidders would also accept a lower price. The issue price is normally the highest price at which the cumulative demand covers the number of shares on offer.
Worked examples
Example 1. Suppose an issue offers 50 lakh shares: 20 lakh to small investors, 25 lakh to institutions and 5 lakh to others. Applications are 30 lakh, 75 lakh and 10 lakh respectively. Find the subscription of each part and overall. Small: 30 ÷ 20 = 1.5 times. Institutions: 75 ÷ 25 = 3 times. Others: 10 ÷ 5 = 2 times. Overall: (30 + 75 + 10) ÷ 50 = 115 ÷ 50 = 2.3 times. The average of 1.5, 3 and 2 is 2.17, which is not the overall figure.
Example 2. Suppose an issue is subscribed 3 times and an applicant applied for 90 shares at ₹200. Find the shares allotted and the refund. Allotment = 90 ÷ 3 = 30 shares. Unallotted = 60 shares. Refund = 60 x 200 = ₹12,000. The applicant paid ₹18,000 and keeps shares worth 30 x 200 = ₹6,000.
Example 3. Suppose an issue of 50 lakh shares has a price band of ₹95 to ₹100, and the cumulative demand (in lakh shares) is: 10 at ₹100, 25 at ₹99, 40 at ₹98, 60 at ₹97, 85 at ₹96 and 110 at ₹95. Find the issue price. Go from the top: at ₹100 demand is 10, at ₹99 it is 25, at ₹98 it is 40, all below 50. At ₹97 it is 60, which covers 50. So the issue price is ₹97, the highest price at which the whole issue is taken up.
Example 4. Suppose a company has 1 crore shares before the issue and issues 25 lakh new shares at ₹97. Find the money raised, the shares afterwards and the market capitalisation if the share lists at ₹110. Money = 25 lakh x 97 = ₹24.25 crore. Shares afterwards = 1.25 crore. Market capitalisation = 1.25 crore x 110 = ₹137.5 crore.
Subscription = applied ÷ offered. Pro rata share = 1 ÷ subscription. Cumulative demand counts bids at that price and above.
Key takeaways. Calculate each category against its own quota, and the overall figure from totals. Allotment is proportional when oversubscribed, and the rest is refunded. For book building, accumulate from the highest price downward and stop where demand reaches the issue size.
Check your understanding
-
1. 20 lakh shares are offered and applications are for 50 lakh shares. The subscription is:
- 2.5 times
- 0.4 times
- 3 times
- 5 times
Show answer
Answer: A. 50 ÷ 20 = 2.5 times.
-
2. An issue is subscribed 4 times. An applicant applied for 200 shares. The pro rata allotment is about:
- 20
- 80
- 100
- 50
Show answer
Answer: D. 200 ÷ 4 = 50 shares.
-
3. In the same case the price is ₹40 a share. The refund is:
- ₹4,000
- ₹6,000
- ₹8,000
- ₹2,000
Show answer
Answer: B. Unallotted = 150 shares; 150 x 40 = ₹6,000.
-
4. Cumulative demand (lakh): 20 at ₹50, 45 at ₹49, 70 at ₹48. The issue is 60 lakh shares. The issue price is:
- ₹50
- ₹49
- ₹48
- ₹47
Show answer
Answer: C. Only at ₹48 does demand (70) reach 60. At ₹49 it is 45.
-
5. 1 crore shares exist and 20 lakh are issued at ₹150. The money raised is:
- ₹30 crore
- ₹20 crore
- ₹15 crore
- ₹3 crore
Show answer
Answer: A. 20 lakh x 150 = ₹30 crore.
Sign in to keep track of the lessons you finish.