# Research on Interest Rate Risk of Housing Mortgage Loan Based on Computer Simulation

Authors: Enlin Tang
Journal: Computational Intelligence and Neuroscience
 (2021)

---

## Abstract

In recent years, with the rapid increase of the business volume of housing mortgage loans of commercial banks, the risk of prepayment is increasingly exposed. Prepayment will have a great impact on the duration and convexity of housing mortgage loans of commercial banks and then bring difficulties to the asset liability management of banks. Therefore, empirical research on the changes of duration and convexity of housing mortgage loans caused by prepayment when the market interest rate changes is of great significance for commercial banks to manage interest rate risk exposure. Based on the analysis of the option characteristics of prepayable housing mortgage loan, the CIR model with GARCH(1, 1) is selected to describe the interest rate change path, and the computer simulation method is used to calculate OAS and then calculate the effective duration and effective convexity of housing mortgage loan under different prepayment rates, so as to understand the interest rate risk of housing mortgage loan in the presence of embedded option.


---

## Body

## 1. Introduction

Since the 1980s, China’s real estate market began to start. After several years of tortuous development, it entered a stable development stage in 1995. Since then, China’s real estate market has seized the important opportunity of urban housing system reform and started to take off. In the context of the prosperity and development of the real estate market, in 1992, China Construction Bank began to issue the first housing mortgage loan business. This innovative financial way enabled most people who could not afford to buy a house with full payment to realize their dream of buying a house. It not only greatly improved the consumption ability of Chinese urban residents but also stimulated the demand of the whole real economy. It promotes the rapid growth of GDP. When the total amount of personal consumption credit in the whole society is growing rapidly and the housing mortgage loan business of commercial banks is booming, the risks contained in the housing mortgage loan, as the main assets of banks, are increasingly exposed, especially the phenomenon of loan prepayment caused by the changes of benchmark interest rate of deposit loan and personal income is becoming more and more obvious. That is to say, the prepayment risk of housing mortgage is exposed [1]. In 2004, in the principles of interest rate risk management and supervision, the basic committee has clearly pointed out that the option risk caused by prepayment belongs to interest rate risk [2]. Under the background of interest rate marketization in China, commercial banks will face frequent and large fluctuation of benchmark interest rate of deposit and loan in the future, so commercial banks have to face up to the phenomenon of prepayment of housing mortgage loan and take active measures to deal with the interest rate risk of housing mortgage loan caused by prepayment [3]. Therefore, studying the impact of prepayment on the duration and convexity of housing mortgage loan from the microperspective can provide some ideas for commercial banks to manage interest rate risk.


## 2. Analysis on the Option Characteristics of Housing Mortgage Loan

### 2.1. Influencing Factors of Prepayment of Housing Mortgage Loan

#### 2.1.1. Interest Rate

The interest rate factor is the primary factor to determine the prepayment behavior. The interest rate factor here refers to the difference between the contract interest rate and the market interest rate. The contract interest rate determines the interest expense of the loan, and the market interest rate determines the refinancing cost for prepayment. Suppose the borrower prepays at timet, the cost of refinancing is expressed as Vt, the penalty is expressed as α, and the loan balance at t is expressed as Lt. When Wt=Vt−Lt+α is greater than zero, the borrower will choose to prepay.


#### 2.1.2. Economic Factors

With the increase of population and family income under the three child policies, people’s demand for improved housing increases, so there will be the phenomenon of prepaying the mortgage loan of old housing. In addition, when the national macroeconomy is running well, the whole real estate market is hot. When the rise of house prices exceeds the balance of mortgage loans, there will be a large number of prepayment behaviors.


#### 2.1.3. Institutional Factors

Commercial banks have formulated a series of regulations on prepayment of housing mortgage loans, such as the minimum repayment amount of each prepayment, the level of default interest for prepayment, and the limit of the times of prepayment.


#### 2.1.4. Other Factors

Other factors are relocation, characteristics of mortgage loans, and seasons [4–6].


### 2.2. An Analysis of Option Characteristics of Housing Loan

