Navigation: Appendix A - Merge Field Descriptions (Loans) >
All P/I change fields are checked for a change, and any change is reported on the letter. The letter includes a summary of interest rate changes that have occurred since the last P/I change. This letter can only be generated if the Use Event Letter 40 field on the Rate Caps & Negative Amortization tab is checkmarked (Loans > Account Information > ARM Information screen in CIM GOLD), the Rate Change Frequency is not the same as the P/I Change Frequency, and you have requested the event letter by work order.
For example, if the next P/I change is on April 1, the last P/I change was April 1, and the interest rate does not change on April 1, the event letter will generate showing the next P/I change date and amount and all the rate changes since April 1.
If this letter is turned on, a new section of the Event Letter Report (FPSRP175) is created called "Account with Accrual Rate Change Only." See the Loan Reports manual for more information.
Merge Field |
Field Mnemonic/ Calculation |
Description |
---|---|---|
ARM 2ND NEXT P/I CHANGE DATE |
LNPIEF + |
Next P/I Change Date plus the P/I Change Frequency on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM 2ND NEXT RATE CHANGE DATE |
LNAMDT + |
Next Rate Change Date plus the Rate Change Frequency on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL INDEX 1 |
LNNDX1 |
Oldest index in Rate Table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE 1 |
LNANR1 |
Oldest accrual rate in Rate Table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE EFFECTIVE DATE 1 |
LNADT1 |
Oldest accrual rate effective date in Rate Table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL INDEX 2 |
LNNDX2 |
Index 2 in Rate Table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE 2 |
LNANR2 |
Accrual rate 2 in Rate Table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE EFFECTIVE DATE 2 |
LNADT2 |
Accrual rate 2 effective date in Rate Table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL INDEX 3 |
LNNDX3 |
Index 3 in Rate Table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE 3 |
LNANR3 |
Accrual rate 3 in Rate Table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE EFFECTIVE DATE 3 |
LNADT3 |
Accrual rate 3 effective date in Rate Table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL INDEX 4 |
LNNDX4 |
Index 4 in Rate Table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE 4 |
LNANR4 |
Accrual rate 4 in Rate Table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE EFFECTIVE DATE 4 |
LNADT4 |
Accrual rate 4 effective date in Rate Table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL INDEX 5 |
LNNDX5 |
Index 5 is in Rate Table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE 5 |
LNANR5 |
Accrual rate 5 in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE EFFECTIVE DATE 5 |
LNADT5 |
Accrual rate 5 effective date in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL INDEX 6 |
LNNDX6 |
Index 6 in rate table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE 6 |
LNANR6 |
Accrual rate 6 in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE EFFECTIVE DATE 6 |
LNADT6 |
Accrual rate 6 effective date in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL INDEX 7 |
LNNDX7 |
Index 7 in rate table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE 7 |
LNANR7 |
Accrual rate 7 in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE EFFECTIVE DATE 7 |
LNADT7 |
Accrual rate 7 effective date in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL INDEX 8 |
LNNDX8 |
Index 8 in rate table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE 8 |
LNANR8 |
Accrual rate 8 in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE EFFECTIVE DATE 8 |
LNADT8 |
Accrual rate 8 effective date in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL INDEX 9 |
LNNDX9 |
Index 9 in rate table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE 9 |
LNANR9 |
Accrual rate 9 in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE EFFECTIVE DATE 9 |
LNADT9 |
Accrual rate 9 effective date in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL INDEX 10 |
LNNDXA |
Index 10 in rate table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE 10 |
LNANRA |
Accrual rate 10 in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE EFFECTIVE DATE 10 |
LNADTA |
Accrual rate 10 effective date in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL INDEX 11 |
LNNDXB |
Index 11 in rate table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE 11 |
LNANRB |
Accrual rate 11 in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE EFFECTIVE DATE 11 |
LNADTB |
Accrual rate 11 effective date in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL INDEX 12 |
LNNDXC |
Index 12 in rate table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE 12 |
LNANRC |
Accrual rate 12 in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM ACCRUAL RATE EFFECTIVE DATE 12 |
LNADTC |
Accrual rate 12 effective date in table on the Loans > Account Information > ARM Information screen > ARM Rates & P/I Tables tab. |
ARM AMORTIZED P/I PAYMENT |
LNAPIC or LNPINX |
Amortized P/I field: The P/I payment required to fully amortize the loan. If this amount is zero, the amount in the Next P/I field (LNPINX) will be used. |
ARM AMORTIZED PRINCIPAL BALANCE |
AMTZ PRIN |
The principal balance on which the new adjusted payment is based. |
ARM BASE INDEX |
LNBINX |
Base index value used when calculating the new rate on the loan account when the Use this Base Index option is checked. |
ARM DAYS BEFORE RATE CHANGE |
LNAMAD |
Days Before Rate Change field: Days before the next accrual rate change date to calculate a new rate. |
ARM DIFF BETWEEN NXT CURRENT INDEX |
NEW INDEX- |
Difference between the next accrual index and current accrual index |
ARM DIFF BETWEEN NXT ORIGINAL RATE |
LNAMNA- |
Difference between the next accrual rate and the original rate |
ARM GRADUATED PMT INCREASE PERCENT |
LNAMGI |
Repay Percent field: The percentage the P/I payment that will increase each P/I change frequency. This field is obsolete. |
ARM INDEX PUBLISHING FREQUENCY |
RTPBFQ |
Frequency the index is published (e.g., weekly, daily). This information is entered on the Loans > System Setup Screens > Interest Rate Table screen. |
ARM INTEREST ACCRUAL RATE |
LNAMRT |
Current Rate field: The rate at which interest is accruing for this ARM loan. |
ARM INTEREST ONLY P/I PAYMENT |
LNIPIC |
Interest Only P/I field: The P/I payment required to satisfy the calculated interest. |
ARM INTEREST RATE POINTER |
LNAMPT |
Index Rate Pointer field: The accrual rate pointer that is tied to the rate index. |
ARM LENGTH OF RATE CAP PERIOD |
LNAMLP |
Length of Rate Cap Period field |
ARM NAME OF RATE INDEX |
RTCL34 |
Name of the index, such as LIBOR. This information is entered on the Loans > System Setup Screens > Interest Rate Table screen. |
ARM NEW INDEX |
LNAPIN |
Last Index Rate field |
ARM NEW INDEX WITH OFFSET |
LNAPIN+ |
Last Index Rate plus Interest Rate Margin |
ARM NEW P/I PAYMENT |
LNPINX |
Next P/I field: Newly calculated P/I payment. |
ARM NEW R1 PAYMENT |
Effective Reserve 1 Payment |
Reserve 1 payment effective with the new loan payment change. |
ARM NEW R2 PAYMENT |
Effective Reserve 2 Payment |
Reserve 2 payment effective with the new loan payment. |
ARM NEW SUBSIDY PAYMENT |
Effective Subsidy Payment |
The subsidy payment effective with the new loan payment. |
ARM NEW TOTAL PAYMENT |
NEW P/I+ |
New P/I payment plus new Reserve 1 payment plus new Reserve 2 payment minus new Subsidy payment. |
ARM NEXT INTEREST ACCRUAL RATE |
LNAMNA |
Next Rate field: Next accrual rate for this account. |
ARM NEXT RATE CHANGE DATE |
LNAMDT |
Next Rate Change Date field |
ARM OLD INDEX |
TRLG |
Old (prior) index |
ARM OLD P/I PAYMENT |
LNPICN |
Current P/I payment in effect prior to the new payment change. |
ARM OLD R1 PAYMENT |
Effective Reserve 1 Payment |
Reserve 1 payment in effect prior to the new loan payment change. |
ARM OLD R2 PAYMENT |
Effective Reserve 2 Payment |
Reserve 2 payment in effect prior to the new loan payment change |
ARM OLD SUBSIDY PAYMENT |
Effective Subsidy |
Subsidy payment in effect prior to the new loan payment change. |
ARM OLD TOTAL PAYMENT |
OLD P/I + |
Old P/I loan payment plus old Reserve 1 payment plus old Reserve 2 payment minus old Subsidy payment. |
ARM ORIGINAL RATE |
LNAMOA |
Original Rate field |
ARM P/I PAYMENT BASED ON INC LMT |
LNPICN * |
Current P/I payment multiplied by the P/I Increase Limit |
ARM P/I PAYMENT CHANGE COUNTER |
LNAMCC |
P/I Change Counter field: Number of times the system calculates the next P/I payment automatically. |
ARM P/I PAYMENT CHANGE DATE |
LNPIEF |
Next P/I Change Date field: The date that the next P/I payment will replace the current P/I payment. |
ARM P/I PAYMENT CHANGE FREQUENCY |
LNAMPC |
P/I Change Frequency field: Number of months that should occur between payment changes. |
ARM P/I PAYMENT INCREASE LIMIT |
LNAMPL |
P/I Increase Limit field: The percentage the P/I payment can increase with a payment change. |
ARM PAYMENT RATE |
LNRATE |
Payment Rate field |
ARM RATE AT PERIOD START |
LNAMSY |
Rate at Period Start field: Interest rate at the start of the rate cap period. |
ARM RATE CHANGE FREQUENCY |
LNAMFQ |
Rate Change Frequency field: Number of months that should occur between rate changes. |
ARM RATE CHANGE MINIMUM |
LNAMCM |
Rate Change Minimum field: The minimum percentage by which the loan rate can be changed |
ARM REMAINING TERM |
LNMATD- |
Month’s difference between the maturity date and next accrual rate change date. For bi-weekly loans, take the term in months divided by 12 multiplied by 26 to get the number of payments. Subtract the installment from the number of payments to get remaining payments. Take remaining payments divided by 26 then multiply by 12 to get the remaining term in months. |
ARM START OF ACCRUAL PERIOD |
LNAMPD |
Start of Accrual Period field: Starting date of the current rate cap period. |
ARM SOURCE OF RATE INDEX |
RTPBDS |
Publishing source of the index rate (e.g., Wall Street Journal). This information is entered on the Loans > System Setup Screens > Interest Rate Table screen. |
DEFERRED INTEREST |
LNDEFI |
Deferred Interest field |
PREPAYMENT PENALTY END DATE |
Calculated field |
End date of the prepayment penalty |
YTD DEFERRED INTEREST |
LNYTDD |
Year-to-Date Deferred Interest Paid field |
PROJECTED PMT PRINCIPAL PORTION |
Calculated |
Principal portion of the projected new payment. |
PROJECTED PMT INTEREST PORTION |
Calculated |
Interest portion of the projected new payment. |
See also: