Ques 5) Please provide the answer in word or excel:

5) Table 16-7

The following are transactions in the purchase and sale of Straton Ltd. shares by Samuels Inc.

January 15, 2017 Purchased 2, 000 shares of Straton at $20.00 and paid $125 in brokerage fees

February 10, 2017 Received $1.00 dividend from Straton.

December 31, 2017 Straton reported net income of $6,000.

December 31, 2017 Market value of Straton shares $22.00.

June 30, 2018 Sold all shares of Straton for $21.00 per share.

Refer to Table 16-7. Record the transactions for Samuels Inc. Assume that the investment in Straton shares is classified as a short-term investment by Samuels and Samuels exerts no significant influence over Straton.