Question

In: Accounting

The following information relates to the Cisco Corporation for the years ended December 31. Cisco Corporation...

The following information relates to the Cisco Corporation for the years ended December 31.

Cisco Corporation

Comparative Balance Sheets

December 31

Assets

2019

2018

Cash

$ 92,700

$ 33,400

Accounts receivable

70,800

37,000

Inventory

131,900

102,650

Investments

84,500

107,000

Equipment

310,000

205,000

Accumulated depreciation - equipment

(49,500)

(40,000)

Total

$640,400

$445,050

Liabilities and Stockholders’ Equity

Accounts payable

$ 62,700

$ 48,280

Accrued expenses payable

15,100

18,830

Bonds payable

140,000

70,000

Common stock

250,000

200,000

Retained earnings

172,600

107,940

Total

$640,400

$445,050

Cisco Corporation

Income Statement

For the Year Ended December 31, 2019

Sales revenue

$

$297,500

Gain on sale of plant assets

5,000

302,500

Less:

Cost of goods sold

$119,460

Operating expense excluding depreciation

14,670

Depreciation expense

35,500

Income tax expense

27,270

Interest expense

2,940

199,840

Net income

$102,660

Additional information:

1.   New equipment costing $141,000 were purchased for cash during the year.

2.   Investments were sold at cost.

3.   Old equipment costing $36,000 were sold for $15,000. The equipment had a book value of $10,000 at the time of the sale..

4.    A cash dividend of $38,000 was declared and paid during the year

Instructions:

Prepare a statement of cash flows for the year ended December 31, 2019 using the indirect method.

Solutions

Expert Solution

No. Conceptual Notes
1 Cash Flow Statement reflects the Cash Inflows and Outflows during a period of time.
2 Effects of Non - Cash Transaction are adjusted from Net Income.
3 Depreciation Expense, Amortisation expenses are Added back to Net Income in Cash Flow Statement.
4 Decrease in Current Assets OR Increase in Current Liabilities are ADDED to Net Income
5 Increase in Current Assets OR Decrease in Current Liabilities are DEDUCTED from Net Income

--Requirement

Statement of cash flows
for the year ended December 31, 2019 using the
A. Cash Flows from Operating Activities
Net Income $102,660
Adjustment to Nreconcile net cash to Net Income
Depreciation expense $35,500
Gain on Sale of Old Equipment [15000 - 10000] ($5,000)
Increase in Accounts receivables ($33,800)
Increase in Inventory ($29,250)
Increase in Accounts Payable $14,420
Decrease in Accrued Expenses Payable ($3,730) ($21,860)
Net Cash Provided from Operating Activities $80,800
B. Cash Flows from Investing Activities
Purchase of Equipment ($141,000)
Sale of Investment $22,500
Sale of Old Equipment $15,000
Net Cash Flows from Investing Activities ($103,500)
C. Cash Flows from Financing Activities
Issue of Bonds Payable $70,000
Issue of Common Stock $50,000
Dividends ($38,000)
Net Cash flows from financing activities $82,000
Net Increase (Decrease) during the period $59,300
Cash at the beginning $33,400
Cash at the end $92,700

Related Solutions

The following information relates to the Brown Corporation for the year ended December 31, 2017: 2017...
The following information relates to the Brown Corporation for the year ended December 31, 2017: 2017 net income $75,000 Unrealized holding gain on available-for-sale debt securities during the year $6,000 Unrealized holding loss on equity securities classified as trading securities ($4,000) The accumulated other comprehensive income (AOCI) account had a credit balance of $45,000 at the end of 2016. Assuming no other changes during the year affected AOCI and assuming that the unrealized loss on trading securities is already reflected...
10. The following information relates to Nabisco Corporation for the year ended December 31, 2016. All...
10. The following information relates to Nabisco Corporation for the year ended December 31, 2016. All amounts are before income taxes. Assume a 25% income tax rate for all items.      Net sales                                                $ 1,050,000      Other expenses and losses                                 $ 100,000      Operating expenses                                         $ 200,000      Other revenues and gains                                   $ 60,000      Cost of goods sold                                         $ 450,000      Unrealized loss on available-for-sale securities           $ 50,000 Additional information: The entire snack division was discontinued on September 30....
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The...
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The company tells you that Income from Continuing Operations PRE Taxes is $ 300,000. However, this amount was computed before the company considered these items: (i.e. none of the items listed below are factored into the $300,000) Restructuring Costs incurred in 2018 were $25,000 When recording depreciation expense for the previous year (2017), they mistakenly recorded depreciation twice for the same asset. The amount of...
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The...
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The company tells you that Income from Continuing Operations PRE Taxes is $ 300,000. However, this amount was computed before the company considered these items: (i.e. none of the items listed below are factored into the $300,000) Restructuring Costs incurred in 2018 were $25,000 When recording depreciation expense for the previous year (2017), they mistakenly recorded depreciation twice for the same asset. The amount of...
The following information relates to Walnut Ltd. for the year ended December 31, 2013: Sales                          &nbsp
The following information relates to Walnut Ltd. for the year ended December 31, 2013: Sales                                                                                                         $3,500,000 Purchases: Direct materials                                                                                   $700,000 Indirect materials                                                                                 $50,000 Office supplies                                                                                     $20,000       Salaries                                                                                                      $500,000 * Direct labour                                                                                              $800,000       Rent                                                                                                          $100,000 *       Utilities                                                                                                     $80,000 *       Advertising and promotional                                                                     $30,000       Inventories:                             Dec. 31, 2012                      Dec. 31, 2013 Direct materials                $45,000                                $62,000 Indirect materials                 -----                                  $ 9,000 Office supplies                  $1,000                                     ----- Work-in-process               $4,100                                   $3,300 Finished goods                  $90,000                                 $81,700 *Of these costs, 80 % are assigned to manufacturing activities and the remainder pertain to selling and administrative functions.                         (Assume that there is no "over-or-under" applied overhead.) Instructions: Prepare in good form...
The following schedule of information relates to Lumos, Inc. for the year ended December 31, 2017:...
The following schedule of information relates to Lumos, Inc. for the year ended December 31, 2017: Nonoperating cash receipts: For sale of common stock $ 65,280 From sale of land (original cost $111,600) 94,800 From sale of intangible assets (at net book value) 37,800 Nonoperating cash payments: For purchase of common stock as investment 1,020,000 To stockholders as dividends 117,600 The company’s balance sheet reports the following: December 31, 2017 December 31, 2016 Cash $ 134,160 $ 100,800 Accounts receivable...
The following information is available for United Corporation on December 31 for the year just ended....
The following information is available for United Corporation on December 31 for the year just ended. A review of the $12,000 unadjusted balance in the prepaid rent account shows a remaining balance of $8,750 at the end of the year. $2,200 of the television advertising paid for in advance has been used. The yearly depreciation on the building is $150. The yearly depreciation on the equipment is $800. $1,200 of the advertising paid for in advance has been published by...
The following information relates to Hudson City for its fiscal year ended December 31, 2017. During...
The following information relates to Hudson City for its fiscal year ended December 31, 2017. During the year, retailers in the city collected $1,700,000 in sales taxes owed to the city. As of December 31, retailers have remitted $1,100,000, $200,000 is expected in January 2018, and the remaining $400,000 is expected in April 2018. On December 31, 2016, the Foundation for the Arts pledged to donate $1, up to a maximum of $1 million, for each $3 that the museum...
The following information relates to Hudson City for its fiscal year ended December 31, 2017. During...
The following information relates to Hudson City for its fiscal year ended December 31, 2017. During the year, retailers in the city collected $1,700,000 in sales taxes owed to the city. As of December 31, retailers have remitted $1,100,000, $200,000 is expected in January 2018, and the remaining $400,000 is expected in April 2018. On December 31, 2016, the Foundation for the Arts pledged to donate $1, up to a maximum of $1 million, for each $3 that the museum...
The following inventory information is available for Muscat Manufacturing Corporation for the year ended December 31,...
The following inventory information is available for Muscat Manufacturing Corporation for the year ended December 31, 2018:                                                                      Beginning                 Ending             Inventories:             Raw materials                                    $68,000                 $76,000             Work in process                                   36,000                   56,000             Finished goods                                   44,000                   32,000 Total $148,000         $164,000 In addition, the following transactions occurred in 2018: 1.   Raw materials purchased on account, $280,000. 2.   Incurred factory labor, $320,000, all is direct labor. (Credit Factory Wages Payable). 3.   Incurred the following overhead costs during the year:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT