Capsim Simulation Bond Market Summary Explanation

Updated on March 14, 2018
JamesCage profile image

In 2014, James retired from teaching at Georgian Court University, where he taught the Capsim business simulation for four years.

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

  1. Andrews
  2. Baldwin
  3. Chester
  4. Digby
  5. Eire
  6. 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

    0 of 8192 characters used
    Post Comment

    • JamesCage profile imageAUTHOR

      JamesCage 

      16 months ago from New Jersey

      Heather,

      Thanks

      James

    • profile image

      Heather 

      16 months ago

      This is so insightful.

    • profile image

      Diakaridia 

      3 years ago

      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.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, owlcation.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://owlcation.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)