Funding Schedule [R0111]

The Funding Schedule report [R0111] provides a comparison of debt + equity (from borrowings) and principal outstanding (from leases/loans), based on the existing portfolio, projected to the maturity dates of the borrowings or leases/loans. Borrowings are debts (or, liabilities) to the client and should be stored on LeasePak in separate offices and using the lease type of ‘BORR’.

The report is organized by Fiscal Quarter. The report may be accessed through the Strategic Management report menu [R01] and may be selected interactively for:

• all offices
• a portfolio
• a company
• a region
• an office

Funding Schedule Selection

• EQUITY
  Enter the amount of equity to be added to each quarter of the DEBT + EQUITY column.

• INCLUDE/EXCLUDE
  Enter ‘I’ to include specific portfolios, companies, regions, and/or offices. Enter ‘E’ to exclude specific portfolios, companies, regions, and/or offices.

• PORT (scrolled area)
  Enter the number of the portfolio upon which to report. Leave blank if reporting across portfolios.

• COMP (scrolled area)
  Enter the number of the company upon which to report. Leave blank if reporting across companies.

• REGN (scrolled area)
  Enter the number of the region upon which to report. Leave blank if reporting across regions.
  
  
• OFFIC (scrolled area)
  Enter the number of the office upon which to report. Leave blank if reporting across offices.

Funding Schedule Report

The Funding Schedule report [R0111] provides a single page of information by fiscal quarter and year:

• YEAR
  The year is displayed, starting with the current year. The first line of the report contains information previous to the current quarter, and is marked ‘PAST DUE’.

• QTR
  The fiscal quarter is displayed, starting with the current quarter. The first line of the report contains information previous to the current quarter, and is marked ‘PAST DUE’.
  
  
• DEBT + EQUITY
  The total outstanding borrowings as of each quarter end plus the amount of equity, as entered on the selection screen, is displayed. Borrowings are designated by a lease type of ‘BORR’.
  
  
• PRINCIPAL OUTSTANDING
  The total outstanding principal balance of leases as of each quarter end is displayed. Leases are designated by a lease type other than ‘BORR’. Operating leases are not included in the report.

• OVER (SHORTFALL)
  The difference between the DEBT + EQUITY and the PRINCIPAL OUTSTANDING is displayed. OVER (SHORTFALL) is calculated as follows:

  DEBT + EQUITY
  - PRINCIPAL OUTSTANDING

  If the DEBT + EQUITY is greater than the PRINCIPAL OUTSTANDING, a positive number is displayed (OVER). If the DEBT + EQUITY is less than the PRINCIPAL OUTSTANDING, a bracketed number is displayed (SHORTFALL).

• AVERAGE
  The average of the OVER or SHORTFALL for each year is displayed. It is the sum of the OVER and SHORTFALL (shortfall is negative) for each quarter of the year divided by the number of quarters in the year.

• PAYBACK
  The payback is the AVERAGE of the next year less the AVERAGE of the current year for each year on the report.

• BORROWINGS YIELD
  The weighted average yield of all the borrowings for each quarter is displayed.

• LEASE/LOAN YIELD
  The weighted average yield of all the leases for each quarter is displayed.

Additional Notes

While this is a very specialized report, it could be used generically as a simple type of forecasting report of future principal outstandings.

This report is not related to the funding interest fields on the Book Lease option of the New Lease update [U0101].

Because this report may take a long time to create, it should be executed in batch mode or when the system load is light.

© 2001 by McCue Systems Incorporated.
All rights reserved.

The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.