Question

In: Accounting

Instruction: Only prepare the statement of Cash flows for the year ending 12/31/2018 The trial balances...

Instruction:

Only prepare the 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

Rockford Plumbing Supply, Inc.
Statement of Cash Flows (Indirect Method)
For the Year ended Dec 31, 2018
Cash Flow from opearating activities:
Net Income (Loss)             (30,996)
Add/(Less) non cash effects on operating activities
Depreciation expense                23,000
Loss on Disposal of Plant Assets 2000
Increase in Accounts Receivables           (111,532)
Increase in Inventory              (37,711)
Increase in Supplies                (1,360)
Increase in Accounts Payables              230,750
Decrease in FICA Tax Payable                    (257)
Increase in Income Tax Payable              125,000
Decrease in Federal Withholding Taxes Payable                (7,606)
Incerase in State Withholding Taxes Payable                      415
Increase in Interest Payable                23,261             245,960
Net Cash provided by operating activities             214,964
Cash flow from Investing Activities
Purchase of Equipment              (31,100)
Sale of Truck                  8,000
Net Cash used by Investing activities             (23,100)
Cash Flow from Financing Activities
Proceeds from of Bank Line credits                15,000
Payment on Notes Payable                (5,000)
Dividend Paid              (50,000)
Net Cash used by Financing activities             (40,000)
Net Increase / (Decrease) in Cash             151,864
Cash & Cash Equivalents at the beginning - Dec 31, 2017             280,080
Cash & Cash Equivalents at the beginning - Dec 31, 2018             431,944

Related Solutions

Prepare a statement of cash flows for the month ending July 31
Seth Feye established Reliance Financial Services on July 1, 20Y2. Reliance Financial Services offers financial planning advice to its clients. The effect of each transaction and the balances after each transaction for July follow:   Assets =Liabilities + Stockholders’ Equity     Accounts   Accounts Common   Fees Salaries Rent Auto Supplies Misc.   Cash +Receivable + Supplies = Payable + Stock - Dividends + Earned - Expense - Expense - Expense - Expense - Expense a. +52,000    ...
Prepare Stoughton's statement of cash flows for the year ended December​ 31, 2018​, using the indirect...
Prepare Stoughton's statement of cash flows for the year ended December​ 31, 2018​, using the indirect method. Evaluate the​ company's cash flows for the year. In your​ evaluation, mention all three categories of cash flows and give the rationale for your evaluation. Evaluate the​ company's cash flows for the year. In your​ evaluation, mention all three categories of cash flows and give the rationale for your evaluation. Revenues: Service revenue                                 $283,000 Dividend revenue                                     8,700                                                                                                                             $291,700 Expenses: Cost of goods...
Ensemble Co. Unadjusted Trial Balance For the Year Ending December 31, 2018 Debit Balances Credit Balances...
Ensemble Co. Unadjusted Trial Balance For the Year Ending December 31, 2018 Debit Balances Credit Balances Cash 42,900 Accounts Receivable 123,500 Prepaid Insurance 27,000 Equipment 300,000 Accounts Payable 52,000 Salaries Payable 4,800 Common Stock 40,000 Retained Earnings 137,200 Dividends 5,000 Service Revenue 1,216,000 Salary Expense 660,000 Advertising Expense 275,000 Miscellaneous Expense 16,600 1,801,500 1,801,500 How does grading work? Ensemble Co. UNADJUSTED TRIAL BALANCE ACCOUNT TITLE DEBIT CREDIT 1 Cash 2 Accounts Receivable 3 Prepaid insurance 4 Equipment 5 Accounts Payable...
The Murdock Corporation Statement of Cash Flows For the Year Ended December 31, 2018 Cash flows...
The Murdock Corporation Statement of Cash Flows For the Year Ended December 31, 2018 Cash flows from Operating Activities: Net Income $         50,000 Adjustments to reconcile Net Income to Net Cash provided by operations Depreciation Expense $     53,000 Gain on Sale of Debt securities $     (4,500) Gain on Sale of Equipment $       1,000 Increase in Accounts Receivables $   (11,750) increase in Inventory $   (20,000) Decrease in Prepaid Insurance $          500 Decrease in Accounts Payable $   (72,330) Decrease in Salaries Payable...
age Corp. uses the direct method to prepare its statement of cash flows. Sage trial balances...
age Corp. uses the direct method to prepare its statement of cash flows. Sage trial balances at December 31, 2017 and 2016, are as follows. December 31 Debits 2017 2016 Cash $34,700 $31,700 Accounts receivable 33,100 29,900 Inventory 30,600 46,600 Property, plant, & equipment 100,800 95,700 Unamortized bond discount 4,500 5,000 Cost of goods sold 247,800 380,000 Selling expenses 140,900 171,900 General and administrative expenses 137,300 149,800 Interest expense 4,400 2,600 Income tax expense 20,300 61,800 $754,400 $975,000 Credits Allowance...
Prepare a Statement of Cash Flow for the year ending 2019 from the following information. 2018...
Prepare a Statement of Cash Flow for the year ending 2019 from the following information. 2018 2019 Cash 85,000 27,000 Accounts Receivable 95,000 80,000 inventory 130,000 134,000 prepaid expenses 9,500 9,000 land 89,700 130,000 PP&E 295,500 256,700 accumulated depr -30,000 -13,000 total assets 674,700 623,700 accounts payable 98,000 77,000 accrued liabilities 54,000 70,000 bonds payable 110,000 60,000 common stock 100,000 101,000 retained earnings 312,700 315,700 674,700 623,700 PP&E with a historical cost of $50,000 and a net book value of...
Prepare the financing section of the statement of cash flows for the year ended December 31,...
Prepare the financing section of the statement of cash flows for the year ended December 31, 2018. 13) Dakota Telescopes Company uses the indirect method to prepare the statement of cash flows. Refer to the following income statement:                                    Dakota Telescopes Company                                              Income Statement                                  Year Ended December 31, 2019 Sales Revenue                                                   $275,000 Interest Revenue                                                     2,600 Total Revenues                                                                                   $277,600 Cost of Goods Sold                                             135,000 Salary Expense                                                      66,500 Depreciation Expense                                          32,000 Other Operating Expenses                                 35,900 Interest Expense                                                      2,400 Income Tax...
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...
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...
A statement of cash flows explains the differences between the beginning and ending balances of: Multiple...
A statement of cash flows explains the differences between the beginning and ending balances of: Multiple Choice Cash, cash equivalents, and short-term investments. Working capital. Net income. Equity. Cash and cash equivalents.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT