MUST USE THE PRICE FUNCTION IN EXCEL & SHOW THE INPUT VALUES!!

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? Input areo Settlement date Maturity date Coupon rate 9 Coupons per year 10 Redemption value (% of par) Yield to maturity 12 Par value 1/1/2020 1/1/2034 5.4096 2 100 4.5096 $1,000 . (Use cells A6 to B12 from the given information 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.) 15 16 Output area: 10 18 10 19 20 20 21 22 Price% of par) Price