Certificate Interest Calculation

Shares and Certificates Shares/Certificates Certificate Interest Calculation

The Certificate Interest Calculation feature in the FLEX system allows users to perform “What If?” scenarios for projecting certificate interest. This tool is designed to assist in understanding potential interest earnings based on various input parameters.

Accessing Certificate Interest Calculation

To access the Certificate Interest Calculation tool:

  • Navigate to the FLEX Main Menu.
  • Select Certificates.
  • From the sub-menu, choose Interest Calculation.
    (Refer to Image 1 in the original document for a visual representation of the menu path.)

Understanding the Interface

The “Certificate Interest Calculation” screen presents several parameters for input, along with output fields for the calculated interest and balance.

Parameters Section

This section allows you to input the variables for your interest projection.

  • Amount:
    • Description: The principal amount of the certificate.
    • Example: 10,000.00
  • Term Code:
    • Description: Defines the unit of the term.
    • Options: Year, (other options may be available via dropdown).
    • Example: Year
  • Number of Terms:
    • Description: The duration of the certificate based on the selected Term Code.
    • Example: 5 (e.g., 5 Years if Term Code is Year)
  • Frequency:
    • Description: How often the interest is compounded or paid.
    • Options: Monthly, (other options may be available via dropdown).
    • Example: Monthly
  • Interest Rate:
    • Description: The annual interest rate applied to the certificate.
    • Example: 2.500%
  • Daily Compounding:
    • Description: Indicates whether interest is compounded daily.
    • Options: Yes / No (radio buttons).
    • Example: No
  • Effective Date:
    • Description: The start date for the interest calculation.
    • Format: MM/DD/YYYY
    • Example: 3/29/2019
    • Note: A calendar icon is typically available next to this field for date selection.
  • Days In Year:
    • Description: The number of days used in the annual interest calculation.
    • Options: 365, (other options like 360 may be available via dropdown).
    • Example: 365

Output Fields

These fields display the results of the interest calculation.

  • Interest Due:
    • Description: The total projected interest earned over the specified term.
    • Example: 1,331.55
  • Balance:
    • Description: The projected final balance of the certificate (Principal Amount + Interest Due).
    • Example: 11,331.55

Action Buttons

  • Calculate Interest:
    • Function: Initiates the interest calculation based on the parameters entered.
    • Action: Click this button after entering all desired projected information.
  • Reset to Defaults:
    • Function: Clears all entered parameters and resets them to their default values.

How to Use for “What If?” Scenarios

  1. Input Initial Parameters: Enter the desired Amount, Term Code, Number of Terms, Frequency, Interest Rate, Daily Compounding preference, Effective Date, and Days In Year.
  2. Calculate: Click the Calculate Interest button.
  3. Review Results: Observe the Interest Due and Balance fields to see the projected outcome.
  4. Adjust and Recalculate: To perform a “What If?” scenario, modify one or more parameters (e.g., change the Interest Rate or Number of Terms) and click Calculate Interest again to see how the changes affect the projected interest and balance.
  5. Reset (Optional): If you wish to start a new calculation from scratch, click Reset to Defaults.

This tool provides a quick and efficient way to model various certificate interest scenarios, aiding in financial planning and decision-making within the FLEX system.