Place Company owns a majority voting interest in Sassano, Inc. On January 1, 2016. Place issued $1,000,000 of 11 percent 10-year bonds at $943,497.77 to yield 12 percent. On January 1, 2018, 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: I. 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 schedules, compute the worksheet adjustment for a December 31, 2018, consolidation of Place and Sassano to reflect the effective retirement of the Place bonds. Formulate your solution to be able to accommodate various yield rates (and therefore prices) on the repurchase of the bonds. HintsPresent value of 1 = 1/(1 + r)n Present value of an annuity of 1 = (1 — 1/[1 + r]n)/r Where r = effective yield and n = years remaining to maturity
Place Company owns a majority voting interest in Sassano, Inc. On January 1, 2016. Place issued $1,000,000 of 11 percent 10-year bonds at $943,497.77 to yield 12 percent. On January 1, 2018, 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:
I. 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 schedules, compute the worksheet adjustment for a December 31, 2018, consolidation of Place and Sassano to reflect the effective retirement of the Place bonds. Formulate your solution to be able to accommodate various yield rates (and therefore prices) on the repurchase of the bonds.
Hints
Present value of 1 = 1/(1 + r)n
Present value of an annuity of 1 = (1 — 1/[1 + r]n)/r
Where r = effective yield and n = years remaining to maturity
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 6 images