1) Using Be Prepared, Inc.?s adjusted trial balance and prior period?s balance sheet, prepare the following Financial...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
Nutistep Income statement for month of January 2019 Statement of Retained Earning for month of Janua... View the full answer
Related Book For
Financial and Managerial Accounting
ISBN: 978-0132497978
3rd Edition
Authors: Horngren, Harrison, Oliver
Posted Date:
Students also viewed these accounting questions
-
The income statement for the month of February indicates a net income of $17,500. During the same period, $25,500 in cash dividends was paid. Would it be correct to say that the business incurred a...
-
The following bank statement for the month of May is for El Guapo Industries: The following information was taken from the books at El Guapo: Required Prepare El Guapo's May bank reconciliation and...
-
The cash records and bank statement for the month of May for Diaz Entertainment are shown below. Additional information: a. The difference in the beginning balances in the companys records and the...
-
Write using only positive exponents and then evaluate. Assume that all variables represent nonzero real numbers. 5 -2
-
Show that is increasing. Find an upper bound. 3n- n2 2
-
You start with an inflated balloon with a volume of 1 m 3 ?. While keeping the balloon at atmospheric pressure, you heat the balloon from 17 o C to 23 o C. How much work does the air perform on the...
-
Describe and distinguish between positive and negative confirmation requests.
-
Develop the material requirements plan for all components and intermediate items associated with product A for the next 10 weeks. Refer to Solved Problem 1 (Figure) for the bill of materials and...
-
a. If a South pole moves toward the loop in the plane of the page, in what direction is the induced current? (10 points) b. If a coil is expanding in a magnetic field pointing out from the page, in...
-
Compute the missing amount (?) for each company. (Amounts are in millions.) At the end of the year, which company had the highest net income? highest percent of net income to revenues? Babble Co....
-
Suppose that a system uses a combination of 2 frequencies and 2 amplitudes to transmit at 9600 baud (symbol/second), How many discrete levels does it has? - what is the maximum data rate? Assume...
-
Discuss the ethical responsibility of high-visibility athletes who become role models during a public health crisis. If you were in charge of a sports league, how would you handle an athlete who is...
-
What are other examples of letters to fans in sport communication? Discuss these examples and how they were employed.
-
How could campaigners and sponsors/marketeers work together to end pay inequality for women athletes?
-
Race and gender differences often correlate with poor treatment and support for mental health. What, if any, additional obligations should organizations have to act with a differential response? In...
-
How have other sports responded to athlete concerns about mental health? How have athletes in other sports brought attention to mental health concerns in their sport?
-
Under what conditions would the Fed choose to decrease the money supply, how would it do so , and what is the goal of doing so ? How does the Fed factor inflation into its actions?
-
suppose a nickel-contaminated soil 15 cm deep contained 800 mg/kg Ni, Vegetation was planted to remove the nickel by phytoremediation. The above-ground plant parts average 1% Ni on a dry-weight bas...
-
The power of HR metrics and analytics is an untapped resource for many organizations. Human resource information systems (HRIS) are commonly used to capture and store gigabytes of data about...
-
Dependable Drivers Driving School charges $250 per student to prepare and administer written and driving tests. Variable costs of $100 per student include trainers wages, study materials, and...
-
Rita Lane is the accountant for Outdoor Living, a manufacturer of outdoor furniture that is sold through specialty stores and Internet companies. Lane is responsible for reviewing the standard costs....
-
Heart of Texas Telecom has these account balances at December 31, 2012: Requirements 1. Compute Heart of Texas Telecoms current ratio and debt ratio. 2. How much in current assets does Heart of Texas...
-
Assuming that the failure mode for longitudinal compression of unidirectional E-glass/epoxy with fiber volume fraction \(v_{\mathrm{f}}=0.6\) is a transverse tensile rupture due to Poisson strains,...
-
For the IM-9/8551-7 carbon/epoxy composite rod design of Problem 3.3 in Chapter 3, what would be the increase in the longitudinal tensile strength compared with that of the original 6061-T6 aluminum...
-
Using the maximum strain criterion and micromechanics, set up the equations for predicting the averaged isotropic strength of a randomly oriented continuous fiber composite. Your answer should be...
Study smarter with the SolutionInn App