In order to clarify the option characteristics of prepayable housing mortgage loan more clearly, this paper assumes that a borrower and a commercial bank sign a loan contract with a term ofT at time 0. In the contract, the loan amount is expressed as 1, the penalty is α, and the loan interest rate is expressed as continuous compound interest rate r0,T. Without considering prepayment, the total cost of borrowing is er0,TT, assuming that the benchmark interest rate changes to r1,T at time t, and the refinancing cost is er0,Tt+αer1,TT−t; if er0,TT≥er0,Tt+αer1,TT−t, the rational borrower will prepay; otherwise, the prepayment will not be executed. This method can be used for similar analysis at any time of interest rate adjustment.At timet, the mathematical expression of the borrower’s borrowing cost is(1)−miner0,Tt+αer1,TT−t,er0,TT=−er0,TT−miner0,Tt+αer1,TT−t−er0,TT,0=−er0,TT+maxer0,TT−er0,Tt+αer1,TT−t,0.In formula (1), −er0,TT represents a loan contract with default risk, and maxer0,TT−er0,Tt+αer1,TT−t,0 represents an interest rate call option with the price of K=er0,TT implied in the loan contract.The housing mortgage loan of commercial banks can be understood as the borrower issues bonds to the bank that can be repaid in advance. This kind of bonds implies options. At any time during the loan contract period, the borrower can choose to repay in advance. Therefore, such a loan contract can be decomposed into the borrower issuing callable bonds to the bank; the bank issued an American callable option to the borrower (as shown in Figure1), in which A was often ignored by the bank, and the bank did not charge the option fee to the borrower [7, 8].Figure 1
Decomposition of housing mortgage business.


### 2.3. Measurement of Interest Rate Risk of Housing Mortgage Loan in the Presence of Embedded Options

When the embedded option exists, the traditional duration and convexity will lose the accuracy in measuring the interest rate risk of housing mortgage loan. At this time, in order to measure the interest rate risk of housing mortgage loan more accurately, we introduce effective durationDeff and effective convexity Ceff [9], whose expressions are as follows:(2)Deff=P+−P−2ΔrP0,(3)Ceff=P+−2P0+P−Δr2P0.The meanings ofP+ and P− in formulas (2) and (3) are as follows:(4)P+=1m∑j=1m∑t=1nCFtj∏i=1t1+rij+Δr+OAS,(5)P−=1m∑j=1m∑t=1nCFtj∏i=1t1+rij−Δr+OAS.In formulas (2) and (3), Δr is the base point of interest rate difference; P0 is the initial value of the bond; P+ represents the bond price when the interest rate moves upward by a certain base point; P− is the bond price when the interest rate drops to a certain base point; and m in expressions P+ and P− represents the number of interest rate change paths.In formulas (4) and (5), t is the period of cash flow generation; j is the j-th path of interest rate change; n is the total term of the contract; CFtj refers to the cash flow of period t under the path of interest rate change in article j; rij refers to the market interest rate of period i under the path of interest rate change in article j; and OAS is the risk compensation after eliminating the embedded option when the theoretical value of the bond is equal to the market value. OAS is the basis for calculating the effective duration and effective convexity; its mathematical expression is as follows:(6)P=1m∑j=1m∑t=1nCFtj∏i=1t1+rij+OAS,where P represents the market price of the bond; 1/m is the mean value of risk neutral probability measure. In the formula, the calculation of OAS depends on the simulation of interest rate path. When simulating the interest rate path, the selected interest rate model should not only conform to the assumed stochastic process characteristics but also conform to the initial interest rate term structure. Then, based on cash flow and discount factor, P+ and P− are obtained, and then the effective duration and effective convexity are calculated [10, 11].


## 2.1. Influencing Factors of Prepayment of Housing Mortgage Loan

### 2.1.1. Interest Rate

The interest rate factor is the primary factor to determine the prepayment behavior. The interest rate factor here refers to the difference between the contract interest rate and the market interest rate. The contract interest rate determines the interest expense of the loan, and the market interest rate determines the refinancing cost for prepayment. Suppose the borrower prepays at timet, the cost of refinancing is expressed as Vt, the penalty is expressed as α, and the loan balance at t is expressed as Lt. When Wt=Vt−Lt+α is greater than zero, the borrower will choose to prepay.


### 2.1.2. Economic Factors

With the increase of population and family income under the three child policies, people’s demand for improved housing increases, so there will be the phenomenon of prepaying the mortgage loan of old housing. In addition, when the national macroeconomy is running well, the whole real estate market is hot. When the rise of house prices exceeds the balance of mortgage loans, there will be a large number of prepayment behaviors.


### 2.1.3. Institutional Factors

Commercial banks have formulated a series of regulations on prepayment of housing mortgage loans, such as the minimum repayment amount of each prepayment, the level of default interest for prepayment, and the limit of the times of prepayment.


### 2.1.4. Other Factors

Other factors are relocation, characteristics of mortgage loans, and seasons [4–6].


## 2.1.1. Interest Rate

The interest rate factor is the primary factor to determine the prepayment behavior. The interest rate factor here refers to the difference between the contract interest rate and the market interest rate. The contract interest rate determines the interest expense of the loan, and the market interest rate determines the refinancing cost for prepayment. Suppose the borrower prepays at timet, the cost of refinancing is expressed as Vt, the penalty is expressed as α, and the loan balance at t is expressed as Lt. When Wt=Vt−Lt+α is greater than zero, the borrower will choose to prepay.


## 2.1.2. Economic Factors

With the increase of population and family income under the three child policies, people’s demand for improved housing increases, so there will be the phenomenon of prepaying the mortgage loan of old housing. In addition, when the national macroeconomy is running well, the whole real estate market is hot. When the rise of house prices exceeds the balance of mortgage loans, there will be a large number of prepayment behaviors.


## 2.1.3. Institutional Factors

Commercial banks have formulated a series of regulations on prepayment of housing mortgage loans, such as the minimum repayment amount of each prepayment, the level of default interest for prepayment, and the limit of the times of prepayment.


## 2.1.4. Other Factors

Other factors are relocation, characteristics of mortgage loans, and seasons [4–6].


## 2.2. An Analysis of Option Characteristics of Housing Loan

In order to clarify the option characteristics of prepayable housing mortgage loan more clearly, this paper assumes that a borrower and a commercial bank sign a loan contract with a term ofT at time 0. In the contract, the loan amount is expressed as 1, the penalty is α, and the loan interest rate is expressed as continuous compound interest rate r0,T. Without considering prepayment, the total cost of borrowing is er0,TT, assuming that the benchmark interest rate changes to r1,T at time t, and the refinancing cost is er0,Tt+αer1,TT−t; if er0,TT≥er0,Tt+αer1,TT−t, the rational borrower will prepay; otherwise, the prepayment will not be executed. This method can be used for similar analysis at any time of interest rate adjustment.At timet, the mathematical expression of the borrower’s borrowing cost is(1)−miner0,Tt+αer1,TT−t,er0,TT=−er0,TT−miner0,Tt+αer1,TT−t−er0,TT,0=−er0,TT+maxer0,TT−er0,Tt+αer1,TT−t,0.In formula (1), −er0,TT represents a loan contract with default risk, and maxer0,TT−er0,Tt+αer1,TT−t,0 represents an interest rate call option with the price of K=er0,TT implied in the loan contract.The housing mortgage loan of commercial banks can be understood as the borrower issues bonds to the bank that can be repaid in advance. This kind of bonds implies options. At any time during the loan contract period, the borrower can choose to repay in advance. Therefore, such a loan contract can be decomposed into the borrower issuing callable bonds to the bank; the bank issued an American callable option to the borrower (as shown in Figure1), in which A was often ignored by the bank, and the bank did not charge the option fee to the borrower [7, 8].Figure 1
Decomposition of housing mortgage business.


## 2.3. Measurement of Interest Rate Risk of Housing Mortgage Loan in the Presence of Embedded Options

