question archive The following are the income statement and balance sheets of Medico Company: Medico Company Income Statement Year Ended December 31, 2002 Sales $840,000 Cost of goods sold (490,000) Gross profit $350,000 Salary expense $175,000 Depreciation expense 35,000 Rent expense 16,000 Utilities expense 74
Subject:FinancePrice:3.86 Bought36
The following are the income statement and balance sheets of Medico Company: Medico Company Income Statement Year Ended December 31, 2002 Sales $840,000 Cost of goods sold (490,000) Gross profit $350,000 Salary expense $175,000 Depreciation expense 35,000 Rent expense 16,000 Utilities expense 74.000 Interest expense 18.000 Total other expenses (318,000) Net income $32,000 Medico Company Balance Sheet December 31, 2001 and 2002 2002 2001 Cash $28.000 $35.000
2002 2001 Cash $28.000 $35.000 Accounts receivable 97,000 87,000 Merchandise inventory 120,000 132,000 Supplies 15,000 10,000 Buildings and equipment 510,000 410,000 Accumulated depreciation (195.000) (160.000) Total assets $575.000 $514,000 Accounts payable $35,000 $41,000 Wages payable 21,000 39,000 Utilities payable 7,000 4,000 Bonds payable 240,000 200,000 Common stock 110,000 80.000 Retained earnings 162.000 150,000 Total liabilities and owners' equity $575,000 3514,000 Required: a. Prepare the statement of cash flows for the year ended December 31, 2002, using both the direct and the indirect method for the net cash flow from operating, investing and financing activities. b. Calculate Medico's free cash flow
a] | Cash flows from operating activities--Indirect Method | ||
Net income | $ 32,000 | ||
Adjustments to reconcile net income to net cash provided by operations: | |||
Depreciation | $ 35,000 | ||
Increase in accounts receivable [97000-87000] | $ (10,000) | ||
Decrease in merchandise inventory [132000-120000] | $ 12,000 | ||
Increase in supplies [15000-10000] | $ (5,000) | ||
Decrease in accounts payable [41000-35000] | $ (6,000) | ||
Decrease in wages payable [39000-21000] | $ (18,000) | ||
Increase in utilities payable [7000-4000] | $ 3,000 | $ 11,000 | |
Net cash from operating activities | $ 43,000 | ||
Cash flows from operating activities-Direct Method | |||
Collections from customers (840000+87000-97000) | $ 830,000 | ||
Cash payments for: | |||
Purchases for merchandise and supplies (490000+120000-132000+41000-35000+15000-10000) | $ -489,000 | ||
Salaries (175000+39000-21000) | $ -193,000 | ||
Rent | $ -16,000 | ||
Utilities (74000+4000-7000) | $ -71,000 | ||
Interest | $ -18,000 | ||
Net cash from operating activities | $ 43,000 | ||
Cash flows from investing activities: | |||
Purchase of building and equipment (510000-410000) | $ (100,000) | ||
Net cash from investing activities | $ (100,000) | ||
Cash flows from financing activities: | |||
Issue of bonds [240000-200000] | $ 40,000 | ||
Sale of common stock [110000-80000] | $ 30,000 | ||
Payment of dividends [150000+32000-162000] | $ (20,000) | ||
Net cash used by financing activitites | $ 50,000 | ||
Net increase in cash | $ (7,000) | ||
Cash at the beginning of the period | $ 35,000 | ||
Cash at the end of the period | $ 28,000 | ||
b] | Free cash flow = OCF-Net capital expenditure-Change in NWC | ||
OCF = NI+Interest+Depreciation = 32000+18000+35000 = | $ 85,000 | ||
Net capital expenditure = | $ 100,000 | ||
Change in NWC = (28000+97000+120000+15000-35000-21000-7000)-(35000+87000+132000+10000-41000-39000-4000) = | $ 17,000 | ||
Free cash flow = 85000-100000-17000 = | $ (32,000) | ||
Alternatively: | |||
Cash flow from operating activities+Decrease in cash+Interest paid-Capital expenditure = 43000-7000+18000-100000 = | $ (32,000) |