Question

In: Finance

Dec. 31, Year 2 Dec. 31, Year 1 ASSETS Current assets: Cash and cash equivalents $...

Dec. 31, Year 2

Dec. 31, Year 1

ASSETS

Current assets:

Cash and cash equivalents

$ 92,069  

$ 72,634

Accounts receivables, net

55,947

75,492

Inventories

50,784

53,129

Prepaid expenses

   12,112

   13,057

Total current assets

210,912

214,312

Equipment

145,444

134,312

Less: Accumulated depreciation

(50,515)

(36,689)

Total assets

$305,841

$311,935

LIABILITIES AND STOCKHOLDERS’ EQUITY

Current liabilities:

Accounts payable

$ 25,466

$ 34,879

Accrued liabilities

    40,574

    40,722

Total current liabilities

    66,040

    75,601

Long-term debt

    10,422

    10,206

Stockholders’ equity:

Contributed capital

1,662

1,284

Retained earnings

227,717

224,844

Total stockholders’ equity

229,379

226,128

Total liabilities and stockholders’ equity

$305,841

$311,935

Consolidated Statement of Income

(in thousands)

Year 2

Net sales

$130,896   

Cost of sales

   74,040     

Gross profit

   56,856     

Operating expenses:

Selling, general & administrative expenses

33,211     

Depreciation expense

13,826

Total operating expenses

47,037

Operating income

9,819  

Interest income

        239

Income before income taxes

10,058     

Income tax expense

     3,621      

Net income

$   6,437    

The Group, Inc. did not sell any equipment or repay any borrowings during the year ended December 31, Year 2. The company declared and paid dividends in the amount of $3,564 during the year ended December 31, Year 2.

Questions

  1. Using the information provided above, compute the net cash flow provided by (used in) operating, investing and financing activities using the indirect method.

  1. Prepare a cash flow statement for the year ended December 31, Year 2.

Solutions

Expert Solution

STATEMENT OF CASH FLOWS [INDIRECT METHOD]
Cash flows from operating activities:
Net income $               6,437
Adjustments to reconcile net income to net cash provided by operations:
Depreciation $ 13,826
Decrease in receivables [75492-55947] $ 19,545
Decrease in inventories [53129-50784] $                   2,345
Decrease in prepaid expenses [13057-12112] $ 945
Decrease in accrued liabilities [40722-40574] $ -148
Decrease in accounts payable [34879-25466] $ -9,413 $             27,100
Net cash from operating activities $             33,537
Cash flows from investing activities:
Purchase of equipment [145444-134312] $               -11,132
Net cash from investing activities $ -11,132
Cash flows from financing activities:
Issuance of common stock [1662-1284] $ 378
Issue of additional debt [10422-10206] $ 216
Payment of dividends $                 -3,564
Net cash used by financing activitites $              -2,970
Net increase in cash $             19,435
Cash & cash equivalents in the beginning $             72,634
Cash & cash equivalents in the end $             92,069

Related Solutions

