What break-even analysis answers
Every project appraisal comes back to one question: how much must this unit sell before it stops losing money? Break-even analysis answers that question with a number. It separates the costs a business must meet whether it produces anything or not from the costs that move with production, and works out the sales value at which the two are covered. In a project report for a bank loan, that number tells the credit officer how much cushion sits between the projected sales and the loss-making zone.
The costs behind it
Fixed costs
Rent, insurance, salaries of permanent staff, licence and compliance costs, contractual maintenance and depreciation are the usual fixed costs in a project, because they are incurred across the year regardless of how much the unit produces. In a fresh project, interest on the term loan also behaves as a fixed charge during the repayment period, since it is payable on the loan outstanding rather than on the month's output.
Variable costs
Raw material, packing, power consumed in production, wages paid on output and sales commission rise and fall with volume. Their per-unit behaviour is what matters: material per unit, power per unit, and so on. Where a cost is part fixed and part variable, such as electricity with a demand charge and a usage charge, split it into the two components rather than treating it as one.
Contribution
Contribution is the amount left from each unit sold after its variable cost, and it is what first absorbs fixed costs and then becomes profit. If a product sells at ₹500 a unit and its variable cost is ₹300 a unit, the contribution is ₹200 a unit for as long as those figures hold.
The calculations
- Break-even in units = fixed costs divided by contribution per unit.
- Break-even in sales value = fixed costs divided by the contribution ratio, where the contribution ratio is contribution per unit divided by the selling rate.
- Margin of safety = projected sales minus break-even sales, usually expressed as a percentage of projected sales.
Take a unit with annual fixed costs of ₹40,00,000, a selling rate of ₹500 a unit and a variable cost of ₹300 a unit. Contribution per unit is ₹200, so the break-even volume is 20,000 units a year, and at ₹500 a unit the break-even sales value is ₹1,00,00,000, or one crore. If the project projects sales of 25,000 units, the margin of safety is 5,000 units, which is 20% of the projected volume. The same numbers in value terms: projected sales of ₹1,25,00,000 against break-even sales of ₹1,00,00,000.
A margin of safety of 20% means the unit can lose a fifth of its projected volume before it starts making a loss, which is the kind of statement a bank can weigh against the market risk of the project.
Break-even and the loan file
Break-even is normally shown in the project report beside the projections, the DSCR working and the ratio analysis, because it explains the risk behind the repayment case rather than only the return. Three uses are common:
- Test the sales assumption. Where the break-even is close to the projected sales, the project has little room for a slow start, and the appraisal will look harder at the market assumptions.
- Set the year it turns profitable. Break-even tells the bank the volume at which the unit stops absorbing cash, which supports the timing of the first repayment instalment.
- Support a moratorium request. If break-even is reached only in the second year, the repayment schedule should reflect that rather than assume profitability in the first month.
Cash break-even, and why it differs
Accounting break-even includes depreciation among fixed costs. Cash break-even removes non-cash charges such as depreciation, because a business does not pay depreciation in cash, and it shows the sales needed to keep the bank account from going negative. During the repayment period, principal repayment also leaves the business in cash without appearing in the profit and loss account, so a project can show profit at the accounting break-even while still running short of cash for an instalment. That gap is why DSCR is read next to break-even rather than instead of it.
Sensitivity: what happens when the figures move
A single break-even point assumes one set of costs and one selling rate for the whole projection. In practice both move, so present at least three readings:
- A fall in the selling rate, which cuts contribution and pushes break-even up sharply where the contribution ratio is thin.
- A rise in material or power cost, which does the same from the other side.
- A shortfall in volume, which is the simplest test: the margin of safety already states how much volume can be lost.
A contribution ratio of, say, 25% is a useful benchmark to mention, because a small drop in the selling rate removes a much larger share of contribution, and the sensitivity working makes that visible.
Errors that weaken the working
- Treating the term-loan instalment, including principal, as a fixed cost in the break-even calculation, which understates the real break-even point. Principal is a cash outflow addressed through DSCR.
- Leaving interest out of fixed costs, which flatters the break-even in a debt-funded project.
- Using one blended contribution figure where the unit sells several products with different margins.
- Taking semi-variable costs, such as power or contract labour, as wholly fixed or wholly variable.
- Ignoring working capital interest and the cost of holding additional stock at higher volumes.
- Presenting a single number with no note of the assumptions it rests on, which makes it impossible to test.
Presenting it in the report
Show break-even as a sales value, as a share of projected sales and with the margin of safety, and attach the fixed and variable split that produced it. A short note on the assumptions, a sensitivity table with two or three variations, and an explanation of the year in which break-even is expected to be crossed complete the section. Where a seasonal business earns unevenly, monthly figures support the annual break-even better than a single yearly total.
Working it out in one place
Finxora's project report software computes break-even from the same inputs as the projections, and presents the break-even sales value, the break-even point as a share of sales and the margin of safety, so the section agrees with the profit and loss account instead of being built separately in a spreadsheet. Sensitivity analysis is produced alongside the projected years, and the DSCR, ratio analysis and turnover and MPBF workings sit in the same report, so the debt service case and the break-even reading can be checked together. A change in a sales or cost assumption recalculates the dependent statements.
The CMA module carries the same break-even and sensitivity working where the file is for a working capital limit. If you want to try the arithmetic first, the financial calculators cover interest and instalment workings, and a filled sample project report shows how the section prints. The project report software page describes the rest of the report.
A worked checklist
- Split costs into fixed, variable and semi-variable, and state the basis of each.
- Compute contribution per unit and the contribution ratio.
- Work out break-even in units and in sales value.
- Compare it with projected sales and state the margin of safety.
- Show a cash break-even beside the accounting figure, and note where principal repayment affects cash without appearing in profit.
- Attach a sensitivity table and the assumptions behind it.
