using the trial blance and prior balance sheet to answer the question

Phase #2 I 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) IT IM IN AaBbCcDdEe = 1 Normal Aded Trial Relea January 31, 20 $ Debits 421,615 25,000 Credes Account Account Desi 1001 Cash 1021 Accounts Rece 1022 Alware for Double 1027 interest Recebe 1031 Not Receivals 1051 Merchandisine 1101 Store Supplier 1111 Office Supple 1125 Prepaid insurance 1401 Lanc 100.00 15,000 8,000 500.00 1,600 375,000 500,000 72,000 70,000 17,500.00 95,000 15,800 30,000.00 12,500 5,500.00 325,000 375,000 10,500 210,000 120,000 61,2500 295,000 90,000 850.00 90,000 1412 AcoDep Mild 1431 Office Equipment 1432 Ace Dep: Oke 1451 Store Equipment 1452 Acum Der Store 1501 Patent 2001 Accounts Paya 2005 Income Tax Payak 2031 Interest Payable 2101 Notes Payable long to 2301 Bonds Payable 2003 Discount on Bonds Payas 3001 Preferred Stod 3011 Commonsta 3101 Paid in Capitalin Excess of par: Pride 3111 Paid in Capitalin Excess of par: 3121 Paid in Capital Treasury Sto 3300 Retained Earning 3351 Treasury Stars 4001 Sales Revenue 4002 Sales Discount 400) Sales Returns & Allowance 4101 Interest Rever 5001 Cost of Goods Sok 5010 Insurance Expense-Gerd 5012 Repairs Expense: Ofiar sous Depreciation Expense Bulding-Ger 5020 Depreciation Exp: Office 5025 Supplies Expense. Sell 5027 Utilities Expense: Offer 5030 Office Salaries Expo 5035 Office Payroll Tax Expens 6005 Depreciation Exp: Stor 6010 Amortuation Expense: Pot. Gered 6015 Sales salaries Expere 5020 Sales Payroll Tax Expers 6022 Utles Exper: Stor 6025 Delivery Expense Gone 6030 Repairs Experie: Stor 6040 Bad Debes Expenses 7001 Interest Expens 275,575.0 750.00 5,250 C 50 125,500 2,1000 9,000.00 2,500 2,400 1,1000 25,000 7.000 800 a 800 20,000 5,600 1,200.00 1,500 750.00 2,000m 6.5000 Be Prepared Inc Balance Shed December 31, 20 $ $ 25,00 7,50C 175,000 150.00 357,500 Asset Cash Accounts Receivable Merchandise inventy Office Supplies Prepaid insurance Land Buiding Accumulated Depreciaton, Buildrg Office Equipmet Accumulated Depreciation, OficeEquipmet Store Equipment Accumulated Depreciation Store Equipment Patents Total Assets Llabilities 74,80 Accounts Payak 40,00 Income Taxes Payitse 50,00 Note Payable 1.500 Mortgage Pavate 3,000 Total Liabilities 125, OLT 400.0 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.0od Retained Earnine 65,80 TotalStockholder's Equs 812 10 Total Liabilities and Stockholder's Equi $2,50 115,000 61,290 200,000 25.890 454 601 812 10