| Coefficients | p-value | |
| Intercept | -9.7267 | 0.0001 |
| X[1] : LTV | 2.7337 | 0.0001 |
| X[2] : Max farmland | -0.3138 | 0.0001 |
| value decline | ||
| X[3] : DSCR | -0.1822 | 0.0003 |
| X[4] : Loan size | 8.222E-7 | 0.0001 |
| X[5] : D/A ratio | 2.3229 | 0.0001 The low p-values on each coefficient indicate a highly significant relationship between loan default and the respective independent variables. Other goodness-of-fit indicators are: |
| Table 1. Financial Positions Used in |
| Performing the Sensitivity Analysis |
| Financial ComponentFinancialFinancial |
| (in millions)Position 1Position 2 |
| Assets$ 2,566$ 3,206 |
| Liabilities2,4813,095 |
| Capital84111 |
| Off-Balance Sheet Assets |
| Overall Portfolio8283,187 |
| Characteristics |
| Lower Credit Risk1,9312,133 |
| Exposure Assets |
| Higher Credit Risk1,4594,260 |
| Exposure Assets We used these two hypothetical financial positions as our initial starting positions. For each initial position, we calculated a "base" case risk-based capital requirement. We then increased or decreased Farmer Mac's risk levels by varying: |
| Table 2.--Changes in Risk-Based Capital |
| Requirements for Changes in Mortgage Characteristics |
| Risk-Based Capital Requirement |
| Sensitivity CasesFinancialFinancial |
| (in millions)Position 1Position 2 |
| 1. Base Case$ 29.5$ 43.2 |
| 2. Origination D/A Ratios38.365.8 |
| Increase |
| 3. Origination LTV Ratios37.263.1 |
| Increase |
| 4. Origination DSCR Decrease30.345.3 |
| 5. Origination Loan Size65.2141.6 |
| Increases |
| 6. Increases Stated 2 to 5109.5266.9 |
| Above Occur Simultaneously The mortgage factors were increased from the base case on a loan-by-loan basis to increase risk levels in Farmer Mac's current portfolio. In each case, the increase in a mortgage factor was limited to the maximum permitted under Farmer Mac's underwriting standards or the unadjusted existing loan origination value, whichever was greater. We used the existing origination values in Farmer Mac's current portfolio as our starting point and then increased and decreased individual loan underwriting ratios to perform our sensitivity testing. The sensitivity tests are: |
| Table 3.--Changes in Risk-Based Capital |
| Requirements for Changes in Loan Age |
| Risk-Based Capital Requirement |
| Sensitivity CasesFinancialFinancial |
| (in millions)Position 1Position 2 |
| 1. Base Case$ 29.5$ 43.2 |
| 2. Loan Age Increases by 126.935.8 |
| year |
| Table 4.--Changes in Risk-Based Capital Requirements |
| for Changes in Interest Rate Risk Exposure |
| Risk-Based Capital |
| Requirement |
| Sensitivity CasesFinancialFinancial |
| (in millions)Position 1Position 2 |
| 1. Base Case$ 29.5$ 43.2 |
| 2. IRR Exposure54.774.9 |
| Increases |
| 3. IRR Exposure16.927.3 |
| Decreases The interest rate environment affects stress test results. When interest rates are low, the rate change used in the stress test is relatively small compared to when interest rates are high. Clearly, interest rates can change by a greater degree when they are high compared to when they are low. In addition, the large changes in interest rates expose Farmer Mac to greater risk. The stress test, therefore, requires higher risk-based capital in rate environments where interest rates are high relative to low rate environments as indicated in the following table: [*61754] |
| Table 5.--Changes in Risk-Based Capital |
| Requirements for Different Initial Rates |
| Risk-Based Capital |
| Requirement |
| Sensitivity CasesInitial RateFinancialFinancial |
| (in millions)(percent)Position 1Position 2 |
| 1. Base Case5.54$ 29.5$ 43.2 |
| 2. Higher Initial Rate11.0862.675.8 |
| Table 6.--Changes in Risk-Based Capital |
| Requirements for Changes in Earning Spreads |
| and Guarantee Fees |
| Risk-Based Capital |
| Requirement |
| Sensitivity CasesFinancialFinancial |
| (in millions)Position 1Position 2 |
| 1. Base Case$ 29.5$ 43.2 |
| 2. Spread Tighten by31.044.2 |
| 5 bp |
| 3. Spread Tighten by33.845.2 |
| 10 bp |
| 4. Guarantee Fee38.459.6 |
| Decrease |
| Year | Proportion of |
| loss (percent) | |
| 1 | 0.58 |
| 2 | 8.30 |
| 3 | 21.98 |
| 4 | 27.56 |
| 5 | 21.99 |
| 6 | 12.45 |
| 7 | 5.18 |
| 8 | 1.57 |
| 9 | 0.33 |
| 10 | 0.05 |
| 11 | 0.00 |
| 12 | 0.00 |
| 13 | 0.00 |
| 14 | 0.00 b. How you must use the loan seasoning distribution is shown in step 7 of section 2.3 of this appendix entitled Example Calculation of Dollar Loss on One Loan. |
| Loan Origination Year | 1996 |
| Loan Origination Balance | $ 1,250,000 |
| LTV at Origination | 0.5 |
| D/A at Origination | 0.5 |
| DSCR at Origination | 1.3984 |
| Maximum Percentage Land | -23.52 |
| Price Decline (MAX | n6 In the example calculations, we rounded numbers. However, the stress test does not use rounded numbers. |
| Non-standby | Standby loans | Blended rate | |
| loans | (percent) | for stress | |
| (percent) | test use | ||
| (percent) | |||
| All States | 3.24 | 0.14 | 2.42 |
| Alaska | 3.24 | 0.00 | 0.00 |
| Alabama | 4.58 | 0.14 | 4.58 |
| Arkansas | 1.97 | 0.14 | 1.97 |
| Arizona | 2.32 | 0.14 | 1.68 |
| California | 3.89 | 0.33 | 3.83 |
| Colorado | 2.78 | 0.14 | 2.78 |
| Connecticut | 3.24 | 0.14 | 2.42 |
| Delaware | 1.90 | 0.14 | 1.90 |
| Florida | 1.46 | 0.00 | 1.42 |
| Georgia | 3.78 | 0.14 | 3.78 |
| Hawaii | 3.24 | 0.44 | 0.44 |
| Iowa | 3.81 | 0.14 | 3.81 |
| Idaho | 2.88 | 0.12 | 1.57 |
| Illinois | 3.95 | 0.31 | 3.86 |
| Indiana | 3.31 | 0.14 | 3.31 |
| Kansas | 1.92 | 0.00 | 1.92 |
| Kentucky | 1.46 | 0.14 | 1.46 |
| Louisiana | 2.06 | 0.14 | 2.06 |
| Massachusetts | 3.24 | 0.14 | 2.42 |
| Maryland | 1.40 | 0.14 | 1.40 |
| Maine | 3.24 | 0.00 | 0.00 |
| Michigan | 2.42 | 0.00 | 2.41 |
| Minnesota | 2.46 | 0.00 | 2.46 |
| Missouri | 2.96 | 0.14 | 2.96 |
| Mississippi | 3.62 | 0.14 | 3.62 |
| Montana | 2.09 | 0.10 | 0.82 |
| North Carolina | 2.31 | 0.00 | 2.12 |
| North Dakota | 2.04 | 0.14 | 2.04 |
| Nebraska | 1.89 | 0.14 | 1.89 |
| New Hampshire | 3.24 | 0.14 | 2.42 |
| New Jersey | 3.24 | 0.81 | 0.81 |
| New Mexico | 3.79 | 0.00 | 3.73 |
| Nevada | 4.74 | 0.00 | 4.62 |
| New York | 1.17 | 0.33 | 1.06 |
| Ohio | 2.05 | 0.14 | 2.05 |
| Oklahoma | 2.13 | 0.14 | 2.13 |
| Oregon | 2.84 | 0.15 | 1.13 |
| Pennsylvania | 3.24 | 0.14 | 2.42 |
| Rhode Island | 3.24 | 0.14 | 2.42 |
| South Carolina | 3.24 | 0.14 | 2.42 |
| South Dakota | 1.49 | 0.14 | 1.49 |
| Tennessee | 1.25 | 0.14 | 1.25 |
| Texas | 4.53 | 0.71 | 4.51 |
| Utah | 2.39 | 0.39 | 2.29 |
| Virginia | 3.55 | 0.29 | 2.40 |
| Vermont | 3.24 | 0.14 | 2.42 |
| Washington | 2.93 | 0.13 | 1.65 |
| Wisconsin | 6.72 | 0.14 | 6.72 |
| West Virginia | 3.24 | 0.14 | 2.42 |
| Wyoming | 2.61 | 0.00 | 2.48 b. How the stress test uses the blended loss rates is discussed in section 4.3 of this appendix entitled Risk Measures. |
| Month end | 10-year |
| CMT monthly | |
| series | |
| 04/1999 | 5.18 |
| 05/1999 | 5.54 |
| 06/1999 | 5.90 |
| Average | 5.54 b. The amount by which the stress test shocks the initial rate up and down is determined by calculating the 12-month average of the 10-year CMT monthly series. If the resulting average is less than 12 percent, the stress test shocks the initial rate by an amount determined by multiplying the 12-month average rate by 50 percent. However, if the average is greater than or equal to 12 percent, the stress test shocks the initial rate by 600 bp. For example, you would determine the amount by which to increase and decrease the initial rate for June 30, 1999 as: |
| Month End | 10-year CMT |
| Monthly | |
| Series | |
| 07/1998 | 5.46 |
| 08/1998 | 5.34 |
| 09/1998 | 4.81 |
| 10/1998 | 4.53 |
| 11/1998 | 4.83 |
| 12/1998 | 4.65 |
| 01/1999 | 4.72 |
| 02/1999 | 5.00 |
| 03/1999 | 5.23 |
| 04/1999 | 5.18 |
| 05/1999 | 5.54 |
| 06/1999 | 5.90 |
| 12-Month Average | 5.10 Calculation of Shock Amount: |
| All other Farmer Mac I program | Long-term standby commitments |
| loans | |
| Loan Number | Loan Number. |
| Ending Scheduled Balance | Current Month Actual Balance. |
| Group | Group. |
| Pre/Post Act | Pre/Post Act. |
| Property State | Property State. |
| Product Type | Product Type. |
| Origination Date | Note Date. |
| Origination Loan Balance | Origination Loan Balance. |
| Origination Scheduled P&I | Cutoff Scheduled P&I. |
| Origination Appraised Value | Most Recent Appraised Value. |
| Loan-to-Value Ratio | Loan-To-Value Ratio. |
| Current Assets | Current Assets. |
| Current Liabilities | Current Liabilities. |
| Total Assets | Total Assets. |
| Total Liabilities | Total Liabilities. |
| Gross Farm Revenue | Gross Farm Revenue. |
| Net Farm Income | Net Farm Income. |
| Depreciation | Depreciation. |
| Interest on Capital Debt | Interest On Capital Debt. |
| Capital Lease Payments | Capital Lease Payments. |
| Living Expenses | Living Expenses. |
| Income & FICA Taxes | Income & FICA Taxes. |
| Net Off-Farm Income | Net Off-Farm Income. |
| Total Debt Service | Total Debt Service. |
| Guarantee Fee | Commitment Fee Rate. |
| Seasoned Loan | Seasoned Loan. (2) From the loan-level data, you must identify the geographic distribution by state of Farmer Mac's loan portfolio and enter the current loan balance for each state in the "Data Inputs" worksheet. We discussed previously how to calculate age-adjusted origination year loss rates in section 2.0 of this appendix entitled Credit Risk. The age-adjusted origination year loss rates, blended across standby and non-standby program assets are entered in the "Risk Measures" worksheet of the stress test. In addition, we discuss how the stress test applies loss rates in section 4.3 of this appendix entitled Risk Measures. |