Question

In: Accounting

Instruction: Prepare a classified balance sheet, multi-step income statement and statement of Cash flows for the...

Instruction:

Prepare a classified balance sheet, multi-step income statement and statement of

Cash flows for the year ending 12/31/2018

The trial balances for the beginning of the year and End of the year, as well as

Additional information, are provided below.

The name of the company is: Rockford Plumbing Supply, Inc.

Final (Ending) Trial Balance - 12/31/2018

Account

Name

Debit

Credit

101

Cash

431,794

105

Petty Cash

150

112

Accounts Receivable

464,550

113

Allowance for Doubtful Accounts

40,178

115

Notes Receivable

0

120

Inventory

569,671

126

Supplies

3,680

130

Prepaid Insurance

11,020

131

Prepaid Rent

25,410

135

Other Assets

145,000

140

Land

43,000

145

Buildings

306,000

146

Accum. Depr. Buildings

78,040

151

Equipment

63,900

152

Accum. Depr. Equipment

21,200

163

Trucks

60,400

164

Accum. Depr. Trucks

41,540

200

Bank Line of Credit

15,000

201

Accounts Payable

357,600

214

FICA Taxes Payable

1,530

215

Income Taxes Payable

125,000

216

Federal Withholding Taxes Payable

1,967

218

State Withholding Taxes Payable

2,901

224

FUTA Taxes Payable

400

226

SUTA Taxes Payable

2,600

230

Interest Payable

23,261

268

Dividends Payable

0

270

Notes Payable

417,606

273

Bonds Payable

275,000

311

Discount on Bonds Payable

6,400

317

Common Stock

189,000

320

Paid-in Capital in Excess of Stated Value

256,400

330

Retained Earnings

362,748

332

Treasury Stock

401

Dividends

50,000

412

Sales Revenue

5,433,396

414

Sales Returns and Allowances

14,060

505

Sales Discounts

115,459

610

Cost of Goods Sold

3,995,710

612

Advertising Expense

7,178

631

Bad Debt Expense

1,120

644

Supplies Expense

1,540

711

Freight-out

18,542

726

Depreciation Expense

23,000

730

Salaries and Wages Expense

943,752

732

Payroll Tax Expense

83,681

820

Utilities Expense

16,669

905

Interest Revenue

3,150

921

Interest Expense

47,831

999

Loss on Disposal of Plant Assets

2,000

Income Tax Expense

197,000

Total

7,648,517

7,648,517

Additional information: A truck was sold for cash proceed of $ 8,000

The increase in equipment was due to purchase of equipment.

The decrease in debt is due to re-payments.

The portion of the notes and Bonds payable that will become due next year is $ 10,000.

Beginning Trial Balance - post closing 12/31/2017

Account

Name

Debit

Credit

101

Cash

       279,930

  

105

Petty Cash

              150

  

112

Accounts Receivable

       317,420

  

113

Allowance for Doubtful Accounts

  

           4,580

115

Notes Receivable

                  -  

  

120

Inventory

       531,960

  

126

Supplies

           2,320

  

130

Prepaid Insurance

         11,020

  

131

Prepaid Rent

         25,410

  

135

Other Assets

       145,000

  

140

Land

         43,000

  

145

Buildings

       306,000

  

146

Accum. Depr. Buildings

  

         73,040

151

Equipment

         32,800

  

152

Accum. Depr. Equipment

  

         13,200

163

Trucks

         78,400

  

164

Accum. Depr. Trucks

  

         39,540

200

Bank Line of Credit

  

                 -  

201

Accounts Payable

  

      126,850

212

FICA Taxes Payable

  

           1,787

214

Income taxes payable

                 -  

215

Federal Withholding Taxes Payable

  

           9,573

216

State Withholding Taxes Payable

  

           2,486

218

FUTA Taxes Payable

  

              400

224

SUTA Taxes Payable

  

           2,600

226

Interest Payable

                 -  

230

Dividends Payable

                 -  

250

Notes Payable

  

      422,606

268

Bonds Payable

  

     275,000

270

Discount on Bonds Payable

           6,400

  

273

Common Stock

  

      189,000

311

Paid-in Capital in Excess of Stated Value

  

      256,400

317

Retained Earnings

  

      362,748

320

Treasury Stock

                  -  

  

Total

   1,779,810

   1,779,810

Solutions

Expert Solution


Related Solutions

