I need help with the formulas that go into the pink boxes.

BOND PRICING Semi-Annual YTM and Price Sensitivity Inputs Bond Price as Time Approaches Maturity Time Until Maturity Bond Price 4% Annual Coupon Rate H 1.75% Yield to Maturity (Annualized) For this problem 2 1 Number of Payments Year consider the bond 8 2 Number of Years to Maturity price if the time 3 Face Value $1,000 until it matures equals the values Outputs in column E YTM Payment Semiannual Coupon Payment