Please do in excel!

The following transactions of Big Company were completed during the fiscal year just ended: (a) Purchased $100,000 of U.S. Treasury 7% bonds, paying 102.5 plus accrued interest of $1, 750. Big Company uses the revenue approach to record accrued interest. Big Company classified these bonds as a trading security. (b) Purchased 1,000 shares of Ferris Company common stock at $125. Big Company classifies this stock as an available-for-sale security. (c) Received semiannual interest on the U.S. Treasury Bonds. (d) Sold 150 shares of Ferris at $132 per share. (e) Sold $16,000 of U.S. Treasury 7% bonds at 102 plus accrued interest of $93. (f) Purchased a $12,000. 6-month certificate of deposit. The certificate is classified as a trading security. Prepare the entries necessary to record the above transactions