1. Lease Origination User Guide
  2. Funding
  3. Escrow Analysis Tab

8.19 Escrow Analysis Tab

If escrow is allowed for the selected instrument, the Escrow Analysis link is available on the Contract drop-down link. This screen enables you to view and perform the initial escrow analysis. When you are satisfied with the analysis, complete the Approval Dt field in the Approval section and save your entry.

The escrow payment for the Lease account starts on the 1st date of the Lease payment month. The disbursement happens on the 10th of the month (as per the disbursement rules). The escrow analysis lasts for a year (12 months) irrespective of the Lease term.

You can perform multiple analysis; however, the Escrow Analysis screen only records the last analysis performed. No record of any earlier analysis is currently available.

To complete the Escrow Analysis screen
  1. Open the Funding screen and load the application you want to work with.
  2. On the Funding screen, Click Escrow Analysis tab.

    Figure 8-19 Escrow Analysis


    Description of Figure 8-19 follows
    Description of "Figure 8-19 Escrow Analysis"

  3. In the Escrow Analysis section, view or enter the following information:

    Table 8-27 Escrow Analysis section

    Field View
    Escrow The escrow item.
    Disbursement Rule The escrow disbursement rule.
    Yearly Amt The escrow disbursement yearly amount.
  4. Click Analyze.
  5. Information on the Analysis Details screen is based on expected cash flow from contract and escrow disbursement setup. Payments received appear before escrow disbursement in any given month. Click View in Escrow Analysis section.
  6. In the following section, enter, view, or edit the following information:

    Table 8-28 Escrow Analysis

    Field View
    Parameters section
    Date The date.
    From Dt The FROM date for the escrow activity.
    To Dt The TO date for the escrow activity.
    Opening Bal (Act) The opening balance actual amount.
    Opening Bal (Est)

    The opening balance estimated amount.

    Calculation: cushion amount + low required balance

    Cushion Type The cushion type.
    Cushion Value The cushion value.
    Cushion Amt

    The cushion amount.

    Calculation: as per the shortage /cushion Rule maintenance

    Results section
    Std Pmt Amt The standard payment amount.
    Escrow Pmt Amt (+)

    The escrow payment amount.

    Calculation: Yearly Amount/12.

    Spread Pmt Amt (+)

    The spread payment amount.

    Calculation: Surplus amount / 12

    Other Pmt Amt (+) The other payment amount.
    New Pmt Amt =

    The new payment amount.

    Calculation: standard payment amount + escrow payment amount + spread payment amount + other payment amount

    Surplus section
    Surplus /<Shortage Amt>

    The surplus shortage amount.

    Calculation: escrow account balance - opening balance

    Refund Amt The refund amount.
  7. Click View in the Analysis Details section.
  8. On the Analysis Details sub screen, view the following information:

    Table 8-29 Analysis Details

    Field View
    Txn Dt The transaction date.
    Transaction The escrow transaction.
    Vendor The vendor name.
    Txn Amt The amount of the transaction.
    Balance Amt (Est) The estimated amount of balance.
    Balance Amt (Act) The actual amount of balance.

    Information on the Analysis Details sub screen is based on expected cash flow from contract and escrow disbursement setup. Payments received appear before escrow disbursement in any given month.

  9. If you want to re-analyze the escrow analysis, change the escrow information on the Contract link’s screen and sub screens.

    If you want to approve the escrow analysis, complete the following information fields on the Approval section:

    Table 8-30 Approval

    Field View
    Approval section
    Approval Dt The approval date.
    Approved By The person who approved the Lease.
  10. Click Save on the Funding screen.

Parent topic: Funding