Please show excel calculations!

Question 7 (Mandatory) (10 points) ) Listen Use the following information to calculate the dirty price of the Zyngo Inc. bond as of 4/21/2021. Assume 100 Face Value for the bonds. Last Coupon 12/15/2020 Date Next Coupon 6/15/2021 Date Settlement 4/21/2021 Date Maturity Date 12/15/2050 Coupon Rate 4% Yield 4.96% Redemption 100.00 frequency 2 Basis 0 100 97.64 86.56 89.90