Retail finance
Forecast, store plan, budget, profit and loss, cash, ways to close a gap and VAT.
Route steps
- 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 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. - 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. - 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. - 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. - 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. - 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. - 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. - 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. - 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. - 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
- Cash flow statement: direct and indirect method
- The unified tax account and the tax calendar: the unified payment, notifications, balance, penalties, the payment calendar of a brand and a retailer
- Management balance sheet
- Business lending: bank products, a pledge of goods in circulation, a limit and an overdraft, what the bank looks at and how to prepare an application
- LFL and comparable sales (4-5-4 calendar)
- Market research: TAM/SAM/SOM, CustDev, UX tests and benchmarking
- Payment calendar: priorities and cash gap
- Income statement (P&L): management and statutory