Looking for clarification. Provided a portion of my sample below, please show work so I can apply to my homework.

For each security classification (i.e., Trading, AFS, HTM), if necessary, determine the unrealized gain or loss to be recognized during June 2021 and propose adjusting journal entries. [6 points]

• Your numbers must be formatted using comma separators and to the nearest cent (2 decimal places).
• Your entries must identify the security classification affected by the entry.
• Your entries must identify the unrealized gain or loss as affecting net income (NI) or other comprehensive income (OCI).

For each security classification, if necessary, determine the June 30 balance in the Fair Value Adjustment account. [4 points]

• You must identify the dollar value of the balance and the type of balance (debit or credit) for each classification as needed.
• Your numbers must be formatted comma separators and to the nearest cent (2 decimal places).

Sample Excel Data:

362610735BCurrentAFSCTDebt11/9/20191294515084294008429400405487312ACurrentTradingDCEquity5/10/20199811767691273.72884.64428761124ACurrentTradingTXEquity6/9/202075.241805.76146.023504.48146.023504.48452650010ACurrentTradingNCEquity5/10/2020137.741377.45353052.47524.7453560827BCurrentTradingNCEquity6/9/2019113.853073.951333591133359161694128ACurrentTradingDCEquity11/9/201929232146.021168.16144.531156.24653169220ACurrentTradingCOEquity8/9/202030.69613.8121.522430.4120.282405.6660721420BCurrentTradingFLEquity3/12/201958.561171.295190094.051881672620225ACurrentTradingNYEquity2/9/2019133.44333653.461336.552.92132367373257ACurrentHTMWVDebt2/9/201975.665296.2138.189672.6139.599771.3676462914DCurrentTradingFLEquity2/9/2019114.661605.24140.581968.12140.581968.12681505730ACurrentTradingWIEquity3/12/2019109.613288.375.242257.275.242257.2705466315ACurrentHTMOHDebt2/9/2019137.742066132480032480070773077BCurrentTradingAREquity2/9/201984.15589.0515.84110.8815.52108.64737630825ACurrentTradingMAEquity1/9/202123.7659488220086.242156765657521ACurrentAFSAZDebt2/9/2019122.8825804.810622260103.8821814.8770099111ACurrentTradingWIEquity5/10/2019112123232.34355.7432.01352.11