Question

Westco Co. issued 15-year bonds a year ago at a coupon rate of 5.4 percent. The bonds make semiannual payments and have a par value of $1,000. If the YTM on these bonds is 4.5 percent, what is the current price of the bond in dollars? Settlement date 1/1/2020 Maturity date 1/1/2034 Coupon rate 5.40% Coupons per year 2 Redemption value (% of par) 100 Yield to maturity 4.50% Par value $1,000 (Use cells A6 to B12 from the given information to complete this question. You must use the built-in Excel function to answer this question. Leave the “Basis” input blank in the function. You may enter a constant as a hard coded value.) Question. Slove Using Excel A. Price (% of Par) B. Price

          Westco Co. issued 15-year bonds a year ago at a coupon rate of 5.4 percent. The bonds make semiannual payments and have a par value of $1,000. If the YTM on these bonds is 4.5 percent, what is the current price of the bond in dollars?
Settlement date
1/1/2020
Maturity date
1/1/2034
Coupon rate
5.40%
Coupons per year
2
Redemption value (% of par)
100
Yield to maturity
4.50%
Par value
$1,000 
(Use cells A6 to B12 from the given information to complete this question. You must use the built-in Excel function to answer this question. Leave the “Basis” input blank in the function. You may enter a constant as a hard coded value.)
Question. Slove Using Excel
A. Price (% of Par)
B. Price

Added by Maria P.

Question

Please give Ace some feedback