Please help with journel Entries and T Accounts

In the project you will assume the role of the staff accountant for Shipping Inc., and perform Shipping Inc.'s accounting for the transactions that occurred during January 2021. A list of the transactions that Shipping Inc. engaged in during January 2021 is attached at the end of this assignment. As the staff accountant, you will need to: 1. Prepare journal entries for each of the attached transactions. 2. Post each of the journal entries to related T-accounts. 3. Prepare a trial balance at the end of the month. 4. Prepare any necessary adjusting entries. 5. Prepare an adjusted trial balance. 6. Prepare Shipping Inc.'s Income Statement for the month ended January 31, 2021. 7. Prepare Shipping Inc.'s January 31 closing entries. 8. Prepare Shipping Inc.'s January 31 post-closing trial balance. 9. Prepare Shipping Inc.'s Statement of Retained Earnings for the month ended January 31, 2021, and their Balance Sheet as of January 31, 2021. You should complete this project using the Excel spreadsheet Shipping Inc. Accounting Cycle Spreadsheet.xls posted to Canvas. The first tab of the spreadsheet provides Shipping Inc.'s trial balance as of the beginning of January 2021. The remaining tabs of the spreadsheet correspond to each of the 9 tasks above. In the "Journal Entries" tab you should prepare the appropriate journal entry for each of the transactions that Shipping Inc. engaged in during January 2021 (the journal entry for the first transaction has been completed as an example). On the third tab, T Accounts," you will post each of the entries to the related accounts (again the appropriate T-accounts have been adjusted for the first transaction). The fourth tab of the spreadsheet is the trial balance for January 31, 2021. You will need to transfer the amounts from the T-accounts to the new trial balance. On the fifth tab of the worksheet, you will need to create any appropriate adjusting entries for Shipping Inc. for January 2021. The sixth tab of the spreadsheet is the adjusted trial balance for January 31, 2021. You will need Shipping Inc.'s transactions during January 2021: 1. Jan. 1 - Issued 7,500 shares of no-par common stock for $14 per share. 2. Jan. 1 - Purchased a deliver van (used) for $16,000 in cash. Monthly depreciation for the van is $250. 3. Jan. 1- Paid $3,840 for a one-year insurance policy covering the period January 1, 2021 - December 31, 2021. 4. Jan. 7 - Performed repairs and maintenance on their computer equipment costing $2,000. 5. Jan. 12 - Purchased inventory on credit for $92,000. 6. Jan. 15 - Declared and paid $4,000 in dividends to its shareholders. 7. Jan. 22 - Paid $65,000 to its suppliers for inventory purchased on credit in December 2020. 8. Jan. 25 - Provided services for which a customer had paid $3,000 in December of 2020 (hint: see the deferred revenue account in the January 1, 2021 trial balance). 9. Jan. 31 - Paid its employees $45,000 for work performed from December 26 - January 25. $6,800 was for work performed in December 2020, and 38,200 was for work performed from January 1 - January 25, 2021. 10. During January Shipping Inc. collected $118,300 in accounts receivable. (Make a summary entry for the entire month). 25. $6,800 was for work performed in December 2020, and 38,200 was for work performed from January 1 - January 25, 2021. 10. During January Shipping Inc. collected $118,300 in accounts receivable. (Make a summary entry for the entire month). 11. During January Shipping Inc. made credit sales for $210,000. The cost of the goods sold was $125,000. (Make summary entries for the entire month). Other information: 1. Monthly depreciation for the Furniture & Fixtures is $500, and monthly depreciation for the computer equipment is $350. 2. The note payable for $60,000 is a 5-year note that matures on December 31, 2023. The interest on the note is 8% and is payable annually on each December 31st Shipping Inc. made their regularly scheduled interest payment of $4,800 on December 31, 2020. 3. During the period January 26 - January 31 employees earned an additional $5,900 which will be included in their February paycheck. Insert Format TOOIS Data window Help AutoSave OFF os 121 Shipping Inc Accounting Cyc Home Insert Draw Page Layout Formulas Data Review View X Times New Roman v 12 Custom V Paste BIU v a y A $ %) Soo- B15 x fx 0 B D A 1 Trial Balance Summary 2 As of January 1, 2021 3 4 5 Description 6 Cash 7 Accounts Receivable 8 Inventory 9 Furniture & Fixtures 10 Computer Equipment 11 Accum. Dep. - F&F 12 Accum. Dep. - Comp. Eqp 13 Accounts Payable 14 Salaries Payable 15 Notes Payable 16 Deferred Revenue 17 Common Stock 18 Retained Earnings 19 Total 20 21 22 23 24 25 26 27 28 29 30 Beginning Trial Balance Debit 107,800.00 114,300.00 89,500.00 26,000.00 16,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 353,600.00 Credit 0.00 0.00 0.00 0.00 0.00 1,200.00 6,000.00 78,400.00 6,800.00 60,000.00 5,000.00 60,000.00 136,200.00 353,600.00 Journal Entries T Accounts Ending Trial Balance Adjusting AutoSave OFF @su Shipping Inc Accounting Cycle Home Insert Draw Page Layout Formulas Data Review View Times New Roman 12 A A LEH General v Paste BIU v A $ % 9 F5 4 x fe A B D E F G H 1 DR CR Cash 105,000 Common Stock 105,000 1 2 Entry 1 3 Description Issuance of Common Stock 4 Date 1-Jan 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Beginning Trial Balance Journal Entries T Accounts Ending Trial Balance Adjusting Er AutoSave OFF Shipping Inc Accounting Cycles Home Insert Draw Page Layout Formulas Data Review View X Calibri (Body) 11 A A General v Paste BIUDAD a. Av $ % ) 00 ST A1 X V fx A B D E F G H 1 Cash 107,800 Common Stock 60000 BB BB 4 Prepaid Insurance 0 BB Van BB 0 Maintenance Expense 0 BB 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Accounts Payable 78400 BB Retained Earnings 136200 Inventory 89500 BB Deferred Revenue 5000 BB Beginning Trial Balance Journal Entries T Accounts Ending Trial Balance Adjusting Entri AutoSave OFF Shipping Inc Accounting Cycle Sprea Home Insert Draw Page Layout Formulas Data Review View X v Calibri (Body) 11 VA A General v v Paste 00 BIU v a. Av 40 C00 $ % ) FO 30 A1 fx B D E G H 27 Inventory 89500 BB Deferred Revenue 5000 BB Salary and Wage Expense 0 BB Service Revenue O BB Accounts Receivable 114300 BB 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Sales Revenue O BB Furniture & Fixtures 26000 BB COGS 0 BB JE 11 0 Acc Dep. Furniture & Fix 1200 BB Computer Equipment BB 16000 Ending Trial Balance Adjusting Entries Beginning Trial Balance Journal Entries T Accounts AutoSave OFF AS5= Shipping Inc Accounting Cycle Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 11 A A General V Ulili II = = Paste BI U v Av $ % ) 1 A1 x x A B D E F G JE 11 0 Acc Dep. Furniture & Fix 1200 BB Computer Equipment 16000 BB Salaries Payable 6800 BB Acc. Dep. Computer Equip 6000 BB 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 Notes Payable 60000 BB Beginning Trial Balance Journal Entries T Accounts Ending Trial Balance Adjusting Ent