Place Company owns a majority voting interest in Sassano, Inc. On January 1, 2009, Place issued $1,000,000

Question:

Place Company owns a majority voting interest in Sassano, Inc. On January 1, 2009, Place issued $1,000,000 of 11 percent 10-year bonds at $943,497.77 to yield 12 percent. On January 1, 2011, 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 schedules, compute the worksheet adjustment for a December 31, 2011, 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 of 1 = (1 - 1/[1 + r]n)/r
Where r = effective yield and n = years remaining to maturity

Annuity
An annuity is a series of equal payment made at equal intervals during a period of time. In other words annuity is a contract between insurer and insurance company in which insurer make a lump-sum payment or a series of payment and, in return,...