Name   

Has the options ‘Open’ and ‘Check Exists’. Enter name of adjustment set in Expression column.

Add new item

Has the options ‘End of list’, ‘Insert before current’ and ‘Insert after current’. Using these options will determine where the new adjustment is placed.

Type

Adjustment type (e.g. Missed payment, override…)

Note: If you select an incorrect adjustment for the case type this will default to an incorrect type.

Value

Enter a value for the adjustment

    ■    Calculated PPI premium (based on fee per £100).Based on the Premium loan calculator, calculated PPI premium options will only calculate the monthly PPI premium not the single

    ■    Calculated PPI premium (inc. premium)

    ■    Previous adjustment value

    ■    Previous adjustment value * set value (specify)

    ■    Make a value negative

    ■    Make a value positive

    ■    Balance * set value (specify)

    ■    Total payment * set value (specify) = loan payment (Notional) * term in months * set value

    ■    RU78 refund (ALL)

    ■    RU78 refund (Exc. Loan)

    ■    RU78 refund (ALL Exc Int)

    ■    RU78 refund (Exc. Loan & Int)

    ■    Payment in period * set value (specify)

     o     calculates differences in months between From month an To month (ignores days)

     o     multiplies this value by the monthly payment value

     o     gets second payment as first normally includes uncollected interest

     o     multiplies the new value by the specified value in the wizard (should ideally be 1 or -1)

    ■    Last payment * set value

    ■    Last loan payment * set value

    ■    Last premium * set value

    ■    Period end interest balance = total interest applied to loan

    ■    Period end capital balance = last line of actual rework - Balance (period end)

    ■    Period end balance

    ■    Period end repay balance = total Net Payments

    ■    Period end premium balance = total Net Payments (Premium case)

DTA can also be used as a value (enter this in the value column).

Only use ‘Set’ or ‘Set and Enter’ as selecting ‘Enter’ does not display the dropdown options.

From date

From date for the adjustment, includes period, first payment, last adjustment and period + term from dates

To date

To date for adjustment, includes period and last adjustment to date

NOTE: When using ‘Last adjustment from date’ as an option you need to set this first otherwise you will get the same date as the from date.

Calc

Set which calculation this adjustment is for:

    ■    Specify value – Allows values / user variables.

    ■    Current calc

    ■    Current calc + 1

Description

Set an alternative description for the adjustment

Loan

Loan A / Loan B / ALL

Part

Set which part the adjustment applies to (Part A-X, All, User Variable)

Increase type

Simple % / Amount / Compound / Table % / Table % x 1.5 / Table % x 2 / Table % x 2.5 / Table % x 3

Increase amount

Amount to increase by or Table name

Increase period

Annual, Monthly, Quarterly and variants therein

Get average value

Returns an average value of the adjustment type selected – adjustments need to be saved first in a previous step.

Get sum

Returns the sum value of the adjustment type selected - adjustments need to be saved first in a previous step.

Get rows

Returns the number of the selected adjustment, if no adjustment selected returns the total number of all adjustments - adjustments need to be saved first in a previous step.

Find adjustment

Locate adjustment type within the set. You can find the first, last or next of a type of adjustment. A selection of methods to locate and move through the adjustment set are available.

Check adjustment

Checks if adjustment is not found. If not found wizard will perform the specified action.

Note. Check adjustment should be used after ‘Find adjustment’. Check adjustment will look at condition status if type not specified. If an adjustment is not found, ‘Not found - go to step’ option can be used to direct the wizard to another step or ‘Not found – go to label (forwards)/ (backwards)’ option can be used to direct the wizard to a set label.

If an adjustment is on the last row within an adjustment set,’Last row – go to step’ option can be used and will go to the step specified or or ‘Last row – go to label (forwards)/ (backwards)’ option can be used to direct the wizard to a set label.

.

Save adjustments

Save & Close, Save, Close, Save As & Close, Save As, Add To and Add To & Close. Add To & Close creates a copy of existing adjustments (if retrieved first via "Name" item). It is used for editing the existing adjustments, but also creating a copy of the existing ones to keep unedited. E.g. You could want to create another monthly payment with a new value (but same dates) as well as keeping the original

Clear adjustments

Select options to clear the adjustment set.  Please note, this item action should be used after the name of the adjustment set has been entered.   

Duplicate setup

This will repeat the whole step up to a maximum of 20 times (Include any open / save in steps before / after a duplicate step)

Align Data

Adjustments that have overlapping dates can be corrected

Remove current adjustment

Current adjustment selected will be removed

Remove duplicates

Removes all or named adjustment duplicates