Manage CFWC settings

Designate the settings to display results on various pages throughout Cash Flow / Working Capital.

  1. On the Treasury Cash Management page, click Administration > Cash Flow / Working Capital.

  2. Click Settings.

  3. Select the Cash Balance Code code from the dropdown.

  4. Enter the number of Days Cash on Hand - Upper Limit.

  5. Enter the number of Days Cash on Hand - Lower Limit.

  6. Select the Dynamic Forecast Date check box to automatically update the Forecast Date as the first work day following actual data as part of the import process (default is deselected). If deselected, select a Beginning Forecast Date.

  7. For Cash Forecast Summary Level, select the level at which the Cash Forecast is developed.

  8. For Default Report View, select the company or plan code to determine which reports are viewed on the Variance Report, Working Capital Dashboard, and Cash Flow Analytics pages.

    1. If you select All, skip to Step 9.

    2. If you select Company, select the Default Company for the Cash Forecast and Cash Flow Analytics pages.

    3. If you select Plan Code, select the Default Plan Code for the Cash Forecast and Cash Flow Analytics pages.

  9. Enter the number of Forecast Future Weeks to calculate in the Axiom scheduler.

  10. Enter the number of Forecast Weeks to calculate on the Cash Forecast page.

  11. Enter the number of Historical Days to calculate on the Cash Forecast page.

  12. Enter the number of Forecast History Days Data to calculate the number of rows displayed on the Cash Forecast page.

  13. Enter the number of History Weeks to calculate the number of rows displayed on the Cash Flow Analytics page.

  14. Enter the two-digit Fiscal Last Month (for example, 12 = December).

  15. Enter the allocation percentage for Investment tier 1B and 1C.

    NOTE: The percentage for Investment tier 1A - allocation % is calculated automatically by subtracting the allocation percentages for 1B and 1C from 100% to ensure that the sum of all tiers is 100%. The percentages are used in the yield calculation to determine the amount of excess cash to be invested in each tier.

  16. Enter the yield rates for Investment tier 1A, Investment tier 1B, and Investment tier 1C. These rates are used as the Assumptions on the Yield Opportunity page to calculate the potential annual return for each tier.

  17. Enter the Default Interest Rate. This value is used as the default on the Yield Opportunity page.

  18. Select check boxes for line items on the Cash Forecast and Cash Flow Analytics pages. At least one selection is required.

  19. Click one of the save options:

    • To save your information, click Save.

      NOTE: If you made any selections in Step 18, Save is disabled.

    • To calculate the forecast for the defined number of weeks from the specified forecast date, click Save and run.