Please show working formulas in excel so I understand how you got to answer please.

P 14-7 Issuer and investor; effective interest LO14-2 McWherter Instruments sold $400 million of 8% bonds, dated January 1, on January 1, 2021. The bonds mature on December 31, 2040 (20 years). For bonds of similar risk and maturity, the market yield was 10%. Interest is paid semiannually on June 30 and December 31. Blanton Technologies, Inc., purchased $400,000 of the bonds as a long-term investment. Required: 1. Determine the price of the bonds issued on January 1, 2021. 2. Prepare the journal entries to record (a) their issuance by McWherter and (b) Blanton's investment on January 1, 2021. 3. Prepare the journal entries by (a) McWherter and (b) Blanton to record interest on June 30, 2021 (at the effective rate). 4. Prepare the journal entries by (a) McWherter and (b) Blanton to record interest on December 31, 2021 (at the effective rate)