1) Using Be Prepared, Inc.?s adjusted trial balance and prior period?s balance sheet, prepare the following Financial Reports in good form using Microsoft Excel:

Multi-Step Income Statement for the month of January 2019

Statement of Retained Earnings for the month of January 2019

Note: There are no prior period adjustments and all dividends declared are cash dividends in the amount of $31,060.

Account ID Account Description 1001 Cash 1021 Accounts Receivable 1022 Allowance for Doubtful Acc 1027 Interest Receivable 1031 Notas Receivable 1051 Marchandise Inventory 1101 Store Supplies 1111 Office Supplies 1125 Prepaid Insurance 1401 Land 1411 Building 1412 Accum Dap: Building 1431 Office Equipment 1432 Accum Dep: Office Equipm 1451 Store Equipment 1452 Accum Depr: Store Equipm 1501 Patents 2001 Accounts Payable 2005 Income Taxas Payable 2031 Interest Payable 2101 Notas Payable long tam 2301 Bonds Payable 2303 Discounton Bonds Payable 3001 Preferred Stock 3011 Common Stock 3101 Paid in Capitan Excess of par Prater 3111 Paid in Capitalin Excess of par com 3121 Paid in Capital Treasury Stock 3300 Retained Earnings 3351 Treasury Stock 4001 Sales Revenue 4002 Sales Discount 4008 Salas Ratums & Allowances 4101 Interest Revenue 5001 Cost of Goods Sold 5010 Insurance Expense - General 5012 Repairs Expense: Office Be Prepared Adjusted Tral Balance January 31, 2019 5015 Depreciation Expense: Building-General 5020 Depreciation Exp: Office Eq 5025 Supplies Expansa-Salling 5027 Utilities Expense: Office 5030 Office Salaries Expanse 5035 Office Payroll Tax Expense 6005 Depreciation Exp: Store Eq 6010 Amortization Expanse: Pat-General 6015 Sales Sales Expense 6020 Sales Payroll Tax Expense 6022 Utilities Expanse: Stor 6025 Delivery Expanse-General 6030 Repairs Expanse: Stor 6040 Bad Debts Expense-Selling 7001 Interest Expense $ $ Debits 687 490.00 $ 23,000.00 60.00 10,000.00 5.190.00 10,000.00 300.00 2,800.00 414,250.00 400,000.00 90,000.00 125,000.00 69,300.00 23,900.00 72,000.00 800.00 3,000.00 84,560.00 200.00 2,500.00 750.00 2,300.00 1,200.00 1,500.00 15,000.00 1,200.00 800.00 700.00 10,000.00 800.00 1,100.00 1,000.00 800.00 460.00 5878.00 2,068,038.00 $ Credits 460.00 45,750.00 17.500.00 15,800.00 25,000.00 7,500.00 4,778.00 200,000.00 800,000.00 400,000.00 105,000.00 15,000.00 166 250.00 72,000.00 53,940.00 139,000.00 60.00 2,068,038.00 Cash Accounts Receivable Merchandise Inventory Office Supplies Prepaid Insurance Land Assets Building Accumulated Depreciation, Building Office Equipment Accumulated Depreciation, Office Equipment Store Equipment Accumulated Depreciation, Store Equipment Patents Total Assets $ $ Be Prepared Inc. Balance Sheet December 31, 2018 27,500 Accounts Payable 40,000 Income Taxes Payable 50,000 Mortgage hayable 1,500 Total Liabilities 3,000 Liabilities $ 64,250 400,000 (45,000 Preferred Stock 90,000 Common Stock (15,000 Paid in Capital in Excess of par: Preferred 75,000 Paid in Capital in Excess of par: Common (15,000 Retained Earnings 70,000 Total Stockholder's Equity 746,250 Total Liabilities and Stockholder's Equity $ Stockholder's Equity 25,000 7,500 200,000 232,500 250,000 100,000 7,500 71,250 85,000 513,750 746,250