Question

In: Accounting

XS Supply Company is developing its annual financial statements at December 31. The statements are complete...

XS Supply Company is developing its annual financial statements at December 31. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized:

Current Year Previous Year
  Balance Sheet at December 31
     Cash $ 32,570 $ 27,500
     Accounts Receivable 33,600 27,300
     Inventory 39,600 37,300
     Equipment 110,500 93,000
     Accumulated Depreciation—Equipment (28,600 ) (24,300 )
$ 187,670 $ 160,800
     Accounts Payable $ 34,600 $ 26,300
     Salaries and Wages Payable 1,170 1,300
     Note Payable (long-term) 31,700 37,000
     Common Stock 84,400 71,900
     Retained Earnings 35,800 24,300
$ 187,670 $ 160,800
  Income Statement
     Sales Revenue $ 113,000
     Cost of Goods Sold 66,500
     Other Expenses 35,000
     Net Income $ 11,500
Additional Data:
a. Bought equipment for cash, $17,500.
b. Paid $5,300 on the long-term note payable.
c. Issued new shares of stock for $12,500 cash.
d. No dividends were declared or paid.
e.

Other expenses included depreciation, $4,300; Salaries and wages, $19,300; taxes, $5,300; utilities, $6,100.

f.

Accounts Payable includes only inventory purchases made on credit. Because there are no liability accounts relating to taxes or other expenses, assume that these expenses were fully paid in cash.

Required:
1.

Prepare the statement of cash flows for the current year ended December 31 using the indirect method. (Amounts to be deducted should be indicated with a minus sign.)

Solutions

Expert Solution

XS SUPPLY COMPANY
Statement of Cash Flows
For the Year Ended December 31
Cash flows from operating activities:
Net income 11500
Adjustments to reconcile net income to net cash
provided by operating activities:
Depreciation expense 4300
Increase in accounts receivable -6300
Increase in inventory -2300
Increase in accounts payable 8300
Decrease in Salaries and wages payable -130
3870
Net cash provided by operating activities 15370
Cash flows from investing activities:
Cash payments to purchase equipment -17500
Net cash used by investing activities -17500
Cash flows from financing activities:
Cash payments on long-term note -5300
Cash receipts from issuing stock 12500
Net cash provided by financing activities 7200
Net increase in cash during the year 5070
Cash balance, January 1 27500
Cash balance, December 31 32570

Related Solutions

XS Supply Company is developing its annual financial statements at December 31. The statements are complete...
XS Supply Company is developing its annual financial statements at December 31. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized: Current Year Previous Year Balance Sheet at December 31 Cash $ 33,440 $ 28,400 Accounts Receivable 34,200 27,600 Inventory 40,200 37,600 Equipment 115,000 96,000 Accumulated Depreciation—Equipment (29,200 ) (24,600 ) $ 193,640 $ 165,000 Accounts Payable $ 35,200 $ 26,600 Salaries and Wages Payable 1,440 1,600 Note...
XS Supply Company is developing its annual financial statements at December 31. The statements are complete...
XS Supply Company is developing its annual financial statements at December 31. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized: Current Year Previous Year Balance Sheet at December 31 Cash $ 33,720 $ 28,700 Accounts Receivable 34,600 27,800 Inventory 40,600 37,800 Equipment 118,000 98,000 Accumulated Depreciation—Equipment (29,600 ) (24,800 ) $ 197,320 $ 167,500 Accounts Payable $ 35,600 $ 26,800 Salaries and Wages Payable 1,320 1,500 Note...
Hunter Company is developing its annual financial statements at December 31. The statements are complete except...
Hunter Company is developing its annual financial statements at December 31. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized: Current Year Prior Year Balance Sheet at December 31 Cash $ 44,100 $ 13,000 Accounts Receivable 18,000 19,000 Inventory 21,000 26,000 Equipment 100,000 92,000 Accumulated Depreciation—Equipment (33,000 ) (25,000 ) Total Assets $ 150,100 $ 125,000 Accounts Payable $ 19,000 $ 17,000 Salaries and Wages Payable 900 1,000...
Hunter Company is developing its annual financial statements at December 31. The statements are complete except...
Hunter Company is developing its annual financial statements at December 31. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized: Current Year Prior Year Balance Sheet at December 31 Cash $ 44,440 $ 16,000 Accounts Receivable 23,400 25,000 Inventory 26,400 32,000 Equipment 106,600 98,000 Accumulated Depreciation—Equipment (35,400 ) (28,000 ) Total Assets $ 165,440 $ 143,000 Accounts Payable $ 22,600 $ 20,000 Salaries and Wages Payable 840 1,000...
Audio City, Inc. is developing its annual financial statements at December 31. The statements are complete...
Audio City, Inc. is developing its annual financial statements at December 31. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized below: Current Year Previous Year Balance Sheet at December 31      Cash $ 82,500 $ 84,800      Accounts Receivable 18,600 24,500      Inventory 27,400 24,500      Equipment 241,000 159,000      Accumulated Depreciation–Equipment (73,500 ) (54,000 )    $ 296,000 $ 238,800         Accounts Payable $ 8,900 $ 20,800      Salaries and Wages...
BG Wholesalers is developing its annual financial statements at December 31, 2016. The statements are complete...
BG Wholesalers is developing its annual financial statements at December 31, 2016. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized: 2016 2015   Balance sheet at December 31      Cash $ 39,400 $ 31,600      Accounts receivable 36,300 31,600      Merchandise inventory 45,000 40,500      Property and equipment 125,600 102,700      Less: Accumulated depreciation (34,000) (27,100)    $ 212,300 $ 179,300         Accounts payable $ 40,300 $ 31,600      Accrued wage expense 3,500 4,000...
Audio City, Inc. is developing its annual financial statements at December 31. The statements are complete...
Audio City, Inc. is developing its annual financial statements at December 31. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized below: Current Year Previous Year Balance Sheet at December 31      Cash $ 65,200 $ 69,400      Accounts Receivable 15,800 21,000      Inventory 23,200 21,000      Equipment 227,000 152,000      Accumulated Depreciation–Equipment (63,000 ) (47,000 )    $ 268,200 $ 216,400         Accounts Payable $ 8,200 $ 19,400      Salaries and Wages...
Audio City, Inc. is developing its annual financial statements at December 31. The statements are complete...
Audio City, Inc. is developing its annual financial statements at December 31. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized below: Current Year Previous Year Balance Sheet at December 31      Cash $ 72,700 $ 76,000      Accounts Receivable 17,000 22,500      Inventory 25,000 22,500      Equipment 233,000 155,000      Accumulated Depreciation–Equipment (67,500 ) (50,000 )    $ 280,200 $ 226,000         Accounts Payable $ 8,500 $ 20,000      Salaries and Wages...
BGP Electrical Supply is developing its annual financial statements at December 31, current year. The statements...
BGP Electrical Supply is developing its annual financial statements at December 31, current year. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized: Current Year Prior Year Balance sheet at December 31 Cash $ 37,800 $ 30,500 Accounts receivable 33,700 29,500 Merchandise inventory 46,000 38,800 Property and equipment 122,800 101,200 Less: Accumulated depreciation (31,700 ) (25,900 ) $ 208,600 $ 174,100 Accounts payable $ 37,700 $ 29,000 Accrued...
A company annual financial statements at December 31, 2017. The statements are complete except for the...
A company annual financial statements at December 31, 2017. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized: 2017 2016   Balance Sheet at December 31      Cash $ 48,375 $ 34,100      Accounts Receivable 38,150 30,200      Merchandise Inventory 46,300 42,000      Property and Equipment 136,750 114,000      Less: Accumulated Depreciation (37,550 ) (28,500 ) $ 232,025 $ 191,800      Accounts Payable $ 44,000 $ 32,400      Wages Payable 3,625 3,950      Note Payable, Long−Term 41,500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT