Fill in the table using the correct EXCEL FORMULAS - this is being answer in excel so don't just show the math, use the actual formula (ex. =FV, =PV)

Calculate solutions for problems 3 (Bond C) and 4 (Bond D) assuming annual compounding and again assuming semiannual compounding. Assume pricing on coupon dates, stated coupons are annual, and \$100 FACE value. 3. Bond C: 6s of 2038 ; maturity 15 years Note: Data given as annual coupon (6%)/ maturity date (2038)/maturity (15 years) a. Find the selling price if the yield is 8% b. Find the selling price if the yield is 6% c. Find the selling price if the yield is 4% 4. Bond D: 6s of 2053; maturity 30 years a. Find the selling price if the yield is 8% b. Find the selling price if the yield is 6% c. Find the selling price if the yield is 4%