Question

) when originally issued, an investment in bonds of Flushing Dough, Inc., promised to provide an annual coupon of 7.50%. The bonds have 4 years until maturity, a market price of $735, and are expected to pay all coupon on time. At maturity, however, the bonds are only forecasted to pay 84% of their par value. What is the likely yield to maturity on the bonds

Answer 1

Answer:

The likely yield to maturity on the bonds is 10.23%.

Explanation:

The likely yield to maturity on the bonds can be calculated using the following RATE function in Excel:

YTM = RATE(nper,pmt,-pv,fv) .............(1)

Where;

YTM = likely yield to maturity on the bonds = ?

nper = number of periods = number of years until maturity = 4

pmt = annual coupon payment = annual coupon rate * Face value = 7.50% * $1,000 = $75 = 75

pv = present value = market price = $735 = 735

fv = face value or par value of the bond = 1000

Substituting the values into equation (1), we have:

YTM = RATE(40,75,-735,1000) ............ (2)

Inputting =RATE(40,75,-735,1000) into a cell in an excel (Note: as done in the attached excel file), the YTM is obtained as 10.23%.

Therefore, the likely yield to maturity on the bonds is 10.23%.