Management balance sheet from the P&L and turnover figures
From the P&L, the inventory, receivable and payable days and the opening balance sheet builds the closing balance sheet: cash by the indirect method, assets, liabilities, equity; checks that it ties, shows net working capital and net debt and compares the calculated cash with the actual.
At a glance
- What question does it answer?
- What the closing balance sheet will be from the P&L and turnover figures, whether it ties and how much cash is tied up in turnover.
- What data is needed?
- The P&L: revenue, cost of sales, expenses, depreciation, interest, tax, CAPEX, loans, dividends.
- How to read the result?
- On the default data (the Model B balance sheet) closing assets are 116,326,039, liabilities 40,795,372, equity 75,530,668, the check is zero. Cash is 14,351,092 (14,351 thousand in the “Balance” document), EBITDA 35,047,557, profit 21,050,668. Net working capital is 72,004,575 (an increase of 6,124,575 is tied up in turnover), net debt 9,648,908, that is 0.28 of EBITDA, equity to assets 64.9%. The difference from the document is a few thousand roubles at most because of the model’s rounding to thousands. Example on the default values: Total assets at the end: RUB 116.3 million; Total liabilities at the end: RUB 40.8 million; Equity at the end: RUB 75.5 million; Cash at the end (calculated): RUB 14.4 million. The figures are illustrative: enter your own to see your result.
Why and how to reason
A profit and loss statement shows whether the business earned, while the balance sheet shows what that money turned into: stock, receivables, fixed assets or cash in the account. A management balance sheet is built from the P&L and working-capital indicators because balances depend on the speed of turnover. Stock equals cost × days ÷ 365: at 240 days and a cost of 90.2 million it is 59.3 million. Payables depend on purchases, and purchases on cost and the change in stock. Receivables are counted by channel: revenue with VAT × days ÷ 365. Cash is found by the indirect method: opening cash plus profit plus depreciation minus growth in working assets plus growth in liabilities minus investment plus loans minus dividends. The result is 14.35 million. Balance check: assets 116.3, liabilities 40.8, equity 75.5 million, the difference is zero.
When to use it
It is useful for a yearly forecast, preparing for a loan, assessing the effect of a change in turnover and reconciling a plan with the accounts. It does not replace the accounting balance sheet: it is a model on average days, not on postings. Assumptions: turnover is given by days at period end, tax and VAT payable are entered by you, provisions and advances are set as shares. It is also a check on your plan: if the turnover days look reasonable but cash does not reconcile, look for the error in the assumptions.
How to read the result
Look at three things. Reconciliation: if the difference is not zero, the input is incomplete and the result cannot be used. Net working capital (72 million) and its growth (6.1 million): this shows how much money growth “ate”. Net debt (9.6 million) and net debt ÷ EBITDA (0.28): this is the health of the business for a bank. If you enter actual closing cash, the calculation shows a discrepancy: it must be explained (a missed payment, wrong turnover). Change the days of inventory and receivables to see how much money a speed-up releases, and compare with the cost of achieving it.
Common mistakes
Typical trap: entering revenue with VAT where without is needed, not entering the whole opening balance (so that it reconciles), taking days of inventory at the start instead of the end, forgetting the provision and advances. A zero reconciliation proves arithmetic, not the correctness of the source data.
What data is needed?
- The P&L: revenue, cost of sales, expenses, depreciation, interest, tax, CAPEX, loans, dividends.
- Inventory, payable and payroll days, reserve and advance shares, receivables by channel.
- The opening balance sheet and the closing liabilities you know.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Revenue excl. VAT | ₽ | 206,665,000 | Net revenue for the period after returns. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Cost of sales | ₽ | 90,222,000 | Cost of goods sold for the period excl. VAT, including write-offs. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Operating expenses | ₽ | 80,956,000 | All expenses above EBITDA: payroll, rent, marketing, commissions, logistics; without depreciation and interest. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| of which payroll with contributions | ₽ | 33,800,000 | The part of operating expenses that creates a liability to staff. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Depreciation | ₽ | 3,200,000 | Accrued for the period. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Interest payable | ₽ | 3,780,000 | Interest on loans for the period. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Corporate income tax rate | % | 25 | Tax is taken on profit before tax, with a loss there is no tax. Check the regime with an accountant. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Capital expenditure (CAPEX) | ₽ | 4,000,000 | Spend on fixed assets for the period. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Loans drawn | ₽ | 0 | New loans for the period. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Loans repaid | ₽ | 6,000,000 | Principal repaid in the period. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Dividends | ₽ | 6,000,000 | Paid to owners in the period. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Inventory days at the end | days | 240 | Closing stock at cost ÷ cost of sales × 365. For footwear and children’s the seasonal cycle is longer: take your own. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Inventory impairment reserve | % | 6 | The share of stock at cost reserved at the end. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Supplier advances | % | 5 | The share of purchases for the period paid in advance and not yet delivered. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Payable days | days | 30 | The average days to pay suppliers; applied to purchases with VAT. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Days of payroll owed | days | 15 | How many days of payroll remain owed at the end. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| VAT rate in the receivables and payables | % | 22 | Receivables and payables are booked with VAT. Your rate (different for benefits and the simplified regime): check with an accountant. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| VAT payable at the end | ₽ | 3,871,000 | From the tax calculation or the payment calendar. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Corporate income tax payable at the end | ₽ | 1,754,000 | The remainder due after advance payments. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Loyalty liabilities at the end | ₽ | 0 | The liability to loyalty program members; zero for a brand without a program. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Actual cash at the end | ₽ | — | From the bank statement and the till. If entered, the calculation shows the gap: actual minus calculated. Empty: no cash check. The example value is illustrative. |
| Cash | ₽ | 12,000,000 | The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Receivables | ₽ | 22,500,000 | All receivables at the start. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Inventory at cost | ₽ | 52,000,000 | Before the reserve. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Inventory reserve | ₽ | 3,120,000 | The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Supplier advances | ₽ | 5,000,000 | The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Fixed assets | ₽ | 18,000,000 | At net book value. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Payables | ₽ | 9,000,000 | The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Owed to staff | ₽ | 1,500,000 | The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| VAT payable | ₽ | 3,800,000 | The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Corporate income tax payable | ₽ | 1,600,000 | The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Loyalty liabilities | ₽ | 0 | The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Loans and borrowings | ₽ | 30,000,000 | The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Opening equity per the books | ₽ | — | For the tie-out check: if entered, the opening balance sheet is compared with the equity per the books and the closing equity is rolled forward from it. Empty: opening equity is found as assets minus liabilities, so the balance ties by construction (no check). The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Inventory and reserve | stock = cost of sales × days ÷ 365; reserve = stock × share |
| Purchases and payables | purchases = cost of sales + closing stock − opening stock; payables = purchases × (1 + VAT) × days ÷ 365; advances = purchases × share |
| Receivables and staff | by channel: revenue × (1 + VAT) × days ÷ 365; payroll × days ÷ 365 |
| Profit | EBITDA = revenue − cost of sales − reserve increase − expenses; minus depreciation, interest, tax |
| Cash | opening cash + profit + depreciation + reserve increase − growth of current assets + growth of liabilities − CAPEX + loans − dividends |
| Balance sheet and check | equity = opening + profit − dividends; assets − liabilities − equity is zero |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Total assets at the end
- 116.3 m ₽
- Total liabilities at the end
- 40.8 m ₽
- Equity at the end
- 75.5 m ₽Opening equity + net profit − dividends.
- Cash at the end (calculated)
- 14.4 m ₽The indirect method: profit, depreciation, the change in working capital, CAPEX, loans, dividends.
- EBITDA
- 35 m ₽
- Net profit
- 21.1 m ₽
- Net working capital
- 72 m ₽Receivables + net inventory + advances − payables − owed to staff − loyalty liabilities.
- Increase in net working capital
- 6.12 m ₽Plus: cash is tied up in turnover.
- Net debt
- 9.65 m ₽Loans minus cash; negative means cash exceeds debt.
- Net debt ÷ EBITDA
- 0.28×
- Equity to assets
- 64.9 %
- Tie-out check: assets − liabilities − equity
- opening equity per the books not entered: no check
- Cash gap: actual minus calculated
- actual cash not entered
Balance sheet: opening, closing, change
| Line | Opening | Closing | Change |
|---|---|---|---|
| Cash | 12 m ₽ | 14.4 m ₽ | 2.35 m ₽ |
| Receivables | 22.5 m ₽ | 22.5 m ₽ | 33,032 ₽ |
| Inventory at cost | 52 m ₽ | 59.3 m ₽ | 7.32 m ₽ |
| Inventory reserve (minus) | −3.12 m ₽ | −3.56 m ₽ | −439,443 ₽ |
| Supplier advances | 5 m ₽ | 4.88 m ₽ | −122,697 ₽ |
| Fixed assets | 18 m ₽ | 18.8 m ₽ | 800,000 ₽ |
| Total assets | 106.4 m ₽ | 116.3 m ₽ | 9.95 m ₽ |
| Payables | 9 m ₽ | 9.78 m ₽ | 781,330 ₽ |
| Owed to staff | 1.5 m ₽ | 1.39 m ₽ | −110,959 ₽ |
| VAT payable | 3.8 m ₽ | 3.87 m ₽ | 71,000 ₽ |
| Profit tax payable | 1.6 m ₽ | 1.75 m ₽ | 154,000 ₽ |
| Loyalty liabilities | 0 ₽ | 0 ₽ | 0 ₽ |
| Loans and borrowings | 30 m ₽ | 24 m ₽ | −6 m ₽ |
| Total liabilities | 45.9 m ₽ | 40.8 m ₽ | −5.1 m ₽ |
| Equity | 60.5 m ₽ | 75.5 m ₽ | 15.1 m ₽ |
Opening equity is found as assets minus liabilities, so the closing balance sheet ties by construction and proves nothing by itself. Enter the opening equity per the books or the actual closing cash: then the calculation shows the gap. Assets 116.3 m ₽, liabilities 40.8 m ₽, equity 75.5 m ₽.
Net working capital 72 m ₽, net debt 9.65 m ₽.
This is a management balance sheet of a simplified structure and not statutory reporting: VAT is in receivables and payables, taxes payable are entered as ready numbers, cash comes from the indirect method. Reconciliation with accounting is required. Amounts in roubles.
Nuances and limits
- A balance sheet that ties by construction proves nothing: enter actual cash to see the gap.
- Take inventory days at period end and not the annual average: seasonal footwear and children’s stock differs at season end.
- Receivables and payables are booked with VAT: calculate them from revenue and purchases with VAT and profit without it.