Grid Pricing enables you to model varying interest rates over time by incrementing or decrementing rates based on company performance against a metric.
To use grid pricing:
Access Forecast Method.
See Accessing Forecast Methods.
From Forecast, select Forecast Method.
Select Using grid pricing.
Click Edit Grid.
In Base Grid Pricing on, browse to or select a criteria account.
This account becomes the metric for measure.
In Comparison to use, select how to compare to the criteria account:
Less than or equal to
Greater than or equal to
In Adjust by, select an adjustment type:
In Reprice, select the frequency of calculation. The system adjusts rates at the beginning periods. Options:
In the Grid Pricing table, click Add to create rows. Then click in cells to enter values:
Criterion in Millions of Dollars
In this column, enter the value of the criteria in the same scale as the account.
Adjustment in Percent
This column is the effect on the rate, as a decimal. For example, if the rate rises a quarter of a point, enter .25.
To delete, select a row and click Delete.
To reorder, select a row and click the arrows.
Click OK .