More flexibility to calculate fees in Disclosure > Cost Details area
In the 3/26/2022 update, the Disclosure > Cost Detail section users are presented with an updated UI for fees calculation as shown below.
Cost detail screen:
Fees configuration in Settings:
Three options are supported - Constant, Field, and Formula
Select the calculator or edit option next to the fee item, in the "Setter Type" field, there are 3 options as shown below:
- Constant - if a fee is a constant dollar amount, use this option.
- Field - if a fee always equates to a field in the system, use this option.
- Formula - if a fee is calculated - addition, subtraction, multiplication, division, and tiered scheduled calculations.
- "Re-Calculate Automatically" option, if true, means that the system will constantly recalculate the value whenever the factor(s) in the formula changes. In the following example, it means whenever the purchase price is updated in the system, this fee will get automatically calculated as well.
Example
Simple formulas such as a percentage of the purchase price are presented below. The system can also take in multiple factors (or operands), in a more complex calculation as well as supporting nested formulas.
If a fee always defaults to 1.514% of the purchase price. , users would simply enter 1.514 in the field for percentage. However, with the new update, the factor needs to be entered as 0.01514.
Fee = Purchase Price * 1.514%
Support of tiered and volume schedule
Under Formula, "Tiered Schedule" is now supported. In the "Type" field, Use "Graduated Pricing" to apply a different tier and percent calculation for each range of value for the parameter selected in "Field". Use "Volume Pricing" to apply a single-tier calculation of the Field parameter that falls into one of the ranges.
For example, you could use "Tiered Schedule" to estimate title insurance premiums. In the Field area, select "Loan amount". In Type, select "Graduated Pricing". In the following example, the resulting calculation for a $150,000 loan amount will be
$200 + (100,000 - 1) x 1% + $300 + (150,000 - 100,001) x 0.5%.
Note - updating fee configurations will affect all loans going forward. Please always consult an experienced system administrator or the support desk before applying fee updates.