PLEASE USE EXCEL AND SHOW YOUR WORK :)

25. Cairns owns 75 percent of the voting stock of Hamilton, Inc. The parent's interest was acquired several years ago on the date that the subsidiary was formed. Consequently, no goodwill or other allocation was recorded in connection with the acquisition. Cairns uses the equity method in its internal records to account for its investment in Hamilton. On January 1,2020, Hamilton sold $1,000,000 in 10-year bonds to the public at 105 . The bonds had a cash interest rate of 9 percent payable every December 31 . Cairns acquired 40 percent of these bonds at 96 percent of face value on January 1,2022. Both companies utilize the straight-line method of amortization. Prepare the consolidation worksheet entries to recognize the effects of the intra-entity bonds at each of the following dates. a. December 31,2022 b. December 31,2023 c. December 31,2024