Setting Up Rate Sheets for Loans

You can set up rate sheets for fixed-rate loans, floating-rate loans, and adjustable-rate loans on the Rate Sheet Set page.

1. Select Pricing > Rate Sheets from the menu.
2. Open the rate sheet set that you want to work with by selecting its name in the Rate Sheet Set Name column.
3. Update the Funding Date, if needed.
   This date determines the appropriate value of funds for a deposit. You can use the calendar selection or manually enter a date.
4. Update the Effective Date, if needed.
   This date represents when the current rate sheet goes into effect. You can use the calendar selection or manually enter a date.
5. Select Add.
   You can also select an existing rate sheet to modify from the list.
   The Add Rate Sheet dialog box opens.
6. Enter a Name.
7. Select Loan as the Type.
8. Select a Product.
9. Select Add.
10. Select a situation and follow the corresponding steps.

    Situation	Steps
    Adding Fixed-Rate Loan Rate Sheets	Select Fixed for the Rate Type. Select a Payment Type. Enter a percentage in the Target ROE field. Enter a percentage in the Initial % Fee field. Enter a dollar amount in the Initial Flat Fee field. Enter a dollar amount in the Annual Fee field.
    Adding Floating-Rate Loan Rate Sheets	Select Floating for the Rate Type. Select a Payment Type. Enter a percentage in the Target ROE field. Select an index option from the Index drop-down menu. Enter a percentage in the Initial % Fee field. Enter a dollar amount in the Initial Flat Fee field. Enter a dollar amount in the Annual Fee field.
    Adding Adjustable-Rate Loan Rate Sheets	Select Adjustable for the Rate Type. Select a Payment Type. Enter a number of months in the Initial Period field. Enter a number of months in the Adjustment Frequency field. Enter a percentage in the Target ROE field. Select an index option from the Index drop-down menu. Enter a percentage in the Spread to Index field. Enter a percentage in the Initial % Fee field. Enter a dollar amount in the Initial Flat Fee field. Enter a dollar amount in the Annual Fee field.

11. Enter Comments as needed.
12. Update the tier table as needed.

    You can edit the amounts in the Lower Tier column, and you can add or delete tier rows.

    You can update the Amortization and Expected Life from Manage Columns. Amortization terms are not needed for non-amortizing payment types.

13. Select Save when the tiers and term combinations are set.
    The remaining rates that are required to meet the product's target return on equity (ROE) calculations appear.