Instruction: Prepare a classified balance sheet, multi-step income statement and statement of Cash flows for the...
Instruction: Prepare a classified balance sheet, multi-step income statement and statement of Cash flows for the year ending 12/31/2018 The trial balances for the beginning of the year and End of the year, as well as Additional information, are provided below. The name of the company is: Rockford Plumbing Supply, Inc. Final (Ending) Trial Balance - 12/31/2018 Account Name Debit Credit 101 Cash 431,794 105 Petty Cash 150 112 Accounts Receivable 464,550 113 Allowance for Doubtful Accounts 40,178 115 Notes...
Instruc(ons Prepare a classified balance sheet, mul(-step income statement and statement of cash flows for the...
Instruc(ons Prepare a classified balance sheet, mul(-step income statement and statement of cash flows for the year ending 12/31/2018. The trial balances for the beginning of the year and end of the year, as well as addi(onal informa(on, are provided in the peach box on the next worksheet. The name of the company is Rockford Plumbing Supply, Inc. Final (Ending) Trial Balance - 12/31/2018 Beginning Trial Balance - post closing 12/31/2017 Account Name Debit Credit Account Name Debit Credit 101...
Prepare a multi step income statement, statement of retained earnings and classified balance sheet NFT Consulting...
Prepare a multi step income statement, statement of retained earnings and classified balance sheet NFT Consulting and Sales Inc PARTIALLY ADJUSTED TRIAL BALANCE October 31 2017 Part Adj T/B October Jes Trial Balance Adj Jes Adj T/B DR CR DR CR DR CR DR CR DR CR Cash $332,218         332,218         332,218 Accounts Receivable 146,800 16,275         163,075             4,109         158,966 Allowance for Uncollectible Accounts $3,689             3,689                388             4,077 Supplies 42,600           42,600           42,600...
Prepare a multiple step external income statement and classified balance sheet for the owner.
Case Background A sole proprietor (the owner) has established a service business specializing in recruitment for businesses needing specialized Tool Industry staff. The trail balance at the end of the first three months of operations is provided below. Part of the service is to train people before they are placed with companies. The owner has asked, you, the accountant for HR, to prepare the answers to the questions below considering the notes provided. Trial Balance Accounts Debits Credits Cash 24,500...
a) From the data in the worksheet, prepare a multi-step Statement of Income and a classified...
a) From the data in the worksheet, prepare a multi-step Statement of Income and a classified Balance Sheet. b) Prepare closing entries. c) Present a post-closing trial balance.    Balance Sheet & Unadjusted     Adjusted     Statement of Trial Balance Adjustments Trial Balance Income Statement Owner's Equity    Account Titles Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. Cash       17,920            54       1,717       16,257       16,257 Accounts receivable         42,350          725       43,075      ...
prepare a classified balance sheet and a statement of cash flows for the month ending August...
prepare a classified balance sheet and a statement of cash flows for the month ending August On the 1st of August, “Brothers haircut” had these transactions during this month. On August 2, Paid $2200 cash for August salon rent. On August 4, Incurred $380 of advertising costs due in 20 days On August 5, Purchased salon equipment for $120 On August 7, Paid for supplies (shampoos, creams, and gels) $350 On August 8, received $280 for selling gels On August...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 84,000 Operating Expenses $ 77,000 Common Stock 100,000 Cash Flow from Investing Activities 93,400 Notes Receivable (short term) 39,000 Prepaid Rent 14,000 Allowance for...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 79,000 Operating Expenses $ 72,000 Common Stock 100,000 Cash Flow from Investing Activities 88,400 Notes Receivable (short term) 34,000 Prepaid Rent 13,500 Allowance for...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 75,000 Operating Expenses $ 68,000 Common Stock 100,000 Cash Flow from Investing Activities 84,400 Notes Receivable (short term) 30,000 Prepaid Rent 13,100 Allowance for...
Multi-step Income Statement & Classified Balance Sheet Presented below is information from the trial balance (out...
Multi-step Income Statement & Classified Balance Sheet Presented below is information from the trial balance (out of account order-had to give you a little bit of a challenge) for DDD Corporation for the year ended December 31, 2017. Prepare a multi-step income statement and classified balance sheet in proper form. DDD is a coffee company and has decided to discontinue its entire manugacturing division and retain its retail operations. Debit Credit Accounts Payable        70,000 Accounts Receivable           60,000 Accumulated...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT