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 Mature Lease Tracking module which automates the tracking process of maturing leases.
LeasePak Documentation Suite
©
by NetSol Technologies Inc. All rights reserved.
The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies 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 NetSol Technologies Inc. is prohibited.