create a comparative balance sheet for december 2020 and january 2021

Phase #2 Using Be Prepared, Inc.'s adjusted trial balance and prior period's balance sheet, prepare the following Financial Report in good form using Microsoft Excel Comparative Balance Sheet for the months of December 2020 and January 2021 (See page 616 in your textbook for guidance) Submission method. Please upload your Excel file to the submission folder in D2L using the assignment link provided for you. Be sure to name your file Phase2firstnamelastname.xls. For example: Phase2Evelyn Money.xls Credits Debits 423,615 25,000 540 100. 15,0000 7,200 8,000 500.00 1,600 375,000 500,000.00 72,000.00 70,000 17,500 95,000 15,800.00 65,000 30,000 12.500 5,500 325,000.00 375,000 10,500 Be Preparec Adjusted Trial Belange January 31, 2017 Account Account Description 1001 Cash $ 1021 Accounts Receivak 1022 Allowance for Doubtful Ar 1027 Interest Recent 1031 Notes Receivas 1051 Merchandise Inventy 1101 Store Supplies 1111 Office Supplie 1125 Prepaid insurance 1401 Lanc 1411 Building 1412 con Dep: Builder 1431 Office Equipment 142 ambea Clear 1451 Store Equipment 1452 Acova Depr: Stor El 1501 Patent 2001 Accounts Payak 2005 Income Taxe Payak 2031 Interest Payak 2101 Notes Payable long to 2301 Bonds Payable 2303 Discount on Bonds Payab 3001 Preferred Stars 3011 Common Stas 3101 Paid in Capitalin Excess of par: Pree 3111 Paid in Capitalin Excess of par: Gor 3121 Paid in Capital Treasury Stol 3300 Retained Earning 3351 Treasury Stod 4001 Sales Revenu 4002 Sales Discount 4003 Sales Returns & Alowance 4101 Interest Reven 5001 Cost of Goods Sok 5010 Insurance Expense-Gered 5012 Repairs Expense: Office 5015 Depreciation Expense: Building - Gered 5020 Depreciation Exp: Office 5025 Supplies Expense. Selle 5027 Utilities Expense: Offio 5030 Office Salaries Expens 5035 Office Payroll Tax Expers 6005 Depreciation Exp: Store 6010 Amortization Expense: Pat Gered 6015 Sales Salaries Expere 6020 Sales Payroll Tax Expers 6022 Utilities Expense: Stor 6025 Delivery Expense Games 6030 Repairs Expense: Stor 6040 Bad Debts Expense - Sdi 7001 Interest Expen 210,000 120,000 61,250 295,000 90,000 90,000 275,575.00 750.00 5,250.00 SO 125, 5000 300.00 2,1000 9,000.00 2,500.00 2,400.00 1,100.00 25,000 7,000.00 800. 800. 20,000 5,6000 1,200.00 1,500.00 750. 2.000 6.500 a 1.903 565 1.906 5650 Be Prepared Inc Balance Shed December 31, 2 THE $ $ 25,00 7,50C 175,000 150.00 357,500 Asset Cash Accounts Receivable Merchandise Inventy Office Supplies Prepaid insurance Land Building Accumulated Depreciation, Buildrg Office Equipmet Accumulated Deprecaton, OficeEquipmet Store Equipment Accumulated Depreciation Store Equipment Patents Total Assets Llabilities 74,80 Accounts Payatke 40,00 Income Taxes Payaitse 50,00 Note Payable 1.500 Mortgage Pavate 3,000 Total Liabilities 125, OCT 400.OK Stockholder's Equity (63,00 Preferred Stack 70,00D Common Stack (15,00 Paldin Capital in Excess of par: Preferred 75,00 Paid in Capital in Excess of par: Common (15.000 Retained Earnine 65.80 TotalStockholder's Equ 812 10 Total Liabilities and Stockholder's Eque 52,50 115,00 61,290 200,000 25.890 454 601 812.10