Future Loan Collection Estimate Report
Contents
Report Summary
This report provides an estimate of the amount of principal and interest expected to be collected through a specified year. You have the option to also include interest only loans.
Report Criteria
Field | Description |
---|---|
Base Date | Select the date that you wish to use as the base. Base date sets the "as of" date for the report |
Year ending | Set the "as of" year for the report. This year must be the same as or beyond the current fiscal year |
Loan types | If you wish to report only on certain loan types, you can do so here. Type a loan type or types, separated by commas, or click the list icon to select from a list of active loan types in the system. Leave this field blank to report against all loan types |
Loan number | If you wish to report only on one or more loans, you can enter that here. Type a loan number or numbers, separated by commas, or click the list icon to select from a list of loans within the system. Leave this field blank to report on all loans |
Detail mode | If selected, the report will display estimated figures for each loan meeting the other criteria entered |
Include interest only loans | If selected, the report output will include both regular loans and interest only loans |
Print Options
After clicking the Print Options button you will see the following options. Choose the desired options and click OK to return to the report parameters screen.
Option | Description |
---|---|
Printer | Click the drop down arrow to select from a list of available printers. DDI Connect uses your default printer unless told otherwise |
Format | Click the drop down arrow to select from a list of available formats. Select paper size, number of columns, and number of rows for printing. Each report has built-in format defaults. Select “Use Defaults” to use the built-in report defaults. The number of rows and columns controls the print size and amount of information per page |
Memo | If you wish, you can add a memo to the output of the report. NOTE: It is recommended that Word documents be saved with the .docx extension |
View Report | This option generates a pdf file that is displayed on the screen when the report is generated |
Archive Report | If this option is selected, the system will archive the report in the DDI Connect report archives. For information on working with archived reports, please reference this page: Archived Report Viewer |
Print Report | If selected, the system will generate the report output to your default printer. NOTE: You will also receive a pdf version of the report, displayed on your screen |
Print via PDF | Prints directly to your printer. |
This option allows you to send a .pdf attachment of the report to the indicated users' email addresses. When OK is clicked, a dialog box will open requesting a recipient | |
Duplex/Top | Prints the report on both sides of the paper in landscape style. The printer must be capable of printing on both sides or an error will occur |
Duplex/Side | Prints the report on both sides of the paper in portrait style. The printer must be capable of printing on both sides or an error will occur |
Green bar | Adds shaded, horizontal bars to the report, making it easier to read across columns |
No dialog | Selecting this option means that no ‘Report Completed’ dialog will display after the report has been generated |
Extra copies | If you want extra copies of the report generated, type the number in this field |
Report Examples
Summary
Detailed
Selection Logic
- Ending year must be greater than the process date year
- Search all loans
- If necessary, exclude loans that don't match loan number criteria
- Find before/after history as of the ending date
- Exclude loans with a non numeric loan status in before/after history
- Exclude loans that are not in process or closed
- If necessary, exclude interest only loans based on report criteria
- If necessary, exclude loans (based on before/after history) that don't match the desired loan types
Estimation Logic
- Only amortize loans with a closed loan status
- Do not estimate any loans with an unknown payment due date
- Exclude loans where the estimated interest amount exceeds the regular payment amount
- Review next payment date
- Review interest accrued
- Review regular payment amount
- If payment due date is less than the current process date then determine the next loan payment date after the process date
- Cycle through each date up through the ending year range and estimate both the principal and interest paid per loan payment
Sort Logic
- Results sorted by loan type
- Results sub-totaled by loan type
- Results grand-totaled