Equity Research puzzles, solved step by step

About Rs 271 crore a year, on these assumptions. A weekday carries 240,000 boardings: six peak hours at 25,000, four shoulder hours at 12,000 and seven quiet hours at 6,000. Weekends and holidays run at 60% of a weekday, giving 77.5 million trips a year. At an average fare of Rs 35, that is about Rs 271 crore.

How do you estimate a weekday's ridership?

Think about any busy road near an office district: jammed from 8 to 11 and from 5 to 8, calm in between. A metro line has the same shape. Ridership is concentrated in two peaks, so build the day hour by hour; a flat hourly average taken from the peak overstates it badly. Assume the line runs 6 am to 11 pm, 17 hours, with 25,000 boardings in each of six peak hours, 12,000 in four shoulder hours and 6,000 in seven quiet hours. That gives 240,000.

How do you check it and turn it into revenue?

Check from the stations. A line of 25 stations at 240,000 boardings a day is about 9,600 per station, which is plausible for a mix of busy interchanges and quiet suburban stops. Two routes that land close together give you licence to use the number; if they did not, the gap would tell you which assumption to test. Then annualise: 260 weekdays at 240,000 and 105 weekend and holiday days at 60% of that give 77.52 million trips.

Say which input you trust least: the average fare, since metro fares usually rise with distance and a line's trip-length mix is hard to guess. A research analyst would also note that fare revenue is only part of a metro's income, with advertising and property often material, and would check the operator's published ridership rather than rely on the estimate.

About Rs 69 crore of revenue and Rs 2.2 crore of gross profit a year, on stated assumptions. Assume 12,000 vehicles a day pass on the pump's side, about 500 an hour. About 384 stop, filling 20,232 litres a day, most of it diesel for trucks. At assumed pump prices near Rs 90 to Rs 100 a litre that is Rs 18.8 lakh a day; at an assumed dealer margin of Rs 3 a litre the pump keeps about Rs 2.2 crore a year.

Where does the estimate start?

Think of a roadside dhaba: its takings depend less on how many vehicles pass than on which ones stop and how much each group eats. Start from the traffic on the pump's side of the road, split it by vehicle type, and apply a stop rate and litres per fill to each, because the three types differ by a factor of forty in what they buy. Every input below is an assumption for the method; fuel prices and dealer margins change and should be checked before use.

How do you turn litres into revenue and profit, and check the answer?

Revenue is litres times the pump price: petrol for two-wheelers and cars at an assumed Rs 100, diesel for trucks at Rs 90, which gives Rs 18.8 lakh a day and Rs 68.6 crore a year. The dealer does not keep the pump price; it earns a commission per litre, so gross profit is litres times margin, about Rs 2.2 crore a year at Rs 3 a litre. Sanity check the stops: 384 a day is about 16 an hour, one fill every four minutes, which a pump with a few nozzles handles easily. The weakest assumption is the truck stop rate, since fleet operators choose pumps by contract and credit terms, not by chance.

About Rs 4.4 crore a year, on stated assumptions. Five shows a day on 200 seats at 30% occupancy is 300 visitors a day, about 1,09,500 a year. At Rs 250 a ticket that is Rs 2.74 crore; at Rs 120 of food per head, Rs 1.31 crore; screen advertising adds about Rs 0.30 crore. Food is under a third of revenue, but because a distributor takes about half of each ticket, it is well over a third of what the screen keeps.

How do you build the visitor count?

Count it the way you would count lunches at an office canteen: seats, times sittings, times how full each sitting is, times days. Visitors are shows x seats x occupancy x days, and occupancy is the number to defend, because most screens are far from full outside weekend evenings. Five shows on 200 seats at 30% gives 300 visitors a day and 1,09,500 a year. Every figure here is an assumption for the exercise, and prices are taken net of GST, whose rates should be confirmed.

Why does food matter more than its price suggests?

Because the two rupees are not shared the same way. A ticket rupee is split with the film's distributor, while a food rupee mostly stays with the screen, so Rs 120 of popcorn and a drink keeps about Rs 90, close to the Rs 125 the screen keeps from a Rs 250 ticket. That is why chains price food high and push it hard, and why an analyst tracks spend per head as closely as ticket prices. The distributor's share and the food cost here are assumptions to check against a company's disclosures.

Which assumption would the interviewer push on?

Occupancy first. It moves both big lines at once: at 35% instead of 30%, revenue rises to about Rs 5.03 crore. A screen's economics turn on filling empty seats, because rent, staff and power are the same whether the hall is a third full or packed. Then the average ticket price, which blends weekday discounts with weekend premiums, and the number of shows, which depends on film lengths. Name all three and you have shown how the business works, not just its size.

About Rs 28,800 crore a year on these assumptions, most of it from private schools. Government schools: 13 crore children, 2 sets a year at Rs 300, Rs 7,800 crore. Private schools: 12 crore children, 2.5 sets at Rs 700, Rs 21,000 crore. A single blended average would have given Rs 20,000 crore, so the split matters more than any one input. Confirm enrolment against the latest official school data.

Why split by school type before anything else?

Think of two families on the same street. One sends a child to the government school, where the uniform is supplied through the state at a fixed allowance. The other pays a private school's appointed tailor for a blazer, a house t-shirt and two sets of the regular uniform. Who pays decides both how many sets are bought and what each costs, so the segments must be sized separately and then added. A national average price describes neither family.

State the assumptions plainly and treat each as a placeholder to be replaced with data. Assume about 25 crore children in school, 13 crore in government schools and 12 crore in private ones; confirm against the latest UDISE+ report. Assume 2 sets a year at about Rs 300 a set in government schools, where many states fund uniforms through schemes, and 2.5 sets at about Rs 700 in private schools, allowing for sports and house uniforms. Each number is round on purpose; the point is a structure you can defend.

How do you sanity check it?

Turn it into a number a parent can feel. The market works out to about Rs 1,152 a child a year, roughly Rs 1,750 for a private school child and Rs 600 for a government school child. If a private school parent you know spends about that on uniforms each year, the build is in the right range. A second check comes from the supply side: the number of uniform makers and school tailors in one town, times their annual sales, scaled by the number of similar towns.

What would you refine with more time?

The private segment carries almost three quarters of the value, so refine it first. Private schools range from low-fee neighbourhood schools, where uniforms cost little more than in government schools, to premium schools with branded kits. Splitting private schools into two or three fee bands is the next step, because price varies most there. Replacement is a second lever: younger children outgrow uniforms every year, while older ones may make one set last two.