Please do all of them pleeeease
Using Be Prepared, Inc.'s adjusted trial balance and prior period's balance sheet, prepare the following Financial Reports: 1. Multi-Step Income Statement for the month of January 2018 (see page 180/181 in your textbook for guidance). 2. Statement of Retained Earnings for the month of January 2018 (see page 479/480 in your textbook for guidance). Note: There are no prior period adjustments and all dividends declared are cash dividends in the amount of $31,060. 3. Comparative Balance Sheet for the months of December 2017 and January 2018 (See page 617/618 in your textbook for guidance). 4. Common-Size Comparative Balance Sheet for the months of December 2017 and January 2018 (See page 619 in your textbook for guidance). D E F G H Credits Debits 687,490.00 23,000.00 $ 460.00 A B 1 Be Prepared 2. Adjusted Trial Balance 3 January 31, 2018 4 5 Account ID Account Description 6 1001 Cash $ 7 1021 Accounts Receivable 8 1022 Allowance for Doubtful Accounts 9 1027 Interest Receivable 10 1031 Notes Receivable 11 1051 Merchandise Inventory 12 1101 Store Supplies 13 1111 Office Supplies 14 1125 Prepaid Insurance 15 1401 Land 16 1411 Building 17 1412 Accum Dep: Building 18 1431 Office Equipment 19 1432 Accum Dep: Office Equipment 20 1451 Store Equipment 21 1452 Accum Dep: Store Equipment 1501 Patents 23 2001 Accounts Payable 24 2005 Income Taxes Payable 25 2031 Interest Payable 26 2101 Notes Payable Long Term 27 2301 Bonds Payable 28 2303 Discount on Bonds Payable Jan 31 Adj Trial Balance Dec 31 Balance Sheet 60.00 10,000.00 5,190.00 10,000.00 300.00 2,800.00 414,250.00 400,000.00 45,750.00 90,000.00 17,500.00 125,000.00 15,800.00 22 69,300.00 25,000.00 7,500.00 4,778.00 200,000.00 800,000.00 23,900.00 Sheet1 PUH Alignment Number B4 x fx E F G D 23,900.00 H 28 29 1 30 400,000.00 105,000.00 15,000.00 166,250.00 72,000.00 53,940.00 72,000.00 139,000.00 31 32 33 34 35 36 37 38 39 40 41 42 43 800.00 3,000.00 60.00 A B C 2303 Discount on Bonds Payable 3001 Preferred Stock 3011 Common Stock 3101 Paid in Capital in Excess of Par: Proffered 3111 Paid in Capital in Excess of Par: Common 3121 Paid in Capital Treasury Stock 3300 Retained Earnings 3351 Treasury Stock 4001 Sales Revenue 4002 Sales Discount 4003 Sales Returns and Allowances 4101 Interest Revenue 5001 Cost of Goods Sold 5010 Insurance Expense - General 5012 Repairs Expense: Office 5015 Depreciation Expense: Building. General 5020 Depreciation Expense: Office Equipment 5025 Supplies Expense - Selling 5027 Utilities Expense: Office 5030 Office Salaries Expense 5035 Office Payroll Tax Expense 6005 Depreciation Expense: Store Equipment 6010 Amortization Expense: Patents - General 6015 Sales Salaries Expense 6020 Sales Payroll Tax Expense 6022 Utilities Expense: Store 6025 Delivery Expense - General 5030 Repairs Expense Store Jan 31 Adj Trial Balance Dec 31 Balance Sheet 44 45 46 47 AB 49 50 84,560.00 200.00 2,500.00 750.00 2,500.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 Sheet 52 5 55 D E H 2 3 F 166,250.00 72,000.00 53,940.00 S 72,000.00 6 139,000.00 7 8 800.00 3,000.00 60.00 9 0 1 2 3 4 5 16 17 18 19 50 51 52 53 54 55 56 57 58 59 A B 3111 Paid in Capital in Excess of Par: Common 3121 Paid in Capital Treasury Stock 3300 Retained Earnings 3351 Treasury Stock 4001 Sales Revenue 4002 Sales Discount 4003 Sales Returns and Allowances 4101 Interest Revenue 5001 Cost of Goods Sold 5010 Insurance Expense - General 5012 Repairs Expense: Office 5015 Depreciation Expense: Building - General 5020 Depreciation Expense: Office Equipment 5025 Supplies Expense - Selling 5027 Utilities Expense: Office 5030 Office Salaries Expense 5035 Office Payroll Tax Expense 6005 Depreciation Expense: Store Equipment 6010 Amortization Expense: Patents - General 6015 Sales Salaries Expense 6020 Sales Payroll Tax Expense 6022 Utilities Expense: Store 6025 Delivery Expense - General 6030 Repairs Expense: Store 6040 Bad Debts Expense - Selling 7001 Interest Expense 84,560.00 200.00 2,500.00 750.00 2,500.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 5,878.00 2,068,038.00 2,068,038.00 A4 D F F G 1 2 3 B Be Prepared Balance Sheet December 31, 2017 Liabilities $ $ 25,000 7,500 200,000 232,500 4 5 Assets 6 Cash 7 Accounts Receivable 8 Merchandise Inventory 9 Office Supplies 10 Prepaid Insurance 11 Land 12 Building 13 Accum Dep: Building 14 Office Equipment 15 Accum Dep: Office Equipment 16 Store Equipment 17 Accum Dep: Store Equipment 18 Patents 19 Total Assets Liabilities 27,500 Accounts Payable 40,000 Income Taxes Payable 50,000 Mortgage Payable 1,500 Total Liabilities 3,000 64,250 400,000 Stockholders' Equity (45,000) Preferred Stock 90,000 Common Stock (15,000) Paid in Capital in Excess of Par: Proffered 75.000 Paid in Capital in Excess of Par: Common (15,000) Retained Earnings 70,000 Total Stockholders' Equity 746,250 $ 250,000 100,000 7,500 71,250 85,000 513,750 746,250 S 20 21 22 23 24 25 26 27 28 Sheet1 Dec 31 Balance Sheet Jan 31 Ad Trial balance Be Prepared Adjusted Trial Balance January 31, 2018 Credits $ Debits 687,490.00 $ 23,000.00 460.00 5 Account ID Account Description 6 1001 Cash 7 1021 Accounts Receivable 8 1022 Allowance for Doubtful Accounts 9 1027 Interest Receivable 10 1031 Notes Receivable 11 1051 Merchandise Inventory 12 1101 Store Supplies 13 1111 Office Supplies 14 1125 Prepaid Insurance 15 1401 Land 16 1411 Building 17 1412 Accum Dep: Building 18 1431 Office Equipment 19 1432 Accum Dep: Office Equipment 20 1451 Store Equipment 21 1452 Accum Dep: Store Equipment 22 1501 Patent 23 2001 Accounts Payable 24 2005 Income Taxes Payable 25 2031 Interest Payable 26 2101 Notes Payable Long Term 27 2301 Bonds Payable 28 2303 Discount on Bonds Payable 60.00 10,000.00 5,190.00 10,000.00 300.00 2,800.00 414,250.00 400,000.00 45,750.00 90,000.00 17,500.00 125,000.00 15,800.00 69,300.00 25,000.00 7,500.00 4,778.00 200,000.00 800,000.00 23,900.00 D E G F 800,000.00 23,900.00 400,000.00 105,000.00 15,000.00 166,250.00 72,000.00 53,940.00 72,000.00 139,000.00 800.00 3,000.00 9 A B 2301 Bonds Payable 2303 Discount on Bonds Payable 3001 Preferred Stock 3011 Common Stock 3101 Paid in Capital in Excess of Par: Proffered 3111 Paid in Capital in Excess of Par: Common 3121 Paid in Capital Treasury Stock 3300 Retained Earnings 3351 Treasury Stock 4001 Sales Revenue 7 4002 Sales Discount 8 4003 Sales Returns and Allowances 4101 Interest Revenue 0 5001 Cost of Goods Sold 11 5010 Insurance Expense - General 42 5012 Repairs Expense: Office 43 5015 Depreciation Expense: Building - General 44 5020 Depreciation Expense: Office Equipment 45 5025 Supplies Expense - Selling 46 5027 Utilities Expense: Office 47 5030 Office Salaries Expense 48 5035 Office Payroll Tax Expense 6005 Depreciation Expense: Store Equipment 50 6010 Amortization Expense: Patents - General 51 6015 Sales Salaries Expense 52 6020 Sales Payroll Tax Expense 53 6022 Utilities Expense: Store 54 6025 Delivery Expense - General 60.00 84,560.00 200.00 2,500.00 750.00 2,500.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 D E E G F 166,250.00 72,000.00 53,940.00 72,000.00 139,000.00 800.00 3,000.00 60.00 B 3111 Paid in Capital in Excess of Par: Common 3121 Paid in Capital Treasury Stock 3300 Retained Earnings 3351 Treasury Stock 4001 Sales Revenue 4002 Sales Discount 4003 Sales Returns and Allowances 4101 Interest Revenue 5001 Cost of Goods Sold 5010 Insurance Expense - General 5012 Repairs Expense: Office 5015 Depreciation Expense: Building - General 5020 Depreciation Expense: Office Equipment 5025 Supplies Expense - Selling 5027 Utilities Expense: Office 5030 Office Salaries Expense 5035 Office Payroll Tax Expense 6005 Depreciation Expense: Store Equipment 6010 Amortization Expense: Patents - General 6015 Sales Salaries Expense 6020 Sales Payroll Tax Expense 6022 Utilities Expense: Store 6025 Delivery Expense - General 6030 Repairs Expense: Store 6040 Bad Debts Expense Selling 7001 Interest Expense 84,560.00 200.00 2,500.00 750.00 2,500.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 5,878.00 2,068,038.00 2,068,038.00 Be Prepared Balance Sheet December 31, 2017 $ S 25,000 7,500 200,000 232,500 . 3 4 5 Assets 6 Cash 7 Accounts Receivable 8 Merchandise Inventory 9 Office Supplies 10 Prepaid insurance 11 Land 12 Building Accum Dep: Building 14 Office Equipment 15 Accum Dep: Office Equipment 16 Store Equipment 17 Accum Dep: Store Equipment 1B Patents 19 Total Assets 20 21 22 Liabilities 27500 Accounts Payable 40,000 Income Taxes Payable 50,000 Mortgage Payable 1,500 Total Liabilities 3,000 64,250 400,000 Stockholders' Equity (45.000) Preferred Stock 90,000 Common Stock (15,000) Paid in Capital in Excess of Par: Proffered 75,000 Paid in Capital in excess of Part Common (15,000) Retained Earnings 70,000 Total Stockholders' Equity 746,250 s 250,000 100,000 7,500 71,250 85,000 513,750 746, 250 S S
