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,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 Payable (long-term) 34,400 40,000 Common Stock 86,200 72,200 Retained Earnings 36,400 24,600 $ 193,640 $ 165,000 Income Statement Sales Revenue $ 116,000 Cost of Goods Sold $ 68,000 Other Expenses 36,200 Net Income $ 11,800 Additional Data: Bought equipment for cash, $19,000. Paid $5,600 on the long-term note payable. Issued new shares of stock for $14,000 cash. No dividends were declared or paid. Other expenses included depreciation, $4,600; Salaries and wages, $19,600; taxes, $5,600; utilities, $6,400. 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

Solution:

XS Supply Company
Statement of Cash Flows
For Current Year
Particulars Details Amount
Cash Flow from Operating Activities:
Net Income $11,800.00
Adjustments to reconcile net income to net cash provided by operations:
Depreciation Expense $4,600.00
Increase in accounts receivables ($34,200 - $27,600) -$6,600.00
Increase in inventory ($40,200 - $37,600) -$2,600.00
Increase in accounts payable ($35,200 - $26,600) $8,600.00
Decrease in Salaries and wages payable ($1,600 - $1,440) -$160.00
Net Cash provided by operating activities $15,640.00
Cash Flow from Investing Activities:
Purchase of equipment -$19,000.00
Net Cash used in Investing activities -$19,000.00
Cash Flow from Financing Activities:
Payment of long term note -$5,600.00
Proceed from issue of common stock $14,000.00
Net Cash Provided by financing activities $8,400.00
Net Increase / (Decrease) in Cash $5,040.00
Cash balance at beginning of year $28,400.00
Cash balance at end of year $33,440.00

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