Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Be Prepared, Inc.s adjusted trial balance and prior periods balance sheet, prepare the following Financial Reports in good form using Microsoft Excel or Microsoft

Using Be Prepared, Inc.s adjusted trial balance and prior periods balance sheet, prepare the following Financial Reports in good form using Microsoft Excel or Microsoft Word: Multi-Step Income Statement for the month of January 2014 Statement of Retained Earnings for the month of January 2014. Note: There are no prior period adjustments and all dividends declared are cash dividends in the amount of $31,060.

Be Prepared
Adjusted Trial Balance
January 31, 2014
Account ID Account Description Debits Credits
1001 Cash $ 687,490.00 $
1021 Accounts Receivable 23,000.00
1022 Allowance for Doubtful Acc 460.00
1027 Interest Receivable 60.00
1031 Notes Receivable 10,000.00
1051 Merchandise Inventory 5,190.00
1101 Store Supplies 10,000.00
1111 Office Supplies 300.00
1125 Prepaid Insurance 2,800.00
1401 Land 414,250.00
1411 Building 400,000.00
1412 Accum Dep: Building 45,750.00
1431 Office Equipment 90,000.00
1432 Accum Dep: Office Equipm 17,500.00
1451 Store Equipment 125,000.00
1452 Accum Depr: Store Equipm 15,800.00
1501 Patents 69,300.00
2001 Accounts Payable 25,000.00
2005 Income Taxes Payable 7,500.00
2031 Interest Payable 4,778.00
2101 Notes Payable long term 200,000.00
2301 Bonds Payable 800,000.00
2303 Discount on Bonds Payable 23,900.00
3001 Preferred Stock 400,000.00
3011 Common Stock 105,000.00
3101 Paid in Capital In Excess of par: Prefer 15,000.00
3111 Paid in Capital In Excess of par: Com 166,250.00
3121 Paid in Capital Treasury Stock 72,000.00
3300 Retained Earnings 53,940.00
3351 Treasury Stock 72,000.00
4001 Sales Revenue 139,000.00
4002 Sales Discount 800.00
4003 Sales Returns & Allowances 3,000.00
4101 Interest Revenue 60.00
5001 Cost of Goods Sold 84,560.00
5010 Insurance Expense - General 200.00
5012 Repairs Expense: Office 2,500.00
5015 Depreciation Expense: Building - General 750.00
5020 Depreciation Exp: Office Eq 2,500.00
5025 Supplies Expense - Selling 1,200.00
5027 Utilities Expense: Office 1,500.00
5030 Office Salaries Expense 15,000.00
5035 Office Payroll Tax Expense 1,200.00
6005 Depreciation Exp: Store Eq 800.00
6010 Amortization Expense: Pat - General 700.00
6015 Sales Salaries Expense 10,000.00
6020 Sales Payroll Tax Expense 800.00
6022 Utilities Expense: Store 1,100.00
6025 Delivery Expense - General 1,000.00
6030 Repairs Expense: Store 800.00
6040 Bad Debts Expense - Selling 460.00
7001 Interest Expense 5,878.00
$ 2,068,038.00 $ 2,068,038.00
$ 2,068,038.00 $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions