Business, 23.04.2021 16:10 kianag312

Suppose a 10-year, $1,000 bond with an 8% coupon rate and semiannual coupons is trading for $1,034.74. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section.
a. What is the bond’s yield to maturity (expressed as an APR with semiannual compounding)?
b. If the bond’s yield to maturity changes to 9% APR, what will the bond’s price be?
Maturity (years) 10
Face value $ 1,000
Coupon rate 8%
Bond price $ 1,034.74

Answers: 1

Show answers

Another question on Business

Business, 22.06.2019 11:00

The role of the credit department includes: a. evaluating customers' credit applications to determine whether they meet the company's approval standards. b. approving all credit applications in order to avoid losing sales. c. collecting cash from customers. d. following unwritten approval standards for processing customers' credit applications.

Answers: 2

Answer

Business, 22.06.2019 11:20

Mae jong corp. issues $1,000,000 of 10% bonds payable which may be converted into 10,000 shares of $2 par value ordinary shares. the market rate of interest on similar bonds is 12%. interest is payable annually on december 31, and the bonds were issued for total proceeds of $1,000,000. in accounting for these bonds, mae jong corp. will: (a) first assign a value to the equity component, then determine the liability component. (b) assign no value to the equity component since the conversion privilege is not separable from the bond.(c) first assign a value to the liability component based on the face amount of the bond.(d) use the “with-and-without” method to value the compound instrument.

Answers: 3

Answer

Business, 22.06.2019 11:50

Select the correct answer. ramon applied to the state university in the city where he lives, but he was denied admission. what should he do now? a.change his mind about graduating and drop out of high school so he can start working right away. b. decide not to go to college, because he didn’t have a backup plan. c.stay positive and write a mean letter to let the college know that they made a bad decision. d. learn from this opportunity, reevaluate his options, and apply to his second and third choices.

Answers: 2

Answer

Business, 23.06.2019 10:30

According to the graph, how much did individuals making $20,000 to $50,000 a year pay in income taxes? according to the graph, how much revenue did the government receive from individuals earning $200,000 and above?

Answers: 2

Answer

You know the right answer?

Suppose a 10-year, $1,000 bond with an 8% coupon rate and semiannual coupons is trading for $1,034.7...

Questions