Analyzing Trends in the CFO KPI Balance Sheet : Cash Flow Dashboard

The CFO KPI Balance Sheet : Cash Flow Dashboard shows the Balance Sheet key performance indicators (KPIs) and year-over-year (YoY) variances. The dashboard also shows cash flow KPIs and cash activities by period, quarter, or full year. The dashboard includes Balance Sheet and Cash Flow trend graphs. The Balance Sheet trend graphs show asset and liabilities trend and their compositions. The Cash Flow trend graphs shows cash balance and free cash flow trends, and cash outflow and inflow trend.

This section gives general instructions for using these interactive subforms in the CFO KPI Balance Sheet: Cash flow Dashboard:

• Balance Sheet KPIs – Shows Balance Sheet performance metrics by month for all Class, Relationship, Department, Item, and Locations. These metrics include current ratio, debt to equity, debt to earnings before interest, taxes, depreciation and amortization (EBITA), and return on assets.

  The KPI ratios are calculated as:

• • Current Ratio = Current Assets ÷ Current Liabilities

  • Debt to Equity = Total Liabilities ÷ Equity

  • Debt to EBITDA = Total Liabilities ÷ EBITDA

  • Return on Assets = (Net Income ÷ Assets) × 100

• YoY % Change – Shows YoY variances as a percentage on Balance Sheet KPIs (current ratio, debt to equity, debt to EBITA, and return on assets) by month for all Class, Relationship, Department, Item, and Locations.

• Cash Flow KPIs – Shows the operating cash flow ratio, free cash flow to debt, and cash generating power ratio.

• Cash Activities – Shows cash flow roll ups (operating activities, investing activities, financing activities) by month for all Class, Relationship, Department, Item, and Locations.

• Assets : Liabilities Trend – Shows total asset and total liability trends, with an the option to drill down to individual asset or liability accounts.

• Asset Composition – Shows total current, fixed, and other assets values as a pie chart for the selected period. The subform includes an option to drill down to the individual accounts.

• Liability Composition – Shows total current and long-term liabilities and the total equity as a pie chart for the selected period. The subform includes an option to drill down to the individual accounts.

• Cash Balance and FCF Trend – Shows cash at the end of the period compared to the free cash flow trends for the selected Year.

• Cash Outflow : Inflow Trend – Shows operating, investing and financing activities for the selected Year. The subform includes an option to drill down into each activity.

To analyze the Balance Sheet KPIs and trends:

Note:

Maximize or refresh each trend graph by clicking the Maximize icon or Refresh icon in each subform .

1. From the Home page, click the Reporting and Analytics card.

2. To open CFO Dashboards, click the 4 tab on the left.

3. Click CFO KPI Balance Sheet : Cash flow Dashboard.

4. In the Point of View, choose a Version, Subsidiary, Currency, and Year.

5. Review the Balance Sheet KPIs, YoY % Change, Cash Flow KPIs, and Cash Activities.

6. Review the trends in each interactive subform for the selected year.

7. (Optional) Drill down to individual trend levels in the graphs for these subforms:

   • Assets : Liabilities Trend

   • Asset Composition

   • Liabilities Composition

   • Cash Outflow : Inflow Trend

   To drill down to the individual trend details in a subform, click a specific line or segment in the graph or click a specific name in the legend.

8. Hover over a series line or segment in any graph to see the series name, period (group), and value.

Related Topics

• Working With CFO Dashboards
• Analyzing Trends in the CFO KPI Income Statement Dashboard

General Notices