Frequently Asked Questions

What can I do to increase performance of the leases model as mine seems to be slow?

The 50 lease model draws a significant amount of computer power.  To improve performance:
 
  • Close all programs except excel
  • Only have the relevant excel spreadsheet open and close all other spreadsheets
  • Turn calculation to manual (formulas/calculation options/manual)
If you have tried all of the above and are still experiencing issues, please feel free to email vicleasesupport@moorestephens.com.au.

What does the operating lease account represent?

The operating lease account represents the balance sheet items in your financial statements under the previous lease accounting standard.  Typically, it represents the unamortised lease incentive and straight lining accrual.  To see more details on this account go to the calculation tab on the spreadsheet and expand the boxes for a particular lease.  There is a separate calculation of the ‘Accrual’ each month which you can track.
 
What happens if the operating lease account doesn’t equal what I have in my Balance sheet on transition?

The model makes certain assumptions regarding the lease incentives and straight lining accruals under the old standard.  Any variation between what the model calculates for the operating lease account and your actual balance on transition should be treated as follows:
 
  • Transition options 1 and 2 adjust the entry to retained earnings (for instance if the model calculates the operating lease account as $20,000 and your actual balance on transition is $15,000 then increase the entry to retained earnings by $5,000)
  • Transition option 3 adjust the entry to ROU asset (for instance if the model calculates the operating lease account as $20,000 and your actual balance on transition is $15,000 then increase the entry to ROU asset by $5,000)
The above entries can not be hard coded into the model but rather as an adjustment in your actual ledger system when posting the entry.

What does the ‘consolidated FS Impacts’ tab in the transition model represent?

The tab compares the existing standard (AASB 117) to option 1 under the new standard (AASB 16).
 
  • The EBITDA line = operating lease expense under the existing standard (no expense in EBITDA under the new standard)
  • The EBIT line compares the expenses under the existing standard to option 1 under the new standard (excluding interest)
  • The NPBT line compares the expenses under the existing standard to option 1 under the new standard (shows overall impact of new standard
Can the model produce monthly journals?

Yes it can.  Expand the boxes on the calculations tab in either model to find the monthly journals.