Fin Maverick
Foundations VocabularyAccounting & ReportingEconomics & MacroQuant Methods & ProgrammingBusiness & Company AnalysisCorporate Finance & ValuationBehavioural Finance
Banking & Market InfrastructureFixed Income & RatesDerivatives & Structured ProductsPublic EquitiesTransactions & DealsPortfolio ConstructionFunds & AMCs
Private Markets & AlternativesRisk, Treasury & ControlAI & Digital FinanceStochastic Calculus & PricingWealth & Personal FinanceIndian Markets & RegulationProfessional Practice
CalculatorComparison
Frameworks
Explore Bootcamps
Equity ResearchPortfolio ManagementMutual Fund MasteryInvestment Banking Analyst
Private Equity AnalystQuant & Hedge Fund AnalystBreaking Into VCFinancial Analyst Program
Risk Management ProgramPrivate Wealth ManagementDebt Capital MarketsDerivatives Foundation
Explore Free Courses

Equity Research6

Writing an Investment ThesisBuilding a Discounted Cash FlowReading an Annual Report FastReading a Sector Before a CompanySpotting Quality of Earnings Red FlagsBuilding a Revenue Forecast From Drivers

Portfolio Management3

Rebalancing: When, Why and What It CostsStrategic and Tactical Asset AllocationMeasuring Risk in a Portfolio

Mutual Fund Mastery3

Comparing Funds Without Being FooledHow a NAV Is Struck and Which Day You GetReading a Fund Factsheet Properly

Derivatives Unlocked4

Hedging a Real ExposureThe Greeks, PracticallyFutures, the Basis and What Moves ItReading an Option Payoff

AI For Finance2

Retrieval and Grounding for FinanceDocument Extraction in Finance

Breaking Into Quants4

Backtesting a StrategyHypothesis TestingCleaning Financial DataRegression for Finance

Breaking Into VC3

Sizing a MarketReading a Term Sheet as a FounderHow a Venture Round Actually Works

Financial Analyst Program4

Common Size and Trend AnalysisReading a Cash Flow StatementRatio Analysis That Says SomethingBuilding a Working Capital Schedule

Risk Management Program2

Credit Exposure and How It Is ReducedValue at Risk and What It Hides

Investment Banking Analyst3

Precedent Transactions and Why They DifferReading a Term Sheet StructurallyBuilding a Comparable Companies Table

Private Wealth Management3

Tax Aware Portfolio DecisionsBuilding a Client Risk ProfileGoal Based Planning Arithmetic

Debt Capital Markets3

Analysing an Issuer's CreditDuration and What It Does Not Tell YouBond Pricing and Yield Mechanics

Private Equity Analyst2

Fund Waterfalls and CarryThe LBO in Structure

Hedge Funds Analyst2

Short Selling MechanicsLong Short Mechanics
QuarksCourses
Explore Interview Preparation
Investment BankingEquity ResearchVenture CapitalistPrivate EquityHedge Funds
QuantFinancial AnalysisPrivate Wealth ManagementDebt Capital MarketsRisk Management
Derivatives FoundationPortfolio ManagementMutual Fund Mastery
PartnershipsShowdown
Log inSign up
Interview tracksAll
1Investment Banking
Question bankPuzzlesCase studies
2Equity Research
Question bankPuzzlesCase studies
3Venture Capital
Question bankPuzzlesCase studies
4Private Equity
Question bankPuzzlesCase studies
5Hedge Funds
Question bankPuzzlesCase studies
6Quant
Question bankPuzzlesCase studies
7Financial Analysis
Question bankPuzzlesCase studies
8Private Wealth Management
Question bankPuzzlesCase studies
9Debt Capital Markets
Question bankPuzzlesCase studies
10Risk Management
Question bankPuzzlesCase studies
11Derivatives Foundation
Question bankPuzzlesCase studies
12Portfolio Management
Question bankPuzzlesCase studies
13Mutual Fund Mastery
Question bankPuzzlesCase studies
045

Case 045Budgeting, variance and reportingCore

Tejomaya Technologies has 1,000 staff, a mid-year hike, 18% attrition backfilled after two months, and 150 net new hires. Build the year's staff cost budget month by month.

1The situation

Tejomaya Technologies runs a 1,000-person engineering centre. Average cost to company is Rs 15 lakh a year. The financial year runs April to March, and a 10% hike applies to everyone on the rolls from 1 July; later joiners come in at the hiked pay scale. Attrition runs at 18% a year, spread evenly, with leavers going on the first of the month and each vacancy backfilled two months later at 5% below the leaver's cost. The business also plans 150 net new hires, spread evenly through the year and joining on the first of each month.

The finance lead's first draft was 1,150 heads at the hiked rate for twelve months. The CFO sent it back.

2Your task

Build the monthly staff cost, the annual total, and the bridge from the 1,000-head base to it, and say why the first draft was wrong.

Quick check

The first draft costed 1,150 heads at Rs 16.5 lakh for the full year. Is that too high or too low?

Worked solution

Try it on paper, then open one step at a time.

30-second answerThe answer to give first

The year costs about Rs 169.3 crore, not the Rs 189.8 crore of the first draft. Build it monthly: the original roster shrinks by 15 heads a month, backfills arrive two months later at 95%, new hires add 12.5 a month, and the rate steps from Rs 15 lakh to Rs 16.5 lakh in July. Monthly cost runs from Rs 12.47 crore in April to Rs 15.30 crore in March. The bridge from the Rs 150 crore base is the hike, less vacancy savings, plus new hires, each a timing question.

Step 1Why is a people budget a roll-forward and not a multiplication?

A household that hires a cook in October does not budget twelve months of her salary; a family whose rent rises in July pays the old rent for three months. Staff cost is headcount times rate, month by month, and both move during the year, so the annual number is the sum of twelve different months. Tejomaya has three moving parts: the rate steps up in July, leavers thin the original roster every month, and two kinds of joiners add to it on their own schedules. Multiply year-end heads by the year-end rate and all three timing effects are lost.

Step 2How do you build each month?

Three head counts, one rate. The original roster loses 15 people on the first of each month, so in month m it has 1,000 less 15m. Backfills for those leavers arrive two months later at 95% of cost, so in month m there are 15 times (m minus 2) of them. New hires add 12.5 a month, so 12.5m. Each count is multiplied by the going rate over twelve: Rs 15 lakh until June and Rs 16.5 lakh from July, with backfills at 95% of it. April is 985 originals and 12.5 new hires at Rs 15 lakh, Rs 12.47 crore; March is 820 originals, 150 backfills and 150 new hires at the hiked rate, Rs 15.30 crore.

MonthOriginalBackfillsNew hiresRate, Rs lakhCost, Rs crore
Apr985012.515.012.47
May970025.015.012.44
Jun9551537.515.012.58
Jul9403050.016.514.00
Aug9254562.516.514.17
Sep9106075.016.514.33
Oct8957587.516.514.49
Nov88090100.016.514.65
Dec865105112.516.514.81
Jan850120125.016.514.97
Feb835135137.516.515.14
Mar820150150.016.515.30
Year169.35
Heads at the start of each month and the month's cost. The step in July is the hike; the steady rise after it is new hires outrunning the vacancy gap, ending with 1120 heads on the rolls in March.
A people budget is twelve months, not one number: Tejomaya's monthly staff cost, Rs crore048121612.47Apr12.44May12.58Jun14.00Jul14.17Aug14.33Sep14.49Oct14.65Nov14.81Dec14.97Jan15.14Feb15.30Mar1,000 heads at the going rate, no churn, no hiringhike lands 1 Julyoriginal rosterbackfills at 95%net new hiresYear total Rs 169.3 crore, against Rs 189.8 crore if 1,150 heads were costed at the hiked rate all year.
Tejomaya's monthly staff cost climbs from Rs 12.47 crore to Rs 15.30 crore with a step at the July hike, and sits below the no-churn line for most of the year because every leaver's seat is empty for two months.
Step 3What is the bridge from the base, and why was the draft wrong?

Start at 1,000 heads for a year at Rs 15 lakh, Rs 150 crore. The hike adds Rs 11.25 crore, nine months of 10% on the base; vacancies save Rs 5.22 crore, because each of 180 leavers leaves a seat empty for two months and the replacement costs 5% less; and the new hires add Rs 13.31 crore, which is far less than 150 times Rs 16.5 lakh because the average new hire is on the rolls for only half the year. That sums to Rs 169.3 crore. The draft's Rs 189.8 crore applied the year-end headcount and the year-end rate to all twelve months, which overstates by about Rs 20 crore, enough to misprice every project the centre bills.

Say what the model does not know. Attrition is rarely even; it spikes after bonuses and hikes, which pulls leavers forward and raises the vacancy saving while hurting delivery. Backfill at two months is an average that hides long searches for senior roles. And joiners' cost to company is an assumption until the offers are signed. The finance lead should hold the roll-forward and reforecast it quarterly against actual joiners and leavers, not defend one annual figure.

Where candidates lose it

The common loss is the first draft itself: year-end heads at the year-end rate for twelve months. Hikes, exits and hires all have dates, and the dates are the budget.

The second is forgetting the vacancy. A leaver who is replaced two months later is a saving in the year, not a cost, and a budget that misses it will show a favourable variance nobody earned.

What the interviewer asks next

  • Attrition jumps to 24% in the two months after the hike and falls afterwards. How does the annual cost change?
  • How would you add a variable bonus of 10% of CTC paid in October on the previous year's rolls?
  • What monthly report would you build so the budget can be reforecast against actual joiners and leavers?
← Case 044Kumudini Hotels can spend Rs 25 crore renovating 200 rooms to lift the room rate by Rs 1,200. Compute the IRR of the renovation and the occupancy it would need to clear a 12% hurdle.Case 046 →Sindhuja Electronics owes US $20 million in six months. Compare leaving it open, a forward and a call option if the rupee ends at 80, 84 or 88, and say what each choice is really a decision about.

Company names and figures are illustrative.

Fin Maverick Free CoursesExplore Free Courses
Fin Maverick BootcampsExplore Bootcamps
Fin Maverick

Finance education that ends in a job, not a certificate that gathers dust. Built for young India.

LEARN
CalculatorsFrameworksComparisonsInterview RoadmapsShowdown
RESOURCES
All CoursesFree CoursesBootcampsInternships
COMPANY
AboutJob openingPartnership
LEGAL
Privacy PolicyTerms & ConditionsContent LicenseReturn & Refund Policy
© 2026 FIN MAVERICK / BUILT FOR INDIA.DO FINANCE, DO NOT JUST READ ABOUT IT.