Analyzing Trends in the Cash Flow Dashboard

You can view the Cash Flow Dashboard for a single Subsidiary, a total parent, or company consolidated Subsidiary, in either input or reporting currency.

Use this dashboard to:

• Review the end-of-month cash position for the projected Forecast periods to assess if the projections make sense.

• Analyze the Actual and projected operating cash flow trends to see if the Forecast is realistic and meets company goals.

• Analyze the cash activities to make sure they align with company expectations.

• Drill down into cash flow activities to see trends at a detailed level.

This section gives general instructions on for using these interactive subforms:

• Cash Flow Trend – Shows the end-of-month cash projection and free cash flow.

  The trends in the Cash Flow Trend graph use these calculations per period:

  • Cash at the Beginning of Period =Prior Period Closing Balance

  • Cash at the End of Period =Cash at the Beginning of Period +Net Change in Cash for Period +Effect of Exchange Rate on Cash

  • Free Cash Flow = Total Operating Activities – Total Investing Activities

• Cash Flow Ratios – Shows the total operating activities to sales, free cash flow to debt, and cash generating power ratio trends.

  The trends in the Cash Flow Ratio graph use on these calculations per period:

  • Total Operating Activities to Sales =Total Operating Activities ÷Total Sales

  • Free Cash Flow to Debt =Free Cash Flow ÷Total Liabilities

  • Cash Generating Power Ratio =Total Operating Activities ÷(Total Operating Activities +Total Investing Activities +Total Financing Activities)

• Cash Flow Activities – Shows the trends for total operating, total investing, and total financing activities. the subform lets you drill down into each activity to analyze trends at a detailed level.

To analyze Cash Flow's trends, ratios, and activities:

Note:

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

1. From the Home page, go to Financials > Cash Flow.

2. Click Cash Flow Dashboard at the bottom of the page.

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

4. Review the trends in each interactive subform for the selected Subsidiary. Hover over a series line in the graph to see the series name, period (group), and value.

5. (Optional) In the Cash Flow Activities subform, to see a cash flow activity trend at a detailed level, click a cash flow activity in the legend.

   • If you drill into Total Operating Activities, drilling shows the total net income and total adjustments to net income trends.

     To see the source and trend of the change activities, drill down further to Total Adjustments to Net Income.

     You can continue to drill further to Adjustment to Net Income and then Change in Accounts Payable.

   • If you drill into Total Investing Activities, drilling shows the change in fixed assets and depreciation and amortization trends.

   • If you drill into Total Financing Activities, drilling shows the change in long term liabilities and change in equity trends.

Related Topics

• Working With Financial Statement Dashboards
• Analyzing Trends in the Cash Cycle Dashboard
• Analyzing Trends in the Income Statement Dashboard
• Analyzing Trends in the Balance Sheet Dashboard

General Notices