Solution
Ingersoll Inc
Calculation of cash flow from assets:
Cash flow from assets = operating cash flow +/– changes in net working capital +/- changes in fixed assets
Operating cash flow = $3,704
Changes in net working capital = ($3,050)
Changes in fixed assets = (77,730 – 72,861) = $4,869
Cash flow from assets = 3,704 – 3,050 – 4,869 = ($4,215)
Cash flow to creditors:
Cash flow to creditors = interest – changes in long-term debt
Interest for 2019 = $1,345
Changes in long term debt = (35,329 – 29,180) = $6,149
Cash flow to creditors = 1,345 – 6,149 = ($4,804)
Cash flow to stockholders:
Cash flow to stockholders = dividends paid = $2,354
Computations:
Income statement for the year 2019:–
Sales $18,888
Cost of goods sold $6,771
Gross margin $12,117
Less: operating expenses $1,198
Depreciation $2,524
Interest $1,345
income before tax $7,050
income tax at 40% $2,820
After tax income $4,230
Operating cash flow:
Operating cash flow: |
||
net income |
$4,230 |
|
adjustments to reconcile net income to net cash flow from operations: |
||
Add: depreciation |
$2,524 |
|
Less: increase in accounts receivable |
($2,074) |
|
Less: increase in inventory |
($1,410) |
|
decrease in short term notes payable |
($33) |
|
Add: increase in accounts payable |
$467 |
($526) |
cash flow from operating activities |
$3,704 |
Changes in net working capital = - (13,602 – 11,528) + (1,681 – 1,714) + (6,760 – 6,293) – (21,902 – 20,492) = ($3,050)
Use the following information for Ingersoll, Inc. Assume the tax rate is 24 percent. Sales Depreciation...
Use the following information for Ingersoll, Inc., (assume the tax rate is 35 percent) 2014 2015 Sales Depreciation Cost of goods sold Other expenses Interest Accounts receivable Short-term notes payable Long-term debt Net fixed assets Accounts payable Inventory Dividends $ 8,235 $ 8,809 1,166 3,100 574 643 5,243 6,167 786 13,90016,450 34,855 35,757 4,225 9,978 1,091 1,165 2,736 679 565 4,149 5,479 834 4,396 9,710 996 For 2015, calculate the cash flow from assets, cash flow to creditors, and cash...
Use the following information for Ingersoll, Inc. Assume the tax rate is 24 percent. 2018 Sales $ 15,573 Depreciation 1,741 Cost of goods sold 4,379 Other expenses 986 Interest 835 Cash 6,187 Accounts receivable 8,120 Short-term notes 1,250 payable Long-term debt 20,560 Net fixed assets 51,064 Accounts payable 4,512 Inventory 14,419 Dividends 1,350 2019 $ 15,336 1,816 4,787 864 966 6,706 9,667 1,227 24,836 54,513 4,884 15,368 1,698 Prepare a balance sheet for this company for 2018 and 2019. (Do...
Problem 2-25 Calculating Cash Flow Use the following information for Ingersoll, Inc., (assume the tax rate is 30 percent) 2016 2017 $20,073 $18,036 1,8311,906 4,8294,877 Sales Depreciation Cost of goods sold other expenses Interest Cash Accounts receivable Long-term debt Net fixed assets Accounts payable Inventory Dividends 1,031 8801,011 6,3226,976 8,210 9,937 20,830 25,061 51,262 58,060 5,9966, 471 14, 57215,458 For 2017, calculate the cash flow from assets, cash flow to creditors, and cash flow to stockholders (Do not round intermediate...
Use the following information for Ingersoll, Inc. Assume the tax rate is 21 percent. Sales Depreciation Cost of goods sold Other expenses Interest Cash Accounts receivable Short-term notes payable Long-term debt Net fixed assets Accounts payable Inventory Dividends 2018 2019 $18,073 $ 16,836 1,791 1,866 4,629 4,837 1,011 889 860 991 6,262 6,856 8,170 9,817 1,300 1,277 20,710 24,961 51,174 54,663 4,592 5,034 14,504 15,418 1,600 1,748 Prepare a balance sheet for this company for 2018 and 2019. (Do not...
Use the following information for Ingersoll, Inc. Assume the tax rate is 21 percent. Sales Depreciation Cost of goods sold Other expenses Interest Cash Accounts receivable Short-term notes payable Long-term debt Net fixed assets Accounts payable Inventory Dividends 2018 2019 $ 18,073 $ 16,836 1,791 1,866 4,629 4,837 1,011 889 860 991 6,262 6,856 8,170 9,817 1,300 1,277 20,710 24.961 51,174 54,663 4,592 5,034 14,504 15,418 1,600 1,748 Prepare a balance sheet for this company for 2018 and 2019. (Do...
Use the following information for Taco Swell, Inc., (assume the tax rate is 21 percent) 2017 2018 $17,049 $ 18,798 Sales Depreciation 2,386 2,494 5,740 6,741 Cost of goods sold Other expenses 1,350 1,183 1,115 1,330 8,681 9,277 Accounts receivable 11,49813,512 Interest Cash Short-term notes 1,684 1,651 payable Long-term debt Net fixed assets Accounts payable Inventory Dividends 29,090 35,254 72,792 77,640 6,2756,670 20,441 21,872 2,0292,324 For 2018, calculate the cash flow from assets, cash flow to creditors, and cash flow...
Use the following information for Taco Swel Inc., (assume the tax rate is 21 percent) 2017 2018 Sales Depreciation Cost of goods sold Other expenses Interest Cash Accounts receivable Short-term notes $17,049 18,798 2,386 2,494 6,741 1,183 1,330 8,681 9,277 13,512 5,740 1,350 1,115 11,498 ,684 1,651 payable Long-term debt Net fixed assets Accounts payable Inventory Dividends 29,090 35,254 72,792 77,640 6,275 6,670 20,441 21,872 2,029 2,324 For 2018, calculate the cash flow from assets, cash flow to creditors, and...
Use the following information for Taco Swell, Inc., (assume the tax rate is 23 percent): 2017 2018 Sales $26,049 $ 19,338 Depreciation 2,566 2,674 Cost of goods sold 6,640 6,921 Other expenses 1,476 1,273 Interest 1,205 1,420 Cash 8,771 9,817 Accounts receivable 11,678 14,052 Short-term notes 1,864 1,831 payable Long-term debt 29,630 35,704 Net fixed assets 73,206 78,160 Accounts payable 6,383 7,210 Inventory 20,747 22,052 Dividends 2,929 2,504 For 2018, calculate the cash flow from assets, cash flow to creditors,...
Use the following information for Taco Swell, Inc., (assume the tax rate is 30 percent): 2014 2015 Sales Depreciation Cost of goods sold Other expenses interest Cash Accounts receivable Short-term notes payable Long-term debt Net fixed assets Accounts payable Inventory Dividends $19,573 $17.736 1,821 1896 4,779 4,867 904 1,026 875 1.006 6,307 6,946 8,200 9,907 1,307 20,800 25,036 51,240 58,030 4,640 5,124 14,555 15,448 1,750 1,778 1,330 For 2015, calculate the cash flow from assets, cash flow to creditors, and...
Use the following information for Ingersoll, Inc. Assume the tax rate is 22 percent. 2018 2019 Sales $ 20,573 $ 18,336 Depreciation 1,841 1,916 Cost of goods sold 4,879 4,887 Other expenses 1,036 914 Interest 885 1,016 Cash 6,337 7,006 Accounts receivable 8,220 9,967 Short-term notes payable 1,350 1,327 Long-term debt 20,860 25,086 Net fixed assets 51,284 54,813 Accounts payable 4,672 5,184 Inventory 14,589 15,468 Dividends 1,850 1,798 Prepare a balance sheet for this company for 2018 and...