Place Company owns a majority voting interest in Sassano. Inc. On January 1, 2019. Place issued \$1,000,000 of II percent 10 -year bonds at \$943,497.77 to yield 12 percent. On January 1.2021. Sassano purchased all of these bonds in the open market at a price of $904,024.59 with an effective yield of 13 percent. Required Using an Excel spreadsheet, do the following: 1. Prepare amortization schedules for the Place Company bonds payable and the Investment in Place Bonds for Sassano. Inc. 2. Using the values from the amortization schedule s. compute the worksheet adjustment for a December 31. 2021. consolidation Page 320 of Place and Sassano to reflect the effective retirement of the Place bonds. Formulate your solution to be able to acconmodate various yield rates (and therefore prices) on the repurchase of the bonds. Hints Present yalue of 11/(1+v)n Present value of an annuity of 1[11/(1+r)n] Where r - effective yield and n - years remainine to maturity