You are here: Supplements > Five Year Projections

FIVE YEAR PROJECTIONS
Function
To provide cash-flow projections related to loan portfolio, including five year projections of principal to be repaid, interest to be paid, total payments expected, and projected loan balances.


Operating Instructions

Cutoff Date                
This will determine the loan balances reflected on the report, and the “five years” are 12-month periods following the cutoff date. 

Loan #                        
This will default to all loans in your portfolio but may be edited by entering the loan numbers or selecting from the drop downs.

Sort Options              
Report may be sorted by loan number or alphabetically. 

Projection Type        
Options are included to project Principal to be repaid, Interest to be paid, total Repayment expected, and projected loan Balances

Selection Criteria     
Options for narrowing selection criteria include:

Funds 

County 

City 

Status 

Loan Officer 

Loan Type

Borrower 
The following instructions relate to limiting the search to specific Funds, and the same instructions apply to each of the potential criteria above.

If you do not wish to include all loans, click on the Funds tab.  All existing funds will be displayed for your selection.  To select a fund, move the cursor to the fund to be included and click – it will then be highlighted, indicating loans with that fund are to be included on the report.  If you wish to include more funds, hold down the Ctrl key and click on the additional fund to be included.  If you select a fund by mistake, hold down the Ctrl key and click on the fund again – the highlighting will disappear, indicating it no longer is to be included in the selection criteria.  Continue this process until you have narrowed the search to include only those loans you wish to review.

Things You Should Know
  • Each “year” of the projection report represents 12 months of activity.  The report is usually pulled with a cutoff date at the end of a month or the end of a year.  For example, using a cutoff date of 12/31/08, year one represents anticipated activity in 2009, year two represents 2010, etc. 
  • The projections are determined by terms established in the Loan Master file.  Accuracy of basic payment amount, interest rate and payment frequency will determine the accuracy of the projections.  If the projections do not appear to be correct, review the Loan Master file for accurate data. 
  • Projections are determined by an internal amortization schedule.  The loan balance, basic payment amount, payment frequency and interest rates are used to calculate the schedule. 
  • The loan balances listed on the report reflect the balance as of the cutoff date. 
  • If the maturity date is attained within the five year period, the entire remaining balance will be considered due at that time.