CFO Dashboard reports

The CFO Dashboard reports use mainly global variable M3A_FKRReport3 as input for the report ID. Default value is M3FKR3. Cash and Cash Equivalence in Solvency Ratio by Period report uses M3A_FKRReport1; default value is M3FKR1. Gross Profit in Gross Profit Margin Pct by Period report uses M3A_FKRReport2; default value is M3FKR2. The measures used in CFO Dashboard reports are sourced from the Finance Key Ratio fact. These measures are analyzed by Accounting Period Date and use the Sum aggregation.

Working Capital & Liquidity Ratios by Period

Description: This report shows the fiscal period trend of the recorded amounts for report lines Current Ratio, Quick Ratio, and Return on Working Capital. The amounts for Current Ratio and Quick Ratio are plotted on the primary axis and Return on Working Capital percentage on the secondary.

Measure: Recorded Amt

Chart type: 3 data series combo, 2 column chart on Y axis 1 and 1 line on Y axis 2

Solvency Ratio by Period

Description: This report shows the fiscal period trend of the recorded amounts for report lines Cash and Cash Equivalence and Solvency Ratio. The Cash Equivalence amount is plotted on the primary axis and Solvency Ratio on the secondary.

Measure: Recorded Amt

Chart type: 2 data series combo, 1 column chart on Y axis 1 and 1 line on Y axis 2

Gross Profit Margin Pct by Period

Description: This report shows the fiscal period trend of the recorded amounts for report lines Gross Profit and Gross Profit Margin (%). The Gross Profit amount is plotted on the primary axis and Gross Profit Margin (%) on the secondary.

Measure: Recorded Amt

Chart type: 2 data series combo, 1 column chart on Y axis 1 and 1 line on Y axis 2

AR & AP Turnover by Period

Description: This report shows the fiscal period trend of the recorded amounts for report lines AR Turnover Ratio and AP Turnover Ratio. The amounts are plotted on the primary axis.

Measure: Recorded Amt

Chart type: 2 data series line chart