I need the excel formulas for this.

Question 7 Input area: Settlement date Maturity date Annual coupon rate Coupons per year Bond price (% of par) Face value (% of par) 1/1/00 1/1/13 5.4% 2 106 Pricing Specific Bonds in Excel =PRICE(Settlement, Maturity, Rate, Yld, Redemption, Frequency, Basis). =YIELD(Settlement, Maturity, Rate, Pr, Redemption, Frequency,Basis). 100 . a Output area: Settlement = actual date as a serial number. Maturity = actual date as a serial number. Redemption and Prlice) = % of par value. Rate (coupon) and Yld = annual rates as decimals. Frequency = # of coupons per year. Basis = day count convention (enter "2" for ACT/360). = Yield to maturity Semiannual case =YIELD(D7, DB, 0.054, 106,100,2) 0.0478