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 8.7%. Bond C pays a 11% 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. X Open spreadsheet Assuming that the yield to maturity of each bond remains at 8.7% 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 3 2 1

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 8.7%. Bond C pays a 11% 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. X Open spreadsheet Assuming that the yield to maturity of each bond remains at 8.7% 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 3 2 1

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

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…
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 8.3%. 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. Assuming that the yield to maturity of each bond remains at 8.3% 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 $   $   0 $   $
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…
1 ) Solve the following quesitons in an Excels spreadsheet, and create a cash-flow table for each Bond A and Bond B over 6 years. a) Calculate the yield rates for two bonds described below. b) Correctly use Rate of Return (ROR) analysis to determine which, if either, bond an investor with a MARR of 10%, should purchase. c) Confirm your answer to part (b) using Present Worth Analysis. Type out formulas used and calculations performed. d) Confirm your answer to part (b) using Annual Worth Analysis. Type out formulas used and calculations performed.
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using the Present Value Tables. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=C3” was entered, the formula would output the result from cell C3, or $500,000 in this example. Multi-Tab Cell Reference: Allows you to refer to data from another cell in a separate tab in the worksheet. When using the multi-tab cell reference, type the equal sign first, then click on the other tab and then click on the cell you want to reference. The syntax of a multi-tab cell reference looks different than a normal cell reference, since it includes the tab name surrounded by apostrophes and also an exclamation…
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using the Present Value Tables. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=C3” was entered, the formula would output the result from cell C3, or $500,000 in this example. Multi-Tab Cell Reference: Allows you to refer to data from another cell in a separate tab in the worksheet. When using the multi-tab cell reference, type the equal sign first, then click on the other tab and then click on the cell you want to reference. The syntax of a multi-tab cell reference looks different than a normal cell reference, since it includes the tab name surrounded by apostrophes and also an exclamation…
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?
Bond valuation related 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 If D1 = $1.50 g (which is constant) = 6.5%, Po = $56, what is the stock's expected capital gains yield for the coming year?
All computations must be done and shown manually Question 4 Complete the following table and draw a graph showing how bond price for each bond changes over time as they move towards their maturity dates. Describe the relationship between bond prices and time remaining for maturity. Years remaining to maturity BOND A Coupon. rate = 8% p.a. Market interest rate = 6% p.a. BOND B Coupon rate = 6% p.a. Market interest rate = 6% p.a. BOND C Coupon rate = 4% p.a. Market interest rate = 6% p.a. 10 9 8 7 6 5 4 3 2 1 0
Calculate the duration (and price) of a bond with the following characteristics: A semi-annual payment bond with a $1,000 face value, a 4,5% coupon rate, a 7.8% YTM, and 8 years to maturity. Show your table of calculations or show Excel inputs if using the Excel commands.
Submit your solutions as an Excel document. Be sure to clearly label the various parts of the problem. 1. Consider the following two bonds that make semi - annual coupon payments. Assume the first coupon payment occurs in exactly six months, and the bond has a face value of $1000. Coupon Rate Time to Maturity YTM Bond A 3.80% 8 years 3.6% Bond B 3.80% 18 years 4.2% a.) What is the current price (t = 0) of Bond A? Be sure to set up the valuation equation. b.) What will be the price of Bond A exactly halfway in between t = 0 and the first coupon date? c.) Using a spreadsheet, plot the price - yield relationship for both Bond A and Bond B on the same set of axes. Do this for a range of yields from 2% to 11% (in increments of 50 basis points). d.) Use a spreadsheet to compute the annualized Macaulay duration and modified duration for Bond A at a yield - to - maturity of 3.6%. Provide an interpretation of the modified duration with regards to maturity and interest rate risk. e.) Use a…
You have 4 types of assets in your portfolio: Corporate bonds earn 5% return and make up 15% of your portfolio Large cap stocks earn 12% return and make up 45% of your portfolio Government bonds earn 2% return and make up 10% of your portfolio International stocks earn 11% return and make up 30% of your portfolio What is the average rate of return on your portfolio? Find the weighted average of the returns. Enter your answer as two decimal places

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