# Capsim Simulation Bond Market Summary Explanation

In this Capsim simulation course, there are three bond issues by all six companies. The companies are:

- Andrews
- Baldwin
- Chester
- Digby
- Eire
- Ferris

The industry simulation is the sensor industry. All bonds are ten-year notes. These are the bonds for round zero of two practice rounds.

This article will cover Capsim Simulation for the three bond issues in the sensor industry:

- First bond issue at 11%
- Second bond issue at 12.5%
- Third bond issue at 14%

## Download and Start Spreadsheets

The first bond series number is 11.0S2014. The first three numbers list the bond’s interest rate at 11.0%. The letter S (series) separates the last four numbers, which stand for the year the bond is due (December 31, 2014). The face value of the bond issue is $6,950,000. The bond’s yield is 11.0% and the closing value is $100.00. The bond yield, 11.0%, is the interest rate paid to bondholders, which is equal to (at par) the original interest rate. A closing value of $100.00 means the bond is selling at par value, the original bond offering. The Standard and Poor’s (S&P) Bond Rating of B means the bond is lowly rated and is considered junk.

This bond is currently at par value. Let’s say team Ferris wants to retire the entire bond early. Ferris pays $6,950,000, plus a 1.5% broker's fee ($6,950,000 x 0.015 = $104,250). The broker’s fee is shown within the "other category" on the income statement. The entry to record this reacquisition is: DEBIT: Bonds Payable $6,950,000 and Other-Brokers Fee 104,250 and CREDIT: Cash $7,054,425.

Team Ferris’s cash flows from financing activities show early retirement of long-term debt as a negative number ($6,950,000). On the balance sheet, Ferris’s long-term debt is decreased by $6,950,000.

Sometimes a team wants to pay part of a long-term debt. For example, team Erie pays $1,000,000 of debt on this first bond issue. A broker’s fee of $15,000 ($1,000,000 x 1.5%) is calculated with other fees into the "other category" on the income statement. The face value of the bond is decreased by 1,000,000 ($6,950,000 -$1,000,000 = $5,950,000) plus a factor of $3,422 calculated by the simulation. Therefore the face value of the bond is now $5,953,422 as displayed in the "bond market summary."

BB are considered investment grade bonds. Therefore, these bonds are a good investment and will not default. In the simulation, all companies are issued bonds with a B rating. S&P Bonds rated BB, B, CCC, CC, and C are rated junk bonds. This means these bonds are speculative issues and may default.

## Research and Development

The second bond series number is 12.5S2016. This bond has an interest rate of 12.5% and is due December 31, 2016. The face value of this bond issue is $13,900,000, the yield is 11.9%, and the closing price is $105.30.

This second bond is selling at a premium to the original par value of the bond. Par value is $100.00 and the bond’s closing price is $105.30, which means it has increased in value. There is an inverse relationship between the price of a bond and the bond’s yield. When the value of a bond increases the interest rate/yield decreases. The second bond’s initial interest rate was 12.5%. The present interest/yield rate is 11.9%. If you purchase this bond on the open market you will pay a premium of $5.30 per bond ($105.30 - $100.00) and receive a payment of 11.9% for the year. The interest rate has been reduced by 0.6% (12.5% - 11.9%). The bond has an S&P rating of "B" and is a junk bond.

Team Ferris paid part of this debt issue in the simulation. Ferris paid more than par value to retire part of the debt because the closing price is $105.30 or $5.30 over the par value of $100.00. The excess becomes a loss or write off and is reflected in the "other category" on the "income statement."

## Marketing

The third bond is designated 14.0S2018. Bond number three has an original interest rate of 14.0% and is due December 31, 2018. The face value of the bond issue is $20,850,000. The present yield paid to bondholders is 12.3% and the closing price of the bond is $113.62. This bond has also increased in value and decreased in yield. The bond is selling at a premium of $13.62 ($113.62 - $100.00) and the yearly interest rate paid to a purchaser of the bond on the open market has decreased by 1.7% (14.0% - 12.3%). This bond also has an S&P rating of "B" and is considered junk.

Sometimes bonds are sold at a discount. An example would be a bond with a face value of $10,000,000 at original value/par value of $100 and an interest rate/yield of 7.0%. We will designate this bond series as 07.0S2015. This means the bond has a 7.0% interest rate and is due December 31, 2015. Let’s say the bond’s closing value is now $98.00 and the interest rate is 7.4%. Therefore, the bond is selling at a discount of $2.00 ($98.00 - $100.00 = -$2.00). The interest/yield has increased by 0.4% (7.4% - 7.0%). When the face value of the bond issued is $10,000,000 at $100 PAR value for each bond, you divide $10,000,000 by $100 and get an issue of 100,000 bonds. The S&P rates this bond "A" or investment grade. If you retire this bond and pay a discount, you will gain $200,000 on the repurchase ($10,000,000 x 0.98 = $9,800,000). This is reflected as a negative write off in the "other category" on the income statement. Remember that each time you retire a bond you pay a broker’s fee of 1.5%.

In the Capsim Simulation, bond issues fund long-term capacity and automation. A bond issue can also fund the invention of a new sensor. When a company issues a bond, there is a 5.0% broker’s fee. Let’s say the company Andrews issues $1,000,000 face value of bonds. The cost to Andrews for the bond issue is $1,050,000.($1,000,000 x 0.05 = $50,000 + $1,000,000 = $1,050,000). This $50,000 fee is reflected on the income statement in the "other category."

Note that in Capstone, S&P rates go from AAA to D and ratings are evaluated by comparing the current debt interest rates with the prime rate. When bonds are issued in the simulation, the rate for the issue is 1.4% over the current debt rate. Thus, if the current debt rate is 8.6%, you add 1.4% and get the 10.0% interest rate on the bond issue.

When a bond becomes due, the long-term debt goes to current debt on the balance sheet. Assume you have a face amount of $1,000,000 for bond 12.6S2014. This bond is due on December 31, 2014. On the 2015 spreadsheet, the $1,000,000 goes into current debt and the long-term bond disappears.

If your team has no debt, long term or short term, your company will have an AAA bond rating. Your company’s bond rating slips one category for each additional 0.5% in current debt interest. Thus, your team would have an AA rating instead of an AAA rating if the prime interest rate is 10.0% and your company’s current debt rate is 10.5%.

I hope this lesson helps students understand the bond market summary in the Capstone Simulation.

## Comments

This is so insightful.

The interest rate on your bonds will stay solid as long as that is the type of bond you phurcased. Some bonds have step rates or zero coupon rates. However, it sounds like you are buying a regular bond that has a fixed percent with a fixed term. Each day, the market price of the bond fluctuates based on its selling and buying values. As long as you hold it to maturity, none of this matters. The only down side for a bond these days is the solvency of the company. Like Lehman Bros. Their bond holders just received a notice that they will get $600 from a $5K investment. Bonds are a fab investment right now. Best investment is a mid term bond that would be held for five years. You can get some good ones out there with a term of five years with a 7 plus percentage return. Anything over five years, plan to hold them for a while. Eventually interest rates will go up and if you need to sell your bond, you may not get the full value.

3