Brand finance director: what to learn and where to start
A brand finance director turns the collection into money: cost, margin, working capital, taxes and a safety margin. Start with the income statement, cash flow and the 13-week forecast.
What to understand
- Profit is not cash
- Profit grows while cash is short: it sits in stock, receivables and supplier prepayments.
- Working capital and the cash cycle
- The cash conversion cycle is days of inventory plus receivables minus payables.
- VAT and taxes in calculations
- Revenue and cost in calculations are excl.
- Wholesale receivables and reserves
- Credit to a client is a loan.
- The price of money
- Overdraft, factoring, inventory loans and early-payment discounts carry different effective rates.
- Budget and plan versus actual
- A monthly budget with seasonality and cash gaps buys time to arrange funding ahead.
- Investment
- A store, collection or equipment is judged by NPV, IRR and payback on cash flows, not profit.
- The 13-week cash plan
- Profit does not tell whether cash lasts the coming weeks.
- Tax load by regime
- The choice between the simplified regime and the general system depends on the cost share, the VAT threshold and insurance contributions.
- Valuation and a funding round
- Valuation by multiples and by cash flows gives a range, not a point.
- Payment abroad and import
- Rate, spread, duty and import VAT make up the full price of imported goods.
- Buying calendar and discount budget
- The open-to-buy budget (OTB) and the promotion calendar set when money goes out and returns.
- EDI, reconciliation and exchange lag
- Electronic documents cut processing time and errors, but count the gain on your volumes and operator rates.
The first 30 days
- Build the 13-week cash plan. The 13-week cash plan: balance, gap and stress
- Compute the end-to-end gap from factory prepayment to buyer cash. End-to-end cash gap: from the factory deposit to the buyer’s money
- Compare tax regimes at your cost share and show your accountant. Total tax load: simplified on income, on income minus costs, and the general system
- Check the VAT threshold on the simplified regime. VAT threshold on the simplified regime: when you start paying and which rate is better
- Run the plan through the sensitivity tornado. Plan sensitivity and breaking point
- Compute runway and business valuation. Runway: how many months the cash lasts
- Open the planning calendar and mark the buying and discount decision dates. The planning calendar
- Compare buying plan adherence with the cash plan. Buying plan adherence: receipts, sales and stock
Which measures to track
| Measure | Formula |
|---|---|
| Cash conversion cycle | Days of inventory + days of receivables − days of payables |
| Stock turnover | Cost of goods sold ÷ average stock for the period |
| GMROI | Gross profit ÷ average stock at cost |
| Cash balance by month | Opening balance + receipts − payments |
| Payback and NPV | Discounted cash flows minus the investment |
| Margin of safety | (Revenue − break-even revenue) ÷ revenue |
| Minimum weekly cash balance | Opening balance + receipts − payments, by week, take the minimum |
| Tax load | (Taxes + insurance contributions) ÷ revenue |
| Runway | Cash ÷ average monthly cash burn |
| Full landed unit price | Price + duty + import VAT + logistics + rate spread |
| Enterprise value | EBITDA × multiple or discounted flows |
| Buying plan adherence | Actual receipts ÷ planned receipts for the period |
Calculations in order
- 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. - 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. - Cash conversion cycle and working capital
Shows how many days money lives in stock and receivables net of supplier credit, and how much capital it freezes. - 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. - Customer credit limit and wholesale receivables aging
Shows for each wholesale customer how much has been shipped on credit, how much of the limit is used, how much debt is overdue and what doubtful-debt reserve to create by age group. The reserve rates are editable. - 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. - 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. - Investment project: NPV, IRR and payback
Appraises a project from its cash flows: opening a store, launching a collection, buying equipment. Calculates net present value, internal rate of return and payback. - 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. - Tax regime: simplified or general system
Compares tax under the simplified regime on income, the simplified regime on income minus expenses, and the general system (corporate income tax) for your revenue and costs, and shows the point at which the better option changes. - Inventory write-down: cost against net realizable value
For stock groups compares cost with net realizable value (expected price less costs to sell), calculates the write-down, stock at the lower of the two and how much to add to the reserve already created.
Documents to start with
- Income statement (P&L): management and statutory
- Cash flow statement: direct and indirect method
- Management balance sheet
- Budget: P&L, cash, purchase, marketing, payroll and CAPEX budgets
- Budgeting methods: rolling forecast, ZBB, what-if scenarios
- Plan versus actual and profit factor analysis (bridge)
- Payment calendar: priorities and cash gap
- Financial model (FinModel): sheets, links, checks, scenarios
- Business plan of a brand and a retailer: sections, assumptions, presenting to an investor and a bank
- Investment case: opening a store, a line, IT (NPV, IRR, payback)
Data templates
Purchase orders
Order lines to a factory or supplier: SKU, quantity, price, dates and delivery actuals.
Supplier terms
Minimum order, lead time, payment and currency by supplier.
Questions you will be asked
- Is there enough cash for payments by month of the season?
- Why is there profit but no cash?
- How much capital is frozen in stock and receivables?
- What is cheaper: overdraft, factoring or an inventory loan?
- What credit limit to set for a wholesale client?
- Will a store opening or a collection launch pay back?
- Which tax regime is better at our turnover?
- How did profit change: by cause?
- How much reserve is needed for the write-down of leftovers?
- How much reserve to hold for bonus points?
- How does the rate affect collection margin and how much of the purchase to hedge?
- Will there be a cash gap in the next 13 weeks?
- Which tax regime pays at our cost share?
- What is the business worth and what does a round give?
- What happens to margin if the rate or duties rise?
- What do EDI versus paper and stock mismatches cost us?