An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000 8.1%. Bond C pays a 10.5% annual coupon, while Bond Z is a zero coupon bond. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Assuming that the yield to maturity of each bond remains at 8.1% over the next 4 years, calculate the price of the bonds át each of the following years to maturity. Do not round intermediate calculations. Round your answers to the nearest cent.

An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000 8.1%. Bond C pays a 10.5% annual coupon, while Bond Z is a zero coupon bond. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Assuming that the yield to maturity of each bond remains at 8.1% over the next 4 years, calculate the price of the bonds át each of the following years to maturity. Do not round intermediate calculations. Round your answers to the nearest cent.

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

A bond with face value $1399 and a term of 11 years pays quarterly coupons of 11% per annum. The bond is offered at a price of $1050. You are to enter the above values into a spreadsheet, along with - an initial wild guess at what the yield would be, and - a calculation of the bond price using your guess as the yield. (a) Use Excel’s “Solver” (which is different from “Goal Seek”) to solve for the actual yield that produces the correct bond price. Take a screen shot of your computer with “Solver” open showing clearly the entries that you put into Solver. Paste the screen shot into an application (like Paint), and save it as a (.png) file. Upload your screenshot below. (b) What is the yield calculated by Solver?
You have been hired as a consultant for Pristine Urban-Tech Zither, Incorporated (PUTZ), manufacturers of fine zithers. The market for zithers is growing quickly. The company bought some land three years ago for $2.65 million in anticipation of using it as a toxic waste dump site but has recently hired another company to handle all toxic materials. Based on a recent appraisal, the company believes it could sell the land for $2.85 million on an aftertax basis. In four years, the land could be sold for $3.05 million after taxes. The company also hired a marketing firm to analyze the zither market, at a cost of $325,000. An excerpt of the marketing report is as follows: The zither industry will have a rapid expansion in the next four years. With the brand name recognition that PUTZ brings to bear, we feel that the company will be able to sell 6,600, 7,300, 7,900, and 6,200 units each year for the next four years, respectively. Again, capitalizing on the name recognition of PUTZ, we feel…
A bond trader purchased each of the following bonds at a yield to maturity of 9%. Immediately after she purchased the bonds, interest rates fell to 6%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet What is the percentage change in the price of each bond after the decline in interest rates? Assume annual coupons and annual compounding. Fill in the following table. Do not round intermediate calculations. Round your answers to two decimal places. Price @ 9% Price @ 6% Percentage Change 10-year, 10% annual coupon $ fill in the blank 2 $ fill in the blank 3 fill in the blank 4 % 10-year zero fill in the blank 5 fill in the blank 6 fill in the blank 7 % 5-year zero fill in the blank 8 fill in the blank 9 fill in the blank 10 % 30-year zero fill in the blank 11 fill in the blank 12 fill in the blank 13 % $100 perpetuity fill in the blank…
Please answer all 4 price bonds with explanations thx
Show all workings. Complete the following table and draw a graph showing how bond pricefor each bond changes over time as they move towards their maturitydates. Describe the relationship between bond prices and timeremaining for maturity.YearsreminingtomaturityBOND ACoupon rate = 8% p.a.Market interest rate =6% p.a.BOND BCoupon rate = 6% p.a.Market interest rate =6% p.a.BOND CCoupon rate = 4% p.a.Market interest rate =6% p.a.109876543210
You are the portfolio manager of a large company that invests in many securities including corporate bonds. You have been assigned the task of bond portfolio management. You are provided with the following data in relation to bonds: Maturity period 15 years Coupon rate 12% Par value $1,000 Coupons on bonds are paid annually Yield to maturity of bonds 8% Required: i) Calculate the Macualay’s duration, modified duration and convexity ii) Calculate the change in bond price when yield to maturity changes by one percent using modified duration iii) Calculate the change in bond price when yield to maturity changes by one percent when convexity is considered Please show me the details calculation.
problems should be solved by using a financial calculator or MS excel spreadsheet. Accordingly, you must show the values of all relevant time valu of money variables Findlay company recently issued bonds with a 20-year maturity, a 7.5% semiannual coupon, and a par value of $1,000. The going interest rate (kd, rd) is 6.0%, based on semiannual compounding. What is the bond's price?
Video Excel Online Structured Activity: Bond valuation An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity of 9.1%. Bond C pays a 10.5% annual coupon, while Bond Z is a zero coupon bond. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Assuming that the yield to maturity of each bond remains at 9.1% over the next 4 years, calculate the price of the bonds at each of the following years to maturity. Do not round intermediate calculations. Round your answers to the nearest cent. Years to Maturity Price of Bond C Price of Bond Z 4 3 $ $ 2 $ 1 $ $ Check My Work Reset Problem
Excel Online Structured Activity: Bond valuation An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity of 9.4%. Bond C pays a 10% annual coupon, while Bond Z is a zero coupon bond. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Assuming that the yield to maturity of each bond remains at 9.4% over the next 4 years, calculate the price of the bonds at each of the following years to maturity. Do not round intermediate calculations. Round your answers to the nearest cent. Years to Maturity Price of Bond C Price of Bond Z 4 $ fill in the blank? $ fill in the blank? 3 $ fill in the blank? $ fill in the blank? 2 $ fill in the blank? $ fill in the blank? 1 $ fill in the blank? $ fill in the blank? 0 $ fill in the blank? $ fill in the…
Bond prices. Price the bonds from the following table with quarterly coupon payments: Hint: Make sure to round all intermediate calculations to at least seven decimal places. a. Find the price for the bond in the following table: (Round to the nearest cent.) Years to Par Value $5,000.00 Data table Yield to (Click on the following icon in order to copy its contents into a spreadsheet.) Years to Par Value Coupon Rate Maturity Yield to Maturity Price $5,000.00 8% $5,000.00 12% $1,000.00 $1,000.00 10% 9% 5232 8% ? 7% ? 30 12% ? 9% ? Print Done - ☑
Interest rates on 4-year Treasury securities are currently 5.85%, while 6-year Treasury securities yield 7.85%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. If the pure expectations theory is correct, what does the market believe that 2-year securities will be yielding 4 years from now? Calculate the yield using a geometric average. Do not round your intermediate calculations. Round your answer to two decimal places.
A 10-year, 6.1-percent coupon bond is selling for 102.0 percent of par. What is the bond's market yield if it makes semi-annual coupon payments? (Round answer to 3 decimal places, e.g. 5.795.) Please show and explain your steps in detail and show how to calculate this on a financial calculator as well.

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

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

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