Matrix Pricing

Matrix Pricing

When fixed-rate bonds are not actively traded, or there is no market price to calculate the rate of return required by investors, it is common practice to estimate the market discount rate and price based on quoted or flat prices of more frequently traded comparable bonds with similar credit quality, maturity, and coupon rates. This estimation process is called matrix pricing.

Illustrative Example

Assume that an analyst needs to value a 4-year, 5% annual coupon payment bond, Bond-K, which is not actively traded. The analyst could find some other bonds with comparable credit quality:

  • bond-L: 3-year, 5.5% annual coupon payment bond at a price of 108; and
  • bond-M: 5-year, 4.5% annual coupon payment bond at a price of 105.

Therefore, we start with the following matrix:

$$
\begin{array}{l|c|c|c}
\text{} & \begin{array}{c} \text{4.5%-coupon} \\ \text{Bond} \end{array} & \begin{array}{c} \text{5%-coupon} \\ \text{Bond} \end{array} & \text{5.5%-coupon Bond} \\
\hline
\text{3-year Bond} & \text{} & \text{} & \begin{array}{c} \text{Price = 108} \\ \text{YTM = ?} \end{array} \\
\hline
\text{4-year Bond} & \text{} & \begin{array}{c} \text{Price = ?} \\ \text{YTM = ?} \end{array} & \text{} \\
\hline
\text{5-year Bond} & \begin{array}{c} \text{Price = 105} \\ \text{YTM = ?} \end{array} & \text{} & \text{} \\
\end{array}
$$

Step 1: Find the Yield-to-Maturity of Observed Bonds

Using the financial calculator for Bond-L: N=3; PV=-108; PMT=5.5; FV=100; CPT => I/Y = 2.6887. The required yield on Bond-L is 2.69%.

For Bond-M: N=5; PV=-105; PMT=4.5; FV=100; CPT => I/Y = 3.3959. The required yield on Bond-M is 3.40%.

We now have two more data points in our matrix:

$$
\begin{array}{l|c|c|c}
\text{} & \begin{array}{c} \text{4.5%-coupon} \\ \text{Bond} \end{array} & \begin{array}{c} \text{5%-coupon} \\ \text{Bond} \end{array} & \text{5.5%-coupon Bond} \\
\hline
\text{3-year Bond} & \text{} & \text{} & \begin{array}{c} \text{Price = 108} \\ \text{YTM = 2.69%} \end{array} \\
\hline
\text{4-year Bond} & \text{} & \begin{array}{c} \text{Price = ?} \\ \text{YTM = ?} \end{array} & \text{} \\
\hline
\text{5-year Bond} & \begin{array}{c} \text{Price = 105} \\ \text{YTM = 3.4%} \end{array} & \text{} & \text{} \\
\end{array}
$$

Step 2: Find the Yield-to-Maturity of the Non-Actively Traded Bond

The estimated market discount rate for a 4-year bond that has the same credit quality is the average of two required yields:

$$ YTM_{Bond-K} = \frac{2.69\% + 3.40\%}{2} = 3.045\% $$

We now have the following matrix:

$$
\begin{array}{l|c|c|c}
\text{} & \begin{array}{c} \text{4.5%-coupon} \\ \text{Bond} \end{array} & \begin{array}{c} \text{5%-coupon} \\ \text{Bond} \end{array} & \text{5.5%-coupon Bond} \\
\hline
\text{3-year Bond} & \text{} & \text{} & \begin{array}{c} \text{Price = 108} \\ \text{YTM = 2.69%} \end{array} \\
\hline
\text{4-year Bond} & \text{} & \begin{array}{c} \text{Price = ?} \\ \text{YTM = 3.045%} \end{array} & \text{} \\
\hline
\text{5-year Bond} & \begin{array}{c} \text{Price = 105} \\ \text{YTM = 3.4%} \end{array} & \text{} & \text{} \\
\end{array}
$$

Step 3: Find the Price of the Non-Actively Traded Bond

Given an estimated yield-to-maturity of 3.045%, the estimated price of the 4-year 5% illiquid bond is 107.26 per 100 of each par value. To find this value, we need to plug in the following variables into the financial calculator: N=4; I/Y=3.045; PMT=5; FV=100; CPT => PV = -107.26

Alternatively, we could use a timeline to find the same value:

$$
\begin{array}{l|ccccc}
\text{Time Period} & 1 & 2 & 3 & 4\\
\hline
\text{Calculation} & \frac {\$5}{{\left(1+3.045\%\right)}^{ 1 } } & \frac { \$5 }{ { \left( 1+3.045\% \right) }^{ 2 } } & \frac { \$5 }{ { \left( 1+3.045\% \right) }^{ 3 } } & \frac { \$105 }{ { \left( 1+3.045\% \right) }^{ 4 } } \\
\hline
\text{Cash Flow} & \$4.85 & +\$4.70 & +\$4.56 & +\$92.92 & =\$107.03 \\
\end{array}
$$

Benefits of Matrix Pricing

Matrix pricing is also used during the underwriting process to estimate the required yield spread over the benchmark rate. In this context, the benchmark rate is the yield-to-maturity of a similar government bond. Yield spreads are often stated in terms of basis points (bps). For example, if we have a yield-to-maturity of 3.75% and the comparable government bond yield (or benchmark rate) is 2.5%, the yield-spread will be 1.25% or 125 bps.

Question

Matrix pricing allows investors to estimate:

  1. The bond coupon rates for bonds that are comparable to government bonds.
  2. The market discount rates as well as the prices for bonds that are not actively traded.
  3. The required yield spread as well as prices for bonds that become substantially risky after initial issuance of a bond.

Solution

The correct answer is B.

Matrix pricing is a price estimation process that uses market discount rates based on the quoted prices of similar bonds (similar maturity, coupon rates, and credit quality) when a fixed-rate bond is not actively traded or there is no market price.

Shop CFA® Exam Prep

Offered by AnalystPrep

Featured Shop FRM® Exam Prep Learn with Us

    Subscribe to our newsletter and keep up with the latest and greatest tips for success

    Shop Actuarial Exams Prep Shop Graduate Admission Exam Prep


    Sergio Torrico
    Sergio Torrico
    2021-07-23
    Excelente para el FRM 2 Escribo esta revisión en español para los hispanohablantes, soy de Bolivia, y utilicé AnalystPrep para dudas y consultas sobre mi preparación para el FRM nivel 2 (lo tomé una sola vez y aprobé muy bien), siempre tuve un soporte claro, directo y rápido, el material sale rápido cuando hay cambios en el temario de GARP, y los ejercicios y exámenes son muy útiles para practicar.
    diana
    diana
    2021-07-17
    So helpful. I have been using the videos to prepare for the CFA Level II exam. The videos signpost the reading contents, explain the concepts and provide additional context for specific concepts. The fun light-hearted analogies are also a welcome break to some very dry content. I usually watch the videos before going into more in-depth reading and they are a good way to avoid being overwhelmed by the sheer volume of content when you look at the readings.
    Kriti Dhawan
    Kriti Dhawan
    2021-07-16
    A great curriculum provider. James sir explains the concept so well that rather than memorising it, you tend to intuitively understand and absorb them. Thank you ! Grateful I saw this at the right time for my CFA prep.
    nikhil kumar
    nikhil kumar
    2021-06-28
    Very well explained and gives a great insight about topics in a very short time. Glad to have found Professor Forjan's lectures.
    Marwan
    Marwan
    2021-06-22
    Great support throughout the course by the team, did not feel neglected
    Benjamin anonymous
    Benjamin anonymous
    2021-05-10
    I loved using AnalystPrep for FRM. QBank is huge, videos are great. Would recommend to a friend
    Daniel Glyn
    Daniel Glyn
    2021-03-24
    I have finished my FRM1 thanks to AnalystPrep. And now using AnalystPrep for my FRM2 preparation. Professor Forjan is brilliant. He gives such good explanations and analogies. And more than anything makes learning fun. A big thank you to Analystprep and Professor Forjan. 5 stars all the way!
    michael walshe
    michael walshe
    2021-03-18
    Professor James' videos are excellent for understanding the underlying theories behind financial engineering / financial analysis. The AnalystPrep videos were better than any of the others that I searched through on YouTube for providing a clear explanation of some concepts, such as Portfolio theory, CAPM, and Arbitrage Pricing theory. Watching these cleared up many of the unclarities I had in my head. Highly recommended.