Please Show Work

Answers are to be entered in the yellow-shaded areas. Amount ($ million) Remaining maturity (years) Settlement date Maturity date Coupon rate (%) Yield (%) 100 3 12/30/2020 12/30/2023 8.00% 7.00% 1 Year Cash flow ($) Discounted cash flow ($) 8.00 7.48 2 8.00 6.99 3 108.00 88.16 Bond price ($) Using bond pricing formula Using PRICE function Bond duration (years) Using Macaulay formula Using DURATION function