Working With Leased Assets

This chapter provides an overview of leased assets, lists prerequisites, and discusses how to:

Click to jump to parent topicUnderstanding Leased Assets

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:

Note. Your transactions are maintained with multiple currencies if you use them in conjunction with leased assets.

Click to jump to top of pageClick to jump to parent topicCapital and Operating Leases

There are two basic types of leases: capital leases and operating leases.

Click to jump to top of pageClick to jump to parent topicStep Leases

A step lease features variable payment amounts and variable timing over the term of the lease.

Examples of step leases include:

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.

Click to jump to parent topicDefining Payment Schedules

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.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Payment Schedules

Page Name

Object Name

Navigation

Usage

Payment Schedules

LEASE_SCH_ID

Set Up Financials/Supply Chain, Product Related, Asset Management, Payment Schedules

Add or modify payment schedules for leases.

Click to jump to top of pageClick to jump to parent topicDefining Lease Payment Schedules

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.

Click to jump to parent topicAdding Capital and Operating Leases

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Add Capital and Operating Leases

Page Name

Object Name

Navigation

Usage

Express Add - Definition

ASSET_LEASE_01

Asset Management, Asset Transactions, Leased Assets, Express Add

Create a capital lease or an operating lease.

Update Lease Information - Definition

ASSET_LEASE_01

Asset Management, Asset Transactions, Leased Assets, Update Lease Information

Update a capital lease or an operating lease.

Express Add - Cost

ASSET_LEASE_02

Asset Management, Asset Transactions, Leased Assets, Express Add, Cost

Enter cost, ChartField, and depreciation data for a leased asset.

Update Lease Information - Cost

ASSET_LEASE_02

Asset Management, Asset Transactions, Leased Assets, Update Lease Information, Cost

Update cost, ChartField, and depreciation data for a leased asset.

Express Add - Step Lease Payment

ASSSET_LEASE_05

Asset Management, Asset Transactions, Leased Assets, Express Add, Step Lease Payment

Enter a step-lease payment schedule.

Update Lease Information - Step Lease Payment

ASSET_LEASE_05

Asset Management, Asset Transactions, Leased Assets, Update Lease Information, Step Lease Payment

Update a step-lease payment schedule.

Express Add - Payment Schedule

ASSET_LEASE_03

Asset Management, Asset Transactions, Leased Assets, Express Add, Payment Schedule

Create or view lease payment schedules.

Update Lease Information - Payment Schedule

ASSET_LEASE_03

Asset Management, Asset Transactions, Leased Assets, Update Lease Information, Payment Schedule

Update lease payment schedules.

Update Lease Information - Operating ChartFields

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.

Click to jump to top of pageClick to jump to parent topicCreating a Lease

Access the Express Add - Definition page.

Profile ID

Enter an ID if you want to use the default information from an asset profile to define this asset. You must enter a profile ID for a capital lease because all depreciation information is stored in the profile ID. A profile ID is not required for an operating lease.

Trans Date (transaction date) and Acctg Date (accounting date)

Enter a transaction date and accounting date for the lease. For leases, the payment date is based on the transaction date. For example, if a lease begins in October and you need to start the payments in the same month, enter a transaction date of October 1. The accounting date has no bearing on the payment date.

CAP#(capital acquisition planning number) and Seq#(sequence number)

Select the associated Capital Acquisition Plan number for this leased asset or look up the associated Asset ID Sequence number if one has been assigned.

Trans Code (transaction code)

Select the accounting entry template that is used for transactions relating to this asset.

Asset Type

Select the asset type from the available established values. You must enter Asset Type for operating leases if you do not enter a profile.

Subtype

Select the asset subtype from the available defined values for the selected Asset Type.

Currency

Select the currency for the transactions that are processed with this asset.

Serial ID

Enter the Serial ID that is associated with this asset. Serial IDs track physical inventory, especially for IT assets.

Tag Number

Enter the tag number that is associated with this asset. Tag numbers track physical inventory.

Note. To perform a physical inventory with Asset Management, your assets must use tag numbers.

Rate Type

The exchange rate that is defined for the default book for the business unit appears by default in this field. You can select a different rate type.

Lease Information

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

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.

Fair Market Value

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.

Guaranteed Residual Value

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.

Minimum Lease Payments (MLP)

Display a minimum lease payment.

  • If there is no bargain purchase option (and you entered a bargain renewal option instead):

    MLP = (MRP × Lease Terms ÷ 12 periods per year × number of payments per year) + Guaranteed Residual + BRO.

  • If there is a bargain purchase option:

    MLP = (MRP × Lease Terms ÷ 12 periods per year × number of payments per year) + BPO.

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.

  • For the first payment in the schedule, the formula looks at the present value of an ordinary annuity for a series of payments of any amount:

    P1 = Pymt × ([ 1 – (1 + Intr) ^ -npymt ] ÷ (intr))

    where:

    P1 = Present value of an ordinary annuity.

    Pymt = Periodic payment amount.

    Intr = Periodic interest rate.

    npymt = Number of payments.

  • For payments that are made after the first payment, the formula looks at the present value of a single future amount:

    P2 = Single_Future_Pymt × (1 ÷ (1 + intr) ^ nper)

    where:

    P2 = Present value of a single future amount.

    Single_Future_Pymt = Future amount.

    intr = Periodic interest rate.

    nper = Number of periods.

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.

Capitalized Lease Amount

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:

  • Defined a payment schedule.

  • Entered (for leases other than step leases) the minimum rental payment on this page or entered cost information on the Express Add - Cost page.

  • For step leases, entered payment information on the Express Add - Step Lease Payment page.

    You can see the results of the calculation on the Express Add - Payment Schedule page.

Lease Payment Type

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

Lease Type

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:

  • There is an ownership transfer at the end of the lease.

  • The lease contains a bargain purchase option (BPO).

  • The lease term is 75 percent or more of the asset life.

    In Germany, the lease term is 90 percent of the leased asset's economic life.

  • The present value of the minimum lease payment is 90 percent or more of the fair market value of the asset.

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.

Click to jump to top of pageClick to jump to parent topic(Optional) Entering Information About Cost, ChartFields, and Depreciation

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.

Click to jump to top of pageClick to jump to parent topicViewing or Updating a Step-Lease Payment Schedule (Optional)

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.

Click to jump to top of pageClick to jump to parent topicViewing or Updating a 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

  • AD Accumulated Depreciation

  • FA Leased property under capital leases (capitalized lease amount)

  • DE Depreciation Expense

  • LO Obligations under capital leases

Adjust

  • AD Accumulated Depreciation

  • FA Leased property under capital leases (capitalized lease amount)

  • DE Depreciation Expense

  • LO Obligations under capital leases

Transfer In

  • FA Leased property under capital leases (capitalized lease amount)

  • DE Depreciation Expense

AD Accumulated Depreciation

Transfer Out

AD Accumulated Depreciation

  • FA Leased property under capital leases (capitalized lease amount)

  • DE Depreciation Expense

Retire

  • CA Proceeds [Proceeds]

  • LO Obligations under capital leases [Guaranteed Residual]

  • AD Accumulated Depreciation [Current Reserve]

  • LO Obligations under capital leases [Remaining Lease Payments]

  • LG Guaranteed Residual Payable [Guaranteed Residual]

  • FA Leased property under capital leases [Current Cost]

  • GL Gain/Loss on leased property [Remaining Payments + ((Proceeds − Removal Cost) + (Cost − Reserve))]

Click to jump to parent topicCreating Lease Expense Schedules

This section discusses how to create lease expense schedules by running the Lease Expense Schedule process.

You must run this 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:

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.

Click to jump to top of pageClick to jump to parent topicPage Used to Run the Lease Expense Schedule Process

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.

Click to jump to top of pageClick to jump to parent topicRunning 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.

Click to jump to parent topicTransferring Operating Leases

This section describes how to transfer an operating lease.

Click to jump to top of pageClick to jump to parent topicPage Used to Transfer Operating Leases

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.

Click to jump to top of pageClick to jump to parent topicTransferring an Operating Lease

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.

Click to jump to parent topicRetiring or Reinstating Leases

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

Retiring Assets

Click to jump to parent topicGenerating Lease Reports

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:

Note. IT Asset Management also provides a report called Lease End Date.

Click to jump to top of pageClick to jump to parent topicPages Used to Generate Lease Reports

Page Name

Object Name

Navigation

Usage

Lease Expiration

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.

Lease Footnote Disclosure

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.

Lease Information

RUN_AMLE2000

Asset Management, Financial Reports, Leased Assets, Summary or Detail

Define the run parameters for the following reports:

  • Lease Summary Information (AMLE2000)

  • Lease Detail Information (AMLE2100)

  • Lease Amortization Schedule (AMLE2200)

See Also

Asset Management Reports