Cash and cash equivalents, Dec. 31 prior year-end $ 45,000 Cash and cash equivalents, Dec. 31...
Cash and cash equivalents, Dec. 31 prior year-end $ 45,000 Cash and cash equivalents, Dec. 31 current year-end 126,540 Cash received as interest 4,500 Cash paid for salaries 130,500 Bonds payable retired by issuing common stock (no gain or loss on retirement) 140,000 Cash paid to retire long-term notes payable 225,000 Cash received from sale of equipment 110,250 Cash received in exchange for six-month note payable 45,000 Land purchased by issuing long-term note payable 81,200 Cash paid for store equipment...
Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net...
Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net 433,638 279,835 Inventories 783,031 536,714 Prepaid expenses and other current assets 152,242 87,177 Deferred income taxes 52,498 Total current assets 1,498,763 1,549,399 Property and equipment, net 538,531 305,564 Goodwill 585,181 123,256 Intangible assets, net 75,686 26,230 Deferred income taxes 92,157 33,570 Other long-term assets 78,582 57,064 Total assets 2,868,900 2,095,083 Liabilities and Stockholders Equity Accounts payable 200,460 210,432 Accrued expenses 192,935 147,681 Current maturities...
Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net...
Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net 433,638 279,835 Inventories 783,031 536,714 Prepaid expenses and other current assets 152,242 87,177 Deferred income taxes 52,498 Total current assets 1,498,763 1,549,399 Property and equipment, net 538,531 305,564 Goodwill 585,181 123,256 Intangible assets, net 75,686 26,230 Deferred income taxes 92,157 33,570 Other long-term assets 78,582 57,064 Total assets 2,868,900 2,095,083 Liabilities and Stockholders Equity Accounts payable 200,460 210,432 Accrued expenses 192,935 147,681 Current maturities...
1 Dec. 31, 20Y8 Dec. 31, 20Y7 2 Assets 3 Cash $146,480.00 $179,640.00 4 Accounts receivable...
1 Dec. 31, 20Y8 Dec. 31, 20Y7 2 Assets 3 Cash $146,480.00 $179,640.00 4 Accounts receivable (net) 225,010.00 241,920.00 5 Inventories 321,600.00 298,870.00 6 Prepaid expenses 13,030.00 10,420.00 7 Equipment 654,380.00 537,900.00 8 Accumulated depreciation-equipment (169,970.00) (133,130.00) 9 Total assets $1,190,530.00 $1,135,620.00 10 Liabilities and Stockholders’ Equity 11 Accounts payable (merchandise creditors) $240,960.00 $236,720.00 12 Mortgage note payable     0.00 335,410.00 13 Common stock, $10 par 510,000.00 247,000.00 14 Paid-in capital: Excess of issue price over par—common stock 430,000.00 310,000.00 15...
PHAROAH COMPANY Balance Sheets December 31 (in thousands) 2022 2021 Current assets    Cash and cash equivalents...
PHAROAH COMPANY Balance Sheets December 31 (in thousands) 2022 2021 Current assets    Cash and cash equivalents $330 $360    Accounts receivable (net) 570 500    Inventory 640 570    Prepaid expenses 130 160      Total current assets 1,670 1,590 Property, plant, and equipment (net) 410 380 Investments 110 110 Intangibles and other assets 530 510      Total assets $2,720 $2,590 Current liabilities $920 $890 Long-term liabilities 660 560 Stockholders’ equity—common 1,140 1,140      Total liabilities and stockholders’ equity $2,720 $2,590 PHAROAH COMPANY Income Statements For the...
JOHNSTON ENTERPRISES           BALANCE SHEET              31-Dec-17       31-Dec-16 Current Assets:        &nb
JOHNSTON ENTERPRISES           BALANCE SHEET              31-Dec-17       31-Dec-16 Current Assets:           Cash   $140,000        $120,000 Accounts Receivable   200,000       300,000 Inventory   400,000       300,000 Total Current Assets   740,000       720,000 Property, Plant, and Equipment   1,241,000       1,122,000 Less: Accumulated Depreciation   -476,000       -442,000 Total Assets   1,505,000       1,400,000            Current Liabilities:             Accounts Payable   $201,000        $130,000 Notes Payable   40,000       60,000 Income Taxes Payable   90,000       70,000 Total...
Mohammed Corporation's comparative balance sheet for current assets and liabilities was as follows: Dec. 31, Year...
Mohammed Corporation's comparative balance sheet for current assets and liabilities was as follows: Dec. 31, Year 2 Dec. 31, Year 1 Accounts receivable $30,300 $26,600 Inventory 63,500 73,800 Accounts payable 19,800 16,400 Dividends payable 25,000 27,000 Adjust net income of $124,400 for changes in operating assets and liabilities to arrive at net cash flow from operating activities
Balance​ Sheet: ​3/31/2016 ​12/31/2015 ​9/30/2015 ​6/30/2015 Assets Current Assets Cash and cash equivalents 293 300 255...
Balance​ Sheet: ​3/31/2016 ​12/31/2015 ​9/30/2015 ​6/30/2015 Assets Current Assets Cash and cash equivalents 293 300 255 232 Net receivables 401 362 385 460 Inventory 374 342 437 306 Other current assets 60 43 53 45 Total Current Assets ​1,128 ​1,047 ​1,130 ​1,043 ​Long-term investments 128 97 long dash— 200 ​Property, plant, and equipment 979 991 995 ​1,052 Goodwill 744 748 736 742 Other assets 777 830830 903903 797 Total Assets ​3,756 3 comma 7133,713 3 comma 7643,764 ​3,834 Liabilities Current...
2011 2010 Difference Operating Investing Financing ASSETS: Current Assets Cash and equivalents $ 2,291.1 $ 2,133.9...
2011 2010 Difference Operating Investing Financing ASSETS: Current Assets Cash and equivalents $ 2,291.1 $ 2,133.9 157.2 0 0 0 Short-term investments    1,164.2       642.2 522 -522 Account receivable    2,883.9    2,795.3 88.6 -88.6 Inventory    2,357.0    2,438.4 -81.4 81.4 Prepaid expenses and other assets       765.6       602.3 163.3 -163.3 Deferred income taxes, net      272.4       227.2 45.2 -45.2 Total Current Assets $ 9,734.0 $ 8,839.3 894.7 Property and equipment, gross    4,255.7    4,103.0...
Dec. 31, 20Y3 Dec. 31, 20Y2 Assets Cash $269,150 $248,070 Accounts receivable (net) 97,500 89,090 Inventories...
Dec. 31, 20Y3 Dec. 31, 20Y2 Assets Cash $269,150 $248,070 Accounts receivable (net) 97,500 89,090 Inventories 275,250 263,780 Investments 0 102,200 Land 141,180 0 Equipment 303,680 233,220 Accumulated depreciation—equipment (71,100) (62,890) Total assets $1,015,660 $873,470 Liabilities and Stockholders' Equity Accounts payable (merchandise creditors) $183,830 $172,070 Accrued expenses payable (operating expenses) 18,280 22,710 Dividends payable 10,160 7,860 Common stock, $10 par 54,850 42,800 Paid-in capital: Excess of issue price over par-common stock 206,180 118,790 Retained earnings 542,360 509,240 Total liabilities and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT