VideoExcel Online Structured Activity: Bond valuationAn 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 Cpays 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 performthe required analysis to answer the questions below.Open spreadsheetAssuming 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. Donot round intermediate calculations. Round your answers to the nearest cent.Years to Maturity Price of Bond C Price of Bond Z43$$2$1$$Check My WorkReset Problem

Bonds are debt instruments that are issued by entities to raise funds and meet their capital…

Answered: Excel Online Structured Activity: Bond…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

An investment firm recommends that a client invest in bonds rated AAA, A, and B. The average yield on AAA bonds is 4%, on A bonds 6%, and on B bonds 11%. The client wants to invest twice as much in AAA bonds as in B bonds. How much should be invested in each type of bond if the total investment is $28,000, and the investor wants an annual return of $1,740 on the three investments? Question content area bottom Part 1 The client should invest $enter your response here in AAA bonds, $enter your response here in A bonds, and $enter your response here in B bonds
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 - ☑
IS - Sampoerna. O Dashboard VitalSource Booksh. O Spotify - Web Player Company XYZ's bonds have 12 years remaining to maturity, interest is paid annually, the bonds have $1,000 par value, and the coupon rate is 8%. The bonds have a yield to maturity of 9%. What is the current market price of these bonds?* a. 828.78 b. 968.39 c. 1,000,00 d. 1,075.36 O e. none of the above Which of the following statement is (are) correct? a zero coupon bend means the bond does not give (pay) coupon until maturity O b. the price of zero coupon bond is always at discount until its maturity O c. the price of bond will be at discount when the coupon is lower than its interest ra da and b e. a, b and c
Conceptual Overview: Explore the value of fixed-interest coupon bonds of different terms. This graph shows the value of 10% coupon bonds of different terms across differing market interest rates. Each bond pays INT = $100 at the end of each year and returns M = $1,000 at maturity. For comparison, the blue line depicts the value of a one-year bond. The term of the other bond in years may be changed using the slider. Drag on the graph to change the current market interest rate (rd) at which the bond (orange curve) is evaluated. ∑ t = 1 Y r s I N T ( 1 + r d ) + M ( 1 + r d ) = ∑ t = 1 1 5 $ 1 0 0 ( 1 + 0 . 1 0 0 ) + $ 1 0 0 0 ( 1 + 0 . 1 0 0 ) = 1 , 0 0 0 ∑ t=1 Yrs (1+r d ) t INT + (1+r d ) Yrs M =∑ t=1 15 (1+0.100) t $100 + (1+0.100) 15 $1000 =1,000 ∑t=1Yrs(1+rd)tINT+(1+rd)YrsM=∑t=115(1+0.000)t$100+(1+0.000)15$1000=2,500. 1. What is the value of a 15-year 10% $1,000 coupon bond when the market interest rate is 15%? $421$708$1,000$1,5192. What is the value of a 12-year 10% $1,000…
Exploring Finance: Coupon Bonds. Coupon Bonds Conceptual Overview: Explore the value of fixed-interest coupon bonds of different terms. This graph shows the value of 10% coupon bonds of different terms across differing market interest rates. Each bond pays INT = $100 at the end of each year and returns M = $1,000 at maturity. For comparison, the blue line depicts the value of a one-year bond. The term of the other bond in years may be changed using the slider. Drag on the graph to change the current market interest rate (rd) at which the bond (orange curve) is evaluated. 5. For a 10%, $1,000 coupon bond, a longer term bond (say, 15 years) is: less affected by changes in the market rate than a 1-year bond. affected the same by changes in the market rate than a 1-year bond. more affected by changes in the market rate than a 1-year bond. Cannot be determined.
Consider two types of bonds: A 10 year to maturity corporate bond and a 10 year to maturity Treasury bond. We know that Corporate Bonds have default risk. Discuss the impact on the markets for these two type of bonds & on the risk premium when there is a FALL in the risk of corporate default? Provide a DISCUSSION of the impact and ILLUSTRATE the impact graphically using two diagrams, one for corporate bonds and one for Treasuries. The diagrams should show the impact on each yield and the impact on the risk premium [label your diagram clearly to illustrate the old premium vs. the new premium]. hint: draw your diagrams side by side, so you can show the risk premiums as done in lecture.
Yield to maturity Peter, an intern at Elite Investments, is asked by his supervisor to perform simple analysis of bonds in the bond market. He wants to calculate the theoretical values of the following bonds. Using the information provided below, calculate the intrinsic value of each $1,000-par-value bond The value of bond A is S Bond A B (Round to two decimal places.) Coupon rate 6% 8 Coupon frequency semiannually annually Time to maturity 5 years 9 Yield to maturity 6% 7
For the data set Download data set, perform a 3 month moving average to determine the forecast for month 13 (click on the arrow to download the file). Be sure to label the forecasted value for month 13. You must show all work in an Excel file and upload the Excel file. Corporate triple A bond interest rates month rate 1 9.5 2 9.3 3 9.4 4 9.6 5 9.8 6 9.7 7 9.8 8 10.5 9 9.9 10 9.7 11 9.6 12 9.6
Subject:- finance
The Chief Financial Officer of a company would like to raise money for new equipment by floating a new bond issue. The CFO would like to receive $1000 (full face value) for each of the bonds she sells. After collecting the below bond market data, and if the bonds carry a rating of A and have a term of 10 years, what coupon rate should be included in the bond contract? Assume an annual coupon payment. Security& Rating Maturity Face Coupon Price Treasury 1 $ 1,000 0.00% $ 965.00 Treasury 3 $ 1,000 1.90% $ 939.06 Treasury 5 $ 1,000 4.30% $ 932.42 Treasury 10 $ 1,000 6.80% $ 1,007.12 Treasury 15 $ 1,000 6.60% $ 908.25 CorpA A 5 $ 1,000 8.10% $ 990.00 CorpB BB 10 $ 1,000 7.90% $ 859.88 CorpC AA 15 $ 1,000 7.00% $ 660.00

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS