Introduction
This tutorial shows you how to plan for Capital lease assets with IFRS16 Standard support enabled, as well as import existing leased assets. 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.
Note:
For a complete list of changes that occur when you enable IFRS-16 Standard in Capital, see the IFRS in Lease Asset Planning section in the Administering Planning Modules documentation.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
Prerequisites
Cloud EPM Hands-on Tutorials may require you to import a snapshot into your Cloud EPM Enterprise Service instance. Before you can import a tutorial snapshot, you must request another Cloud EPM Enterprise Service instance or remove your current application and business process. The tutorial snapshot will not import over your existing application or business process, nor will it automatically replace or restore the application or business process you are currently working with.
Before starting this tutorial, you must:
- Have Service Administrator access to a Cloud EPM Enterprise Service instance. The instance should not have a business process created.
- If you haven't already, register for a free Oracle Cloud Customer Connect account so you can access the required files.
- Download the latest EPBCS Sample Application LCM snapshot from this idea page.
- Upload and import the latest EPBCS Sample Application LCM snapshot into your Planning instance.
- Set or verify that Forms 2.0 is selected in Application Settings.
- 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.Reviewing Required Configured Features
Verifying IFRS16 Support
In this section, you verify that the IFRS16 feature for Capital is enabled.
- 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, verify that IFRS16 Standard is selected.
- Review all previously enabled features, including the selected custom dimensions.
- Click Close.
Verifying Capital Lease Asset Setup
You can add assets using provided members or create your own asset class. In this section, you verify that Capital Leased Assets was enabled.-
On the Configure page for Capital, from the list of components, click Assets.
- In Assets, verify that Capital Leased Assets is listed.
- Click Close.
Reviewing the Timeframe and Granularity for Plans
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 FY24.
- For Plan Start Year, select Current Fiscal Year.
- 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.Verifying Currency Precision
- From the navigation options on the top of the page, 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, if not already expanded, expand Input Currencies under Currency.
USD is listed as an input currency.
- For USD, scroll to the right, locate the Precision column, and verify that it is set to 0.
- Click Cancel.
Assigning Values to User Variables
- Click (Navigator), then under Tools, click User Preferences.
- On the left, click User Variables.
- For Entity, set it to Manufacturing US.
Tip:
When available, you can click a dimension or prompt's (Member Selector) to open the Select Member dialog where you can search, select, and assign members, user variables, or substitution variables to a dimension. - Click Save.
- At the information message, click OK.
Setting Display Preferences
- On the left, click Display.
- Under Number Formatting, verify that Thousands Separator is set 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, for Entity, select Company Assumptions.
- In the grid, for Capital Leased Assets, set or verify 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 information message, click OK.
- From the horizontal tabs, 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.
- At the information message, click OK.
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
- Set Project to No Project
- In the data grid of New Leased Assets, right-click the top left empty header cell to display menu options, and then select Add New Leased Asset.
- In Add New Leased Asset, enter the following:
Detail Value ID LeaseAsset1001 Description Lease Owned by Lessor Asset Units 1 Capacity UOM Each Priority High Lease Date 6/1/24 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 "LeaseAsset1001" - Verify your selections and click Add Leased Asset.
- At the information message, click OK.
The new lease asset is displayed on the grid.
- In the data grid, right-click LeaseAsset1001 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.
Tip:
In Profit and Loss Impact, click Total Expenses - Capital to drill-through data. - From the navigation options on the top of the page, click Analysis.
- From the vertical tabs on the left, click (Financial Statements).
- In the POV of Balance Sheet Summary Analysis, set Asset Class to Capital Leased Assets.
- Review the contents of the Balance Sheet. Expand periods (Year Total) to drill-through values.
- From the horizonal tabs, click Cash Flow Impacts and review the impact of lease payments to the cash flow.
- From the horizontal tabs, 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
- In the data grid, for LeaseAsset1001, set Lease Term (in Years) to 8.
- On the upper right of the form, click (Save).
- At the information message, click OK.
- In the data grid, right-click LeaseAsset1001 and select Calculate Lease.
- At the information message, click OK.
- In Profit and Loss Impact, click Total Expenses - Capital to drill-through data.
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.
- Make sure you are in Lease Asset Planning, and set or verify the POV:
- Entity: Manufacturing US
- Asset Class: Capital Leased Assets
- Project: No Project
- In the data grid, for LeaseAsset1001, set:
- Lease Term (In Years) to 4
- Ownership After Lease Term to Lesse
- On the upper right of the form, click (Save).
- At the information message, click OK.
- In the data grid, right-click LeaseAsset1001 and select Calculate Lease.
- At the information message, click OK.
- In Profit and Loss Impact, click Total Expenses - Capital to drill-through data.
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.
- Make sure you are in Lease Asset Planning, and set or verify the POV:
- Entity: Manufacturing US
- Asset Class: Capital Leased Assets
- Project: No Project
- In the data grid, for LeaseAsset1001, 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.
- In Profit and Loss Impact, click Total Expenses - Capital to drill-through data.
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.
- Make sure you are in Lease Asset Planning, and set or verify the POV:
- Entity: Manufacturing US
- Asset Class: Capital Leased Assets
- Project: No Project
- In the data grid, for LeaseAsset1001, 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.
- In Profit and Loss Impact, click Total Expenses - Capital to drill-through data.
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.
- Make sure you are in Lease Asset Planning, and set or verify the POV:
- Entity: Manufacturing US
- Asset Class: Capital Leased Assets
- Project: No Project
- In the data grid, for LeaseAsset1001, 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.
- In Profit and Loss Impact, click Total Expenses - Capital to drill-through data.
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.
- Make sure you are in Lease Asset Planning, and set or verify the POV:
- Entity: Manufacturing US
- Asset Class: Capital Leased Assets
- Project: No Project
- In the data grid, right-click the top left empty header cell to display menu options, and then 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 6/1/2024 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 data grid, right-click RentFree and select Calculate Lease.
- At the information message, click OK.
- In Profit and Loss Impact, click Total Expenses - Capital to drill-through data.
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.
- From the horizontal tabs, click Rent Free Period.
- In Rent Free Periods, for RentFree, verify that the Payment Frequency is set to Monthly.
- For RentFree, set the values to Yes for months Jun through Nov.
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.
- From the horizontal tabs, click Lease Asset Planning.
- Set or verify the POV:
- Entity: Manufacturing US
- Asset Class: Capital Leased Assets
- Project: No Project
- For RentFree, review the PV of Lease value.
- In the grid, right-click RentFree and select Calculate Lease.
- At the information message, click OK.
- In Profit and Loss Impact, click Total Expenses - Capital to drill-through data.
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.
- Return to the home page. On the upper-right, click (Home).
Importing and Calculating Lease Assets
In this section, you import existing lease assets.
Adding Existing Lease Members to the Hierarchy
- On the home page, click Application, and then Overview.
- Click Dimensions.
- From the Cube dropdown, select OEP_CPX.
- Click Asset Detail.
- In Edit Member Properties for Asset Detail, expand Asset Detail, then OCX_Total All, and 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:
- Lease1002
- Lease1003
- For both members, set the Default Data Storage to Store.
- Set the Default Alias Table entries to match the member names.
- Verify your entries, and 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:
- In Import Data, 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
- In the data grid, verify that the imported lease assets, Lease1002 and Lease1003 are displayed.
- Set the Lease Date for both assets to:
- Lease1002: 1/1/25
- Lease 1003: 1/15/25
- Locate the Index Rate column and, for both lease assets, set it to 1%.
- Verify your enntries, and then 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.
- Optionally review the impact on Financial Statements in the Analysis card.
Related Links
More Learning Resources
Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.
For product documentation, visit Oracle Help Center.
Lease Asset Planning with IFRS16
F52579-03
September 2024