When the embedded option exists, the traditional duration and convexity will lose the accuracy in measuring the interest rate risk of housing mortgage loan. At this time, in order to measure the interest rate risk of housing mortgage loan more accurately, we introduce effective durationDeff and effective convexity Ceff [9], whose expressions are as follows:(2)Deff=P+−P−2ΔrP0,(3)Ceff=P+−2P0+P−Δr2P0.The meanings ofP+ and P− in formulas (2) and (3) are as follows:(4)P+=1m∑j=1m∑t=1nCFtj∏i=1t1+rij+Δr+OAS,(5)P−=1m∑j=1m∑t=1nCFtj∏i=1t1+rij−Δr+OAS.In formulas (2) and (3), Δr is the base point of interest rate difference; P0 is the initial value of the bond; P+ represents the bond price when the interest rate moves upward by a certain base point; P− is the bond price when the interest rate drops to a certain base point; and m in expressions P+ and P− represents the number of interest rate change paths.In formulas (4) and (5), t is the period of cash flow generation; j is the j-th path of interest rate change; n is the total term of the contract; CFtj refers to the cash flow of period t under the path of interest rate change in article j; rij refers to the market interest rate of period i under the path of interest rate change in article j; and OAS is the risk compensation after eliminating the embedded option when the theoretical value of the bond is equal to the market value. OAS is the basis for calculating the effective duration and effective convexity; its mathematical expression is as follows:(6)P=1m∑j=1m∑t=1nCFtj∏i=1t1+rij+OAS,where P represents the market price of the bond; 1/m is the mean value of risk neutral probability measure. In the formula, the calculation of OAS depends on the simulation of interest rate path. When simulating the interest rate path, the selected interest rate model should not only conform to the assumed stochastic process characteristics but also conform to the initial interest rate term structure. Then, based on cash flow and discount factor, P+ and P− are obtained, and then the effective duration and effective convexity are calculated [10, 11].


## 3. Analysis on the Option Characteristics of Housing Mortgage Loan

### 3.1. Selection of Cases and Determination of Interest Rate Model

The 5-year housing loan of China Construction Bank with the amount of 300000 yuan is selected for analysis. The loan is repaid with equal principal and interest, and the starting date of the loan is November 1, 2019. At the same time, assuming that there are no extra expenses such as intermediate and tax, any amount of prepayment can be made, and the penalty is one month’s repayment. For the sake of simplicity, the variables in the case are represented by letter parameters, as shown in Table1.Table 1
Parameters and significance.
ParameterSignificanceMPtRepayment of phasetMBt−1Loan balance of phaset − 1ib7-day interbank offered ratei=ib+2%Mortgage interest ratenTotal loan termSMMtPrepayment rate of phasetMPt=MBt−1i1+in−t+1/1+in−t+1−1Repayment of phasetIt=MBt−1∗iInterest payable of phasetSPt=MPt−ItPrincipal repayment amount of phasetPRt=SMMtMBt−SPtPrepayment amount of phasetMBt+1=MBt−PRt−SPtOutstanding part oft + 1 principalCt=It+SPt+PRtCash flow from loans of phasetIn order to get the term structure of risk-free interest rate, we select the data of interest bearing bonds on November 1, 2019, to split the coupon from the interest bearing bonds. Using EViews software regression, the final expression of discount factor is as follows [12, 13]:(7)dt=a0+a1t+a2t2+a3t3=1−0.018121t−0.002416t2+0.000099t3.The risk-free interest rate data are further calculated by the discount factor and depicted, as shown in Figure2.Figure 2
Risk-free interest rate term structure.As for the choice of interest rate model, the 7-day interbank offered rate from November 4, 2018, to November 2, 2020, is compounded, and then the ADF test is carried out. The results are shown in Table2.Table 2
ADF test results.
ADF test statistic−3.6599691% critical value−3.40135% critical value−2.860210% critical value−2.5698MacKinnon critical values for rejection of hypothesis of a unit rootIt can be seen from the results in Table2 that the data do not have unit root and are a stationary series. Therefore, in the selection of interest rate model, we consider the CIR model, that is, it has the feature of mean reversion. However, it is found that the residual graph has the “clustering” feature during the fitting, and the ARCH−LM test with the lag order P=3 is further taken. The results are shown in Table 3.Table 3
ARCH-LM test results.
Breusch-Godfrey serial correlation LM testF-statistic2.200313Prob. F (3,744)0.0839Obs∗R−squared6.601124Prob. chi-square (3)0.0841It can be seen from Table3 that the values of P are small, which means that the residual series has ARCH effect. Therefore, GARCH1,1 is added to modify and the parameter estimation results are brought into the formula. The final expression of interest rate model is as follows:(8)dr=0.009890.96033−rdt+1.00898σεrdz.In equation (8), σε satisfies σε2=0.929687+0.348012εt−12+0.640113σεt−12, and then ARCH−LM test is carried out. The results are shown in Table 4.Table 4
ARCH-LM test results.
Heteroskedasticity test: ARCHF−statistic0.279036Prob. F (3,742)0.8772Obs∗R−squared0.735012Prob. chi−square30.8766The twoP values in Table 4 are large, which indicates that the model with GARCH(1,1) can be used as an interest rate model.


