This chapter provides an overview of leased assets, lists prerequisites, and discusses how to:
Define payment schedules.
Add or update capital and operating leases.
Create lease expense schedules.
Transfer operating leases.
Retire or reinstate leases.
Generate lease reports.
Asset Management incorporates full lease management functionality, including calculating and printing lease payment schedules, calculating leased asset revenues, and verifying leases as operating or capital leases, in accordance with the United States Financial Accounting Standards Board (FASB) Statement 13. It also provides the ability to define step leases.
In Asset Management, you can retire and reinstate leased assets and track interim payments.
This section discusses:
Capital and operating leases.
Step leases.
Note. Your transactions are maintained with multiple currencies if you use them in conjunction with leased assets.
There are two basic types of leases: capital leases and operating leases.
A capital lease is treated as a financial asset.
It has a lease term and lease payment amount. The lease is carried on the balance sheet and is periodically depreciated.
An operating lease is treated as a nonfinancial asset to which no cost information is associated. It is normally expensed and can include rent and monthly payments that are expensed periodically.
Asset Management uses the lease classification rules for capital and operating leases as proscribed by the country requirements that were established during the setup of book location. For example, in the United States, leased assets are defined and governed by Financial Accounting Standards Board (FASB) Statement 13.
Note. The United States FASB 13 lease classification rules apply to all countries unless otherwise noted. For example, in Germany, the threshold for capitalization is 90 percent of the leased asset's economic life, as compared to 75 percent under the United States' generally accepted accounting practices. In Canada, the classification of capital or operating leases is the same as that defined in the United States FASB 13. Asset Management supports the United States, Germany, Canada, and Australia for least type verification.
A step lease features variable payment amounts and variable timing over the term of the lease.
Examples of step leases include:
Step-down leases with decreasing or declining lease payments.
Step-up leases with increasingly larger lease payments during the lease term.
Skip-payment leases in which payments are not required during certain periods.
This table provides an example of a step-down lease schedule:
Number of Terms |
Frequency |
Payment Amount |
6 |
Monthly |
$400 |
18 |
Monthly |
$350 |
This table provides an example of a quarterly step-lease payment schedule. It is suggested that you use three payment schedules with due dates as shown.
Schedule |
Due Dates |
Schedule 1 |
January, April, July, October |
Schedule 2 |
February, May, August, November |
Schedule 3 |
March, June, September, December |
For an annual step-lease payment schedule, it is suggested that you use 12 payment schedules, with one schedule for each of the 12 months as the payment due date.
This section discusses how to add or modify payments schedules for leases.
Before you can add leased assets to your system, you must define at least one payment schedule to indicate when a lease starts and ends. Leases can share the same payment schedule ID.
Page Name |
Object Name |
Navigation |
Usage |
LEASE_SCH_ID |
Set Up Financials/Supply Chain, Product Related, Asset Management, Payment Schedules |
Add or modify payment schedules for leases. |
Access the Payment Schedules page.
Complete the information about the begin date, end date, lease term, and payment frequency.
Number of Payments Per Year |
Enter a value to determine the number of lease payments for the lease schedule. |
End of Month Due Date |
Select to always schedule payment on the last day of the month. |
Populate |
After completing the fields about the payment schedule, click the Populatebutton to automatically populate the Payment Datecolumn fields. |
This section discusses how to:
Enter basic information about the lease and lease terms.
(Optional) Enter information about cost, ChartFields, and depreciation.
(Optional) View or update a step-lease payment schedule.
View or update a lease payment schedule.
Page Name |
Object Name |
Navigation |
Usage |
ASSET_LEASE_01 |
Asset Management, Asset Transactions, Leased Assets, Express Add |
Create a capital lease or an operating lease. |
|
ASSET_LEASE_01 |
Asset Management, Asset Transactions, Leased Assets, Update Lease Information |
Update a capital lease or an operating lease. |
|
ASSET_LEASE_02 |
Asset Management, Asset Transactions, Leased Assets, Express Add, Cost |
Enter cost, ChartField, and depreciation data for a leased asset. |
|
ASSET_LEASE_02 |
Asset Management, Asset Transactions, Leased Assets, Update Lease Information, Cost |
Update cost, ChartField, and depreciation data for a leased asset. |
|
ASSSET_LEASE_05 |
Asset Management, Asset Transactions, Leased Assets, Express Add, Step Lease Payment |
Enter a step-lease payment schedule. |
|
ASSET_LEASE_05 |
Asset Management, Asset Transactions, Leased Assets, Update Lease Information, Step Lease Payment |
Update a step-lease payment schedule. |
|
ASSET_LEASE_03 |
Asset Management, Asset Transactions, Leased Assets, Express Add, Payment Schedule |
Create or view lease payment schedules. |
|
ASSET_LEASE_03 |
Asset Management, Asset Transactions, Leased Assets, Update Lease Information, Payment Schedule |
Update lease payment schedules. |
|
ASSET_LEASE_06U |
Asset Management, Asset Transactions, Leased Assets, Update Lease Information, Operating ChartFields |
Update operating lease ChartField information. ASSET_LEASE_06 and ASSET_LEASE_06U are used to allocate operating lease payments to a particular set of chartfields. |
Access the Express Add - Definition page.
Lease IDandDescription |
Select from the available lease IDs assign a new ID for this business unit and add a description of the lease.Description is required only if a Lease ID has been assigned. |
Vendor IDanfVendor Contact |
Select the Vendor ID from the list of available vendors for this asset and enter contact information. Vendor ID is required if Lease ID is assigned. |
Responsibility |
Enter the name of the person who is responsible for this leased asset. Required if Lease ID is entered. |
Acceptance Date |
Indicates the date that the lease contract is accepted (signed and returned to the lessor). If you complete the Interim Rent (Monthly) field in the Lease Term group box, you must enter an acceptance date that is earlier than the commencement date of the lease. Interim rent starts on the acceptance date and ends on the commencement date. You enter the amount of the interim rent in the Interim Rent (Monthly) field. |
Receipt Date |
Enter the date the leased asset is received. This is an information-only date fields for reporting purposes. |
Lease End Date |
Enter the date the leased asset is received. Lease End Date becomes required when a Lease ID is entered. This date is used for the Lease End Date report. |
Display Alert Days |
Enter the number of days in advance to receive the Lease End Date pagelet based on the Lease End Date. |
Commence Date and Expiration Date |
These fields represent the first and last lease payment date (regardless of interim rent), and appear only after you save the page. |
Inception Date |
When viewing this page in Update/Display mode, this field display. The date displayed is the date of the original transaction. |
Comment |
Enter any comments to be noted for this leased asset. |
Display Alert Days |
The field Display Alert Days displays only if IT Asset Management is installed. |
Note. If LEASE is entered and ITAM is installed then Description, Lease End Date, Vendor Id and Responsibility are required fields.
Lease Term |
Enter the number of periods in this lease. |
Estimated Life |
The number of periods that you entered in Lease Term field appears by default. You can change this value. |
Interest Rate (%) (interest rate percentage) |
Enter the approximate percentage of profit the lessor gains by leasing the asset to you. This number must be an annual interest rate percentage in whole numbers. |
Borrowing Rate (%) |
Enter the interest rate that you would have incurred at the inception of the lease if you had borrowed the necessary funds to purchase the leased asset. This number must be an annual interest rate percentage in whole numbers. |
Payment Schedule ID |
If you want the system to define a lease payment schedule, enter a payment schedule ID. Capital leases must have a payment schedule ID. The values that you can select are set up on the Payment Schedule page when you specify the payment frequency and number of periods. |
Enter the fair market value. The system uses the fair market value to verify the lease type. The system calculates the capitalized lease amount using the lesser of the Present value of Lease Payments and Fair Market Value field values. If the present value of lease payments is less than the fair market value, the capitalized lease amount equals the present value of the MLP. If the fair market value is less than the present value of lease payments, the capitalized lease amount equals the fair market value. You might want to change the interest rate so that the net present value equals the fair market value. If you do not enter a fair market value, the capitalized lease amount equals the present value of the MLP. |
|
Calculates depreciation based on the amount of the residual value of the leased asset that is guaranteed by the lessee to the lessor and considered as part of the minimum lease payments. |
|
BPO (bargain purchase option) |
Select if this lease includes a bargain purchase option, which represents a payment by the lessee to the lessor at the end of the lease term, allowing the lessee to obtain title to the leased property. |
BRO (bargain renewal option) |
Select if this lease includes a bargain renewal option, which requires a payment if the lease agreement grants the lessee the right to renew or extend the lease. If the agreement specifies that the lease must be renewed or extended, a penalty might be required for failure to renew. |
Transfer Ownership end lease |
Check if there is an ownership transfer of the asset at the end of the lease period. |
Step lease |
Select if the lease is a step lease. A step lease features variable payment amounts and/or variable timing over the term of the lease. |
Minimum Rental Payment (MRP) |
Enter the minimum rental payment. This field is not required for step leases. Note. You must either enter a minimum rental payment here or complete the cost information on the Cost page. Otherwise, the system cannot calculate the lease payment schedule. |
Display a minimum lease payment.
|
|
Present Value Lease Payments |
Displays the present value of the lease payments for a step lease. The system uses two formulas to determine the present value of the total payment for a step lease.
|
The example illustrates the calculations using an interest rate of 7.2 percent.
Number of Terms |
Frequency |
Payment Amount |
6 |
Monthly |
400 USD |
18 |
Monthly |
350 USD |
PV1 equals Present value of the first payment in the schedule:
400 USD × ([ 1 - (1 + 0.01) ^ -6 ] ÷ (0.01) ) = 2,350.40 USD
PV2 equals Present value of the second payment in the schedule:
[350 USD × ([ 1 - (1 + 0.01) ^ -18 ] / (0.01) )] × (1 ÷ 1.01 ^ 6) = 5,744.88 USD
Present value of the total cash flow equals: 2,350.40 + 5,744.88 = 8,095.28 USD
Note. The lease term during the renewal period is considered part of the overall lease term.
Enter the cost. The system uses the following method to calculate lease payments: Capitalized Lease Amount - Prior Obligation Reduction = Residual Capitalized Lease Amount Residual Lease Amount × (Annual Implicit Interest Rate / Number of Periods per Year) = Interest Expense per Period Interest Expense per Payment + Obligation Reduction = MRP |
For example, this table illustrate a full payment schedule for a simple capital leased asset with a capitalized amount of 10,500 USD, an interest rate of 7 percent, a monthly payment of 908.53 USD, and 12 periods per year:
Period |
Residual Capitalized Lease Amount in USD |
Obligation Reduction |
Interest Expense |
Payment in USD |
1 |
10,500.00 |
847.2800562 |
61.24994377 |
908.53 |
2 |
9,652.71 |
852.2225232 |
56.30747678 |
908.53 |
3 |
8,800.49 |
857.1938213 |
51.33617873 |
908.53 |
4 |
7,943.29 |
862.1941186 |
46.33588144 |
908.53 |
5 |
7,081.10 |
867.2235843 |
41.30641574 |
908.53 |
6 |
6,213.88 |
872.2823885 |
36.2476115 |
908.53 |
7 |
5,341.59 |
877.3707024 |
31.15929757 |
908.53 |
8 |
4,464.22 |
882.4886982 |
26.0413018 |
908.53 |
9 |
3,581.73 |
887.6365489 |
20.89345107 |
908.53 |
10 |
2,694.10 |
892.8144288 |
15.7155712 |
908.53 |
11 |
1,801.28 |
898.022513 |
10.50748703 |
908.53 |
12 |
903.26 |
903.2609776 |
5.26902237 |
908.53 |
Interim Rent (Monthly) |
Enter the amount of monthly interim rent for a capital or operating lease. Interim rent is common for quarterly leases. Interim rent starts on the acceptance date and ends on the commencement date of the lease. Once the lease officially begins, the normal rental payment amount is tracked by the lease payment schedule. Asset Management prorates the first month of interim rent. You can see interim rent payments on the Express Add - Payment Schedule page (ASSET_LEASE_03). Select Capitalize Interim Rent if you want to include these interim payments as part of your asset cost. Note. You must post journal entries for interim rent each month by running the Depreciation Close process (AM_DPCLOSE). |
Capitalize Interim Rent |
Select this check box to capitalize. When selected, the interim rent is added to the cost of the leased asset. |
Calculate |
Click to have the system calculate the lease payment schedule. Before the system can calculate the lease payment schedule, you must have:
|
Select a payment type: Advance or Arrears. You can use either type for both capital leases and operating leases. More details on these two payment types are provided in this table:
Calculation |
Advance Payment Type |
Arrears Payment Type |
Present Value Factor |
Total payment terms for present value factor excludes the term of the advance (or first) payment. |
Total payment terms for present value factor equal the total terms of the lease. |
Present Value of Minimum Lease Payments |
Equals: (Present Value Factor × Periodic Payment Amount) + Advance payment. |
Equals: Present Value Factor × Periodic Payment Amount. |
Amortization Schedule |
Period interest expense equals: Capitalized Amount × the period interest rate. The Capitalized Amount used for the first period of the payment excludes the advance payment amount. |
Period interest expense equals: Capitalized Amount × the period interest rate. |
Advance |
Select if an asset is leased with the first payment that is due before the lease begins. For advance payments, the interest expense is not calculated. If the present value is calculated on a lease with 12 monthly payments of 100.00 USD and an interest rate of seven percent, then the calculated present value factor is 10.6254. Calculated present value = 100 USD + 10.6254 × 100 = 1,162.54 USD |
Arrears |
An arrears payment type means that an asset is leased with the payment due at the end of the period. This is the lease payment type by default. If the present value is calculated on a lease with 12 monthly payments of 100.00 USD and an interest rate of seven percent, then the calculated present value factor is 11.5571. Calculated present value = 11.5571 × 100 = 1,155.71 USD |
When you select the lease type, you can verify that you have selected the correct lease type for a country. If you do not select either the Capital or the Operating options, the system selects the lease type for you. The system can verify the lease types for the U.S., Canada, Germany, and Australia. Canada uses the same criteria as the U.S. for classifying capital and operating leases. Germany uses a higher threshold for the lease term (90 percent instead of 75 percent).
Note. You cannot change a lease type from capital to operating or from operating to capital. If you must change the lease type, you must first retire the leased asset and then reenter the lease with the appropriate lease type.
Capital |
Select if the lease is a capital lease. According to FASB 13, a capital lease must meet one of the following criteria:
|
Operating |
Select if the lease is an operating lease. |
Verify |
Click this button to verify if the lease meets the criteria for a capital lease or an operating lease. If the lease type meets the criteria, the system displays a message confirming that the criteria for FASB Statement 13 has been met. If you do not select the Capital or Operating option before clicking the Verify button, the system looks at the information that you have entered on this page about the lease, including the country code, and selects the lease type for that country. Note. This verification test is disabled for leased assets that use an Indian business unit; designation of capital or operating leases is manual for assets in India. See (IND) Using Asset Management Options to Meet Indian Requirements. |
Access the Cost page.
If you did not enter a minimum rental payment (MRP) on the Definition (ASSET_LEASE-01) page, you must complete the cost information on this page.
The system uses the cost information on this page to calculate the lease payment schedule. Use the Cost, Chartfields, and Depreciation tabs to enter more details. Because the ChartFields are effective-dated, you can use them to track transfers.
Note. If you are working with a step lease, you do not have to enter any information on this page.
Access the Step Lease Payment page.
If you checked the Step lease check box on the Definition (ASSET_LEASE-01) page, you can use this page to change payment information.
Enter a line number, enter the lease term (number of periods), select a payment frequency, and enter a payment amount. For example, you could define a step lease that consists of six monthly payments of 400.00 JPY followed by 18 monthly payments of 350 JPY.
If you are defining a skip payment, enter a payment frequency, the number of lease terms, and a payment amount of zero (0.00).
Note. The line numbers must be in sequential order. For example, if you update a lease schedule and need to insert a row between lines 1 and 2, you can use a line number such as 1.2.
After you are done working with this page, you must return to the Definition (ASSET_LEASE-01) page and click the Calculate button to generate the lease payment schedule.
Access the Express Add - Payment Schedule page.
The system calculates the payment schedule on this page when you click the Calculate button on the Express Add - Definition page.
You can update the information on this page as needed.
Note. In case of capitalizing the interim rent, payments are noted with a C rather than I next to the payment line. You can change this designation by modifying message number 8015,37, using the PeopleTools Message Catalog.
If you elect to process periodic depreciation accounting entries, the system creates the journal entries that are shown in the following table:
Action |
Debits |
Credits |
Add |
|
|
Adjust |
|
|
Transfer In |
|
AD Accumulated Depreciation |
Transfer Out |
AD Accumulated Depreciation |
|
Retire |
|
|
This section discusses how to create lease expense schedules by running the Lease Expense Schedule process.
You must run this process:
After setting up a step lease.
After adjusting transactions in a step lease.
Before running the depreciation close process.
Note. The purpose of running the lease expense schedule process is to prorate payment and interest expenses so that the proper amounts
are sent to the general ledger (GL) according to the FASB. You must run this process for all leases that have non-monthly
payment schedules.
AMLSESCH reads PS_LEASE_SCHEDULE and creates PS_LEASE_SCHED2, which contains all the step-lease non-monthly payment information.
AM_DP_CLOS reads PS_LEASE_SCHED2 (through PS_LEASE_CHART3_vw) to distribute the payment and interest expenses to the GL.
The Lease Expense Schedule process spreads non-monthly lease payments (such as quarterly payments) throughout the year, dividing them into monthly amounts on the lease expense schedule. The results are different for capital leases and operating leases:
For operating leases, the lease expense schedule allocates non-monthly payments to monthly amounts.
For capital leases, the lease expense schedule allocates non-monthly interest expense to monthly amounts, and the payment amount is fully allocated on the date that the payment is due.
The following example uses an arrears type lease for a quarterly payment:
Payment Date |
Payment Amount |
Interest Expense |
06/01/1998 |
300 |
33 |
The lease expense schedule allocates the payments as shown:
Payment Date |
Payment Amount |
Interest Expense |
04/01/1998 |
0.00 |
11 |
05/01/1998 |
0.00 |
11 |
06/01/1998 |
300 |
11 |
If the general ledger period is closed, the allocation is carried forward to the next open period.
Note. Operating leases do not have interest expense on the payment schedule.
Page Name |
Object Name |
Navigation |
Usage |
Lease Expense Schedule |
LEASE_SCHED2_RQST |
Asset Management, Asset Transactions, Leased Assets, Create Expense Schedule |
Run the lease expense schedule process. |
Access the Lease Expense Schedule page.
Select Open Trans Range (select open transaction range) |
If you select this option, use the From Open Trans and To Open Transfields to select a range of transaction values. |
Select Asset Range |
If you select this option, use the From Asset and To Assetfields to select the asset range. |
This section describes how to transfer an operating lease.
Page Name |
Object Name |
Navigation |
Usage |
Operating Lease Chartfields |
LEASE_OPER_TFR_01 |
Asset Management, Asset Transactions, Leased Assets, Transfer Operating Lease |
Transfer an operating lease, for example, from one department to another. |
Access the Operating Lease Chartfields page.
This page displays the current ChartFields for the lease.
Use the New Chartfields section to change the Oper Unit(operating unit), Fund Code, Department, Program, Class Field, Budget Reference,Product, Project,and Category. The Category field is required for an operating lease.
Click the Edit Trans Dates button to change the transaction date.
Leased assets are retired or retired and reinstated using the same processes as all other assets. Review those sections of this PeopleBook for more information.
See Also
Asset Management has several reports that you can use to view information about leases that is required to satisfy generally accepted accounting principals and to comply with FASB 13. You can use the lease reports provided to view when a lease expires, create an annual footnote disclosure report, view summary or detail information about a specific lease, or view a lease amortization schedule.
You may also review operating leases.
You must run the Lease Expense Schedule (LEASE_SCHED2) process before you run a lease report.
This section discusses how to generate the:
Lease Expiration report.
Lease Footnote Disclosure Summary and Lease Footnote Disclosure Detail reports.
Lease Summary Information, Lease Detail Information, and Lease Amortization Schedule reports.
Note. IT Asset Management also provides a report called Lease End Date.
Page Name |
Object Name |
Navigation |
Usage |
RUN_AMLE2400 |
Asset Management, Financial Reports, Leased Assets, Lease Expiration |
Define the run parameters for the Lease Expiration report (AMLE2400). Use the report to list leases that expire as of today's date, after a certain number of days from a specified date, or within a date range that you select. |
|
RUN_AMLE2300 |
Asset Management, Financial Reports, Leased Assets, Footnote Disclosure |
Define the run parameters for a Lease Footnote Disclosure Summary or Detail report (AMLE2000). Use at the end of each fiscal year to view all outstanding capital and operating lease commitments for the next five years. The report also provides the monthly lease payment and yearly totals. |
|
RUN_AMLE2000 |
Asset Management, Financial Reports, Leased Assets, Summary or Detail |
Define the run parameters for the following reports:
|
See Also