Syntha Lab RU

Retail finance

Forecast, store plan, budget, profit and loss, cash, ways to close a gap and VAT.

For retail

Open interactively →

Route steps

  1. 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.
  2. Revenue analysis: price, volume and mix
    Splits the deviation of revenue from plan into three causes: price change, volume change and change in the product mix. Answers why revenue did not match.
  3. Fixed and variable costs, margin of safety
    Splits costs into variable (rising with revenue) and fixed, calculates break-even revenue, margin of safety and shows how strongly profit reacts to a change in sales.
  4. Sales forecast: method, horizon, error
    Builds a forecast from sales history using four methods, shows each method’s error on past data and suggests which is more reliable for your series.
  5. Sales plan by store
    Splits the chain’s revenue plan across stores: growth of existing stores, new stores ramping up, closures and partial years. Shows the total against last year and against the target.
  6. Annual budget by month
    From last year’s revenue, growth and cost structure builds a monthly income and expense budget: revenue, gross profit, EBITDA and the months in which the business goes into the red.
  7. Average stock for the year and turnover
    Calculates average stock from monthly balances, turnover and days of inventory and shows how far a one-date balance distorts the picture in a seasonal business.
  8. Monthly cash flow and cash gap
    From monthly receipts and payments calculates the cash balance, the tightest month and the shortfall against a safe minimum.
  9. Profit versus cash: where the difference went
    Lays out the path from profit to the change in cash: depreciation, growth in stock, receivables and payables, equipment purchases, loans. Shows which line ate the cash despite a positive profit.
  10. Overdraft, factoring or inventory loan: which is cheaper
    Compares three ways to cover a cash need for a term by total cost with fees and by effective annual rate. Bank terms are individual: enter rates from your own offers.
  11. VAT for a period: charged, deductible, payable
    Calculates VAT on sales, input VAT on purchases and the amount payable or refundable, plus the tax burden on revenue.

Documents for this route

Other routes for this audience