Syntha Lab RU

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.

Revenue, profit and costs For whom: Owners, finance directors and investors reviewing results.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Revenue₽120,000,000Revenue for the period excl. VAT from the profit and loss report.
Cost of goods sold₽56,000,000Cost of goods sold for the same period excl. VAT.
Depreciation and amortization₽2,500,000Depreciation and amortization of fixed and intangible assets for the period.
Interest on loans₽1,800,000Interest on loans for the period.
Corporate income tax%25The rate for companies; if you are on the simplified regime calculate tax in the regime tool and enter 0.
Invested capital (optional)₽60,000,000Used for return on capital: leave empty if not needed.

How it is calculated

StepFormula
Gross profitRevenue − cost of goods sold
EBITDAGross profit − operating costs
EBITEBITDA − depreciation
Net profitEBIT − interest − profit tax
ROICEBIT × (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

LineAmount% of revenue
Revenue120 m ₽100 %
Cost of goods sold−56 m ₽−46.7 %
Gross profit64 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 %
EBITDA17.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 tax13.5 m ₽11.3 %
Profit tax−3.38 m ₽−2.8 %
Net profit10.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.

Terms used

Calculate on your data →