Question

In: Finance

How to solve using financial calculator In order to pay for all of its Super Bowl...

How to solve using financial calculator

  1. In order to pay for all of its Super Bowl commercials, assume that Anheuser-Busch issued a bunch of bonds on January 1, 2019 with the following terms:
          Par Value                                                        $10,000,000
          Maturity                                                          20 years (January 1, 2039)
          Annual Coupon                                               6% annual rate
          Market Required Yield-to-Maturity               6% annual rate (at time of issuance)
          Payment frequency                                         Semi-annual (every 6 months)
                                                                                                                                              (8 points)
    1. How much cash did Anheuser-Busch receive upon issuance in January? (Ignore any possible fees or transaction costs – what was the market value of the bonds?)






    2. Now assume that the annual coupon rate was 8% instead of 6%. How much would Anheuser-Busch have received at issuance in this case (and all other terms were the same as above)?









    3. Now imagine it’s January 1, 2024. What would be the market value of the bonds if the annual yield-to-maturity has increased to 8% (and the annual coupon rate were 6%, with semi-annual payments)?




Solutions

Expert Solution

Solution for A)

The market required yield-to-maturity was equal to the coupon rate. When this happens, the bond's market rate = bond's par value.

Hence, in this case, Anheuser-Busch would have received the par value of all the bonds, which is $10,000,000

Solution for B

Now, the coupon rate is 8%. To find out the current price of the bond, we will use a financial calculator and input details. Let's assume the price of 1 bond = $1,000

Currently, there are 20 years till maturity. hence, since the bond pays coupons semiannually,

n = 20 * 2 = 40,

I/Y is YTM/2 = 6/2 = 3

PMT = (8%/2) * $1,000 = $40

FV = future value = par value of the bond = $1,000

inputting all these details into your financial calculator, you will get, PV = $1,231.14772

Next, we calculate how much Anheuser-Busch would have received under these conditions

for every $ 1,000 worth of bond par value Anheuser-Busch is getting $1,231.14772. Hence for total par value of $10,000,000, Anheuser-Busch will get, $10,000,000 *$1,231.14772/$1,000 = $12,311,477.2 (without rounding up intermediate calculations)

Solution for C

In this case, the coupon rate remains at 6%, but YTM is 7%. To find out the current price of the bond, we will use a financial calculator and input details. Let's assume the price of 1 bond = $1,000

In 2024, there are 15 years till maturity. hence, since the bond pays coupons semiannually,

n = 15 * 2 = 30,

I/Y is YTM/2 = 8/2 = 4

PMT = (6%/2) * $1,000 = $30

FV = future value = par value of the bond = $1,000

inputting all these details into your financial calculator, you will get, PV = $827.079667

Next, we calculate how much Anheuser-Busch would have received under these conditions

for every $ 1,000 worth of bond par value Anheuser-Busch is getting $827.079667. Hence for total par value of $10,000,000, Anheuser-Busch will get, $10,000,000 * $827.079667/$1,000 = $8,270,796.67


Related Solutions

How can I solve this using the HP 10bii financial calculator? A well-known financial writer argues...
How can I solve this using the HP 10bii financial calculator? A well-known financial writer argues that he can earn an extremely high return buying wine by the case. Specifically, he assumes that he will consume one $14 bottle of fine Bordeaux per week for the next 12 weeks. He can either pay $14 per week or buy a case of 12 bottles today. If he buys the case, he receives a discount of 8 percent. Assume he buys the...
Using the internet find 3 companies that had Super Bowl ads-- determine if their money was...
Using the internet find 3 companies that had Super Bowl ads-- determine if their money was well spent.
Using the BAII Plus calculator I am having a difficult time using this calculator to solve...
Using the BAII Plus calculator I am having a difficult time using this calculator to solve this MIRR 0 =-325,000 1=50,000 2= 75,000 3=-60,000 4=225,000 5=300,000 Required rate of return =15% We discount all negative CFs(at 15%) time 0 We compound all positive cash flows (at 15%) to 5 years This is now the TV or Terminal Value Please help me understand how to calculate these numbers?
(Could you solve this by using a financial calculator and just telling me what I need...
(Could you solve this by using a financial calculator and just telling me what I need to input) You would like to have the current equivalent in terms of today's buying power of $3,000 in years 4 5 and 6 How much would you have to invest in years 1, 2 and 3 (the same amount in each year in nominal terms) to fund this level of real consumption? You expect inflation to be 3% per year over that time...
Since its inception in 1967, the Super Bowl has been one of the most watched events...
Since its inception in 1967, the Super Bowl has been one of the most watched events on u.S. television every year. The number of u.S. households that tuned in for each Super Bowl, reported by nielsen.com, is provided in the data set SuperBowlratings. a. Construct a time series plot for the data. What type of pattern exists in the data? discuss some of the patterns that may have resulted in the pattern exhibited in the time series plot of the...
**Solve using NPV on financial calculator You are doing some long-range retirement planning. On the day...
**Solve using NPV on financial calculator You are doing some long-range retirement planning. On the day you retire (23 years from now) you want to be able to withdraw $200,000. Then, you want to withdraw the following amounts at the end of each year after that (during your retirement period).                            Years 1-4            $160,000                            Years 5-9            $175,000                            Years 10-15       $165,000                            Years 16-26       $145,000 At the end of the 26th year in retirement, you’d like to have $500,000...
Please solve using graphing calculator. Include what is typed into calculator in your explaination. For example:...
Please solve using graphing calculator. Include what is typed into calculator in your explaination. For example: First, type the data under L1, then go to STAT --> TESTS -->TInverval. Inpt: Data (highlight the word Data) List: L1 Freq: 1 C-level .98 Calculate--> (3.54, 4.29) Show as much work as you can to support answer. In a Pew Research Center poll 745 randomly selected adults, 589 said that it is morally wrong not to report all income on tax returns. Assume...
How do I solve this system of equations without using a calculator or fancy matrix math?...
How do I solve this system of equations without using a calculator or fancy matrix math? v1 = 1.8 v2 = ? v3 = ? (1) v1 = 1.8 (2) 7150v2+1350v3  = 12780 (3) 7150v22 + 1350v32 = 23166
7. A consulting firm has received 2 Super Bowl playoff tickets from one of its clients....
7. A consulting firm has received 2 Super Bowl playoff tickets from one of its clients. To be fair, the firm is randomly selecting two different employee names to "win" the tickets. There are 8 secretaries, 7 consultants and 5 partners in the firm. Which of the following statements is not true? A) The probability of a secretary winning a ticket on the first draw is 8/20. B) The probability of a secretary winning a ticket on the second draw...
please use HP 10bll financial calculator and type the steps to using the calculator no excell...
please use HP 10bll financial calculator and type the steps to using the calculator no excell please Your firm has a loan on a piece of equipment. the loan was secured on January 1 and it is now December 31. you need to conpute the ineteres pain this year on his loan for rax ourposes. the loan was 80,000, it was a 10 year loan at 8% with monthly oayments. if you have made the first eleven payments, how much...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT