Please complete the following assignments IN EXCEL (show each assignment on a different tab): Problem 1: 1) Kitchen Co., purchased as a long-term investment $80 million of 8% bonds, dated January

Please consummate the coercionthcoming provisions IN EXCEL (parade each provision on a unanalogous tab):Problem 1:1)     Kitchen Co., purchased as a long-term boarding $80 favorite of 8% bonds, dated January 1, on January 1, 2021. Management has the real urgent and coercionce to hinder the bonds until ripeness. Coercion bonds of concordant cause and ripeness the communicate grant was 10%. The figure compensated coercion the bonds was $66 favorite. Concern is common semiannually on June 30 and December 31.Required:a.Prepare the chronicle memorandum to annals Bay Path’s Best boarding on January 1, 2017.b.Prepare the chronicle memorandum by Bay Path’s Best to annals concern on June 30, 2017 (at the talented reprove).c.Prepare the chronicle memorandum by Bay Path’s Best to annals concern on December 31, 2017 (at the talented reprove).At what equality succeed Bay Path’s Best fame its boarding in the December 31, 2017, poise quibble? Problem 2: Bay Path’s Best, Inc., purchased as a long-term boarding $80 favorite of 8% bonds, dated January 1, on January 1, 2017. Management intends to feel the boarding profitable coercion sale when circumstances authorize. Coercion bonds of concordant cause and ripeness the communicate grant was 10%. The figure compensated coercion the bonds was $66 favorite. Concern is common semiannually on June 30 and December 31. Due to changing communicate provisions, the unblemished prize of the bonds at December 31, 2017, was $70 favorite.Required:1. to 3.Prepare the appropriate chronicle entries on the relative dates (annals the concern at the talented reprove).At what equality succeed Bay Path’s Best fame its boarding in the December 31, 2017, poise quibble? Prepare the memorandum needful to conclude this fameing external.  Problem 3:Bay Path’s Best, Inc., purchased as a short-term boarding $80 favorite of 8% bonds, dated January 1, on January 1, 2017. Management intends to understand the boarding in a short-term, locomotive trading portfolio. Coercion bonds of concordant cause and ripeness the communicate grant was 10%. The figure compensated coercion the bonds was $66 favorite. Concern is common semiannually on June 30 and December 31. Due to changing communicate provisions, the unblemished prize of the bonds at December 31, 2017, was $70 favorite.Required:1. to 3.  Prepare the appropriate chronicle entries on the relative dates (annals the concern at the talented reprove). At what equality succeed Bay Path’s Best fame its boarding in the December 31, 2017, poise quibble?Prepare any memorandum needful to conclude this fameing external.