In: Accounting
| Use the balance sheet and income statement below : |
|
CLANCY’S DOG BISCUIT CORPORATION Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) |
||||||||||||||
| Assets | 2015 | 2014 | Liabilities and Equity | 2015 | 2014 | |||||||||
| Current assets: | Current liabilities: | |||||||||||||
| Cash and marketable securities | $ | 8 | $ | 8 | Accrued wages and taxes | $ | 13 | $ | 7 | |||||
| Accounts receivable | 38 | 30 | Accounts payable | 27 | 25 | |||||||||
| Inventory | 41 | 35 | Notes payable | 25 | 23 | |||||||||
| Total | $ | 87 | $ | 73 | Total | $ | 65 | $ | 55 | |||||
| Fixed assets: | Long-term debt: | $ | 48 | $ | 43 | |||||||||
| Gross plant and equipment | $ | 111 | $ | 90 | Stockholders’ equity: | |||||||||
| Less: Depreciation | 31 | 25 | Preferred stock (2 million shares) | $ | 2 | $ | 2 | |||||||
| Common stock and paid-in surplus | ||||||||||||||
| Net plant and equipment | $ | 80 | $ | 65 | (5 million shares) | 11 | 11 | |||||||
| Other long-term assets | 28 | 28 | Retained earnings | 69 | 55 | |||||||||
| Total | $ | 108 | $ | 93 | Total | $ | 82 | $ | 68 | |||||
| Total assets | $ | 195 | $ | 166 | Total liabilities and equity | $ | 195 | $ | 166 | |||||
|
CLANCY’S DOG BISCUIT CORPORATION Income Statement for Years Ending December 31, 2015 and 2014 (in millions of dollars) |
|||||||
| 2015 | 2014 | ||||||
| Net sales | $ | 108 | $ | 112 | |||
| Less: Cost of goods sold | 54 | 50 | |||||
| Gross profits | $ | 54 | $ | 62 | |||
| Less: Other operating expenses | 8 | 7 | |||||
|
Earnings before interest, taxes depreciation, and amortization (EBITDA) |
$ | 46 | $ | 55 | |||
| Less: Depreciation | 6 | 6 | |||||
| Earnings before interest and taxes (EBIT) | $ | 40 | $ | 49 | |||
| Less: Interest | 6 | 6 | |||||
| Earnings before taxes (EBT) | $ | 34 | $ | 43 | |||
| Less: Taxes | 16 | 19 | |||||
| Net income | $ | 18 | $ | 24 | |||
| Less: Preferred stock dividends | $ | 1 | $ | 1 | |||
| Net income available to common stockholders | $ | 17 | $ | 23 | |||
| Less: Common stock dividends | 3 | 3 | |||||
| Addition to retained earnings | $ | 14 | $ | 20 | |||
| Per (common) share data: | |||||||
| Earnings per share (EPS) | $ | 3.40 | $ | 4.60 | |||
| Dividends per share (DPS) | $ | 0.60 | $ | 0.60 | |||
| Book value per share (BVPS) | $ | 16.00 | $ | 13.20 | |||
| Market value (price) per share (MVPS) | $ | 16.65 | $ | 16.60 | |||
|
Prepare a statement of cash flows for Clancy’s Dog Biscuit Corporation. (Enter your answers in millions of dollars. Amounts to be deducted should be indicated with a minus sign. Leave no cells blank - be certain to enter "0" wherever required.) |
|
Statement of Cash Flows for Year Ending December 31, 2015 (in millions of dollars) |
|
| A. Cash flows from operating activities | |
| (Click to select)Net incomeNet loss | $ |
| Additions (sources of cash): | |
| (Click to select)Increase in accounts payableIncrease in accrued wages and taxesIncrease in notes payableIncrease in long-term debtDepreciation | |
| (Click to select)Increase in notes payableIncrease in accounts payableIncrease in accrued wages and taxesDepreciationIncrease in long-term debt | |
| (Click to select)DepreciationIncrease in accounts payableIncrease in notes payableIncrease in accrued wages and taxesIncrease in long-term debt | |
| Subtractions (uses of cash): | |
| (Click to select)Increase in accounts receivableIncrease fixed assetsIncrease in inventoryIncrease in notes payableIncrease in long-term debt | |
| (Click to select)Increase in notes payableIncrease fixed assetsIncrease in inventoryIncrease in long-term debtIncrease in accounts receivable | |
| Net cash flow from operating activities | $ |
| B. Cash flows from investing activities | |
| Subtractions: | |
| (Click to select)Increase in other long-term assetsIncrease in fixed assetsIncrease in accrued wages and taxesDepreciationIncrease in accounts payable | $ |
| (Click to select)Increase in other long-term assetsDepreciationIncrease in fixed assetsIncrease in accounts payableIncrease in accrued wages and taxes | |
| Net cash flow from investing activities | $ |
| C. Cash flows from financing activities | |
| Additions: | |
| (Click to select)Increase in notes payableIncrease in accounts payableIncrease in common and preferred stockIncrease accrued wages and taxesIncrease in long-term debt | $ |
| (Click to select)Increase accrued wages and taxesIncrease in notes payableIncrease in long-term debtIncrease in accounts payableIncrease in common and preferred stock | |
| (Click to select)Increase in common and preferred stockIncrease in long-term debtIncrease in notes payableIncrease accrued wages and taxesIncrease in accounts payable | |
| Subtractions: | |
| (Click to select)Preferred stock dividendsIncrease in other long-term assetsIncrease in accounts payableCommon stock dividendsIncrease accrued wages and taxes | |
| (Click to select)Increase accrued wages and taxesIncrease in accounts payablePreferred stock dividendsCommon stock dividendsIncrease in other long-term assets | |
| Net cash flow from financing activities | $ |
| D. Net change in cash and marketable securities | $ |
| Statement of Cash Flows for Year Ending December 31, 2015 | |
| (in millions of dollars) | |
| A. Cash flows from operating activities | |
| Net Income Before interest & Other expenses | 40 |
| Additions (sources of cash): | |
| Increase in Accounts Payable | 2 |
| Increase in Accrued Wages and taxes | 6 |
| Increase in Notes Payable | 2 |
| Subtractions (uses of cash): | |
| Increase in Account Receivable | -8 |
| Increase in Inventory | -6 |
| Taxes | -16 |
| Net cash flow from operating activities | 20 |
| B. Cash flows from investing activities | |
| Subtractions: | |
| Purchase of Plant & Euipment | -15 |
| Net cash flow from investing activities | -15 |
| C. Cash flows from financing activities | |
| Additions: | |
| Increase in Long Term Debt | 5 |
| Interest Paid | -6 |
| Subtractions: | |
| Dividend to Preferred Shareholder | -1 |
| Common Stock Dividend | -3 |
| Net cash flow from financing activities | -5 |
| D. Net change in cash and marketable securities | 0 |
| Add: Opening cash Balance | 8 |
| Closing Cash Balance | 8 |