Spreadsheet Problem: Bond Ratings and Interest Rate Changes Say thatin June of this year, a company issued bonds that are scheduled tomature three years from now in June. The coupon rate is 5.75 percentand is paid semiannually. The bond issue was rated AAA. (LG7-7)a. Build a spreadsheet that shows how much money the firm pays foreach interest rate payment and when those payments will occur if thebond issue sells 50,000 bonds.b. If the bond issue rating would have been BBB, then the coupon ratewould have been 6.30 percent. Show the interest payments with thisrating. Explain why bond ratings are important to firms issuing capitaldebt.c. Consider that interest rates in the economy increased in the first halfof this year. If the firm would have issued the bonds in January of thisyear, then the coupon rate would have only been 5.40 percent. Howmuch extra money per year is the firm paying because it issued thebonds in June instead of January?

Various credit rating companies provides ratings for bonds issued by the firm based on the credit…

Answered: in June of this year, a company issued…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

You are called in as a financial analyst to appraise the bonds of Olsen's Clothing Stores. The $1,000 par value bonds have a quoted annual interest rate of 10 percent, which is paid semiannually. The yield to maturity on the bonds is 12 percent annual interest. There are 25 years to maturity. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. a. Compute the price of the bonds based on semiannual analysis. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Bond price b. With 20 years to maturity, if yield to maturity goes down substantially to 8 percent, what will be the new price of the bonds? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) New bond price
Marshall Company is issuing eight-year bonds with a coupon rate of 6.19 percent and semiannual coupon payments. If the current market rate for similar bonds is 9.23 percent. If the company wants to raise $1.25 million, how many bonds does the firm have to sell? (Round intermediate calculations to 4 decimal places, e.g. 1.2514 and number of bonds to 0 decimal places, e.g. 5,275.) Number of bonds ______________bonds
NJN, Inc.issues bonds due in 15 years with a coupon/stated interest rate of 7% and a total face value of $400,000. Interest payments are made semi-annually. The market rate for this type of bond is 6%. What is the issue price of the bond (rounded to nearest whole dollar? TVM Tables link (will open in a new window)(opens in new window) Select one: a. $452,259 b. $302,878 c. $400,000 d. $438,849 e. $439,201 Clear my choice
BA Corp is issuing a 10-year bond with a coupon rate of 8 percent. The interest rate for similar bonds is currently 6 percent. Assuming annual payments, what is the value of the bond? Knight, Inc., has issued a three-year bond that pays a coupon rate of 6.10 percent. Coupon payments are made semiannually. Given the market rate of interest of 5.80 percent, what is the market value of the bond? Diane Carter is interested in buying a five-year zero coupon bond with a face value of $1,000. She understands that the market interest rate for similar investments is 9 percent. Assume annual coupon payments. What is the current value of this bond? Ruth Hornsby is looking to invest in a three-year bond that makes semiannual coupon payments at a rate of 5.875 percent. If these bonds have a market price of $981.13, what yield to maturity can she expect to earn? Rudy Sandberg wants to invest in four-year bonds that are currently priced at $868.43. These bonds have a coupon rate of 6 percent and make…
The following information applies to this question: Johnson Corporation plans to obtain financing with a $1,000,000 bond issue that has a term of 10 years. Payments wilI be made semi-annually. if the bond (payment) rate is stated at 7%, and the bonds call for semi-annual payments, what is the amount of those payments? O a. $350,000 O b. $70,000 OC. $35,000 d. $700,000
Serotta Corporation is planning to issue bonds with a face value of $440,000 and a coupon rate of 12 percent. The bonds mature in two years and pay interest quarterly every March 31, June 30, September 30, and December 31. All of the bonds were sold on January 1 of this year. Serotta uses the effective-interest amortization method and also uses a premium account. Assume an annual market rate of interest of 8 percent. (FV of $1, PV of $1, FVA of $1, and PVA of $1) (Use the appropriate factor(s) from the tables provided.) 1. Provide the journal entry to record the issuance of the bonds January 1.
An insurance company is analyzing the following three bonds, each with five years to maturity, annual interest payments, and is using duration as its measure of interest rate risk. What is the duration of each of the three bonds? (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) a. $10,000 par value, coupon rate=9.7%, r 0.17 b. $10,000 par value, coupon rate 11.7%, r= 0.17 c. $10,000 par value, coupon rate = 13.7%, p=0.17 Duration of the bond years
Evans Emergency Response bonds have 8 years to maturity. Interest is paid semiannually. The bonds have a $1,200 par value and a coupon rate of 9 percent. If the price of the bond is $1,093.52, what is the annual yield to maturity? (Do not round intermediate calculations. Input your answer as a percent rounded to 2 decimal places.)
Suppose you sold an issue of bonds with a 5-year maturity, a $1,000 par value, a 10% coupon rate, and annual interest payments according to the following data. 2. a. one year after the bonds were issued, the going rate of interest on bonds such as these fell to 6%. At what price would the bonds sell b. two years after the initial issuance, the going interest rate had risen to 12%. At what price would the bonds sell
(Bond valuation relationships) Arizona Public Utilities issued a bond that pays $80 in interest, with a $1,000 par value. It matures in 25 years. The market's required yield to maturity on a comparable-risk bond is 7 percent. a: Calculate the value of the bond b. How does the value change if the market's required yield to maturity on a comparable-risk bond () increases to 10 percent or (4) decreases to 6 percent? c. Explain the implications of your answers in part b as they relate to interest-rate risk, premium bonds, and discount bonds. d. Assume that the bond matures in 5 years instead of 25 years. Recompute your answers in parts a and b e. Explain the implications of your answers in part d as they relate to interest-rate risk, premium bonds, and discount bonds. a. What is the value of the bond if the markets required yield to maturity on a comparable-risk bond is 7 percent? $1,116.54 (Round to the nearest cent) b. () What is the value of the bond if the market's required yield to…
Bonds issued by the Coleman Manufacturing Company have a par value of $1,000, which is also the amount of principal to be paid at maturity. The bonds are currently selling for $520. They have 10 years to maturity, Annual interest is 12 percent ($120), paid semiannually Compute the yield to maturity. (Do not round intermediate calculation. Use a Financial calculator to arrive at the answers. Round the final answer to 2 decimal places.) Yield to maturity %
Serotta Corporation is planning to issue bonds with a face value of $460,000 and a coupon rate of 8 percent. The bonds mature in two years and pay interest quarterly every March 31, June 30, September 30, and December 31. All of the bonds were sold on January 1 of this year. Serotta uses the effective-interest amortization method and also uses a premium account. Assume an annual market rate of interest of 4 percent. (FV of $1, PV of $1, FVA of $1, and PVA of $1) (Use the appropriate factor(s) from the tables provided.) 1. Provide the journal entry to record the issuance of the bonds January 1. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field. Round your final answers to nearest whole dollar amount.) View transaction list Journal entry worksheet 1 > Record the issuance of the bonds on January 1. Note: Enter debits before credits. Date General Jounral Debit Credit January 01

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS