In: Accounting
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 |
|
||||
|
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 |
|||