What If Scenarios/Flexing Tips
How to Amend Later Years Data
Flexing Data in WinForecast
Resetting Credit Terms
Return to List of Topics
How to Amend Later Years Data
When a forecast covers more than one year, you can amend some of the later years' data based on earlier
data. You can do this for the whole forecast, or for the section, sub-section or record highlighted in
the main list of Records.
How to Do It
- From the main screen's menu select Wizards>Amend Later Years Data.
- Select whether to Amend forecast or to Amend [the named section, sub-section or record].
- Specify From when To when the amending is to apply and select to Amend With Data From...- the base data used for amending comes from either the previous year, half-year or quarter as selected.
- Specify the changes to the various types of data that you wish to apply in the Amend (100% no change) boxes.
Back to the top
Flexing Data in WinForecast
Did you know that you can perform What If? Type scenarios in WinForecast while keeping your underlying data?
You can apply a flex up to 999% or down to 1% from 100% which is "unchanged", to a section of records, a sub-section (ie subtotal inc sub items), a single record or different flexed amounts at all 3 levels.
Flexing can only be applied to P&L records/sections, ie Income, Costs, Overheads and Other Income.
How to do it
- From the list of records select the appropriate record or section of records and go to DATA>FLEX then choose the period that you would like to Flex From / To.
- In the Flex section on the main screen, enter the amount of the flex you wish to apply in the Flex Property box e.g 100% is unchanged, 120% reflects a 20% increase and 80% a 20% decrease.
- When you view your reports, the figures showing will be the flexed amounts. Your forecast will be in temporary mode until the flex is accepted or rejected.
- To accept the flexed data as permanent go to Data>Flex>Flex Data As or
go into Data>Flex>Unflex Data to revert to your original data.
You may wish to use the File>Save As functionality to retain different testing scenarios.
NOTE: While you are in flex mode, you can not extend your forecast or set for actuals.
Back to the top
Resetting Credit Terms
Want to see the impact of your cashflow if your debtors paid you in 30 days instead of 60; or if you paid your creditors in 45 days instead of 30?
This can be achieved quickly by updating parameter defaults and resetting credit terms for existing records.
How to do it
- Open up your Forecast File you would like to reset terms on
Its a good idea to do a File>Save As and save a new file as your play file so your original data is not affected
- Go to Options>Parameter Defaults.
- Enter in the new terms for Receipts and Payments
- To have it affect existing records go to Data>Reset Credit Terms
- Select Reset Credit Terms Given to update receipt terms in existing sales records
- Select Reset Credit Terms Taken to update payment terms in existing cost records
- Select All records or Exclude Fixed Assets as appropriate
Now view you your Cashflow report to see the impact
Back to the top
|