Develop Your Skills
EXCEL CASE: INTRA-ENTITY BONDS-ANALYSIS OF ALTERNATIVE YIELD RATES AND PRICES
Place Company owns a majority voting interest in Sassano, Inc. On January 1, 2022, Place issued $1,000,000 of 11 percent 10-year bonds at $943,497.77 to yield 12 percent. On January 1, 2024, 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, 2024, 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 = $\frac{1}{(1+r)^n}$
Present value of an annuity of 1 = $\frac{[1 - \frac{1}{(1+r)^n}]}{r}$
Where $r$ = effective yield and $n$ = years remaining to maturity
RESEARCH CASE: STATEMENT OF CASH FLOWS
