HomeworkLib
Question


Use the following financial statements and additional information. BARCELONA INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Equipment Accum. depreciation-Equipment Total assets $ 86,300 41,700 61,000 92,000 6,300 235, 300201,000 142,000 (39,000 (13,000) 78,000 66,000 5,000 153,000 $349,300 $330,000 Liabilities and Equity Accounts payable s 30,000 36, 00o 19,000 4,000 59,000 75,000 79,600 134,000 Wages payable Income taxes payable Total current liabilities Notes payable (long term) Total liabilities 8,000 3,600 41,600 38,000 Equity Common stock, $5 par value Retained earnings Total liabilities and equity 220, 000160, 000 36, 000 $349,300 $330,000 49,700 S0
BARCELONA INC Income Statement For Year Ended June 30, 2017 Sales Cost of goods sold Gross profit Operating expenses $803,000 491,000 312,000 Depreciation expense $68,000 77,000 Other expenses Total operating expenses 145,000 167,000 Other gains (losses) Gain on sale of equipment Income before taxes Income taxes expense Net income 3,300 170,300 52,130 $118,170 Additional Information a. A $38,000 note payable is retired at its $38,000 carrying (book) value in exchange for cash. b. The only changes affecting retained earnings are net income and cash dividends paid. c. New equipment is acquired for $67,000 cash. d. Received cash for the sale of equipment that had cost $56,000, yielding a $3,300 gain. e. Prepaid Expenses and Wages Payable relate to Other Expenses on the income statement. f. All purchases and sales of inventory are on credit. eral Trial Ledger Indirect Method Requirement General Trial Balance Journal Direct Method Using the income statement, the comparative balance sheet, and the additional information given above, reconstruc the summarized activity of the current fiscal year. Upon completion, the trial balance tab should agree with the
media%2F412%2F412bf674-994d-4729-bbf8-ce
General Requirement General Direct MethodE Indirect Journal Ledger Trial Balance Prepare the Statement of Cash flows for the year ended June 30, 201 7 using the Direct Met T-account on the General Ledger tab to identify the sources and uses of cash. List casl values. Unadjusted BARCELONA INC. Statement of Cash Flows (Direct Method) For Year Ended June 30, 2017 Cash flows from operating activities: Cash flows from investing activities Cash flows from financing activities
Requirement General General Indirect Direct Method Method Ledger Trial Balance Direct M Journal Prepare the operating activities section of the statement of cash flows using the indi reductions to net cash provided by operating activities as negative values. Unadjusted BARCELONA INC Statement of Cash Flows (Indirect Method) For Year Ended June 30, 2017 Cash flows from operating activities: Adjustments to reconcile net income to net cash provided by operating activities:
business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

57 Income Statement Adjustments Cash Flows From Operations 803,000 (491,000) Decrease in Inventory Increase in Accounts Receivable(17,000) 26,000 (6,000) (3,300) 1,300 (11,000) 58 786.000 Cash Collected from Accounts Receivabl Cost of Goods Sold Decrease in Accounts Payable (471,000) Cash Paid to Suppliers 61 Gain on sale of Equipment 3,300 Other Expenses Depreciation Expense Income Tax Expense (77,000) Decrease in prepaid expenses (68,000) Amountof reported Depreciation (52,130) Decrease in Income Tax Payable Decrease in Wages Payable (86,700) Cash paid for Other expenses 63 64 65 expense 68,000 (400) 13,700 (52,530) Cash paid for Income Tax 104,470 Cash Paid for Dividend Net Income 118,170 Increase in Retained Earnings 68 Note: 70 As for journal entry only one requirement is given in the question thats why l am passing only one journal entry 72 Date 73 30-Jun Cash Debit 786,000 Account Title & Explanation Credit Accounts Receivable 786,000 (To record cash collected) 75 76 77 30-Jun Accounts Payable 471,000 Cash 471,000 79 To record cash paid for Inventory)BARCELONAINC 82 83 84 85 Cash flow Statement (Ctrl) For the period ending June 30,2017 Direct method Particulars Details $ Am105 106 107 108 109 110 Net Increase in Cash & its equivalents Add Opening Balance of Cash Closing Balance of Cash 44,600 41,700 86,300 BARCELONA INC Cash flow Statement For the period ending June 30, 2017 (Indirect method) 112 113 114 115 116 (In millions) Details $ (In millions) Amount $ Particulars Cash flows from operating Activities 118,170 118 119 120 121 122 123 124 125 126 127 128 Net Income Add Adjustments to reconcile net income to net cash provided by operating activities: Depreciation Gain on sale of Equipment Increase in Accounts Receivable Decrease in Inventory Decrease in prepaid expenses Decrease in Accounts Payable Decrease in Wages Payable Decrease in Income Tax Pavable Net Cash provided by Operating Activities 68,000 (3,300) (17,000) 26,000 1,300 (6,000) (11,000) 400 57,600 175,770

0 0
Add a comment
Know the answer?
Add Answer to:
Use the following financial statements and additional information. BARCELONA INC. Comparative Balance Sheets June 30, 2017...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • BARCELONA INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 Assets Cash $ 86,300...

    BARCELONA INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 Assets Cash $ 86,300 $ 41,700 Accounts receivable, net 78,000 61,000 Inventory 66,000 92,000 Prepaid expenses 5,000 6,300 Total current assets 235,300 201,000 Equipment 153,000 142,000 Accum. depreciation—Equipment (39,000 ) (13,000 ) Total assets $ 349,300 $ 330,000 Liabilities and Equity Accounts payable $ 30,000 $ 36,000 Wages payable 8,000 19,000 Income taxes payable 3,600 4,000 Total current liabilities 41,600 59,000 Notes payable (long term) 38,000 75,000 Total...

  • The following financial statements and additional information are reported. IKIBAN INC Comparative Balance Sheets June 30,...

    The following financial statements and additional information are reported. IKIBAN INC Comparative Balance Sheets June 30, 2e17 and 2816 2e17 2016 Assets Cash Accounts receivable, net Inventory Propaid expenses Total current assets Equipment Accum. depreciation-Equipment Total assets s 66,e0e 73,000 119,see 9,800 268,308 137,000 (20,000) $385,308 $ 94,300 98,808 85,800 6,600 284,708 146,808 (38,000) $392,788 Liabilities and Equity Accounts payable Wages payable Income taxes payable Total current liabilities Notes payable (long tere) $ 47,808 8,200 5,608 60,800 52,000 112,800 $63,000...

  • The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...

    The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 $ 106,300 68,000 65,800 4,600 244,700 126,000 (28,000) $342,700 $ 46,000 53,000 89,500 5,800 194,300 117,000 (10,000) $301,300 Assets Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Equipment Accum. depreciation-Equipment Total assets Liabilities and Equity Accounts payable Wages payable Income taxes payable Total current liabilities Notes payable (long term) Total liabilities Equity Common stock, $5 par value...

  • The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...

    The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 Assets Cash $ 102,100 $ 53,000 Accounts receivable, net 78,500 60,000 Inventory 72,800 100,000 Prepaid expenses 5,300 7,200 Total current assets 258,700 220,200 Equipment 133,000 124,000 Accum. depreciation—Equipment (31,500 ) (13,500 ) Total assets $ 360,200 $ 330,700 Liabilities and Equity Accounts payable $ 34,000 $ 43,500 Wages payable 6,900 16,800 Income taxes payable 4,300 5,600 Total current liabilities...

  • The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...

    The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 Assets Cash $ 74,900 $ 65,000 Accounts receivable, net 96,500 72,000 Inventory 84,800 118,000 Prepaid expenses 6,500 9,600 Total current assets 262,700 264,600 Equipment 145,000 136,000 Accum. depreciation—Equipment (37,500 ) (19,500 ) Total assets $ 370,200 $ 381,100 Liabilities and Equity Accounts payable $ 46,000 $ 61,500 Wages payable 8,100 19,200 Income taxes payable 5,500 8,000 Total current liabilities...

  • The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...

    The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 $ 75,500 95,000 83,800 6,400 260,700 144,000 (37,000) $367,700 $ 64,000 71,000 116,500 9,400 260,900 135,000 (19,000) $376,900 Assets Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Equipment Accum. depreciation-Equipment Total assets Liabilities and Equity Accounts payable Wages payable Income taxes payable Total current liabilities Notes payable (long term) Total liabilities Equity Common stock, $5 par value...

  • The following financial statements and additional information are reported IKIBAN INC. Comparative Balance Sheets June 30,...

    The following financial statements and additional information are reported IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 $ 73,700 99,500 86,800 6,700 266, 700 147.000 (38,500) $375,200 $ 67,000 74,000 121,000 10,000 272,000 138,000 (20.500) $389,500 Assets Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Equipment Accum. depreciation-Equipment Total assets Liabilities and Equity Accounts payable Wages payable Income taxes payable Total current liabilities Notes payable (long term) Total liabilities Equity Common stock, $5 par...

  • The following financial statements and additional Information are reported. 2018 IKIBAN INC. Comparative Balance Sheets June...

    The following financial statements and additional Information are reported. 2018 IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 Assets Cash $ 79,700 Accounts receivable, net 84,500 Inventory 76,800 Prepaid expenses 5,700 Total current assets 246,700 Equipment 137,000 Accum. depreciation-Equipment (33,500) Total assets $350,200 Liabilities and Equity Accounts payable $ 38,000 Wages payable 7,300 Income taxes payable 4,700 Total current liabilities 50,000 Notes payable (long term) 32,600 Total liabilities 82,600 Equity Common stock, $5 par value 246,000 Retained...

  • The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...

    The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 $ 73,700 99,500 86,800 6,700 266,709 147,000 (38,500) $375,200 $ 67,000 74,000 121,000 10,000 272,000 138,000 (20,500 $389,500 Assets Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Equipment Accum. depreciation Equipment Total assets Liabilities and Equity Accounts payable Wages payable Income taxes payable Total current liabilities Notes payable (long term) Total liabilities Equity Common stock, $5 par...

  • The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...

    The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 $106,300 68,000 65,800 4,600 244,700 126,000 (28,000) $342,700 $ 46,000 53,000 89,500 5,800 194,300 117,000 (10,000) $301,300 Assets Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Equipment Accum. depreciation-Equipment Total assets Liabilities and Equity Accounts payable Wages payable Income taxes payable Total current liabilities Notes payable (long term) Total liabilities Equity Common stock, $5 par value Retained...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT