Before you Begin
This tutorial shows you how to plan for Capital lease assets with IFRS16 Standard support enabled, as well as import existing leased assets. The following use cases are included:
- Ownership with Lessor and Lease Term is less than Useful Life
- Ownership with Lessor and Lease Term is greater than Useful Life
- Ownership with Lessee
- Low Tenure Leases
- Low Value Leases
- Lease with Indexation
- Rent Free Lease
The sections build on each other and should be completed sequentially.
Background
With Capital, you can manage, prioritize, and plan for capital expenses. Capital helps decision-makers and front-line managers communicate throughout the request, justification, review, and approval process.
In Capital, you can perform lease asset planning with IFRS-16-enabled applications.
The following IFRS16 Standard calculations are supported:
- New and existing lease assets
- Asset and liability values based on NPV of Lease
- Depreciation of the assets
- Low value and low tenure assets that are exempt from being capitalized
- Treatment considerations based on ownership of the Lease
- Indexation of the lease cost
- Lease calculations for Plan and Forecast scenarios
Review how lease asset calculations impact Profit & Loss, Balance Sheet and Cash flow in the Analysis card under Capital.
In this tutorial, you plan for lease assets with IFRS16 enabled for the following use cases:
- Ownership with Lessor and Lease Term is less than Useful Life
- Ownership with Lessor and Lease Term is greater than Useful Life
- Ownership with Lessee
- Low Tenure Leases
- Low Value Leases
- Lease with Indexation
- Rent Free Lease
What Do You Need?
An EPM Cloud Service instance allows you to deploy and use one of the supported business processes. To deploy another business process, you must request another EPM Enterprise Cloud Service instance or remove the current business process.
- Have Service Administrator access to an EPM Enterprise Cloud Service instance. The instance should not have a business process created.
- Upload and import this snapshot into your instance.
- Download this data file (Existing Leases.csv) to a local folder.
Note:
If you run into migration errors importing the snapshot, re-run the migration excluding the HSS-Shared Services component, as well as the Security and User Preferences artifacts in the Core component. For more information on uploading and importing snapshots, refer to the Administering Migration for Oracle Enterprise Performance Management Cloud documentation.Enabling IFRS16 Support
In this section, you enable the IFRS16 feature for Capital.
- On the home page, click Application, and then Configure.
- From the Configure dropdown, select Capital.
The Configure page for Capital is displayed. In this application, Capital was configured with a few features enabled. Components related to those enabled features are listed on this page.
- Click Enable Features.
- In Enable Features, under New Capital Investment, select IFRS16 Standard.
- Scroll down and review all previously enabled features, including the selected custom dimensions.
- Click Enable.
- At the confirmation message, click Yes.
The enablement process takes a moment to complete.
- At the information message, click OK.
- Sign out and sign back into Planning.
Adding Capital Lease Assets
You can add assets using provided members or create your own asset class. In this section, you add the provided member: Capital Leased Assets.Adding Provided Members
- On the home page, click Application, and then Configure.
- From the Configure dropdown, select Capital.
- From the list of components, click Assets.
- In Assets, click Actions, and then select Add.
- Then, select Provided Members.
- In Provided Members, locate and select Capital Leased Assets and click OK.
The added provided member is listed in the dialog.
- Click Save.
- At the information message, click OK.
- Click Close.
Refreshing the Database
- On the Configure page for Capital, click Actions, and then select Refresh Database.
- In Refresh Database, click Create.
- In the next Refresh Database dialog, accept default selections and click Refresh Database.
- At the Refresh Database confirmation message, click Refresh.
The cube refresh process takes a moment to complete.
- When the status displays Succeeded, click Finish.
- Click Close, twice, to close both Refresh Database dialogs.
Setting the Current Fiscal Year
In this section, you review the Planning and Forecast Preparation selections and set the current fiscal year.- On the Configure page for Capital, click Planning and Forecast Preparation.
- For Current Fiscal Year, select FY22.
- Review the selected Period, Plan Start Year, and planning frequency for the Plan scenario.
- Click Forecast and review the planning frequency selections.
- Click Save.
- At the Validation message, click OK.
- Click Close.
Setting Application Preferences
You can control many aspects of the application and the system. In this section, you set currency precision, assign values to user variables, and set display preferences.Setting Currency Precision
- From the cards on top, click Overview.
- Click Dimensions.
- From the Cube dropdown, select OEP_CPX.
- From the list of dimensions, click Currency.
- In the grid of Edit Member Properties for Currency, under Currency, expand Input Currencies.
USD is listed as an input currency.
- For USD, scroll to the right, locate the Precision column, and set it to 0.
- Click Save.
- Click Cancel.
Assigning Values to User Variables
- Click
(Navigator), then under Tools, click User Preferences.
- On the left, click User Variables.
- For Entity, click its
(Member Selector) and select Manufacturing US as the variable's value.
Tip:
You can directly type the member name, instead of using Member Selector. - For Years, click its
(Member Selector) and select FY22. as the variable's value.
- Click Save.
- At the information message, click OK.
Setting Display Preferences
- On the left, click Display.
- Under Number Formatting, set Thousands Separator to Comma.
- Click Save.
- At the information message, click OK.
Setting Assumptions
You set assumptions that drive calculations used in the built-in best practice and formulas.- Click
(Navigator), then under Capital, click Investments.
- From the vertical tabs on the left, click
(Assumptions).
Depreciation & Amortization Assumptions is displayed.
- In the POV, verify that Entity is set to Company Assumptions.
- In the grid, for Capital Leased Assets, set the following values:
Detail Value Useful Life (in Years) 6 Depreciation Method Straight Line Depreciation Convention Prorate Actual Date Low Value Lease Term (in Months) 12 Low Value Lease Amount 5000 - Verify your selections and click Save.
- At the bottom, click Funding Assumptions.
- In Funding Assumptions, for Capital Leased Assets, enter the following:
Column Value Cash Flow Incidence Same Month Funding Incidence Same Month - Verify your selections and click Save.
Use Case: Ownership with Lessor and Lease Term is less than Useful Life
In this use case, you add a capitalized lease asset with the following details:
- Lease is owned by Lessor.
- The lease term is shorter than its useful life.
- From the vertical tabs on the left, click
(Lease Asset Planning).
- In the POV:
- Verify that Entity is set to Manufacturing US.
- Set the Asset Class to Capital Leased Assets.
- Verify that Project is set to No Project.
-
Click
(Go).
- In New Leased Assets, within the whitespace, right-click and select Add New Leased Asset.
- In Add Leased Asset, enter the following:
Detail Value ID LeaseAsset001 Description Lease Owned by Lessor Asset Units 1 Capacity UOM Each Priority High Lease Date 1/1/2022 Lease Term (In Years) 4 Lease Payment 40000 Payment Frequency Annual Payment Timing End of Period Implicit Interest Rate 5 Index Rate 1 Index Rate Basis Annual Ownership After Lease Term Lessor Low Value Override No Asset Name "LeaseAsset001" - Verify your selections and click Launch.
- At the information message, click OK.
The new lease asset is displayed on the grid.
- In the grid, right-click LeaseAsset001 and select Calculate Lease.
- At the information message, click OK.
The charts on the dashboard are updated to display impacts on Profit and Loss, and Cash Flow.
The asset value is calculated from the Net Present Value of the asset. The Present Value becomes the Gross PP&E and Liability (right-of-use, or ROU, asset and liability). This is calculated based on the interest rate of 5%, lease payment, and the lease term of four (4) years.
Depreciation is calculated for (four) 4 years, as based on whichever is lower between the lease term or useful life since asset ownership is with the Lessor.
IFRS 16 also refers to the lease asset as an ROU asset. These leases are capitalized and presented on the balance sheet as both assets and liabilities, unless subject to any of the exemptions prescribed by the standard.
- From the cards on top, click Analysis.
- From the vertical tabs on the left, click
(Financial Statements).
- Review the contents of the Balance Sheet. Expand periods (Year Total) to drill-through values.
- From the horizonal tabs at the bottom, click Cash Flow Impacts and review the impact of lease payments to the cash flow.
- From the horizontal tabs at the bottom, click Profit and Loss Impacts and review depreciation and interest expenses.
Use Case: Ownership with Lessor and Lease Term is Greater than Useful Life
In this use case, you set the lease term to eight (8) years so that the lease term becomes greater than the useful life.
- From the cards on top, click Investments.
- Verify that you are on Lease Asset Planning.
- In the POV, verify or set:
- Entity: Manufacturing US.
- Asset Class: Capital Leased Assets.
- Project: No Project.
-
Click
(Go).
- In the grid, for LeaseAsset001, set Lease Term (in Years) to 8.
- On the upper right of the form, click
(Save).
- At the information message, click OK.
- In the grid, right-click LeaseAsset001 and select Calculate Lease.
- At the information message, click OK.
The charts on the dashboard are updated to display impacts on Profit and Loss, and Cash Flow.
The asset value is calculated from the Net Present Value of the asset over the term of eight (8) years.
Depreciation is calculated for (six) 6 years, as based on whichever is lower between the lease term or useful life since asset ownership is with the Lessor.
With the lease asset capitalized, the Present Value is taken from the combination of the Gross PP&E and Liability (right-of-use, or ROU, asset and liability) and Asset Class value.
- Optionally review the impact on Financial Statements in the Analysis card. When finished reviewing, return to Lease Asset Planning.
Use Case: Ownership with Lessee
In this use case, you set the ownership of the lease to the lessee.
- In the POV for Lease Asset Planning, verify or set:
- Entity: Manufacturing US.
- Asset Class: Capital Leased Assets.
- Project: No Project.
-
Click
(Go).
- In the grid, for LeaseAsset001, set:
- Lease Term (In Years) to 4
- Ownership After Lease Term to Lessee
- On the upper right of the form, click
(Save).
- At the information message, click OK.
- In the grid, right-click LeaseAsset001 and select Calculate Lease.
- At the information message, click OK.
The Present Value is again calculated based on the interest rate of 5%, lease payment, and the lease term of four (4) years.
Depreciation is calculated for (six) 6 years, based on the useful life since asset ownership is transferred to the Lessee at the end of the term.
- Optionally review the impact on Financial Statements in the Analysis card. When finished reviewing, return to Lease Asset Planning.
Use Case: Low Tenure Leases
Low tenure lease thresholds are based on the values you entered in Depreciation & Amortization Assumptions for Low Value Lease Term (in Months).
In this use case, you plan for the following exception: If the lease term is less than or equal to the specified Low Value Lease Term (in Months) assumption, the lease is charged off on the P&L rather than being treated like other assets.
- In the POV for Lease Asset Planning, verify or set:
- Entity: Manufacturing US.
- Asset Class: Capital Leased Assets.
- Project: No Project.
-
Click
(Go).
- In the grid, for LeaseAsset001, set:
- Lease Term (In Years) to 1
This sets the tenure to 1 year, which is equal to the Low Value Lease Term (in Months) assumption you defined: 12.
- Ownership After Lease Term to Lessor
- Lease Term (In Years) to 1
- On the upper right of the form, click
(Save).
- At the information message, click OK.
- In the grid, right-click LeaseAsset001 and select Calculate Lease.
- At the information message, click OK.
The charts on the dashboard are updated to display impacts on Profit and Loss, and Cash Flow.
Notice that because the lease term is equal to the Low Value Lease Term (in Months) assumption, the lease is charged off the P&L.
- Optionally review the impact on Financial Statements in the Analysis card. When finished reviewing, return to Lease Asset Planning.
Use Case: Low Value Leases
Lease assets that meet the low value threshold you set for the Low Value Lease Amount assumption are calculated using the IFRS16 standard for low value assets, and are charged off on the P&L rather than being treated like other assets.
In this use case, you add a low value lease asset.
- In the POV for Lease Asset Planning, verify or set:
- Entity: Manufacturing US.
- Asset Class: Capital Leased Assets.
- Project: No Project.
-
Click
(Go).
- In the grid, for LeaseAsset001, set:
- Lease Term (In Years) to 4
- Lease Payment to 5000
Tip:
You may need to scroll to the right of the form to locate Lease Payment.
- On the upper right of the form, click
(Save).
- At the information message, click OK.
- In the grid, right-click LeaseAsset001 and select Calculate Lease.
- At the information message, click OK.
The charts on the dashboard are updated to display impacts on Profit and Loss, and Cash Flow.
Similar to low tenure leases, low value leases are charged off the P&L. In this example, the P&L charge for this lease occurs within the four (4) year lease term.
- Optionally review the impact on Financial Statements in the Analysis card. When finished reviewing, return to Lease Asset Planning.
Use Case: Lease with Indexation
In this use case, you adjust the annual index rate of a lease asset. If you set an Index Rate, lease amounts increase for inflation based on the Index Rate Basis (annual or according to the payment frequency, depending on what you selected). In the previous use cases, an index rate of 1% was used.
- In the POV for Lease Asset Planning, verify or set:
- Entity: Manufacturing US.
- Asset Class: Capital Leased Assets.
- Project: No Project.
-
Click
(Go).
- In the grid, for LeaseAsset001, set:
- Index Rate to 3%
- Lease Payment to 40000
Many companies structure lease contracts with an annual index (inflation) rate rather than according to the payment frequency (for example, monthly). This feature enables you to have an annual index rate increase that is not tied to the payment frequency.
- On the upper right of the form, click
(Save).
- At the information message, click OK.
- In the grid, right-click LeaseAsset001 and select Calculate Lease.
- At the information message, click OK.
The charts on the dashboard are updated to display impacts on Profit and Loss, and Cash Flow.
For leased assets with an Index Rate, Calculate Leased Assets calculates PV of leased assets for all assets whose lease start date is prior to the planning and forecast year range.
- Optionally review the impact on Financial Statements in the Analysis card. When finished reviewing, return to Lease Asset Planning.
Use Case: Lease with Rent Free Periods
Rent free periods are based on periods, not a date range, based on the payment frequency for the lease (monthly, quarterly, yearly).
In this use case, you add a leased asset with rent free periods.
- In the POV for Lease Asset Planning, verify or set:
- Entity: Manufacturing US.
- Asset Class: Capital Leased Assets.
- Project: No Project.
-
Click
(Go).
- In New Leased Assets, within the whitespace, right-click and select Add New Leased Asset.
- In Add Leased Asset, enter the following:
Detail Value ID RentFree Description Rent Free Lease Asset Units 1 Capacity UOM Each Priority High Lease Date 1/1/2022 Lease Term (In Years) 4 Lease Payment 50,000 Payment Frequency Monthly Payment Timing End of Period Implicit Interest Rate 5 Index Rate 2 Index Rate Basis Annual Ownership After Lease Term Lessor Low Value Override No Asset Name "RentFree" - Verify your selections and click Launch.
- At the information message, click OK.
The new lease asset is displayed on the grid.
- In the grid, right-click RentFree and select Calculate Lease.
- At the information message, click OK.
The charts on the dashboard are updated to display impacts on Profit and Loss, and Cash Flow.
After you add new lease assets, on the Rent Free Periods form, for each lease asset, select Yes for any periods that should be rent free.
- At the bottom, click the Rent Free Period horizontal tab.
- In Rent Free Periods, for RentFree, verify that the Payment Frequency is set to Monthly.
- For RentFree, set Jan to Yes, then select or copy the same value through May.
Define rent free periods that can occur any time during the term of the lease.
When companies negotiate long term lease contracts, they might want to offer rent free periods during the term of the lease contract as an incentive. This is also popularly known as Lease Holiday, where certain periods are given as incentive as per the lease terms.
- Click Save.
- At the information message, click OK.
- At the bottom, click the Lease Asset Planning horizontal tab.
- For RentFree, review the PV of Lease value.
- In the grid, right-click RentFree and select Calculate Lease.
- At the information message, click OK.
The charts on the dashboard are updated to display impacts on Profit and Loss, and Cash Flow.
After adding rent free periods and calculating the lease, the Present Value of the lease is lower. Rent free period lease payments are set to zero, and when you calculate the lease, values for present value and cash flow are calculated considering rent free periods.
- Optionally review the impact on Financial Statements in the Analysis card.
- On the upper-right of the page, click
(Home).
Importing and Calculating Lease Assets
In this section, you import existing lease assets.
Adding Existing Lease Members to the Hierarchy
- From the home page, click Application, and then Overview.
- Click Dimensions.
- From the Cube dropdown, select OEP_CPX.
- Click Asset Detail.
- In the grid of Edit Member Properties for Asset Detail, under Asset Detail, expand OCX_Total All, then OCX_Leased Assets.
- Select OCX_Existing Lease.
- Click
(Add Child).
- In Add Child, set the number of members to add to 2, and then click Apply.
Two untitled members rows are added under OCX_Existing Lease.
- Replace the names of the untitled members with the following names:
- Lease002
- Lease003
- For both members, set the Default Data Storage to Store.
- Set the Default Alias Table entries to match the member names.
- Click Save.
- Click
(Refresh Database).
- In the first Refresh Database dialog, accept all default selections and click Refresh Database.
- At the Refresh Database prompt, click Refresh.
Refreshing the database takes a moment to complete.
- When the cube refresh progress completes, click Finish.
- In Refresh Database, click Close.
- In Edit Member Properties for Asset Detail, click Cancel.
Importing Existing Lease Asset Data
- In Dimensions, click Actions, then select Import Data.
- In the first Import Data dialog, click Create.
- In the next Import Data dialog, for Source File, click Choose File.
Note:
Depending on your browser, the button label may display Choose File or Browse. - Navigate to where you saved Existing Leases.csv, then select or open it.
Once selected, it displays as:
- At the top of the dialog, click Import.
Tip:
Oracle recommends validating your import file before running the import process. The import file included in this tutorial has been tested and validated. - At the information message, click OK.
- Click Close, twice to close both Import Data dialogs.
- From the cards at the top, click Jobs.
- In Jobs, locate the following jobs and verify that they completed successfully:
Reviewing the Imported Existing Assets
- Click
(Navigator), then under Capital, click Existing Assets.
- From the vertical tabs on the left, click
(Existing Leased Assets).
- In the POV for Existing Leased Assets, verify or set:
- Entity: Manufacturing US.
- Asset Class: Capital Leased Assets.
- Project: No Project.
-
Click
(Go).
- In the grid, verify that the imported lease assets, Lease002 and Lease003 are displayed.
- Locate the Index Rate column and, for both lease assets, set it to 1%.
- On the upper right of the form, click
(Save).
- At the information message, click OK.
- Right-click Existing Lease and select Calculate All.
- At the information message, click OK.
The charts on the dashboard are updated to display impacts on Profit and Loss, and Cash Flow.
Notice that the calculations are the same for both assets. The assets, however, differ in the number of years they depreciate.
Tip:
Modify the Lease Date, save the data on the form, and calculate the lease to see how the changes impact P&L, as well as Cash Flow. - Optionally review the impact on Financial Statements in the Analysis card.
Learn More
Lease Asset Planning with IFRS16
F52579-02
April 2022
Copyright © 2022, Oracle and/or its affiliates.
This tutorial shows you how to plan for Capital lease assets with IFRS16 Standard support enabled, as well as import existing leased assets. The following use cases are included: Ownership with Lessor and Lease Term is less than Useful Life, Ownership with Lessor and Lease Term is greater than Useful Life, Ownership with Lessee, Low Tenure Leases, Low Value Leases, Lease with Indexation, and Rent Free Lease.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software" or "commercial computer software documentation" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.