The % modifies the What If values only.ī. (iii) When using ‘ Seasonal’ What If cells are based on the same month in selected Reference Season Year to start. (ii) When using ‘ Range’ What If cells are forecasted based on repeating the average of the months selected and displayed in the Reference Period going forward. (i) When using ‘ Single’ What If cells are forecasted based on repeating the Reference Period going forward. Changing the What If Forecast any other way will not be retained. ❗ Note: You MUST use the 'What If %' column to adjust your Forecast. Change a % cell to affect a desired value in a month for an account. For instance, if you use 2019 as a Reference Season Year: 'Jan 2020 What If', 'Feb 2020 What If', 'Mar 2020' What If translates to Jan 2019, Feb 2019, Mar 2019 accordingly.Ī. ❗ Note: Seasonal What If columns are based on the same month in the year you select as baseline. (ii) Reference Season Year – Choose the desired year to set your baseline financial forecast, then hit enter (be sure to use the (i) First What If Month – This option will set the first month to forecast (Option 3) Seasonal - This option will use the specified years’ (within the last 2 years) financial data as a forecast starting point. (iii) Ending Reference Month – Choose the final month you want to average for a baseline, then hit Enter (be sure to use the following format: Apr 2021) (ii) Beginning Reference Month – Choose the first month you want to average for a baseline, then hit Enter (be sure to use the following format: Apr 2021) (i) First What If Month – Choose the first month to forecast, then hit Enter (Option 2) Range - This option will use the average of the specified beginning and ending months’ (within the last 2 years) financial data as a forecast starting point. (ii) Beginning Reference Month – Choose the month of the desired year to set your baseline financial month, then hit enter (be sure to use the following format: Apr 2020) (i) First What If Month – Choose the first month to forecast, then hit Enter (be sure to use the following format: Apr 2021) (Option 1) Single - This option will use any specified months’ (within the last 2 years) financial data as a forecast starting point. Choose a Reference Period Range, then hit Enter (there are 3 options to choose from).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |