Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribed

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 Be Prepared Inc. Balance Sheet December 31, 2020 $ $ 50,000 25,000 7,500 175,000 150,000 357,500 Assets Cash Accounts Receivable Merchandise Inventory Office Supplies Prepaid Insurance Land Building Accumulated Depreciation, Building Office Equipment Accumulated Depreciation, Office Equipment Store Equipment Accumulated Depreciation, Store Equipment Patents Total Assets Liabilities 74,800 Accounts Payable 40,000 Income Taxes Payable Note Payable 1,500 Mortgage Payable 3,000 Total Liabilities 125.000 400,000 Stockholder's Equity (63,000) Preferred Stock 70.000 70,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 65,800 Total Stockholder's Equity 812,100 Total Liabilities and Stockholder's Equity 52,500 115,000 61,250 200,000 25,850 454,600 812,100 $ $ Be Prepared Adjusted Trial Balance January 31, 2021 Credits $ Debits 423,615.00 $ 25,000.00 540.00 100.00 15,000.00 7,200.00 8,000.00 500.00 1,600.00 375,000.00 500,000.00 72,000.00 70,000.00 17,500.00 95,000.00 15,800.00 65,000.00 30,000.00 12,500.00 5,500.00 325,000.00 375,000.00 10,500.00 Account ID Account Description 1001 Cash 1021 Accounts Receivable 1022 Allowance for Doubtful Acc 1027 Interest Receivable 1031 Notes Receivable 1051 Merchandise Inventory 1101 Store Supplies 1111 Office Supplies 1125 Prepaid Insurance 1401 Land 1411 Building 1412 Accum, Dep: Building 1431 Office Equipment 1432 Accum, Dep: Office Equipo 1451 Store Equipment 1452 Accu Depr: Store Evidt 1501 Patents 2001 Accounts Payable 2005 Income Taxes Payabe 2031 Interest Payable 2101 Notes Payable long term 2301 Bonds Payable 2303 Discount on Bonds Payable 3001 Preferred Stock 3011 Common Stock 3101 Paid in Capital In Excess of par: Prefer 3111 Paid in Capital La Excess of par: Com 3121 Paid in Capital Treasury Stock 3300 Retained Earnings 3351 Treasury Stock 4001 Sales Revenue 4002 Sales Discount 4003 Sales Returns & Allowances 4101 Interest Revenue 5001 Cost of Goods Sold 5010 Insurance Expense - General 5012 Repairs Expense: Office 5015 Depreciation Expense: Building - Genera 5020 Depreciation Exp: Office Eq 5025 Supplies Expense - Selling 5027 Utilities Expense: Office 5030 Office Salaries Expense 5035 Office Payroll Tax Expense 6005 Depreciation Exp: Store 69 6010 Amortization Expense: Pat-Genera 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 210,000.00 120,000.00 61,250.00 295,000.00 90,000.00 850.00 90,000.00 275,575.00 750.00 5,250.00 50.00 125,500.00 300.00 2,100.00 9,000.00 2,500.00 2,400.00 1,100.00 25,000.00 7,000.00 800.00 800.00 20,000.00 5,600.00 1,200.00 1,500.00 750.00 2,000.00 6,500.00 1,906,565.00 $ S 1,906,565.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Introductory Statistics For The Behavioural Sciences

Authors: Joan Welkowitz, Robert B. Ewen, Jacob Cohen

2nd Edition

0127432604, 9780127432601

More Books

Students also viewed these Accounting questions

Question

What are the role of supervisors ?

Answered: 1 week ago

Question

Appreciate the services that consultants provide

Answered: 1 week ago

Question

Know about the different kinds of consultants

Answered: 1 week ago