Systems and methods for financial stress testing
Embodiments provide computerized stress testing for evaluating the effect of changes in the financial position of one or more borrowers. A stressed financial parameter (e.g., a risk rating or financial ratio) is generated for a borrower based on a selection of a borrower account type, a stress amount for applying to the account type, and additional financial inputs corresponding to the borrower. In some cases the stressed financial parameter is generated as a function of an unstressed financial parameter for the borrower, the stress amount, a numerator factor corresponding to the selected account type, and a denominator factor corresponding to the selected account type. Systems, methods, and computer-readable media are provided with the stress testing functionality.
1. A computerized method for borrower stress testing, comprising:
receiving by one or more processors a selection of an account type so as to establish a selected account type;
receiving by one or more processors a stress amount for applying to the selected account type;
receiving by one or more processors an input regarding financial information of a borrower from a database in a computer-readable memory device, the database comprising information related to a plurality of account types of the borrower; and
generating by one or more processors a stressed financial ratio for the borrower as a function of an unstressed financial ratio for the borrower, the stress amount, a numerator factor corresponding to the selected account type, and a denominator factor corresponding to the selected account type, wherein
the unstressed financial ratio is a function of a financial ratio numerator and a financial ratio denominator,
the numerator factor is a function of the financial ratio numerator and a numerator account value for the selected account type, and
the denominator factor is a function of the financial ratio denominator and a denominator account value for the selected account type.
2. The computerized method of claim 1 , further comprising generating by one or more processors a stressed risk rating for the borrower as a function of the stressed financial ratio.
3. The computerized method of claim 1 , wherein generating the stressed financial ratio comprises generating by one or more processors the stressed financial ratio according to one of a first relationship being
R
(
X
)
=
r
(
1
-
XM
)
(
1
+
XN
)
,
and a second relationship being
R
(
X
)
=
r
(
1
+
XM
)
(
1
-
XN
)
,
wherein r is the unstressed financial ratio, M is the numerator factor, N is the denominator factor, X is the stress amount, and R(X) is the stressed financial ratio.
4. The computerized method of claim 3 , wherein M=A m /m and N=A n /n, and wherein A m is the numerator account value for the selected account type, m is the financial ratio numerator, A n is the denominator account value for the selected account type, and n is the financial ratio denominator.
5. The computerized method of claim 3 , wherein generating the stressed financial ratio comprises generating the stressed financial ratio so that a larger value indicates a more desirable ratio value when the first relationship is used and a smaller value indicates a more desirable ratio value when the second relationship is used.
6. The computerized method of claim 3 , wherein generating the stressed financial ratio comprises generating by one or more processors at least two different stressed financial ratios for the borrower using, for each of the at least two different stressed financial ratios, the first and/or the second relationship and a corresponding unstressed ratio, a corresponding stress amount, a corresponding numerator factor, and a corresponding denominator.
7. The computerized method of claim 3 , wherein generating the stressed financial ratio comprises generating by one or more processors at least fifteen different stressed financial ratios for the borrower using, for each of the at least fifteen different stressed ratios, the first and/or the second relationship and a corresponding unstressed ratio, a corresponding stress amount, a corresponding numerator factor, and a corresponding denominator factor.
8. The computerized method of claim 1 , wherein the database comprises information related to a plurality of borrowers, and further comprising receiving a selection of a subset of the plurality of borrowers and generating by one or more processors the stressed financial ratio for each borrower within the subset of the plurality of borrowers.
9. The computerized method of claim 8 , further comprising generating by one or more processors a migration table showing changes between unstressed financial ratios and the stressed financial ratios for the subset of the plurality of borrowers.
10. The computerized method of claim 1 , further comprising receiving a selection of a financial ratio for generating the stressed financial ratio.
11. The computerized method of claim 1 , further comprising receiving a selection of a risk rating and generating by one or more processors a stressed risk rating for the borrower as a function of the stressed financial ratio.
12. The computerized method of claim 1 , further comprising receiving a selection of an additional account type so as to establish a selected additional account type;
receiving a stress amount for applying to the selected additional account type; and
generating by one or more processors the stressed financial ratio for the borrower additionally as a function of the selected additional account type, the stress amount for the selected additional account type, a numerator factor corresponding to the selected additional account type, and a denominator factor corresponding to the selected additional account type, wherein
the numerator factor corresponding to the selected additional account type is a function of the financial ratio numerator and a numerator account value for the selected additional account type, and
the denominator factor corresponding to the selected additional account type is a function of the financial ratio denominator and a denominator account value for the selected additional account type.
13. The computerized method of claim 1 , wherein the unstressed financial ratio is selected from the group of financial ratios consisting of term debt coverage ratio, current ratio, quick ratio, debt to tangible net worth ratio, debt to asset ratio, equity to asset ratio, loan to collateral ratio, collateral to loan ratio, gross profit margin ratio, operating income ratio, operating expense ratio, net profit margin ratio, working capital to gross revenues ratio, return on assets ratio, return on equity ratio, return on investment ratio, income sensitivity ratio, expense sensitivity ratio, and interest rate sensitivity ratio.
14. A computer-readable memory device comprising executable instructions for causing one or more processors to:
receive a selection of an account type so as to establish a selected account type;
receive a stress amount for applying to the selected account type;
receive an input from a database regarding financial information of a borrower, the database comprising information related to a plurality of account types of the borrower; and
generate a stressed financial ratio for the borrower as a function of an unstressed financial ratio for the borrower, the stress amount, a numerator factor corresponding to the selected account type, and a denominator factor corresponding to the selected account type, wherein
the unstressed financial ratio is a function of a financial ratio numerator and a financial ratio denominator,
the numerator factor is a function of the financial ratio numerator and a numerator account value for the selected account type, and
the denominator factor is a function of the financial ratio denominator and a denominator account value for the selected account type.
15. A system for borrower stress testing, comprising:
one or more processors adapted for carrying out computer-executable instructions; and
one or more computer-readable memory devices coupled to the one or more processors, the one or more computer-readable memory devices comprising executable instructions for causing the one or more processors to
receive a selection of an account type so as to establish a selected account type,
receive a stress amount for applying to the selected account type,
receive an input from a database regarding financial information of a borrower, the database comprising information related to a plurality of account types of the borrower, and
generate a stressed financial ratio for the borrower as a function of an unstressed financial ratio for the borrower, the stress amount, a numerator factor corresponding to the selected account type, and a denominator factor corresponding to the selected account type, wherein
the unstressed financial ratio is a function of a financial ratio numerator and a financial ratio denominator,
the numerator factor is a function of the financial ratio numerator and a numerator account value for the selected account type, and
the denominator factor is a function of the financial ratio denominator and a denominator account value for the selected account type.
16. The system of claim 15 , wherein the executable instructions for causing the one or more processors to generate the stressed financial ratio comprise executable instructions for causing the one or more processors to generate the stressed financial ratio according to one of a first relationship being
R
(
X
)
=
r
(
1
-
XM
)
(
1
+
XN
)
,
and a second relationship being
R
(
X
)
=
r
(
1
+
XM
)
(
1
-
XN
)
,
wherein r is the unstressed financial ratio, M is the numerator factor, N is the denominator factor, X is the stress amount, and R(X) is the stressed financial ratio.
17. The system of claim 16 , wherein M=A m /m and N=A n /n, and wherein A m is the numerator account value for the selected account type, m is the financial ratio numerator, A n is the denominator account value for the selected account type, and n is the financial ratio denominator.
18. The system of claim 16 , wherein the executable instructions for causing the one or more processors to generate the stressed financial ratio comprise executable instructions for causing the one or more processors to generate at least two different stressed financial ratios for the borrower using, for each of the at least two different stressed financial ratios, the first and/or the second relationship and a corresponding unstressed ratio, a corresponding stress amount, a corresponding numerator factor, and a corresponding denominator factor.
19. The system of claim 15 , wherein the database comprises information related to a plurality of borrowers, and wherein the executable instructions further comprise executable instructions for causing the one or more processors to receive a selection of a subset of the plurality of borrowers and generate the stressed financial ratio for each borrower within the subset of the plurality of borrowers.
20. The system of claim 15 , wherein the executable instructions further comprise executable instructions for causing the one or more processors to receive a selection of a financial ratio for generating the stressed financial ratio.
21. The system of claim 15 , wherein the executable instructions further comprise executable instructions for causing the one or more processors to generate a stressed risk rating for the borrower as a function of the stressed financial ratio.
22. The system of claim 15 , wherein the executable instructions further comprise executable instructions for causing the one or more processors to
receive a selection of an additional account type so as to establish a selected additional account type;
receive a stress amount for applying to the selected additional account type; and
generate the stressed financial ratio for the borrower additionally as a function of the selected additional account type, the stress amount for the selected additional account type, a numerator factor corresponding to the selected additional account type, and a denominator factor corresponding to the selected additional account type, wherein
the numerator factor corresponding to the selected additional account type is a function of the financial ratio numerator and a numerator account value for the selected additional account type, and
the denominator factor corresponding to the selected additional account type is a function of the financial ratio denominator and a denominator account value for the selected additional account type.
23. The system of claim 15 , wherein the unstressed financial ratio is selected from the group of financial ratios consisting of term debt coverage ratio, current ratio, quick ratio, debt to tangible net worth ratio, debt to asset ratio, equity to asset ratio, loan to collateral ratio, collateral to loan ratio, gross profit margin ratio, operating income ratio, operating expense ratio, net profit margin ratio, working capital to gross revenues ratio, return on assets ratio, return on equity ratio, return on investment ratio, income sensitivity ratio, expense sensitivity ratio, and interest rate sensitivity ratio.