3 Using Excel to Record Non-Strategic Investment 3 PROBLEM 5 On January 1, 2024, Dmitry Ltd. purchased bonds at face value 5 (100) with the intention of selling the bonds early the next 7 year. Dmitry receives interest semi-annually on July 1 and 3 January 1. At December 31, 2024, which is the company's 9 fiscal year end, the bonds were trading in the market at 98 (this means 98% of face value). The company used the fair value through profit or loss model. 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 Face value of bonds purchased Bond interest rate Term of bonds in years Trading value in the market $ 150,000 8% 10 98 Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Prepare the journal entries to record the purchase of the bonds on January 1, the receipt of the interest on July 1, and any adjusting entries required at December 31. Jan. 1 Jul. 1 Dec. 31 Dec. 31 DR CR

1 Using Excel to Record Non-Strategic Investment PROBLEM On January 1, 2024, Dmitry Ltd. purchased bonds at face value 5 (100) with the intention of selling the bonds early the next year. Dmitry receives interest semi-annually on July 1 and January 1. At December 31, 2024, which is the company's fiscal year end, the bonds were trading in the market at 98 (this means 98% of face value). The company used the fair 1 value through profit or loss model. O Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Prepare the journal entries to record the purchase of the bonds on January 1, the receipt of the interest on July 1, and any adjusting entries required at December 31. 2 3 Face value of bonds purchased. $ 150,000 4 Bond interest rate 8% Jan. 1 5 Term of bonds in years 10 6 Trading value in the market 98 7 Jul.1 B 9 0 Dec. 31 1 2 3 4 5 6 Dec. 31 DR CR