### 3.2. Selection of Computer Simulation Methods

Monte Carlo simulation was developed in the mid-1940s to adapt to the development of atomic energy at that time. It is a random simulation method, also known as random sampling or statistical test method. Based on probability theory and mathematical statistics, Monte Carlo simulation belongs to a branch of computational mathematics. Traditional empirical methods cannot approach the real physical process, and it is difficult to get satisfactory results. Monte Carlo method can simulate the actual physical process, so it can get the results in line with the actual situation. The use of Monte Carlo simulation is very dependent on computer technology. The core of the problem is to convert the problem to probability model and to solve the problem by using random number or pseudorandom number. Therefore, it is necessary to realize random sampling by computer [14, 15]. In this article, in the process of calculating OAS, effective duration, and effective convexity, it is necessary to simulate the interest rate change path in advance. Therefore, Monte Carlo computer simulation method is used to describe the interest rate change path.


### 3.3. Empirical Analysis Based on Monte Carlo Simulation

Based on the above CIR interest rate model withGARCH1,1, Monte Carlo simulation is carried out here. The loan cash flow is calculated on the basis of the simulated interest rate change path. The prepayment rate refers to the PSA prepayment rate model (as shown in formula (9)) [6]:(9)CPR=0.2%⋅t,1≤t≤30,6%,t>30.The calculation process of cash flow in phase 1 is as follows:(10)MB0=300000,MP1=MB0i1+in−t+11+in−t+1−1=30⋅i1+i601+i60−1,I1=MB0∗i=0.1323,SP1=MP1−I1=0.4375,PR1=SMM1MB0−SP1=0.05913,C1=I1+SP1+PR1=0.62893,Ck=Ik+SPk+PRk,….Using the same principle and method, we calculate the cash flow of the following periods in turn, then discount the cash flow of each period, choose the sum of risk-free interest rate and OAS as the discount rate, and constantly try and error OAS until the weighted average of each cash flow is equal to the market price of mortgage assets [16–18]. The calculation flow chart of OAS is shown in Figure 3.Figure 3
Calculation flow chart of option-adjusted spread.On the basis of OAS value, formulas (2) and (3) are used to calculate the effective duration and effective convexity, and the final calculation results are obtained, as shown in Table 5.Table 5
Calculation results of effective duration and effective convexity.
50%PSA100% PSA150%PSANo embedded optionSimulation results2.161%30.09952.24%30.05022.31%30.04621.91%30.08052.261%30.00122.33%30.00112.39%30.00121.99%30.00122.398%29.90152.39%29.94932.52%29.96022.09%29.9302OAS (%)2.26022.33022.4012—Deff1.881.60121.39522.49863Ceff53.70656.6954−118.9674138.8735From the empirical results, when there is no prepayment (no embedded option) of the mortgage, the effective duration is 2.49863. When the prepayment rate is 50% PSA, the effective duration is 1.88. When the prepayment rate is 100% PSA, the effective duration is 1.6012, and the effective duration is 1.3952 when the prepayment rate is 150% PSA.When there is no prepayment (no embedded option), the effective convexity is 138.8735; when the prepayment rate is 50% PSA, the effective convexity is 53.7065; when the prepayment rate is 100% PSA, the effective convexity is 6.6954; when the prepayment rate is 150% PSA, the effective duration is −118.9674.


## 3.1. Selection of Cases and Determination of Interest Rate Model

The 5-year housing loan of China Construction Bank with the amount of 300000 yuan is selected for analysis. The loan is repaid with equal principal and interest, and the starting date of the loan is November 1, 2019. At the same time, assuming that there are no extra expenses such as intermediate and tax, any amount of prepayment can be made, and the penalty is one month’s repayment. For the sake of simplicity, the variables in the case are represented by letter parameters, as shown in Table1.Table 1
Parameters and significance.
ParameterSignificanceMPtRepayment of phasetMBt−1Loan balance of phaset − 1ib7-day interbank offered ratei=ib+2%Mortgage interest ratenTotal loan termSMMtPrepayment rate of phasetMPt=MBt−1i1+in−t+1/1+in−t+1−1Repayment of phasetIt=MBt−1∗iInterest payable of phasetSPt=MPt−ItPrincipal repayment amount of phasetPRt=SMMtMBt−SPtPrepayment amount of phasetMBt+1=MBt−PRt−SPtOutstanding part oft + 1 principalCt=It+SPt+PRtCash flow from loans of phasetIn order to get the term structure of risk-free interest rate, we select the data of interest bearing bonds on November 1, 2019, to split the coupon from the interest bearing bonds. Using EViews software regression, the final expression of discount factor is as follows [12, 13]:(7)dt=a0+a1t+a2t2+a3t3=1−0.018121t−0.002416t2+0.000099t3.The risk-free interest rate data are further calculated by the discount factor and depicted, as shown in Figure2.Figure 2
Risk-free interest rate term structure.As for the choice of interest rate model, the 7-day interbank offered rate from November 4, 2018, to November 2, 2020, is compounded, and then the ADF test is carried out. The results are shown in Table2.Table 2
ADF test results.
ADF test statistic−3.6599691% critical value−3.40135% critical value−2.860210% critical value−2.5698MacKinnon critical values for rejection of hypothesis of a unit rootIt can be seen from the results in Table2 that the data do not have unit root and are a stationary series. Therefore, in the selection of interest rate model, we consider the CIR model, that is, it has the feature of mean reversion. However, it is found that the residual graph has the “clustering” feature during the fitting, and the ARCH−LM test with the lag order P=3 is further taken. The results are shown in Table 3.Table 3
ARCH-LM test results.
Breusch-Godfrey serial correlation LM testF-statistic2.200313Prob. F (3,744)0.0839Obs∗R−squared6.601124Prob. chi-square (3)0.0841It can be seen from Table3 that the values of P are small, which means that the residual series has ARCH effect. Therefore, GARCH1,1 is added to modify and the parameter estimation results are brought into the formula. The final expression of interest rate model is as follows:(8)dr=0.009890.96033−rdt+1.00898σεrdz.In equation (8), σε satisfies σε2=0.929687+0.348012εt−12+0.640113σεt−12, and then ARCH−LM test is carried out. The results are shown in Table 4.Table 4
ARCH-LM test results.
Heteroskedasticity test: ARCHF−statistic0.279036Prob. F (3,742)0.8772Obs∗R−squared0.735012Prob. chi−square30.8766The twoP values in Table 4 are large, which indicates that the model with GARCH(1,1) can be used as an interest rate model.


## 3.2. Selection of Computer Simulation Methods

