Can you please provide me the correct solution for the part where I did wrong? Please show the work in Excel
American Surety and Fidelity buys and sells securities expecting to earn profits on short-term differences in price. For the first 11 months of 2021, gains from selling trading securities totaled $8 million, losses from selling trading securities were $11 million, and the company had earned $5 million in interest revenue. The following selected transactions relate to American's investments in trading securities and equity securities during December 2021, and the first week of 2022. The company's fiscal year ends on December 31. No trading securities or equity investments were held by American on December 1, 2021. Assume that the bonds are purchased at face value. 2021 Dec. 12 Purchased FF&G Corporation bonds for $12 million. 13 Purchased 2 million shares of Ferry Intercommunications common stock for $22 million. American does not have significant influence over Ferry's operations or policies. 15 Sold the FF&G Corporation bonds for $12.1 million. 22 Purchased U.S. Treasury bills for $56 million and Treasury bonds for $65 million. 23 Sold half the shares of Ferry Intercommunications common stock for $10 million. 26 Sold the U.S. Treasury bills for $57 million. 27 Sold the Treasury bonds for $63 million. 28 Received cash dividends of $200,000 from the Ferry Intercommunications common stock shares. 31 Recorded any necessary adjusting entry relating to the remaining investment. The market price of the Ferry Intercommunications stock was $10 per share. 2022 Jan. 2 Sold the remaining Ferry Intercommunications common stock shares for $10.2 million. 5 Purchased Warehouse Designs Corporation bonds for $34 million. Required: 1. Prepare the appropriate journal entry for each transaction or event during 2021 including any year-end adjusting entries. 2. Indicate any amounts that American would report in its 2021 balance sheet and income statement as a result of these investments. 3. Prepare the appropriate journal entry for each transaction or event during 2022. Balance sheet: Current Assets Investments in equity securities Less: Fair value adjustment Total $ 11.0 >> 1.0 $ 10.0 $ 0.2 5.0 $ 5.2 1.1 Income statement: Other revenue (expenses): Dividend revenue (December) Interest revenue (first 11 months) Total interest and dividend revenue Gain (loss) on investments: Gain on investments (December) Loss on investments (December) Gain on investments (first 11 months) Loss on investments (first 11 months) Loss on investments (first 11 months) Loss on investments (first 11 months) Loss on investments (first 11 months) Net loss on investments (4.0) 8.0 > x (11.0) 0.0 X 0.0 % 0.0 X (5.9) Total other revenue (expenses) ($ in millions) Balance sheet: Current Assets Investments in equity securities Less: Fair value adjustment Total $ 11.0 1.0 $ 10.0 $ 0.2 5.0 $ 5.2 Income statement: Other revenue (expenses): Dividend revenue (December) Interest revenue (first 11 months) Total interest and dividend revenue Gain (loss) on investments: Loss on investments (December) Loss on investments (first 11 months) Gain on investments (December) Dividend revenue (December) Investment in bonds Interest revenue (first 11 months) Loss on investments (first 11 months) Net gain on investments (4.0) (11.0) 1.1 0.8 X 0.8 x x x 0.8 x X 0.8 x (10.7)
