In: Accounting
Question 4 Culver Company, a major retailer of bicycles and accessories, operates several stores and is a publicly traded company. The comparative balance sheet and income statement for Culver as of May 31, 2017, are as follows. The company is preparing its statement of cash flows. CULVER COMPANY COMPARATIVE BALANCE SHEET AS OF MAY 31 2017 2016 Current assets Cash $28,500 $19,900 Accounts receivable 74,900 58,300 Inventory 221,700 251,100 Prepaid expenses 8,900 7,100 Total current assets 334,000 336,400 Plant assets Plant assets 600,200 497,300 Less: Accumulated depreciation—plant assets 149,500 126,200 Net plant assets 450,700 371,100 Total assets $784,700 $707,500 Current liabilities Accounts payable $123,900 $115,300 Salaries and wages payable 47,500 71,500 Interest payable 26,700 24,800 Total current liabilities 198,100 211,600 Long-term debt Bonds payable 70,000 100,000 Total liabilities 268,100 311,600 Stockholders’ equity Common stock, $10 par 370,000 280,000 Retained earnings 146,600 115,900 Total stockholders’ equity 516,600 395,900 Total liabilities and stockholders’ equity $784,700 $707,500 CULVER COMPANY INCOME STATEMENT FOR THE YEAR ENDED MAY 31, 2017 Sales revenue $1,267,200 Cost of goods sold 715,700 Gross profit 551,500 Expenses Salaries and wages expense 253,700 Interest expense 75,500 Depreciation expense 23,300 Other expenses 8,100 Total expenses 360,600 Operating income 190,900 Income tax expense 42,600 Net income $148,300 The following is additional information concerning Culver’s transactions during the year ended May 31, 2017. 1. All sales during the year were made on account. 2. All merchandise was purchased on account, comprising the total accounts payable account. 3. Plant assets costing $102,900 were purchased by paying $33,900 in cash and issuing 6,900 shares of stock. 4. The “other expenses” are related to prepaid items. 5. All income taxes incurred during the year were paid during the year. 6. In order to supplement its cash, Culver issued 2,100 shares of common stock at par value. 7. Cash dividends of $117,600 were declared and paid at the end of the fiscal year. Prepare a statement of cash flows for Culver Company for the year ended May 31, 2017, using the direct method. (A reconciliation of net income to net cash provided is not required.)
Cash flow from Operating activity: | |
Cash received from customers | 1,250,600 |
Cash payment to suppliers | (677,700) |
Cash payment to employees | (277,700) |
Payment of other expenses | (9,900) |
Payment of interest expense | (73600) |
Payment of taxes | (42600) |
Net cash provided by Operating Activities(A) | 169,100 |
Cash flow from Investing Activities: | |
Purchase of plant (cash purchase only) | (33,900) |
Net cash provided by investing activity(B) | (33,900) |
cash flow from financing activity: | |
Payment of bond payable | (30,000) |
Dividend paid | (117,600) |
Issue of common stock [Only cash issue ..issue for land not considered as non cash issue] = 2,100*10 | 21,000 |
net cash provided by financing activity (C) | (126,600) |
net cash provided by financing activity (C) | 8,600 |
Cash as on 1 june 2016 | 19,900 |
cash as on 31 may2017 | 28,500 |
working note :
1)cash received from customers = opening accounts receivable +sales -closing accounts recivable
= 58300+1,267,200-74900
= 1,250,600
2)Purchase =COGS +Closing inventory -opening inventory
= 715,700 +221,700-251,100
= 686,300
3)cash paid to suppliers= opening account payable +purchase- closing account payable
= 115,300+ 686,300- 123900
= 677,700.
4)payment ot employees = Opening salary payable +salary for the year - closing salary payable
= 71,500+253,700 -47500
= 277700
5)Payment of other expenses = Closing prepaid +expense of year -opening prepaid
= 8900+8,100-7,100
= 9900
6)Payment of interest = Opening of interest payable + expense of year - closing interest payable
= 24,800 +75,500-26700
= 73600
7)Payment of taxes = 42,600
**please feel free to drop your quesry in comment box.Thankyou