The finance lease amortization schedule gives a complete listing of all rent payments made for each finance (capital) lease, with the associated liability and interest payments, and the depreciation booked for the rent payment period.
The output shows the breakdown of each rent payment into its parts of liability payment, interest payment, and executory costs or nonlease components (if any), as well as the depreciation expense that applies to the period. In order to keep each period on a single line, this report is printed in landscape mode. For each account, both a current period amount and a cumulative amount from lease inception is shown. The Booking Date is ignored for purposes of the schedule (the schedule starts with the first rent payment, even if the Booking Date is later), though the Booking Date is honored in deciding whether the lease is active as of the date specified in the report setup options, and therefore whether the lease should be included in the report.
Payment date/Period end date
If you have chosen to run the report by payment periods, this is the date of the rent payment: the first day of the payment period for a lease paid in advance, the last day of the period for a lease paid in arrears. If you run the report by fiscal period or year, the period end date is shown.
If you have a rent holiday with a daily period length that immediately follows a one-day rent payment, the two are considered as a unit, and the period includes both rent steps. Otherwise, a rent holiday with a daily frequency is treated as a single unit separate from other rent steps; a rent holiday with a longer frequency is shown period by period the same as a regular rent step.
A counter for the number of payments made (with rent holidays counted as described above).
Finance lease rent
Gross rent less any operating rent; if “Erase executory costs” was chosen in the report options, executory costs are also subtracted to calculate this number. This is shown as a negative number, to indicate a credit to cash (the same as the finance rent paid on the Income Statement/Balance Sheet Detail report).
Liability paid by this rent payment. If the interest paid for a period is greater than the net finance rent, this number will be negative, indicating negative principal amortization which causes the liability balance to increase. The life to date liability is either ascending (total paid) or descending (total remaining), depending on the system option Descending asset and liability balances in amort schedule. The current liability is the liability to be paid for the next 12 months.
Payment of interest accrued since the last rent payment was made. Note that for leases paid in advance, this is not the same as the interest expense for the period. For a normal lease paid in advance, the first payment has no interest payment; since the lease has just started, there has been no time for interest to accrue. Interest then accrues during the period and is paid off when the next rent payment is made.
If the “Erase executory costs” report option was selected, this column is omitted from the report. Otherwise, this displays the executory costs, if any, for the period.
The depreciation recognized for the period. If system option Descending asset and liability balances in amort schedule is set, the cumulative number is the net asset for the lease (right-of-use asset minus accumulated depreciation); if the option is not set, the cumulative number is the accumulated depreciation.
Your report title
Enter any title you want to give to the report. The type of report is always displayed at the top left corner; you can use this title to describe the report (such as “Midwest Division”).
You may get lease by lease detail, or just the totals for all leases.
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 may run the report according to the old standard (FAS 13 or IAS 17, depending on which accounting methodology you have chosen in System Options) and the new standard (ASC 842/IFRS 16/GASB 87). While accounting under the old standard is no longer valid after the implementation date (usually 2019/2020), EZLease still permits you to create reports using the old standard for comparison purposes. If you choose the new standard, reports run for dates before the transition date (usually 1/1/2017 or thereabouts, as set in System Options) will be according to the old standard; once the transition date is reached, the leases will be converted to the new standard. A report that includes the actual transition date shows the transition activity required to convert each lease.
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; a report period 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.
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.
Erase executory costs
Capital leases only: By default, the executory costs for each rent payment are shown separately from the gross rent. (If a lease is part capital, part operating, the operating rent is completely excluded from the Capital Amortization Schedule.) You may choose to have the executory costs eliminated, so that the “Capital lease rent” displayed is reduced to just the net capital rent.
Exclude non-leveled leases
Operating leases only: By default, all operating leases (including part-capital, part-operating leases) are listed. If you wish to see only leases with rent leveling, check this box.
Ignore early terminations in schedule
By default, if the lease has an early termination, the amortization 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.
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.
Report periods by
You may have the output displayed by payment periods (each entry is for the length of a rent payment period) or fiscal periods (each entry is for a fiscal calendar period).
Click this button to get a secondary screen which allows you to select special groups of leases and temporarily capitalize operating leases.