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 $ 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 Payable (long-term) 36,200 42,000 Common Stock 87,400 72,400 Retained Earnings 36,800 24,800 $ 197,320 $ 167,500 Income Statement Sales Revenue $ 118,000 Cost of Goods Sold 69,000 Other Expenses 37,000 Net Income $ 12,000 Additional Data: a. Bought equipment for cash, $20,000. b. Paid $5,800 on the long-term note payable. c. Issued new shares of stock for $15,000 cash. d. No dividends were declared or paid. e. Other expenses included depreciation, $4,800; Salaries and wages, $19,800; taxes, $5,800; utilities, $6,600. 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.

Solutions

Expert Solution

XS Company

Cash Flow Statement

XS Company

Cash Flow Statement

for the year ended December 31,

Cash flow from operating activities:

Net Income

$!2,000

Adjustments to reconcile net income to net cash provided by operating activites -

Depreciation expense

$4,800

Increase in accounts receivable

($6,800)

Increase in inventory

($2,800)

Increase in Accounts Payable

$8,800

Decrease in salaries and wages

($180)

Net cash provided by operating activities

$3,820

Net cash from operating activities

$15,820

Cash flow from investing activities:

Payment towards purchase of equipment

($20,000)

Net cash from investing activities

($20,000)

Cash flow from financing activities:

Issue of common shares for cash

$15,000

payment towards long-tern note

($5,800)

Net cash flow from financing activities

$9,200

Excess of cash over disbursements

$5,020

Add: Beginning cash balance

$28,700

Ending cash balance

$33,720


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 $ 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...
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