Profit and loss statement and profitability
From revenue to net profit: gross profit, costs, earnings before depreciation (EBITDA), operating and net profit, profitability and each line’s share of revenue.
At a glance
- What question does it answer?
- How much profit is left of revenue at each level: gross, EBITDA, operating, net.
- What data is needed?
- Revenue and cost of goods sold excl. VAT.
- How to read the result?
- The table shows each line and its share of revenue: look for lines whose share grows faster than revenue. EBITDA reflects the result of trading itself, net profit what the owner is left with after interest and tax. Example on the default values: Revenue of RUB 120m and cost of RUB 56m: gross margin 53.3%, EBITDA RUB 17.8m (14.8% of revenue), operating profit RUB 15.3m, net profit RUB 10.125m (8.4%) and ROIC 19.1%. Expenses are 38.5% of revenue. If expenses grow faster than revenue, compare the largest line with the previous period. Next: “Fixed and variable costs, margin of safety” and “DuPont: return on equity through three levers”.
Why and how to reason
The profit and loss statement runs from top to bottom, and at each step its own group of costs is deducted so you can see where profit “leaks”. Revenue minus cost of sales = gross profit: what remains after buying the goods. Minus operating expenses (rent, staff, marketing) = EBITDA, profit before depreciation: a measure of operating strength. Minus depreciation = operating profit (EBIT). Minus interest and tax = net profit.
Profitability is the share of profit in revenue. ROIC = EBIT x (1 - tax) / invested capital: how much each invested rouble earned after tax.
Example. Revenue 120, cost 56 gives gross profit RUB 64 m (53.3%). Expenses 46.2 give EBITDA RUB 17.8 m. Depreciation 2.5 gives EBIT 15.3. Interest 1.8, tax 25%: net (15.3 - 1.8) x 0.75 = RUB 10.125 m. ROIC 15.3 x 0.75 / 60 = 19.1%.
When to use it
Use it to summarize a period’s results and compare with last year or plan. The tax rate is entered by you: on a simplified regime tax is computed differently, so check before using. Assumption: all lines for one period and ex VAT. It does not show cash flows: profit is not cash. For that use “Cash flow”. Take data from accounting, not from an estimate.
How to read the result
Go from top to bottom and see at which step the margin drops sharply. Gross margin of 53% speaks of pricing and discounts, expense share of 38.5% of the cost structure, EBITDA at 14.8% of operating strength. ROIC of 19% should be compared with the cost of capital (18% in the examples): it is only slightly above. Decision: if the weak link is gross margin, look at price and buying; if expenses, rent, staff, marketing; if ROIC is low, reduce capital in stock. It is worth comparing with last year line by line to see what changed.
Common mistakes
Mixing revenue with and without VAT; including depreciation twice; leaving some items out of expenses (bonuses, payroll taxes); taking capital at year end rather than average. Also: calling EBITDA “cash”. Also: computing corporate income tax from EBITDA rather than from profit before tax, thereby overstating the tax.
What data is needed?
- Revenue and cost of goods sold excl. VAT.
- Operating costs by line, depreciation, interest and the corporate income tax rate.
- Invested capital if you need return on capital.
- Where to take it: revenue and cost of goods sold excl. VAT from the profit and loss report in 1C; operating expenses by line from management accounting; depreciation, interest and the tax rate from accounting and the tax return (check the rate in the current text for the date and confirm with the accountant); capital from the balance sheet. Fill in from top to bottom.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Revenue | ₽ | 120,000,000 | Revenue for the period excl. VAT from the profit and loss report. |
| Cost of goods sold | ₽ | 56,000,000 | Cost of goods sold for the same period excl. VAT. |
| Depreciation and amortization | ₽ | 2,500,000 | Depreciation and amortization of fixed and intangible assets for the period. |
| Interest on loans | ₽ | 1,800,000 | Interest on loans for the period. |
| Corporate income tax | % | 25 | The rate for companies; if you are on the simplified regime calculate tax in the regime tool and enter 0. |
| Invested capital (optional) | ₽ | 60,000,000 | Used for return on capital: leave empty if not needed. |
How it is calculated
| Step | Formula |
|---|---|
| Gross profit | Revenue − cost of goods sold |
| EBITDA | Gross profit − operating costs |
| EBIT | EBITDA − depreciation |
| Net profit | EBIT − interest − profit tax |
| ROIC | EBIT × (1 − tax rate) ÷ invested capital |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Gross margin
- 53.3 %
- EBITDA
- 17.8 m ₽ · 14.8 %Profit before interest, tax and depreciation: the result of trading itself.
- Operating profit
- 15.3 m ₽ · 12.8 %
- Net profit
- 10.1 m ₽ · 8.4 %
- Return on invested capital (ROIC)
- 19.1 %Operating profit after tax ÷ invested capital.
- Opex share of revenue
- 38.5 %Operating costs ÷ revenue.
Statement and share of revenue
| Line | Amount | % of revenue |
|---|---|---|
| Revenue | 120 m ₽ | 100 % |
| Cost of goods sold | −56 m ₽ | −46.7 % |
| Gross profit | 64 m ₽ | 53.3 % |
| Rent | −10.5 m ₽ | −8.8 % |
| Staff | −17 m ₽ | −14.2 % |
| Marketing | −9 m ₽ | −7.5 % |
| Logistics and warehouse | −5.5 m ₽ | −4.6 % |
| Other | −4.2 m ₽ | −3.5 % |
| EBITDA | 17.8 m ₽ | 14.8 % |
| Depreciation | −2.5 m ₽ | −2.1 % |
| Operating profit (EBIT) | 15.3 m ₽ | 12.8 % |
| Interest | −1.8 m ₽ | −1.5 % |
| Profit before tax | 13.5 m ₽ | 11.3 % |
| Profit tax | −3.38 m ₽ | −2.8 % |
| Net profit | 10.1 m ₽ | 8.4 % |
Of every unit of revenue 8.4 % remains as net profit; EBITDA 14.8 %. The largest cost is “Staff”: compare its share with the previous period.
Nuances and limits
- Tax is simplified: prior-year losses and differences are not included. On the simplified regime enter 0 and calculate tax separately.
- The tax is simplified (past losses and differences are ignored): for the simplified regime use a calculation for your own regime and check with the accountant.
- Take revenue and expenses excl. VAT and for the same period.