The Morgan Corporation has two different bonds currently outstanding. Bond M has a face value of $800$ every six months over the subsequent eight years, and finally pays $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 $8$ percent compounded semiannually. Solve using Excel