NetLease - Weighted Average Rate Report

Overview

This search generates a summary calculation of the weighted average rates, which is a required footnote disclosure item. 

Quantitative Disclosure Guidance

The following is the lease quantitative disclosure guidance that necessitates this report:

The following is an example of a Weighted Average Rate Summary in financial statements. The report in NetLease is intended to fulfill the disclosure requirement:

Navigation

NetLease > Reports  > Disclosure Reports > Weighted Average Rate Report > Run

Filtering

The search can be refined by adjusting filters for subsidiary, consolidated exchange rate, department, class, location, lease, and/or period. After selecting the desired filters, click Preview to view the updated report:

Results

When the report is run, the user will see the consolidated liability balance, consolidated undiscounted remaining payments, and the weighted average rate by liability balance for the period, broken down by lease type. Lease types can be expanded to view individual leases and their detailed information. To download the report in Excel, select the Export button:

Troubleshooting

  • If the desired lease is not appearing, verify that the lease status is not set to "Pending" and that the lease has not been marked as inactive.

  • If the exchange rate does not appear as expected, review the selection in the "Consolidated Exchange Rate" filter. The exchange rates used in the report can be configured by adjusting the filter to one of the following options:

    • Average – Based on the average currency exchange rate effective over the filtered period.
    • Current – Based on the currency exchange rate effective at the end of the reported period.
    • Historical (From Date) – Based on the currency exchange rate effective at the start of the reported period.
    • Custom – The exchange rate is pulled as of the date entered in the "Consolidated Exchange Rate Date" field.
    • None – No consolidation occurs; values are pulled directly from the subledger in the contract currency of the lease, regardless of the selected currency.

Was this article helpful?