In: Finance
Problem 3-5
Axtel Company has the following financial statements.
Axtel Company | ||||||
Balance Sheet | ||||||
For the period ended 12/31/X1 ($000) | ||||||
ASSETS | ||||||
12/31/X0 | 12/31/X1 | |||||
Cash | $ | 3,496 | $ | 2,906 | ||
Accounts receivable | 6,851 | 5,513 | ||||
Inventory | 2,573 | 3,220 | ||||
CURRENT ASSETS | $ | 12,920 | $ | 11,639 | ||
Fixed assets | ||||||
Gross | $ | 22,478 | $ | 24,360 | ||
Accumulated deprec. | (12,238) | (13,274) | ||||
Net | $ | 10,240 | $ | 11,086 | ||
TOTAL ASSETS | $ | 23,160 | $ | 22,725 | ||
LIABILITIES | ||||||
Accounts payable | $ | 1,566 | $ | 1,689 | ||
Accruals | 206 | 384 | ||||
CURRENT LIABILITIES | $ | 1,772 | $ | 2,073 | ||
Long-term debt | $ | 7,112 | $ | 6,002 | ||
Equity | 14,276 | 14,650 | ||||
TOTAL CAPITAL | $ | 21,388 | $ | 20,652 | ||
TOTAL LIABILITIES AND EQUITY | $ | 23,160 | $ | 22,725 |
Axtel Company | |||
Income Statement | |||
For the period ended 12/31/X1 | |||
($000) | |||
Sales | $ | 36,212 | |
COGS | 20,238 | ||
Gross margin | $ | 15,974 | |
Expense | $ | 10,555 | |
EBIT | $ | 5,419 | |
Interest | 713 | ||
EBT | $ | 4,706 | |
Tax | 1,605 | ||
Net income | $ | 3,101 |
In addition, Axtel retired stock for $1,000,000 and paid a dividend of $1,727,000. Depreciation for the year was $1,036,000. Construct a statement of cash flows for Axtel for 20X1. (Hint: Retiring stock means buying it back from shareholders. Assume the purchase was made at book value, and treat it like a negative sale of stock.) Enter your answers in thousands. For example, an answer of $200 thousands should be entered as 200, not 200000. Use a minus sign, to indicate any decreases in cash or cash outflows.
Axtel Company Statement of Cash Flows For the period ended 12/31/X1 ($000) |
||
OPERATING ACTIVITIES: | ||
Net Income | $ | |
Depreciation | $ | |
Net changes in current accounts | $ | |
Cash from Operating Activities | $ | |
INVESTING ACTIVITIES: | ||
Increase in Fixed Assets | $ | |
Cash from Investing Activities | $ | |
FINANCING ACTIVITIES: | ||
Decrease in Debt | $ | |
Dividends Paid | $ | |
Stock Retired | $ | |
Cash from Financing Activities | $ | |
NET CASH FLOW | $ |
Reconciliation | ||
Beginning Cash | $ | |
Net Cash Flow | $ | |
Ending Cash | $ |