Projected Maturing Leases [R0911]

 

The Projected Maturing Leases report [R0911] lists leases maturing on or prior to a selected date. The report may be used as a marketing tool by allowing termination options to be negotiated with the lessee prior to maturity. The report is organized by Portfolio, Company, Region, Office.

The report may be accessed through the Operational report menu [R09] and may be selected interactively for:

• All leases
• All customers and groups
• A portfolio
• A company
• A region
• An office
• A lease
• A customer
• A customer/group
• Leases maturing on or before an entered month/year

 

Projected Maturing Leases

• ALL
  Enter X to report on all leases. If ALL is selected, leases that belong to a customer or to a group are also reported. However, these leases are sorted by their portfolio, company, region, office, and lease numbers, rather than their customer or group numbers.
  
  
• ALL CUST
  Enter X to report on all customers. If ALL CUST is selected, only leases that belong to a customer or to a group are reported (sorted by customer and group).

• PORT
  Enter the number of the portfolio upon which to report. Leave blank if reporting across portfolios.
  
  
• COMP
  Enter the number of the company upon which to report. Leave blank if reporting across companies.
  
  
• REGN
  Enter the number of the region upon which to report. Leave blank if reporting across regions.

• OFFIC
  Enter the number of the office upon which to report. Leave blank if reporting across offices.

• LEASE
  Enter the number of the specific lease upon which to report.

• CUST
  Enter the number of the customer upon which to report. CUST may not be entered if a portfolio, company, region, office, or lease number is entered. CUST must be entered if GROUP is entered.

• GROUP
  Enter the number of the group upon which to report. GROUP may not be entered if a portfolio, company, region, office, or lease number is entered.
  
  
• ENDING MONTH/YEAR
  Enter the ending month and year in MM/YY form. All leases scheduled to mature on or before the date entered are included in the report.

 

Projected Maturing Leases

The Projected Maturing Lease report [R0911] reports at the lease level and provides the following detail for all leases maturing on or prior to the date entered:

• LEASE
  
  
• LESSEE NAME
  
  
• LEASE DATE
  
  
• LEASE TERM
  
  
• TERMINTN DATE
  The maturity date of the lease is displayed.

• ACTIVITY DATE
  The date the activity status was changed to its current value is displayed.

• ACTIVITY STAT
  The activity status code (e.g., ANOR = active normal, NMAT = active matured, AREN = active renegotiated, AREP = active assigned for repossession) of the lease is displayed. Refer to the Status Codes document for a list of lease activity status codes and their meanings.

• RESIDUAL
  The estimated market value of the asset at lease maturity is displayed.

• ESTIMATED PAYOFF
  The estimated payoff (as of the date to which the lease is currently accrued) is displayed. The payoff method is determined by the payoff method code on the lease form for each lease.

  If the payoff amount cannot be calculated, an asterisk is displayed. For example, the payoff amount cannot be calculated if the payoff method entered on the lease form is invalid for the lease type (e.g., OPR is invalid for non-operating leases).

• TIMES DELNQ
  The total number of times the lease has been delinquent over its life is displayed.

• DAYS MATUR
  The number of days from the current date to lease maturity is displayed. A negative number indicates that the lease has already matured.

• COMMENTS
  A blank area for the user's written comments is provided.
  
  
• TOTALS/GRAND TOTALS
  Page totals are displayed for each portfolio, company, region, and office for:
  
  
  • The total number of leases
  • The number of active leases
  • The number of renegotiated leases
  • The number of extended leases
  • The number of leases with a payment extension
  • The number of active leases assigned for repossession
  • The total number of active matured leases
  • The number of active matured leases 30 days delinquent
  • The number of active matured leases 60 days delinquent
  • The number of active matured leases 90 days delinquent
  • The number of active matured leases 91+ days delinquent
  • The residual
  • The estimated payoff

  
  Note: The ending days 30, 60, and 90 are customized values, there is a total of 6 delinquency categories. Refer to the DELINQUENCY CATEGORY BOUNDARIES parameters on the third screen of the Miscellaneous Customizations option of the Portfolio update [U0212].

 

Additional Information

Portfolio and grand totals are shown for Projected Terminations Forecast. This section provides a forecast of the le&ases due to mature within the 12 months following the month/year requested initially by the user. This information is displayed for each individual month.

Placement of the lease in delinquency category 1, 2, 3, or 4 (e.g., 1-30, 31- 60, 61-90, 91+) is based on the number of days between the payment due date and the current date, not upon the number of months delinquent. Consequently, a lease may be placed in a more delinquent category than expected. For example, assume a lease is delinquent for the July 1 and

August 1 payments. On August 31, the lessee is delinquent 61 days and is placed in category 3 (61-90 days), even though only two months are actually delinquent.

A lease is recorded in the renegotiated leases or active leases assigned for repossession categories based upon its lease activity status (AREN or AREP, respectively). The lease activity status may be changed to these statuses through the Master Financial update [U0202].

LeasePak offers an optional Maturing Lease module which automates the tracking process of maturing leases.

 

LeasePak  Reference Guide

©  by McCue Systems Incorporated. All rights reserved.

The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.