The Morgan Corporation has two different bonds currently outstanding. Bond M has a face value of $30,000 and matures in 20 years. The bond makes no payments for the first six years, then pays $3,100 every six months over the subsequent eight years, and finally pays $3,400 every six months over the last six years. Bond N also has a face value of $30,000 and a maturity of 20 years; it makes no coupon payments over the life of the bond. The required return on both these bonds is 12 percent compounded semiannually.

What is the current price of bond M and bond N?

Could you include how I would put this into excel? Thanks