You may report each ARO individually, or combine all AROs for a lease.
For each lease (or individual ARO, if selected) active during the report period specified, six columns are shown. At the top, the initial ARO, discount rate used, and estimated after-inflation cost to remove are displayed. Month by month for the life of the lease, the accretion expense, non-accretion changes in ARO, cumulative ARO, depreciation expense, and net Asset Retirement Cost asset are displayed.
The current month (defined as the month of the starting date for the report) is highlighted in yellow, and the accretion and depreciation expense for the current month are shown at the top of the section for the lease (row 4). If there are changes and you create an Excel spreadsheet (as opposed to an xml or csv file), a comment is attached to the cell with a change to detail the reason for the change (addition, termination, revision, or rate change).
Spreadsheet output can be laid out horizontally (each lease or ARO to the right of the prior record) or vertically. If you choose horizontal output and you have too many leases with ARO to fit in the number of columns Excel provides (256 for .xls format files, 16,384 for .xlsx format files), EZLease creates additional tabs for the additional leases.
ARO Roll Forward Report |
Type of leases to use
You may limit the report to just the capital leases, just the operating leases, or use both (the default). This option is not displayed for reports that include only capital or only operating leases. If a lease is part-capital, part-operating, the appropriate portion is included if you choose one or the other.
You may get AROs combined by lease, or listed individually.
Group of leases to use
You may choose All leases, a Group of leases starting with the same character(s), or a Single lease. If you choose Single lease, a popup displays the leases in the file; choose the one you want. If you choose Group, you are prompted for the beginning character(s) to search for.
You can create a text report that displays on the screen (and which can then be exported in HTML, PDF, Rich Text Format (.rtf), Microsoft Word® (.doc), Microsoft Excel® (.xls), and Crystal Reports (.rpt) formats). Please note that the Excel output exported from a text report is laid out the same way as the text report, which is generally not well-suited for sorting and otherwise manipulating the data inside Excel. If you export a text report, please wait for the “Export completed successfully” message to display before continuing with EZLease.
You can also create spreadsheet output. This is specifically designed to manipulate inside a spreadsheet program; each account of a journal entries transaction is displayed on a single line, so you can select, sort, and sum results. The same information is provided as on the text report, but the layout is considerably different to facilitate data manipulation. If you select spreadsheet output, you are prompted to specify an output filename.
In System Options, you can select whether the spreadsheet output should be generated as an Excel .xls file, or as an XML-format spreadsheet. Output in Excel format requires that you have a licensed copy of Excel on your computer.
Active as of date
Only leases that are active on the date specified (that is, the lease’s begin date is before this date, and its end date, and early termination date if any, is after this date) are included in the report. If you wish to include all leases, no matter when they are active, select the “List all leases” check box.
List all leases
If this box is checked, then all leases in the file are listed, no matter when they start and end. If this is checked, the “Active as of date” box is grayed out, because the date in it is not used.
Ignore early terminations in schedule
By default, if the lease has an early termination, the schedule stops at that point. Check this box to ignore the early termination and see the schedule as if the lease will continue until normal expiration.
Click this button to get a secondary screen which allows you to select special groups of leases.