Good morning
I work in Compliance for a mortgage company, and have no real background in statistics. My company closes loans and sells them to other investors. Between the time that we close a loan and an investor buys a loan there are issues with the loans (called conditions) that have to be resolved before investors will buy the loans.
Each day that passes without the investor buying a loan there is a cost (usually substantial) that occurs, calculated as Expected Revenue (minus) Actual Income. This cost represents the loss of income recieved for the loan. We can’t sell the loan until all of the conditions are cleared, so conditions can be tracked based on the number of days they take to clear (see note at the end of email about the relationship between number of days for conditions and loss of income).
For example, let’s say there are 20 loans closed (a Sample) in a month with Conditions A, B, C. Condition A (A) appears on 10 loans for a total of 100 days, an avg of 10 days per loan. In the end I want to find a way to estimate which of the conditions are the most costly, so we can focus training and a portion of bonuses on the performance of the most costly conditions.
I have been trying to calculate several things: 1) find a way to assign an estimated value to each condition even though there may be several conditions per each loan, each lasting a variable number of days before a final condition is satisfied (I’ve attempted applying a weighted metric derived from percentage of loss from total loss of the whole sample but this isn’t quite doing it) 2) if #1 is too complex then just the best way to Estimated Loss per loan by # of days per each condition. Thank you for any assistance you can provide.
A note: while in most cases the # of days that it takes to satisfy all of the conditions, or the final condition, will determine the Loss of Income for each loan, there are circumstances where no investor will buy a loan and we have to sell it at a greatly reduced price that skews our numbers.
I appreciate any direction you can provide.
Best regards
Jim Lyons
I work in Compliance for a mortgage company, and have no real background in statistics. My company closes loans and sells them to other investors. Between the time that we close a loan and an investor buys a loan there are issues with the loans (called conditions) that have to be resolved before investors will buy the loans.
Each day that passes without the investor buying a loan there is a cost (usually substantial) that occurs, calculated as Expected Revenue (minus) Actual Income. This cost represents the loss of income recieved for the loan. We can’t sell the loan until all of the conditions are cleared, so conditions can be tracked based on the number of days they take to clear (see note at the end of email about the relationship between number of days for conditions and loss of income).
For example, let’s say there are 20 loans closed (a Sample) in a month with Conditions A, B, C. Condition A (A) appears on 10 loans for a total of 100 days, an avg of 10 days per loan. In the end I want to find a way to estimate which of the conditions are the most costly, so we can focus training and a portion of bonuses on the performance of the most costly conditions.
I have been trying to calculate several things: 1) find a way to assign an estimated value to each condition even though there may be several conditions per each loan, each lasting a variable number of days before a final condition is satisfied (I’ve attempted applying a weighted metric derived from percentage of loss from total loss of the whole sample but this isn’t quite doing it) 2) if #1 is too complex then just the best way to Estimated Loss per loan by # of days per each condition. Thank you for any assistance you can provide.
A note: while in most cases the # of days that it takes to satisfy all of the conditions, or the final condition, will determine the Loss of Income for each loan, there are circumstances where no investor will buy a loan and we have to sell it at a greatly reduced price that skews our numbers.
I appreciate any direction you can provide.
Best regards
Jim Lyons