Weighed-Averages Lease Report

Displays weighted average of the remaining contract terms and discount rates. The report contains two tabs: Operating Leases and Finance Leases, and contains data for both RE Contracts and Equipment Contracts. Report filters display in the report, and computed values display as Excel formulas instead of static data.

Data includes Accounting Method, Account Number fields, ASC 842 Schedule, Asset Class, Asset ID, Begin / End Date, Contract Category Code, Contract Group, Contract ID, Contract Name, Contract Rec ID, Contract Status, Contract Type, Currency Type, Current Period Liability Balance, Current Period Asset Balance, Current Remaining Balance Lease Payments, Discount Rate, Facility, Facility ID, IFRS 16 Schedule, Initial Asset Balance, Initial Liability Balance, the Is Approved? flag for the schedule, the Is Inactive? flag for the schedule, Location, Organization Name, Organization Rec ID, and Portfolio.

Example calculations from this report:

• The weighted average of remaining lease term in days = the sum of the remaining liability / sum of the current period's liability

• The weighted average of remaining lease term in years = The weighted average of remaining lease term in days / 365. 25

• The weighted average of the discount rate = the sum of the discount amount / sum of the current remaining balance of lease payments

Leases for which the remaining balance of lease payments sums to zero are not included in this report's calculations.

• Report Type: Entity.

• Default View Type: Native Excel

• Accounting Reference / Guidance: ASC 842-20-50-4 & 55-11, ASC 842-20-50-4 & 55-12, IFRS 16: C12 (borrowing rate only)

• Disclosure Reporting Requirements:

  • Operating: Operating leases weighted avg remaining lease term (in years), Operating leases weighted avg discount rate

  • Finance: Finance leases weighted avg remaining lease term (in years), Finance leases weighted avg discount rate

• Runtime Filters: Fiscal Period.

  When a period is selected, the system uses the Begin Date of the selected period to perform the calculation instead of today's date. The Begin Date of the selected period will also show up in a report field labeled Effective Period Report Begins.