This workbook is ultimately going to be surety bond rating model that will be used to underwrite and price contract surety bonds.
The Worksheet titled "Rating Rules" contains a series of underwriting rules, the total for which are intended to consecutively modify the Base Rate value in cell D1. However, the values calculated in Cell C15, C26, and C34 need to be restricted within a specified range with the minimum value being -25% and the maximum value being +25%.
Additionally, the TOTAL Value for RULE 2 in cell C35 needs to be restricted within a specified range with the minimum value being -40% and the maximum value being +40%.
Can someone please provide some insight regarding the formula that needs to be entered into Cells C15, C26, C34, and C35 in order to yield the desired result?
Thanks in advance for your assistance.
Bookmarks