Cash Forecast Computation for a Single Subsidiary
The cash forecast computation for a single subsidiary varies for account categories and additional values. Read the following topics to know more.
-
Cash Forecast Computation for Account Categories in a Single Subsidiary
-
Cash Forecast Computation for Additional Values in a Single Subsidiary
Cash Forecast Computation for Account Categories in a Single Subsidiary
The cash forecast computation for account categories in a single subsidiary varies depending on the Data To Use and % Movement values on the SuiteApp's Preferences page. For more information, see Setting Cash 360 Preferences.
The following table shows how the cash forecast for account categories is calculated when there is no subsidiary consolidation.
|
Forecast Period |
Cash Forecast Computation Without % Movement |
Cash Forecast Computation with % Movement |
|---|---|---|
|
Daily |
The total amount for the account category, divided by the Data To Use value in months, multiplied by 12 months, and divided by 365 days. Daily Cash Forecast =(Total Amount for the account category ÷Data To Use in months) ×12 months ÷365 days |
The daily cash forecast amount for the account category, multiplied by the percentage of movement, plus the daily cash forecast amount. Daily Cash Forecast with % Movement =(Daily Cash Forecast ×% Movement) +Daily Cash Forecast |
|
Weekly |
The total amount for the account category, divided by the Data To Use value in months, multiplied by 12 months, and divided by 52 weeks. Weekly Cash Forecast =(Total Amount for the account category ÷Data To Use in months) ×12 months ÷52 weeks |
The weekly cash forecast amount for the account category, multiplied by the percentage of movement, plus the weekly cash forecast amount. Weekly Cash Forecast with % Movement =(Weekly Cash Forecast ×% Movement) +Weekly Cash Forecast |
|
Monthly |
The total amount for the account category divided by the Data To Use value in months. Monthly Cash Forecast =Total amount for account category ÷Data To Use in months |
The monthly cash forecast amount for the account category, multiplied by the percentage of movement, plus the monthly cash forecast amount. Monthly Cash Forecast with % Movement =(Monthly Cash Forecast ×% Movement) +Monthly Cash Forecast |
In the Forecast Details table, the % Movement values are not applied to the current day, month, or week but are only applied to succeeding periods.
Cash Forecast Computation for Additional Values in a Single Subsidiary
The following factors affect the cash forecast computation for additional values in a single subsidiary:
-
Whether the amount is considered as outflow or inflow
-
Forecast period
-
Recurrence
-
Recurrence Type
These factors can be set on the SuiteApp's Preferences page. For more information, see Setting Cash 360 Preferences.
The following table shows examples of how the cash forecast for additional values is calculated when there is no subsidiary consolidation.
|
Date |
Amount |
Type |
Recurrence |
Recurrence Type |
Forecast Period |
Cash Forecast |
|---|---|---|---|---|---|---|
|
Today |
1000 |
Inflow |
5 |
Daily |
5 Days |
1000 appears on the cash forecast as an outflow amount for five days starting on the current date. |
|
Today |
2000 |
Outflow |
3 |
Weekly |
4 Weeks |
2000 appears on the cash forecast as an outflow amount for three weeks starting on the current week. |
|
Today |
3000 |
Inflow |
6 |
Monthly |
6 Months |
3000 appears on the cash forecast as an inflow amount for six months starting on the current month. |