Financial Analysis puzzles, solved step by step

About 2,000 sit-down cafés, as a range of roughly 1,000 to 4,000. Take about 1.3 crore people, 70% of them aged 15 to 64, and assume 20% of those visit a café twice a week. That is about 5.2 lakh cups a day; at 250 cups a café a day, about 2,080 cafés. A supply check, 150 commercial clusters with 10 cafés each plus 500 neighbourhood ones, gives about 2,000.

What exactly are you counting?

Say the definition before any number. In Bengaluru the answer changes several times over depending on whether small standing filter coffee counters count, so define a coffee shop as a sit-down café selling espresso-style coffee and say you are leaving the counters out. Then state the population as an assumption, about 1.3 crore for the metro area, and tell the interviewer you would confirm it. In a market sizing nobody is marking the population figure; they are marking whether your chain of reasoning holds.

How do you build it from demand?

Think of a single café first: how many cups does it need to sell to pay its rent? Then ask how many cups the city drinks. Of 1.3 crore people, about 70% are aged 15 to 64, so 91 lakh. Assume 20% of them use cafés, 18.2 lakh people, at two cups a week each: 36.4 lakh cups a week, or about 5.2 lakh a day. A café open 12 hours selling around 20 cups an hour serves about 250 cups a day, so the city supports about 2,080 cafés.

How do you check it, and which assumption matters most?

Count from the other side: supply. Picture the tech parks, malls and busy high streets, say 150 of them, with about 10 cafés each, plus about 500 standalone neighbourhood cafés. That is about 2,000, close to the demand answer. Then name the swing factor. The 20% share of café users is the softest input: halve it and the answer falls to about 1,040. Say the range out loud, roughly 1,000 to 4,000, because a single precise number from soft inputs sounds less credible, not more.

About 2,520 ATMs, on stated assumptions. Of one crore people, 70 lakh are adults and 60% of them, 42 lakh, use ATMs about three times a month: 4.2 lakh withdrawals a day. If 12% fall in the busiest hour, that is 50,400 an hour. A machine handles 30 an hour at two minutes each; plan for two-thirds busy, 20 an hour, and you need about 2,520.

Where do you start, demand or supply?

Think of a canteen deciding how many counters to open. It does not divide the day's meals by 24 hours; it counts the lunch rush and opens enough counters for that. Size a service network to its peak load, so the estimate runs from people to withdrawals to the busiest hour, and only then to machines. Start with demand: 70% of one crore are adults, 70 lakh; assume 60% of them use ATMs for cash, 42 lakh, and that each withdraws three times a month. That is 1.26 crore withdrawals a month, or 4.2 lakh a day.

How much does the peak assumption change the answer, and how do you check it?

Machines stand idle at 3 a.m. and have queues at 6 p.m. If you spread 4.2 lakh withdrawals evenly over 24 hours, you would size for 17,500 an hour and buy 875 machines. The peak-hour share is the assumption that moves the answer most: at 12% of the day in one hour, the city needs nearly three times what the average implies. The same logic explains the planning margin: a machine busy 100% of the time has a queue that never clears, so plan for two-thirds use. Then sanity check the result: 2,520 machines for one crore people is about 25 per lakh, a ratio you can compare with the published ATMs-per-lakh figure for the city, which you should look up rather than quote from memory.

Say what you left out. Salary days bring a bigger rush at the start of the month; digital payments are shrinking cash use, so the user share and the withdrawals per month are both falling; and machines sit where people work and shop, so a city with a dense business district needs more than population alone suggests.

Roughly Rs 4.4 crore a year, on the assumptions below. Five shows a day, 200 seats and 30% average occupancy give about 1.1 lakh admissions a year. At an average ticket of Rs 250 that is Rs 2.74 crore; food and beverage at Rs 130 a head adds Rs 1.42 crore; on-screen advertising adds perhaps Rs 0.2 crore. Every input is an assumption to state and then test.

What is the structure before any number?

Estimating what a hall earns is like estimating a restaurant: count the covers, then what each cover spends, then any income that does not depend on covers. Estimate each revenue stream separately: tickets and food both hang off admissions, while advertising depends on the screen, not the audience on the day. So the first job is admissions: shows a day times seats times occupancy times days.

Assume five shows a day on a 200-seat screen, open every day. Occupancy is the soft input: a weekend evening may be nearly full while a Tuesday matinee is mostly empty. Build it rather than guess it: if weekdays run at 20% and weekends at 55%, the weighted average is (5 x 20% + 2 x 55%) / 7, about 30%.

How do you know the number is sensible?

Check it three ways. Per day: Rs 4.4 crore over 365 days is about Rs 1.19 lakh, which is 300 admissions spending about Rs 400 each in total, plausible for a screen with five shows. Per seat: about Rs 2.2 lakh a year. And the mix: food at about a third of revenue is the kind of share multiplex operators discuss, and it is high-margin money. The softest input is occupancy: every 10 points on it moves revenue by about Rs 1.4 crore, because it drives tickets and food together.

Say what revenue is not. Gross ticket revenue includes entertainment taxes in some form, and a large share of net ticket income goes to the film's distributor. Confirm current tax rates and typical revenue-sharing terms before using the figure for anything beyond a size estimate. Food, by contrast, the operator keeps in full, which is why its share matters to profit far more than its share of revenue suggests.