At December 31, 2018, Hull-Meyers Corp. had the following investments that were purchased during 2018, its first year of operations:
Cost Fair Value
Trading Securities:
Security A $ 930,000 $ 943,000
Security B 135,000 129,400
Totals $ 1,065,000 $ 1,072,400
Securities Available-for-Sale:
Security C $ 730,000 $ 807,000
Security D 930,000 946,200
Totals $ 1,660,000 $ 1,753,200
Securities to Be Held-to-Maturity:
Security E $ 520,000 $ 530,600
Security F 645,000 639,400
Totals $ 1,165,000 $ 1,170,000
No investments were sold during 2018. All securities except Security D and Security F are considered short-term investments. None of the fair value changes is considered permanent.Required:Compute the below table to calculate the following. (Amounts to be deducted should be indicated with a minus sign.)

Note: The data in this question are merged together. They are therefore sorted before answering the question. See the attached pdf file for the full question.

The explanation to the answer is now provided as follows:

Required: Compute the below table to calculate the following. (Amounts to be deducted should be indicated with a minus sign.)

Note: See the attached Excel file for the computed table.

Also note the following:

1. In the computed table, all the Trading Securities and Securities Available-for-Sale are stated at Fair Value, and the Net Income (I/S) of each of the security is calculated by deducting the Cost of each of them their Fair Value.

2. Securities to Be Held-to-Maturity are stated at Cost and therefore, no profit is reported for them.