This report lists accretion and depreciation by period (calendar month, fiscal period, or fiscal year) for the entire life of each ARO. You may report each ARO individually or combine all AROs for a lease.
Report options unique to this report:
Extend Non-Terminated AROs Until at Least
Since AROs continue until explicitly terminated, you can choose to extend the accretion tables past the scheduled end date. Any ARO that isn’t explicitly terminated which has a scheduled end date before the date specified will be extended. Only accretion of the liability is recognized after the scheduled end date; the asset remains, fully depreciated.
Report Periods By
You may have the schedule display one line per calendar month, per fiscal period, or per fiscal year. (Fiscal dates are set in System Options, Fiscal Dates tab.)
Display AROs on Spreadsheet
This option is enabled only if you select spreadsheet output. If you choose horizontally, the second ARO is displayed to the right of the first (in columns I-N). If 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. If you choose vertical output, the second ARO is displayed underneath the first. If the number of rows needed exceeds 65536 for a .xls format spreadsheet, EZLease creates additional tabs.
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, or for each fiscal period, 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. If the report is run by fiscal period, two more columns show the fiscal period and year on a spreadsheet; text output doesn’t have enough space for this.
For spreadsheet output, 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).
If you create text output, each ARO (or lease) is displayed vertically.