Requirements

1. For each security classification (i.e., Trading, AFS, HTM), if necessary, determine the unrealized gain or loss to be recognized during March 2017 and propose adjusting journal entries

. Your solution must include the pivot table results used to prepare the entries.

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).

2. For each security classification, if necessary, determine the March 31 balance in the adjustment account (Fair Value Adjustment).

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).

C23 B C D E F G H I (All) A 1 holding_location 2 3 Row Labels 4 AFS 5 HTM 6 Trading 7 Grand Total Total Cost FV on Feb 28th FV on March 31st $ 74,483,358.47 $ 79,549,800.74 $ 79,154,532.69 $ 62,500,960.80 $ 65,573,176.40 $ 65,253,331.60 $ 76,592,057.31 $ 81,388,533.45 $ 80,975,458.87 $ 213,576,376.58 $ 226,511,510.59 $ 225,383,323.16