BeyondERP.Newsletter
Menu

Report page · Asset leasing

Weighted-average discount rate

A disclosure report that supports the US GAAP ASC 842 requirement to disclose a weighted-average discount rate for leases.

Business process
Analyze asset leases
Menu item
AssetLeaseDisclosureDiscountRate
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA disclosure report that supports the US GAAP ASC 842 requirement to disclose a weighted-average discount rate for leases.
What you do hereUse this page to print, as of a date, the leases with their discount rates and remaining payments for the weighted-average discount rate disclosure.
ExampleFor example, for BEAT's ASC 842 year-end disclosure the controller runs it as of 12/31 and takes the weighted-average discount rate for operating and finance leases from it.
Weighted-average discount rate page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAnalyze assets › Analyze asset leases
Menu pathAsset leasing › Inquiries and reports › Disclosures › Weighted-average discount rate
Set up firstLease summary (Incremental borrowing rate) Microsoft Learn
Used next byGAAP - cash flows Microsoft Learn
Related pagesFive years undiscounted payment forecast Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itAt each reporting date when you prepare the US GAAP ASC 842 lease disclosures.
How oftenAt each quarter or year end close.
What the output showsOne line per lease and book with Discount rate, Lease payments remaining and Weighted payments remaining. The weighted-average rate is the total weighted payments divided by the total remaining payments. A rate that looks off often comes from a lease with a wrong discount rate or an As of date that isn't the period end.

Source: Microsoft Learn

Setup steps on this page

Run the Weighted-average discount rate report

Produce the Weighted-average discount rate figures for the period you report.

Steps from Microsoft

  1. Go to Asset leasing > Inquiries and reports > Disclosures > Weighted-average discount rate.
  2. Set the As of date to the last day of the period you disclose; all leases that start on or before that date are included.
  3. Filter on Legal entity, Book or Lease group as needed for the disclosure.
  4. Use Discount rate, Lease payments remaining and Weighted payments remaining to calculate the weighted-average rate for the ASC 842 disclosure.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
As of dateIncludes all leases that start on or before this date.Microsoft Learn
Legal entityThe legal entity of the lease.Microsoft Learn
BookThe book type of the lease shown.Microsoft Learn
Lease groupThe group the lease belongs to.Microsoft Learn
Discount rateThe rate used to discount the lease payments.Microsoft Learn
Lease payments remainingThe total unpaid lease payments remaining from the As of date.Microsoft Learn
Weighted payments remainingThe remaining lease payments multiplied by the discount rate.Microsoft Learn

Common errors and fixes

MessageWhat to do
The report shows lower figures than expectedJournals for the period aren't posted yet, or a schedule isn't confirmed. Post the period's journals and run it again. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the Weighted-average discount rate reportRun it as of the last day of the period you disclose, as Microsoft advises.It includes leases that start on or before the As of date and weights each discount rate by the lease payments remaining.Which leases are in the disclosure?Running it as of today instead of the period end, so leases signed after the period are included.Test: Rate weighted by remaining payments

Feature management and licence

Feature to turn onAsset leasing (Must be on)Multi-company purpose (Optional)
Licence or add-inAsset leasing must be turned on in Feature management (feature Asset leasing). Microsoft Learn describes three Asset leasing roles: Maintain lease (add, edit and post leases), View lease (view leases and schedules and run reports) and Lease clerk (create new leases only). View lease users run it, as do Maintain lease users.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyRuns for the legal entities you select. With the Multi-company purpose feature (version 10.0.44) the legal entities are picked from an organization hierarchy. Microsoft Learn
Can it be undoneNothing to undo: The report only reads lease data; it changes nothing. Microsoft Learn
If you change it laterThe report reads the posted lease schedules and changes nothing. Its figures change only when journals are posted, reversed or a lease is adjusted, so run it after the period's journals are posted. Microsoft Learn
Technical architect

6Technical

Menu itemAssetLeaseDisclosureDiscountRate Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itLease accountant AssetLeaseLeaseMaintainAccountant LedgerAccountantLease manager AssetLeaseLeaseViewAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 4 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=AssetLeaseDisclosureDiscountRate
Data migrationLoad order: The Weighted-average discount rate report has no data entity in Data management, so it can't be loaded from a file or a configuration template. A report stores no data; it reads the lease books and schedules, so migrate the leases instead.Microsoft Learn
Everyone

8Sources

KEEP EXPLORING

More in Asset leasing.

Open the other pages and setup steps in this module, or go back to the Atlas Hub to search every page.