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