Valid Values Glossary

The table below lists the valid values for each of the abovementioned fields where a drop-down exists. LeaseAccelerator contains detailed logic and algorithms to validate and process information based on the specific values in these fields. LA will reject the imported data file IF the values entered are not in the drop-down.

Note: The valid values below are on the DATA tab in the Customer Workbooks.

Download a PDF version of the guide.

Tab	Field Name	Valid Values
Modification Summary	Commensurate Adjustment	Yes, No
Modification Summary	Remeasure ROU Basis	Liability, Asset
Schedule	Lease Type	FMV, FinLse-FixPO, FinLse-Put, First Amend, Full-Service, Gross, Lev-Debt, Lev-Equity, Loan/NSA, Municipal, Split-TRAC, Synthetic, TRAC, Triple-Net
Schedule	Frequency	Annual, Bi-Monthly, Monthly, Quarterly, Semi-Annual
Schedule	Repayment Mode	Advance, Arrears
Schedule	Payment Basis	Fixed, Floating, LRF
Schedule	Partial Building Flag	Yes, No
Details	Product Category	See Product Category List Below
Details	Units	Square Feet, Square Meters, Acres
Details	Utility Pricing Basis	Total, Usable, Rentable
EOT Options	Timing	EOT, Mid-Term
EOT Options	Option Type	Buyout, Other, Renewal, Return
EOT Options	Reasonably Certain EOT Option	Yes, No
EOT Options	Exercisable by Lessee	Yes, No
EOT Options	Utility Units	Square Feet, Square Meters, Acres
Step Payments	Payment Frequency	Annual, Bi-Monthly, Monthly, Quarterly, Semi-Annual
Category LRFs	Product Category	See Product Category List Below
Remove Reduce Event	Asset Event	Buyout, Renewal, Other, Return, ReduceScope

Product Category List

Agriculture and Forestry	Electronics	Mobile Shop Equipment (Soft Costs)	Stadium Suite
Aircraft and Related	Emergency Vehicles	Modular Building	Recreation
Automobiles	Energy Systems	Mold Tools	Restaurant Fixtures
Broadcast/Audiovisual	Food Processing	Office Equipment	Retail Fixtures
Building Improvement/Equipment	Furniture and Fixtures	Office Equipment (Soft Costs)	Semiconductor
Building Improvement/Equipment (Soft Costs)	Furniture and Fixtures (Soft Costs)	Oil and Gas	Software
Building/HVAC	Gaming	Other	Telecommunications
Buses	Laboratory Equipment	Packaging/Bottling	Telecommunications (Soft Costs)
Computers/Peripherals	Machine/Shop Equipment	Point of Sale	Telephone Systems
Networking	Power Tools	Power and Pipeline	Telephone Systems (Soft Costs)
Servers	Manufacturing/Fabricating	Power and Pipeline (Soft Costs)	Test and Measurement
Storage	Manufacturing/Fabricating (Soft Costs)	Printing/Publishing	Trailers
Supercomputer	Marine	Rail	Trucks
Supercomputer (Soft Costs)	Material Handling	Real Estate	Trucks (Soft Costs)
Computers/Peripherals (Soft Costs)	Material Handling (Soft Costs)	Billboards	Waste Remediation/Recycling
Construction	Medical	Building
Containers	Mining	Data Center
Durable Tooling	Mobile Shop Equipment	Land

Lease Type Definitions and Genre

Key:

EQ = Equipment
RE = Real Estate

The following table defines the Lease Types and the business rules applicable to determining each.

Lease Type	Lease Genre	Value in MDIW	Definition	Business Rule to Identify
Finance Lease - $1Out Mandatory Purchase	EQ	FinLse-Put	Lease which requires the Lessee to purchase the assets at the end of the term.	Any of the following: Title to assets automatically transfers to Lessee at the end of term Buyout Price = $1 Language similar to “Lessee is required to purchase assets”
Finance Lease – Fixed Purchase Option	EQ	FinLse-FixPO	Lease granting Lessee the option to purchase the assets at a fixed amount.	Any of the following: Option to Buy at a price of $$$
First Amendment Lease	EQ	First Amend	A lease which contains a first amendment clause. Used for Lessees who may opt to purchase equipment early. Typically includes a penalty for non-purchase or requires the Lessee to renew for a fixed number of months.
Full-Service Lease	RE	Full-Service	A lease where the Base Rent includes a baseline cost for CAMS and Other Rent charges, but lease allows landlord to pass through incremental charges or credits to reflect the actual cost of CAMS and Other Rent expenses.	Real Estate Lease where: CAMS charges listed CAMS benchmark cost identified Contains CAMS Billing language Contains CAMS expense Reconciliation language
Leveraged Lease Debt	EQ	Lev-Debt	A lease agreement that is partially financed by the Lessor through a third-party financial institution. In a leveraged lease, the lending company holds the title to the leased asset, while the lessor creates the agreement with the Lessee and collects the payment. The payments are then passed on to the lender.
Leveraged Lease Equity	EQ	Lev-Equity
Loan / Note & Security Agreement	EQ	Loan/NSA	This is not a lease but a financed purchase either as a loan or promissory note.
Modified Gross Lease	RE	Gross	A lease where the Base Rent includes all costs including CAMS and Other Rent; however, utilities may be separately identified as a cost where the landlord is allowed to pass through incremental charges or credits to reflect the actual Utility costs.	Real Estate lease where: Base Rent language exists Only Utility Cost Benchmark is identified Excess Utility cost pass through language Utility uses reconciliation language This is the default Lease Type for Real Estate
Municipal Lease Purchase	EQ	Municipal	A municipal or tax-exempt lease agreement allows a political subdivision to use annual revenues to make payments for any type of essential use equipment or facilities. While municipal leases are documented as a lease, they have characteristics similar to a loan. The Lessee owns the equipment at the end of the lease, and the lease can be paid off early. These financing agreements are structured as a lease to accommodate the fiscal funding restrictions of political subdivisions. In most cases, the obligation terminates if the Lessee fails to appropriate funds to make the renewal year's lease payments. Because of this provision, neither the lease nor the lease payments are considered debt (in most states).
Other Financial Product	EQ	Other
Split-TRAC Lease	EQ	Split-TRAC	A modified TRAC lease where the Lessor assumes part of the estimated residual value risk which may allow the Lessee to classify the transaction as an operating lease.	Includes a possible return fee such that the Lessee has limited responsibility for the fee
Synthetic Lease	EQ	Synthetic	A disguised loan. Treated as a loan for tax purposes and an operating lease (off-balance sheet financing) for accounting purposes. Relies on Lessee to exercise FMV purchase option or pay substantial penalty for non-renewal.
TRAC Lease	EQ	TRAC	Terminal Rental Adjustment Clause. A Lessee guaranteed residual value for vehicle leases (automobiles – trucks or trailers), the inclusion of which will not in and of itself disqualify the tax lease status of a tax-oriented vehicle lease.	Includes a possible return fee that is born solely by the Lessee
Triple-Net Lease	RE	Triple-Net	A lease where the Base Rent Rate excludes the full cost of CAMS and Other Rent expenses on a monthly basis.	Real Estate Lease where: Base Rent Rate excludes the full cost of CAMS and Other Rent expenses on a monthly basis CAMS and Other Rent pass through language
True/Operating Lease (FMV)	EQ	FMV	Lease granting the Lessee the option to purchase the assets at the FMV of the lease equipment at the option date. Option may be at the FMV or at a defined percentage of the FMV.	May include the following: True Lease Contains purchase option Contains language referencing Lessee ability to buyout the asset at a date. This is default lease type for non-Real Estate leases

Valid Values Glossary

Product Category List

Lease Type Definitions and Genre

Was this article helpful?