I need help in accounting. Please answer all the parts and don't miss anything. Please read it very carefully and also do it in excel and show me the formulas so i can do it easily.

I put all the parts everything.

Acc 302 Investments and Comprehensive Income M&JB Investment Corp. (with a 12/31 year-end) began operations on 1/1/X1 by issuing 10,000 shares of S5 par value common stock to 5 shareholders. Each shareholder paid S40,000 for their 2,000 shares. M&JB uses straight-line amortization for bond investments, all of which paid annual interest when due on 1231. Use first three, next two, and last four digits of your identification number for AAA, BB, and CCCC, respectively. Ignore income taxes. Use excel to round each transaction to the nearest dollar in the presentation ofthe document The following transactions took place 20X1: Jan. 1 Record the initial investment by the owners described above Bought the following Available-for-Sale (AFS) securities share shar shares of GHI comnon common stock for commo for S 24 per share are 20 per share EF for S Jan. 1 Bought the following Held-to-Maturity securities bonds of POR Co. for S92 1.000 bond onds O or on Feb. 2 Bought the following Trading Securities 300 share common stock for $19 per sharse share share omm0 or Aug 3 Sold 200 shares of JKL Co. stock for S26.26 per share Bought 100 shares ofVWX Co. common stock for S32 per share, classified as AFS Securities old shares HI tock for share Dec 15Received cash dividends from common stock investments for 20X1 Dec 31 Investment expenses of S1,135 were paid in cash for the year Received interest on bond investments, and made necessary amortizations Made all necessary fair market value adjustments Made all necessary closing entries 20X2: Jan. 1 Issued 100 shares of $100 par value, 8%, cumulative Preferred Stock for $16,813 The Preferred Stock is convertible into common stock,5 shares of common for each share of prefered influence was achieved. Assume FVO was not elected Sold 100 shares of JKL Co. stock for S31.35 per share Jan. 2 Bought 300 shares of RJB Co. common stock for $50 per share. Significant Apr 2 Bought 150 more shares of MNO Co. common stock for S15 per share Jul 1 Bought 300 shares ofXYZ Co. common stock for S60.135 per share; classified as a trading security Sold 100 shares of DEF Co. stock for S18.26 per share Novl Declared cash dividends to our shareholders of S1.26 per common share and S8 per preferred share Nov 15 Paid dividends declared on Nov. 1 Dec 15Received cash dividends from common stock investments for 20X2 Dec 31 Investment expenses of S6,813 were paid in cash for the year Received interest on bond investments, and made necessary amortizations Made all necessary fair market value adjustments Made all necessary closing entries Required entries to record the above transactions. Use ExC repare general jO Prepare comparative financial statements for the two years. Include Statement (including BEPS and DEPS - show your computations), a Statement of Sharehold Schedule A Common Stocks Company Name Shares OS Dividends per Share FMV per share at: 20X2 20X1 26 20X1 20X2 26 26 ABC Co DEF Co JKL Co MNO Co VWX Co RJB Co XYZ Co 24 14 4 26 26 29 263126 90. 26 59. 26 1,000 21.35 21.35 26 Company Name Reported Earming for 20X1 40,000 46,813 20X2 RJB Co Schedule B -Bonds All investment bonds pay interest annually on December 31 Company Name Stated Interest Rate Maturity Date PQR Co STU Co 7.00 % 8.25 % 12/31/20X8 12/31/20X9 AutoSum aCopy Format Painter B / U- Jr, . Merge & Center, $, % , conditional Format. Cell . Insert Delete Format Formatting as Table Styles Paste 1 Sort & Find & ClearFiter Select Editing Clipboard Font Alignment Number Cells B19 | Dividend Rev 1 1/1/x1 CashSales price c/s-$5 APIC Par*#shares Plug # 4 1/1/x1 AFS Sec 1/1/x1 HTM Se 8 2/1/X1 Tr/sec 10 8/3/x1 Cash Tr/Sec Real G(L)-TrSec 13 8/3/x1 AFS Sec 15 8/3/x1 Cash AFS Sec Real G(L)-AFS 18 12/15/x1 Cash Dividend Rev 20 12/31/x1 Invest Exp 22 12/31/X1 Cash HTM Sec Interest Rev 25 12/31/x1 UnReal G(L)-AFS 6 Paste B I , Ft Merge & Center. $ % , .; Conditional FormatCell- Insert Delete Format Sort & Find & 2 Clearte Select Editin Formatting as Table Styles Font Alignment Cells B19 Dividend Rev Q. 1 22 12/31/x1 Cash 23 HTM Sec Interest Rev 25 12/31/xi UnReal G(L)-AFS 26 27 12/31/x1 Mkt Adj - Tr/Sec MKt Adj - AFS UnReal G(L)-Tr 29 12/31/X1 Real G(L)-Tr/Sec 30 31 32 Real G(L)-AFS Dividend Rev Interest Rev UnReal G(L)-Tr Invest Exp 37 38 1/1/x2 Cash 39 p/S-$100par APIC-P/S 41 1/2/x2 Invest in RJB Co. 43 4/2/x2 Cash Tr/Sec Real G(L)-Tr/Sec 46 4/2/X2 Tr/Sec Clipboard Font Alignment Number Cells Editing B19 | Dividend Rev 43 4/2/x2 Cash Tr/Sec Real G(L)-Tr/Sec 46 4/2/x2 Tr/Sec 47 48 7/1/x2 Tr/Sec 49 50 7/1/x2 Cash 51 AFS Sec Real G(L)-AFS 53 11/1/x1 RE 55 11/15/x2 Cash Div Pay 57 12/15/x2 Cash 59 12/15/x2 Cash 61 12/31/x2 Invest in RJB Co. 63 12/31/x2 Invest Exp 65 12/31/x2 Cash Cash Div Pay Div Rev Invest in RJB Invest Rev HTM Sed Interest Rev H Sheeti Sheet2 Sheet3 Ready Clipboard Font Alignment Number Cells Editing B19 | Dividend Rev 55 11/15/x2 Cash Div Pay 57 12/15/x2 Cash 59 12/15/x2 Cash 61 12/31/X2 Invest in RJB Co. 63 12/31/X2 Invest Exp 65 12/31/x2 Cash Div Rev Invest in RJB Invest Rev HTM Sec Interest Rev 12/31/X2 70 12/31/x2 72 12/31/x2 68 UnReal G(L)-Tr/S Mkt Adj -Tr/Sec Mkt Adj-AFS UnReal G(L)-AFS Real G(L)-Tr/Sec Real G(L)-AFS Div Rev Invest Rev Interest Rev Invest Exp UnReal G(L)-Tr , ' Sheet1 Sheet2 Sheet3 Acc 302 Investments and Comprehensive Income M&JB Investment Corp. (with a 12/31 year-end) began operations on 1/1/X1 by issuing 10,000 shares of S5 par value common stock to 5 shareholders. Each shareholder paid S40,000 for their 2,000 shares. M&JB uses straight-line amortization for bond investments, all of which paid annual interest when due on 1231. Use first three, next two, and last four digits of your identification number for AAA, BB, and CCCC, respectively. Ignore income taxes. Use excel to round each transaction to the nearest dollar in the presentation ofthe document The following transactions took place 20X1: Jan. 1 Record the initial investment by the owners described above Bought the following Available-for-Sale (AFS) securities share shar shares of GHI comnon common stock for commo for S 24 per share are 20 per share EF for S Jan. 1 Bought the following Held-to-Maturity securities bonds of POR Co. for S92 1.000 bond onds O or on Feb. 2 Bought the following Trading Securities 300 share common stock for $19 per sharse share share omm0 or Aug 3 Sold 200 shares of JKL Co. stock for S26.26 per share Bought 100 shares ofVWX Co. common stock for S32 per share, classified as AFS Securities old shares HI tock for share Dec 15Received cash dividends from common stock investments for 20X1 Dec 31 Investment expenses of S1,135 were paid in cash for the year Received interest on bond investments, and made necessary amortizations Made all necessary fair market value adjustments Made all necessary closing entries 20X2: Jan. 1 Issued 100 shares of $100 par value, 8%, cumulative Preferred Stock for $16,813 The Preferred Stock is convertible into common stock,5 shares of common for each share of prefered influence was achieved. Assume FVO was not elected Sold 100 shares of JKL Co. stock for S31.35 per share Jan. 2 Bought 300 shares of RJB Co. common stock for $50 per share. Significant Apr 2 Bought 150 more shares of MNO Co. common stock for S15 per share Jul 1 Bought 300 shares ofXYZ Co. common stock for S60.135 per share; classified as a trading security Sold 100 shares of DEF Co. stock for S18.26 per share Novl Declared cash dividends to our shareholders of S1.26 per common share and S8 per preferred share Nov 15 Paid dividends declared on Nov. 1 Dec 15Received cash dividends from common stock investments for 20X2 Dec 31 Investment expenses of S6,813 were paid in cash for the year Received interest on bond investments, and made necessary amortizations Made all necessary fair market value adjustments Made all necessary closing entries Required entries to record the above transactions. Use ExC repare general jO Prepare comparative financial statements for the two years. Include Statement (including BEPS and DEPS - show your computations), a Statement of Sharehold Schedule A Common Stocks Company Name Shares OS Dividends per Share FMV per share at: 20X2 20X1 26 20X1 20X2 26 26 ABC Co DEF Co JKL Co MNO Co VWX Co RJB Co XYZ Co 24 14 4 26 26 29 263126 90. 26 59. 26 1,000 21.35 21.35 26 Company Name Reported Earming for 20X1 40,000 46,813 20X2 RJB Co Schedule B -Bonds All investment bonds pay interest annually on December 31 Company Name Stated Interest Rate Maturity Date PQR Co STU Co 7.00 % 8.25 % 12/31/20X8 12/31/20X9 AutoSum aCopy Format Painter B / U- Jr, . Merge & Center, $, % , conditional Format. Cell . Insert Delete Format Formatting as Table Styles Paste 1 Sort & Find & ClearFiter Select Editing Clipboard Font Alignment Number Cells B19 | Dividend Rev 1 1/1/x1 CashSales price c/s-$5 APIC Par*#shares Plug # 4 1/1/x1 AFS Sec 1/1/x1 HTM Se 8 2/1/X1 Tr/sec 10 8/3/x1 Cash Tr/Sec Real G(L)-TrSec 13 8/3/x1 AFS Sec 15 8/3/x1 Cash AFS Sec Real G(L)-AFS 18 12/15/x1 Cash Dividend Rev 20 12/31/x1 Invest Exp 22 12/31/X1 Cash HTM Sec Interest Rev 25 12/31/x1 UnReal G(L)-AFS 6 Paste B I , Ft Merge & Center. $ % , .; Conditional FormatCell- Insert Delete Format Sort & Find & 2 Clearte Select Editin Formatting as Table Styles Font Alignment Cells B19 Dividend Rev Q. 1 22 12/31/x1 Cash 23 HTM Sec Interest Rev 25 12/31/xi UnReal G(L)-AFS 26 27 12/31/x1 Mkt Adj - Tr/Sec MKt Adj - AFS UnReal G(L)-Tr 29 12/31/X1 Real G(L)-Tr/Sec 30 31 32 Real G(L)-AFS Dividend Rev Interest Rev UnReal G(L)-Tr Invest Exp 37 38 1/1/x2 Cash 39 p/S-$100par APIC-P/S 41 1/2/x2 Invest in RJB Co. 43 4/2/x2 Cash Tr/Sec Real G(L)-Tr/Sec 46 4/2/X2 Tr/Sec Clipboard Font Alignment Number Cells Editing B19 | Dividend Rev 43 4/2/x2 Cash Tr/Sec Real G(L)-Tr/Sec 46 4/2/x2 Tr/Sec 47 48 7/1/x2 Tr/Sec 49 50 7/1/x2 Cash 51 AFS Sec Real G(L)-AFS 53 11/1/x1 RE 55 11/15/x2 Cash Div Pay 57 12/15/x2 Cash 59 12/15/x2 Cash 61 12/31/x2 Invest in RJB Co. 63 12/31/x2 Invest Exp 65 12/31/x2 Cash Cash Div Pay Div Rev Invest in RJB Invest Rev HTM Sed Interest Rev H Sheeti Sheet2 Sheet3 Ready Clipboard Font Alignment Number Cells Editing B19 | Dividend Rev 55 11/15/x2 Cash Div Pay 57 12/15/x2 Cash 59 12/15/x2 Cash 61 12/31/X2 Invest in RJB Co. 63 12/31/X2 Invest Exp 65 12/31/x2 Cash Div Rev Invest in RJB Invest Rev HTM Sec Interest Rev 12/31/X2 70 12/31/x2 72 12/31/x2 68 UnReal G(L)-Tr/S Mkt Adj -Tr/Sec Mkt Adj-AFS UnReal G(L)-AFS Real G(L)-Tr/Sec Real G(L)-AFS Div Rev Invest Rev Interest Rev Invest Exp UnReal G(L)-Tr , ' Sheet1 Sheet2 Sheet3