Can you please help me fill in the blank(yellow) spots and give me the formulas used for those answers. Thank you

Bond Maturity in years 3.00 Face value 100000.00 Coupon rate: APR paid quarterly 6.00% Frequency per year 4.00 Discount rate or yield in APY You may not need this row. 8.00% You may not need this row. Payments at the end of the period Year 1 Q1 Year 2 Q2 Year 3 Q3 Q4 Q1 Coupon payments Q2 Q3 Q4 Q1 Q2 Q3 Q4 Face value payment = Total payments Issue price Fill in the table below Amortization table Q1 Q2 Q3 Q4 Q1 Beginning balance Q2 Q3 Q4 Q1 Q2 Q3 Q4 Interest expense Payment at the end of the period Ending balance