Want FREE Templates on Digital Transformation? Download our FREE compilation of 50+ slides. This is an exclusive promotion being run on LinkedIn.

IFRS 16 Lease Accounting for Lessors Excel Calculation Model   Excel template (XLSX)
$55.00

IFRS 16 Lease Accounting for Lessors Excel Calculation Model (Excel template (XLSX)) Preview Image IFRS 16 Lease Accounting for Lessors Excel Calculation Model (Excel template (XLSX)) Preview Image IFRS 16 Lease Accounting for Lessors Excel Calculation Model (Excel template (XLSX)) Preview Image IFRS 16 Lease Accounting for Lessors Excel Calculation Model (Excel template (XLSX)) Preview Image IFRS 16 Lease Accounting for Lessors Excel Calculation Model (Excel template (XLSX)) Preview Image IFRS 16 Lease Accounting for Lessors Excel Calculation Model (Excel template (XLSX)) Preview Image IFRS 16 Lease Accounting for Lessors Excel Calculation Model (Excel template (XLSX)) Preview Image IFRS 16 Lease Accounting for Lessors Excel Calculation Model (Excel template (XLSX)) Preview Image IFRS 16 Lease Accounting for Lessors Excel Calculation Model (Excel template (XLSX)) Preview Image Log in to unlock full preview.
Arrow   Unlock all 10 preview images:   Login Register

IFRS 16 Lease Accounting for Lessors Excel Calculation Model (Excel XLSX)

File Type: Excel template (XLSX)
Secondary File: Excel (XLSX)

$55.00
This financial model is built by former Deloitte financial modeling professionals, accountants, and CFA charterholders. Their financial models have been used by over 4,000+ clients worldwide.
Add to Cart
  


BUY WITH CONFIDENCE

Immediate digital download upon purchase.
Lifetime document updates included with purchase.
Fully editable & customizable XLSX document.
Supplemental XLSX document also included.
Trusted by over 10,000+ organizations.

BENEFITS OF DOCUMENT

  1. Calculation and visualisation of accounting movements and balances for a number of lease agreements from a lessor perspective.

DESCRIPTION

This product (IFRS 16 Lease Accounting for Lessors Excel Calculation Model) is an Excel template (XLSX) with a supplemental Excel document, which you can download immediately upon purchase.

An IFRS 16 Lease Accounting for Lessors Excel Calculation Model is essential for lessors. It facilitates compliance with accounting standards, ensuring accurate lease-related financial reporting. This model aids in calculating lease income, recognizing assets and liabilities, and aligning financial statements with IFRS 16 requirements. Accurate calculations empower lessors to adapt to lease accounting changes, maintain financial transparency, and ensure compliance with international accounting standards. It enhances financial stability, attracts investors, and supports long-term growth by aligning lease accounting strategies with regulatory standards, making it indispensable for lessors navigating the complexities of IFRS 16.

Purpose of the Model
Our Excel calculation model is designed with a user-friendly interface to meet the IFRS 16 requirements from a lessor's perspective. It streamlines calculations for up to 15 lease agreements, automating accounting movements and balances essential for lease management. The model efficiently handles lease received balances (Net investment in the lease), interest income, revenue, cost of sales, inventory (Equipment held for lease), residual value, and months to maturity. It automates lease accounting calculations, journal entries, and crucial disclosures, serving as a vital working file for General Ledger lease agreement postings.

Key Outputs
This versatile model delivers comprehensive outputs, not confined to any specific industry:
• Monthly and annual lease receivable control accounts by lease agreement, showcasing opening and closing balances, additions, interest income, lease payments, and residual value movements.
• Calculation of months to maturity per lease agreement and weighted averages.
• Internal Rate of Return (IRR) by lease.
• Visual representations via charts illustrating lease receivable progression and breakdown of costs and income per lease.
• Journal entries for selected periods, including additions, lease payments, interest income, and residual value movements.

Key Inputs
The inputs are structured for ease of use, comprising setup inputs and cash flow item inputs. Highlights include:
• Setup Inputs: Customizable fields like business name, currency, lease agreement names, non-cancellable periods, extension and termination options, accounting codes, and posting periods.
• Cash Flow Inputs: Detailed inputs covering costs of leased assets, fair values, initial direct costs, fixed and variable lease payments, residual values, and other receipts/payments.

Model Structure
The model consists of 8 tabs for inputs ('i_'), calculations ('c_'), outputs ('o_'), and system functionalities. Users populate the 'i_Setup' and 'i_cashflows' tabs, which then feed into calculation tabs to generate results showcased in 'o_summary', 'o_journals', and 'o_Dashboard' tabs. System tabs include a Front Sheet with instructions and a checks dashboard summarizing validation checks.

Key Features
This tool offers numerous user-friendly and efficient functionalities:
• Adherence to best financial modeling practices with thorough instructions, line item explanations, checks, and validations.
• Capacity to handle up to 15 lease agreements, extendable if necessary.
• Flexibility for inclusion of extension and termination options with selectable probability.
• Support for 8 distinct cash flow types per lease, facilitating comprehensive lease analysis.
• Customizable parameters like business name, currency, presentation years, and lease assumptions.
• Checks dashboard for easy error identification and resolution.

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Best Practices in Real Estate, Management Accounting Excel: IFRS 16 Lease Accounting for Lessors Excel Calculation Model Excel (XLSX) Spreadsheet, Projectify


$55.00
This financial model is built by former Deloitte financial modeling professionals, accountants, and CFA charterholders. Their financial models have been used by over 4,000+ clients worldwide.
Add to Cart
  

OVERVIEW

File Type: Excel xlsx (XLSX)
Secondary File: Excel xlsx (XLSX)
File Size: 2.8 MB

Terms of usage (for all documents from Projectify)

ABOUT THE AUTHOR

Author: Projectify
Additional documents from author: 100

We are financial modelling professionals, accountants and CFA charterholders with experience working within Deloitte supporting clients with their financial planning and decision support needs. Our aim is to provide robust and easy-to-use financial models that follow good practice financial modelling guidelines and assist individuals and businesses with key financial planning and analysis processes. [read more]

Ask the Author a Question

Must be logged in

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.




Trusted by over 10,000+ Client Organizations
Since 2012, we have provided best practices to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab




Read Customer Testimonials





Customers Also Like These Documents

Related Management Topics


Real Estate Integrated Financial Model Management Accounting Private Equity Financial Management Financial Analysis Costing Pricing Strategy Cost Reduction Assessment

Download our FREE Strategy & Transformation Framework Templates

Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more.