All of the yellow boxes must be filled using excel formulas. Please provide excel formulas for your answers.

Problem 6-6 Bond Prices Wiser Co. issued 14 -year bonds two years ago at a coupon rate of 7.4 percent. The bonds make semiannual payments. If the YTM on these bonds is 5.4 percent, what is the current dollar price assuming a par value of $1,000 ? (Do not round intermediate calculations.) Input area: \begin{tabular}{lr} Years to Maturity & 14 \\ Years passed since issue & 2 \\ Coupon rate & 7.4% \\ Coupons per year & 2 \\ Face/Par value (\$) & $1,000.00 \\ Redemption & 100 \\ YTM & 5.4% \\ \hline \end{tabular} Input all stated data in numeric form here: Number of periods Settlement date Maturity date Use PRICE or PV fx here for credit: Quoted Price Dollar Price (\$) NPER stands for Number of Periods, but you don't need to use the NPER fx to calculate here.