Cash Flow & Burn Analysis
The Cash Flow & Burn Analysis dashboard for Sage 300 captures liquidity, cash generation, and free cash flow month by month. It covers cash ratios, operating cash flow measured against current liabilities and total obligations, capital expenditures, and the number of days cash stays tied up in receivables, payables, and inventory.
How to use the cash flow and burn analysis dashboard
- Spot liquidity pressure in the months where the cash ratio and cash flow coverage ratio drop.
- Check operating cash performance against current liabilities using the operating cash flow ratio.
- Trace the effect of capital expenditures on free cash flow across each month.
- Follow days sales, payables, and inventory outstanding to see how many days cash stays tied up in the business.
- Gauge debt coverage with the cash flow coverage ratio, which divides operating cash flow by total debt.
Filters
Use the filtering panel at the top of the Cash Flow & Burn Analysis dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
Year: one value
Period: value range
Company: multiple values
Segment 2: multiple values
Segment 3: multiple values
Key performance indicators (KPIs)
The key performance indicators (KPIs) at the top of the dashboard show six liquidity and cash flow measures, and update based on the filters you apply.
| KPI | What it measures |
|---|---|
| Cash Ratio | Cash and cash equivalents divided by current liabilities, so a higher value means more liabilities can be paid from cash alone. |
| Operating Cash Flow Ratio | Operating cash flow divided by current liabilities, where a higher value means operations generate more cash relative to short term obligations. |
| Cash Flow Coverage Ratio | Operating cash flow divided by total obligations, so a higher value means more of the obligations can be paid from operating cash flow. |
| Working Capital to Total Asset Ratio | Net working capital divided by total assets, where a higher value means a larger share of the assets is financed by working capital. |
| Cash to Current Liabilities | Cash divided by current liabilities, and a higher value means more of the liabilities can be paid with cash on hand. |
| Free Cash Flow | Cash generated from operations after capital expenditures, which is higher when more cash remains for debt repayment and reinvestment. |
Visual components
| View name | Type of view | What it shows |
|---|---|---|
| Cash Flow vs Obligations | Combination | Follows operating cash flow, capital expenditures, operating cash flow ratio, and free cash flow month by month to show whether cash generation keeps pace with spending. |
| Liquidity Ratios Trend | Combination | Compares the cash ratio, cash flow coverage ratio, and working capital to total assets ratio month by month to track how liquidity evolves over time. |
| Working Capital Efficiency | Combination | Tracks DSO, DPO, DIO, and CCC month by month to show how long cash is tied up in receivables, payables, and inventory. |