Monte Carlo simulation was developed in the mid-1940s to adapt to the development of atomic energy at that time. It is a random simulation method, also known as random sampling or statistical test method. Based on probability theory and mathematical statistics, Monte Carlo simulation belongs to a branch of computational mathematics. Traditional empirical methods cannot approach the real physical process, and it is difficult to get satisfactory results. Monte Carlo method can simulate the actual physical process, so it can get the results in line with the actual situation. The use of Monte Carlo simulation is very dependent on computer technology. The core of the problem is to convert the problem to probability model and to solve the problem by using random number or pseudorandom number. Therefore, it is necessary to realize random sampling by computer [14, 15]. In this article, in the process of calculating OAS, effective duration, and effective convexity, it is necessary to simulate the interest rate change path in advance. Therefore, Monte Carlo computer simulation method is used to describe the interest rate change path.


## 3.3. Empirical Analysis Based on Monte Carlo Simulation

Based on the above CIR interest rate model withGARCH1,1, Monte Carlo simulation is carried out here. The loan cash flow is calculated on the basis of the simulated interest rate change path. The prepayment rate refers to the PSA prepayment rate model (as shown in formula (9)) [6]:(9)CPR=0.2%⋅t,1≤t≤30,6%,t>30.The calculation process of cash flow in phase 1 is as follows:(10)MB0=300000,MP1=MB0i1+in−t+11+in−t+1−1=30⋅i1+i601+i60−1,I1=MB0∗i=0.1323,SP1=MP1−I1=0.4375,PR1=SMM1MB0−SP1=0.05913,C1=I1+SP1+PR1=0.62893,Ck=Ik+SPk+PRk,….Using the same principle and method, we calculate the cash flow of the following periods in turn, then discount the cash flow of each period, choose the sum of risk-free interest rate and OAS as the discount rate, and constantly try and error OAS until the weighted average of each cash flow is equal to the market price of mortgage assets [16–18]. The calculation flow chart of OAS is shown in Figure 3.Figure 3
Calculation flow chart of option-adjusted spread.On the basis of OAS value, formulas (2) and (3) are used to calculate the effective duration and effective convexity, and the final calculation results are obtained, as shown in Table 5.Table 5
Calculation results of effective duration and effective convexity.
50%PSA100% PSA150%PSANo embedded optionSimulation results2.161%30.09952.24%30.05022.31%30.04621.91%30.08052.261%30.00122.33%30.00112.39%30.00121.99%30.00122.398%29.90152.39%29.94932.52%29.96022.09%29.9302OAS (%)2.26022.33022.4012—Deff1.881.60121.39522.49863Ceff53.70656.6954−118.9674138.8735From the empirical results, when there is no prepayment (no embedded option) of the mortgage, the effective duration is 2.49863. When the prepayment rate is 50% PSA, the effective duration is 1.88. When the prepayment rate is 100% PSA, the effective duration is 1.6012, and the effective duration is 1.3952 when the prepayment rate is 150% PSA.When there is no prepayment (no embedded option), the effective convexity is 138.8735; when the prepayment rate is 50% PSA, the effective convexity is 53.7065; when the prepayment rate is 100% PSA, the effective convexity is 6.6954; when the prepayment rate is 150% PSA, the effective duration is −118.9674.


## 4. Conclusion

(1)
When the embedded option exists, that is, the mortgage loan is allowed to prepay, the characteristics of duration and convexity of mortgage assets will change. The traditional duration and convexity will lose accuracy in measuring the interest rate risk of the mortgage loan, so it is necessary to introduce the effective duration and effective convexity to measure the interest rate risk.(2)
The effective duration decreases with the increase of prepayment rate, and the effective convexity also decreases with the increase of prepayment rate. Especially when the prepayment rate reaches a certain degree, the effective convexity will become negative, that is, the value interest rate curve of assets bends in the opposite direction.(3)
When the fluctuation of interest rate causes the borrowers of housing mortgage to choose prepayment, the interest rate risk of loan assets of commercial banks will appear. In this case, when managing the interest rate risk, commercial banks need to rematch the assets and liabilities according to the effective duration and effective convexity, so as to reduce or eliminate the interest rate risk exposure.



---

*Source: 6035022-2021-08-24.xml*