Integrative Problem Presented here are a statement of income and retained earnin
ID: 2576932 • Letter: I
Question
Integrative Problem Presented here are a statement of income and retained earnings and comparative balance sheets for Gallagher, Inc., which operates a national chain of sporting goods stores. Gallagher, Inc. Statement of Income and Retained Earnings For the Year Ended December 31, 2016 (all amounts in thousands of dollars)
Net sales $48,000
Cost of goods sold 36,000
Gross profit $12,000
Selling, general, and administrative expense 6,000
Operating income $6,000
Interest expense 280
Income before tax $5,720
Income tax expense 2,280
Net income $3,440
Preferred dividends 100 Income available to common $3,340
Common dividends 500 To retained earnings $2,840
Retained earnings, 1/1 12,000
Retained earnings, 12/31 $14,840
Gallagher, Inc. Comparative Balance Sheets December 31, 2016 and 2015 (all amounts in thousands of dollars) December 31 2016 2015
Cash $840 $2,700
Accounts receivable 12,500 9,000
Inventory 8,000 5,500
Prepaid insurance 100 400
Total current assets $21,440 $17,600
Land $4,000 $4,000
Buildings and equipment 12,000 9,000
Accumulated depreciation (3,700) (3,000)
Total long-term assets $12,300 $10,000
Total assets $33,740 $27,600
Accounts payable $7,300 $5,000
Taxes payable 4,600 4,200
Notes payable 2,400 1,600
Current portion of bonds 200 200
Total current liabilities $14,500 $11,000
Bonds payable 1,400 1,600
Total liabilities $15,900 $12,600
Preferred stock, $5 par $1,000 $1,000
Common stock, $1 par 2,000 2,000
Retained earnings 14,840 12,000
Total stockholders’ equity $17,840 $15,000
Total liabilities and stockholders’ equity $33,740 $27,600
Required: 1. Prepare a statement of cash flows for Gallagher, Inc., for the year ended December 31, 2016, using the indirect method in the Operating Activities section of the statement. If an answer is zero, please enter zero ("0"). Use the minus sign to indicate cash outflows, a decrease in cash, or cash payments. Gallagher, Inc. Statement of Cash Flows For The Year Ended December 31, 2016 (In Thousands of Dollars)
Cash flows from operating activities $
Adjustments to reconcile net income to net cash provided by operating activities:
Net cash provided by operating activities $
Cash flows from investing activities $
Net cash used by investing activities $
Cash flows from financing activities $
Net cash provided by financing activities $
$
Cash balance, December 31, 2015
Cash balance, December 31, 2016 $
2. Gallagher's management is concerned with its short-term liquidity and its solvency over the long run. To help management evaluate these, compute the following ratios, rounding all answers to two decimal points. For percentages, round to two decimal places before converting to a percentage. For example, 0.881 would be entered as 88. Assume 360 days per year.
a. Current ratio to 1
b. Acid-test ratio to 1
c. Cash flow from operations to current liabilities ratio %
d. Accounts receivable turnover ratio times
e. Number of days' sales in receivables days
f. Inventory turnover ratio times
g. Number of days' sales in inventory days
h. Debt-to-equity ratio to 1
i. Debt service coverage ratio to 1
j. Cash flow from operations to capital expenditures ratio % 3.
Explanation / Answer
Gallagher Inc. Statement of Cash Flow For the year ended December 31,2016 1) Cash flows from operating activities Net income after tax $ 3,440.00 Adjustments to net income Depreciation=($3700-$3000) $ 700.00 Increase in accounts receivable=($12500-$9000) $ (3,500.00) Increase in inventories=($8000-$5500) $ (2,500.00) Decrease in Prepaid Insurance=($100-$400) $ 300.00 Increase in accounts payable=($7300-$5000) $ 2,300.00 Increase in Notes Payable=($2400-$1600) $ 800.00 Increase in Taxes Payable=($4600-$4200) $ 400.00 $ (1,500.00) Net cash provided by operating activities=(A) $ 1,940.00 Cash flows from investing activities Purchase of fixed Assets($12000-$9000) $ (3,000.00) Net cash provided by investing activities =(B) $ (3,000.00) Cash flows from financing activities Retirement of Bonds $ (200.00) Dividend to Preferred Stock $ (100.00) Dividends to common stock $ (500.00) Net cash provided by financing activities=(C ) $ (800.00) Change in cash=(A)+(B)+(C ) $ (1,860.00) Cash, beginning balance $ 2,700.00 Cash, ending balance $ 840.00 Building Particular Amount Particular To Bal b/d $ 9,000.00 By Bal C/d To Cash(Balancing Figure) $ 3,000.00 $ 12,000.00 Retained Earnings Statement Beginning Retained Earnings $ 12,000.00 Add: Net Income $ 3,440.00 Less: Dividend Paid $ 600.00 Ending Retained Earnings $ 14,840.00 2) Ratios 1) Current Ratio=Current Assets/Current Liabilities Current Assets Cash $ 840.00 Accounts Receivable(net) $ 12,500.00 Inventory $ 8,000.00 Prepaid Insurance $ 100.00 Total Current Assets $ 21,440.00 Current Liabilities $ 14,500.00 Current Ratio ($21440/$14500)=1.48 Quick Ratio=Quik Assets/Current Liabilites Quick Assets Cash $ 840.00 Accounts Receivable $ 12,500.00 Total Quick Assets $ 13,340.00 Current Liabilities $ 14,500.00 Quick Ratio= ($13340/$14500)=.92 Cash flow from operation /Current Laibilities Cash Flow from Operation 1940 Current Liabilities 14500 Cash flow from operation/Current Liabilities=($1940/$14500) 0.13 Accounts Receivable Turnover Ratio=Net Credit Sales/Average Debtors Net Sales 48000 Average Debtors=(12500+9000)/2 10750 Accounts Receivable Turnover Ratio=($48000/$10750) 4.47 Times
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.