Sample report

See what a monthly management review looks like.

A five-page example for a fictitious distributor with about US$15M in annual revenue. It is the deliverable of week 4 of every cycle.

Illustrative example with fictitious data. Not a client case.

The story in this example

Revenue beat budget. Gross profit barely moved.

In the example month, revenue is ahead of plan and management feels good about it. The review shows why the extra sales did not reach gross profit, and what is about to happen to cash.

Revenue
$1.28M
+6.0% vs budget
Gross margin
31.5%
−1.7 pts vs budget
EBITDA
$91K
7.1% of revenue (budget 8.4%)
Cash at month end
$253K
13-week low: $167K, week 9

Gross profit: budget to actual

March, US$ thousands. Change vs. budget by driver.

Gross profit: budget to actualAgainst a budget gross profit of $400K, volume added $31K, price $13K; discounts took away $34K, mix $4K and unit cost $4K. Net change +$2K, to $402K.Volume: +31+31VolumePrice: +13+13PriceDiscounts: −34−34DiscountsMix: −4−4MixUnit cost: −4−4Unit costNet change: +2+2Netchange
Volume and price added to gross profit. Discounts took almost all of it back.

13-week cash forecast

Projected cash at the end of each week, US$ thousands.

13-week cash forecastCash starts at $253K, falls to a low of $167K in week 9, below the $200K buffer in weeks 8–10, and recovers to $339K by week 13.Minimum buffer $200KW1: $296KW1W2: $291KW2W3: $303KW3W4: $293KW4W5: $342KW5W6: $251KW6W7: $280KW7W8: $183KW8W9: $167KW9W10: $184KW10W11: $279KW11W12: $275KW12W13: $339KW13$296K$167K$339K
Cash falls below the minimum buffer in weeks 8 to 10, while there is still time to act.

What is inside

Five pages. One conversation with management.

  1. Sample report page 1: Executive summary

    Executive summary

    The month in four numbers and three things management should know.

  2. Sample report page 2: Profitability

    Profitability

    Budget vs. actual, the margin bridge and results by product line.

  3. Sample report page 3: Cash and working capital

    Cash and working capital

    Receivables, inventory, payables, and the bridge from profit to cash.

  4. Sample report page 4: 13-week cash forecast

    13-week cash forecast

    When cash gets tight and which levers are still available.

  5. Sample report page 5: Priorities

    Priorities

    What deserves attention, with an estimate of what each item is worth.

Download the sample (PDF)

The exact analysis depends on the business. The structure and the level of reasoning are what stay the same.

Want this for your own numbers?

Start with the financial question you are trying to answer.

A short first conversation. No special report or presentation required.

Discuss your business Assessment