Green cells are what is needed. Greatly appreciated if you can provide the excel formulas, will upvote for logical, excel formulas that are correct. Thank you

D E B 10% 8% 2. A 1 Annual coupon rate 2 Annual market rate 3 Interest payments per year 4 Years to maturity 5 Face (par) value 6 7 Amortization schedule 15 300,000 8 Period Interest (cash) paid Interest expense Amortization of Bond premium Bond NBV (carrying value) End of period 0 9 10 11 12 13 0 1 2 3 N 14 4 15 16 17 18 19 000 a 5 6 7 8 9 20 10