Alan Miltz | How to generate a monthly financial scorecard

This system helps to eliminate business blind spots, using the strategic monthly board reporting process.

=-=-=-=-=-=

System Architect: Alan Miltz

Website: www.cashflowstory.com

Generated as part of the www.BusinessSystemsSummit.com

System Details

Step 1: Create a one-page monthly financial scorecard.

  • The one-page financial record that contains 4 chapters.
    • Chapter 1: Profitability – your profit.
       
    • Chapter 2: Working Capital – equals = (Receivables + Inventory or Work in Progress) – Payables 
       
    • Chapter 3: Other Capital – your Balance Sheet.
      • Funding (Net Debt + Equity) = Net Operating Assets (Working Capital + Other Capital).
         
    • Chapter 4: Funding and Returns – your funding as measured by your cash flow.
      • The quick way to calculate Chapter 4 is the movement in all your bank accounts – that’s the reconciliation of cash.
         
    • Further examples here.
       

 

Step 2: Calculate and include your marginal cash flow on your financial scorecard.

  • Marginal cashflow calculation: Gross Margin % – Working Capital %
    • Formula = (Gross Margin / Revenue) – [Working Capital (Debtors + Inventory / WIP + Creditors)/Revenue]

 

Step 3: Create visibility in your company.

  • Create your Ideal profile/target for each measure in your Profitability and Working Capital.
    • Colour code your business for each of the measures Good (Green) / Average (Yellow) / Bad (Red) for each of the business ratios.

 

Step 4: The financial health review process.

  • Review your one-page scorecard and the colours (green, orange, red) that you are getting each month.
    • Look at your trends in Working Capital
      • Working Capital Timeline (Creditor Days, Stock Days, Debtor Days)
         
    • Profitability trends (Gross Margin %, EBIT %, Net Profit %)
      • Revenue Growth vs. Overheads Growth

 

Step 5: Define actions based on 7 levers to improve business.

  • On a quarterly basis discuss with your management what changes can be made to move the 7 levers to improve profit, cash flow and business value:
    1. Price increase %
       
    2. Volume increase %
       
    3. COGS reduction %
       
    4. Overheads reduction %
       
    5. Reduction in Debtors Days
       
    6. Inventory / WIP – reduction in Stock Days
       
    7. Increase in Creditors Days

 

Step 6: Rinse and repeatreview results and define new actions.

e0beff9e5f4184030a8d0a45886db41e.png

Videos

Attachments

Tags