You use the Sensitivity Analysis—Full Model tab to analyze the entire model. Because it uses the fill model, it has the longest calculation time.
To set the full model options for sensitivity analysis:
In In period, select a time period.
Default: the first forecast period
You can select aggregate time periods only when you select Multiplying By in the Change by field. |
This becomes All Forecast Periods when you select one of these accounts in the Sensitivity of field:
In Relative to (top), select the item on which the sensitivity of the item in Sensitivity of is determined and the calculation based on.
Enter information for the first account variable that is changed. This appears on the matrix.
Select the top variable of the matrix on which the sensitivity is performed.
Select a method for changing the sensitivity variable:
Add the change amount to the input value of the relative variable. The change amount is based on the input type and scale of the relative variable. For example:
An increment of 3 for A/R, if it is forecast in Days of Annualized Sales, adds 3 days to the input value of A/R.
An increment of 2 for Sales, if it is forecast as a Growth Rate, adds 2 percent to the input value of Sales.
An increment of 5 for Fixed Capital Investment, if it is forecast as Actual Value in Millions, adds 5 Million Dollars to the input value of Fixed Capital Investment.
Multiplies the input value for the Relative to account by a percentage. For example:
Enter the amount multiplied by or added to the Relative to account. The maximum is 999.9. You cannot enter negative amounts.
If you enter 2% for Sales Growth Rate and select Multiplying in the Change by field, Strategic Finance multiplies the Sales Growth Rate by 98% to obtain the -2% result and multiplies the Sales Growth Rate by 102% to obtain the +2%.
If you enter 2% for Sales Growth Rate and select Adding in the Change by field, Strategic Finance adds or subtracts 2% to calculate the results. So 10% becomes 8% and 12% growth rate.
Optional: To add another sensitivity variable, in And Relative to (left), select an .
To perform a sensitivity using a second variable, enter information about the account (it appears left of the matrix). Complete the fields as you did in the Relative to fields.
You cannot the select the same account for both relative variables.
To only perform an analysis using one variable, enter a zero for the change amount for one of the relative variables.