Can you please use Excel and provide =formulatext so I can follow work. Cheers!

4. Valuing Bonds Tesla raised money to finance an expansion of their factory in Nevada, so they currently have 2 bonds outstanding. Bond 1 has a face value of $30,000 and matures in 20 years. The bond makes no payments for the first six years, then pays $800 every six months over the subsequent eight years, and finally pays $1,000 every six months over the last six years. Bond 2 also has a face value of 1 $30,000 and a maturity of 20 years; it makes no coupon payments over the life of the bond. If the required return on both these bonds is 5.6 percent compounded semiannually, what is the current price of each bond - Bond 1 and Bond 2