Question: Note: The data needed to complete this task is located in the tab titled, Financial Statements. Using the indirect method, prepare the portions of the

Note:The data needed to complete this task is located in the tab titled, "Financial Statements."

Using the indirect method, prepare the portions of the Statement of Cash Flows of Bayshore Industries, Inc. shown below for the year ended December 31, Year 2. Double-click on a shaded cell in the Statement of Cash Flows below and choose an activity name from the dropdown list. Next to each activity, enter the appropriate value. Enter negative numbers with a leading minus (-) sign. Each item in the dropdown list may be used once, more than once, or not at all. Some of the shaded cells in the table may not be used in the completion of this task.

Note:To use a formula in the spreadsheet, it must be preceded by an equal sign (e.g., =A1+B1).

Note:It is unlikely that the CPA Exam will include a task that requires you to complete a statement of cash flows in its entirety. We have provided this detailed task in order to give you extra practice.

Comparativebalance sheetsand thestatement of income and retained earningsfor Bayshore Industries, Inc. are presented below. Use this information to answer the subsequent questions.
Bayshore Industries, Inc.
BALANCE SHEETS
December 31, Year 2 and Year 1
Year 2 Year 1 Change
Assets
Current assets
Cash and cash equivalents $216,000 $144,000 $72,000
Trade receivablesnet 3,434,000 1,971,000 1,463,000
Inventory 810,000 216,000 594,000
Prepaid expenses 18,000 0 18,000
Total current assets 4,478,000 2,331,000 2,147,000
Property and equipment 7,780,000 7,740,000 40,000
Less: accumulated depreciation 576,000 455,000 121,000
Property and equipmentnet 7,204,000 7,285,000 (81,000)
Intangibles, less accumulated amortization of $14,400Year 2 and $7,200Year 1 21,600 28,800 (7,200)
Total assets $11,703,600 $9,644,800 $2,058,800
Liabilities and Stockholders' Equity
Current liabilities
Accounts payable and accrued expenses $872,600 $396,800 $475,800
Line of credit 108,000 90,000 18,000
Current portion of long-term debt 29,000 27,000 2,000
Total current liabilities 1,009,600 513,800 495,800
Long-term debt 3,069,000 3,098,000 (29,000)
Total liabilities 4,078,600 3,611,800 466,800
Stockholders' equity
Common stock 9,000 9,000 0
Additional paid-in capital 5,400,000 5,400,000 0
Retained earnings 2,216,000 624,000 1,592,000
Total stockholders' equity 7,625,000 6,033,000 1,592,000
Total liabilities and stockholders' equity $11,703,600 $9,644,800 $2,058,800
Bayshore Industries, Inc.
STATEMENT OF INCOME AND RETAINED EARNINGS
For the year ended December 31, Year 2
Net sales $19,800,000
Cost of sales 9,000,000
Gross profit on sales 10,800,000
Operating expenses
Selling expenses 3,600,000
General and administrative expenses 4,050,000
Other operating expenses 393,300
Total operating expenses 8,043,300
Operating income 2,756,700
Other income and expenses
Gain/loss on property and equipment disposal 18,000
Interest income 9,000
Interest expense (252,000)
Other income and expensesnet (225,000)
Income before income taxes 2,531,700
Provision for income taxes 759,700
Net income 1,772,000
Retained earningsbeginning 624,000
Dividends paid (180,000)
Retained earningsending $2,216,000
Additional information on transactions during the year ended December 31, Year 2:
All accounts receivable relate to customer sales
All accounts payable relate to suppliers
All fixed assets were acquired for cash
A building with an original cost of $360,000 and accumulated depreciation of $319,500 was sold for $58,500
The company had no new long-term debt in Year 2
Interest paid in the current year was $250,000
Cash paid for income taxes in the current year was $700,000

There were no non-cash financing or investing activities during the year

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!