Methods and systems for assessing loan portfolios
AssigneeGE Corporate Financial Services, Inc.
InventorsTim Kerry Keyes, Santosh Kumar Srinivas, Marshall Gaines Burchard, Catharine Lynn Midkiff
Life of this patent
Estimating the term…
Abstract
Methods and systems for assessing a loan portfolio for variance are described. In an example embodiment, the method comprises the steps of identifying a milestone for at least one loan in the portfolio at a selected time of assessment, determining planned collections for the loan for the selected time of assessment, determining actual collections for the loan the selected time period of assessment, and populating a spreadsheet identifying a current milestone and a cumulative variance between planned collections and actual collections at the milestone for the loan.
Claims17
A method for assessing a loan portfolio comprising a plurality of non-performing loans, said method comprising the steps of:
- assigning at least one characteristic to each loan included within the portfolio including at least one of size of outstanding balance, nature of collateral security, lien information, historical payment performance, litigation status, and underwritten valuation;
- identifying a current milestone for each loan included within the portfolio at a selected time of assessment from a series of predefined milestones, wherein the series of predefined milestones represent different stages that non-performing loans experience prior to resolution including at least one of not contacted, in negotiation, scheduled for approval, approved, approved delinquent, closed, closed delinquent, paid-in-full, and foreclosed;
- creating a business plan for each loan included within the portfolio including planned collections and timing of collections for each loan;
- electronically segmenting the loan portfolio based on the at least one characteristic assigned to each loan;
- electronically determining planned collections for each loan for the selected time of assessment;
- electronically determining actual collections for each loan for the selected time period of assessment;
- electronically populating a spreadsheet identifying the current milestone and a cumulative variance between planned collections and actual collections at the current milestone for each loan;
- and
- electronically determining a contribution of a portfolio segment to an overall cumulative loan portfolio variance, wherein the portfolio segment includes each loan included within the portfolio having an assigned characteristic that correlates with a loan characteristic selected by a user for analysis.
A variance tracking system, said database comprising a computer coupled to a database said database comprising a memory storage having data stored therein, said database comprising:
- at least one characteristic associated with each of a plurality of non-performing loans included within a loan portfolio, wherein the at least one characteristic assigned to each loan includes at least one of size of outstanding balance, nature of collateral security, lien information, historical payment performance, litigation status, and underwritten valuation;
- a current milestone for each of the plurality of loans, wherein the current milestone is included within a series of predefined milestones, wherein the series of predefined milestones represent different stages that non-performing loans experience prior to resolution including at least one of not contacted, in negotiation, scheduled for approval, approved, approved delinquent, closed, closed delinquent, paid-in-full, and foreclosed;
- a business plan for each of the plurality of loans including planned payments and timing of payments for each loan;
- segments of the loan portfolio based on the at least one characteristic assigned to each loan;
- actual payments for each loan;
- indexes of time associated with each planned payment and with each actual payment;
- a variance between each planned payment and each actual payment;
- and
- wherein the computer is programmed to electronically determine a contribution of each portfolio segment to an overall cumulative loan portfolio variance, wherein each portfolio segment includes each loan included within the portfolio having an assigned characteristic that correlates with a loan characteristic selected by a user for analysis.
A computer program for controlling operation of a computer to determine variance in a loan portfolio of non-performing loans, said computer program executable to control the computer to:
- assign at least one characteristic to each loan included within the portfolio including at least one of size of outstanding balance, nature of collateral security, lien information, historical payment performance, litigation status, and underwritten valuation;
- associate each loan in the portfolio with one of a plurality of milestones, wherein the milestones represent different stages that non-performing loans experience prior to resolution including at least one of not contacted, in negotiation, scheduled for approval, approved, approved delinquent, closed, closed delinquent, paid-in-full, and foreclosed;
- create a business plan for each loan included within the portfolio including planned collections and timing of collections for each loan;
- segment the loan portfolio based on the at least one characteristic assigned to each loan;
- electronically determine cumulative planned collections for each loan for a selected time of assessment;
- electronically determine cumulative actual collections for each loan for the selected time period of assessment;
- electronically determine a cumulative variance for each loan for the selected time period of assessment based on the cumulative planned collections and cumulative actual collections;
- and
- electronically determine a contribution of each portfolio segment to an overall cumulative loan portfolio variance, wherein each portfolio segment includes each loan included within the portfolio having an assigned characteristic that correlates with a loan characteristic selected by a user for analysis.
A variance tracker system for tracking variance in a loan portfolio of non-performing loans, said system comprising:
- a database comprising a memory storage having data stored therein, said data comprising at least one characteristic assigned to each loan including at least one of size of outstanding balance, nature of collateral security, lien information, historical payment performance, litigation status, and underwritten valuation;
- and
- a processor coupled to said database, said processor programmed to:
- associate each loan in the portfolio with a current milestone at a selected time of assessment from a series of predefined milestones, wherein the series of predefined milestones represent different stages that non-performing loans experience prior to resolution including at least one of not contacted, in negotiation, scheduled for approval, approved, approved delinquent, closed, closed delinquent, paid-in-full, and foreclosed;
- store a business plan within the database for each loan included within the portfolio including planned collections and timing of collections for each loan;
- segment the loan portfolio based on the at least one characteristic assigned to each loan;
- determine cumulative planned collections for each loan for a selected time of assessment;
- determine cumulative actual collections for each loan for the selected time period of assessment;
- determine a cumulative variance for each loan for the selected time period of assessment based on the cumulative planned collections and cumulative actual collections;
- and
- determine a contribution of each portfolio segment to an overall cumulative loan portfolio variance, wherein each portfolio segment includes each loan included within the portfolio having an assigned characteristic that correlates with a loan characteristic selected by a user for analysis.
Dependencies are inferred from the claim text.