Question

In: Finance

Problem 3-5 Axtel Company has the following financial statements. Axtel Company Balance Sheet For the period...

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 $  

Solutions

Expert Solution

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE


Related Solutions

The Garvey Company has the following financial statements. Garvey Company Balance Sheet For the period ended...
The Garvey Company has the following financial statements. Garvey Company Balance Sheet For the period ended 12/31/X1 ($000) ASSETS 12/31/X0 12/31/X1 Cash $ 3547 $ 2855 Accounts receivable 6579 5217 Inventory 2573 3220 CURRENT ASSETS $ 12699 $ 11292 Fixed assets Gross $ 22478 $ 24360 Accumulated deprec. (12017) (12927) Net $ 10461 $ 11433 TOTAL ASSETS $ 23160 $ 22725 LIABILITIES Accounts payable $ 1577 $ 1710 Accruals 233 380 CURRENT LIABILITIES $ 1810 $ 2090 Long-term debt $...
Axtel Company has the following financial statements. Axtel Company Balance Sheet For the period ended 12/31/X1...
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 $ 3492 $ 2855 Accounts receivable 6984 5617 Inventory 2573 3220 CURRENT ASSETS $ 13049 $ 11692 Fixed assets    Gross $ 22478 $ 24360    Accumulated deprec. (12367) (13327)    Net $ 10111 $ 11033 TOTAL ASSETS $ 23160 $ 22725 LIABILITIES Accounts payable $ 1503 $ 1690 Accruals 215 424 CURRENT LIABILITIES $ 1718 $ 2114 Long-term debt $ 7112...
Axtel Company has the following financial statements. Axtel Company Balance Sheet For the period ended 12/31/X1...
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,458 $ 2,943 Accounts receivable 6,548 5,234 Inventory 2,573 3,220 CURRENT ASSETS $ 12,579 $ 11,397 Fixed assets    Gross $ 22,478 $ 24,360    Accumulated deprec. (11,897) (13,032)    Net $ 10,581 $ 11,328 TOTAL ASSETS $ 23,160 $ 22,725 LIABILITIES Accounts payable $ 1,543 $ 1,698 Accruals 271 408 CURRENT LIABILITIES $ 1,814 $ 2,106 Long-term debt $ 7,112...
Axtel Company has the following financial statements. Axtel Company Balance Sheet For the period ended 12/31/X1...
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 $ 3463 $ 2909 Accounts receivable 6548 5906 Inventory 2573 3220 CURRENT ASSETS $ 12584 $ 12035 Fixed assets    Gross $ 22478 $ 24360    Accumulated deprec. (11902) (13670)    Net $ 10576 $ 10690 TOTAL ASSETS $ 23160 $ 22725 LIABILITIES Accounts payable $ 1581 $ 1692 Accruals 260 393 CURRENT LIABILITIES $ 1841 $ 2085 Long-term debt $ 7112...
Problem 3-6 Financial Statements (LO1,4) South Sea Baubles has the following (incomplete) balance sheet and income...
Problem 3-6 Financial Statements (LO1,4) South Sea Baubles has the following (incomplete) balance sheet and income statement. BALANCE SHEET AT END OF YEAR (Figures in $ millions) Assets 2015 2016 Liabilities and Shareholders' Equity 2015 2016 Current assets $ 100 $ 190 Current liabilities $ 70 $ 90 Net fixed assets 900 1,000 Long-term debt 650 850 INCOME STATEMENT, 2016 (Figures in $ millions) Revenue $ 2,000 Cost of goods sold 1,080 Depreciation 400 Interest expense 250 a&b. What is...
QUESTION 1 The Garvey Company has the following financial statements. Garvey Company Balance Sheet For the...
QUESTION 1 The Garvey Company has the following financial statements. Garvey Company Balance Sheet For the period ended 12/31/X1 ($000) ASSETS 12/31/X0 12/31/X1 Cash $ 3547 $ 2855 Accounts receivable 6579 5217 Inventory 2573 3220 CURRENT ASSETS $ 12699 $ 11292 Fixed assets Gross $ 22478 $ 24360 Accumulated deprec. (12017) (12927) Net $ 10461 $ 11433 TOTAL ASSETS $ 23160 $ 22725 LIABILITIES Accounts payable $ 1577 $ 1710 Accruals 233 380 CURRENT LIABILITIES $ 1810 $ 2090 Long-term...
The following are the financial statements of Nosker Company.    Nosker Company    Comparative Balance Sheet...
The following are the financial statements of Nosker Company.    Nosker Company    Comparative Balance Sheet    December 31, Assets 2017 2016 Cash $ 38,000. $ 20,000 Accounts receivable 30,000 14,000 Inventory 27,000 20,000 Equipment 60,000 78,000 Accumulated depreciation- equipment (29,000) (24,000) Total $126,000 $108,000 Liabilities and Stockholders' Equity Accounts payable $ 24,000 $ 15,000 Income taxes payable 7,000 8,000 Bonds payable 27,000 33,000 Common stock 18,000    14,000 Retained earnings 50,000 38,000 Total $126,000. $ 108,000 NOSKER COMPANY INCOME...
X Company prepares monthly financial statements. The following is the company's July 1 Balance Sheet: Balance...
X Company prepares monthly financial statements. The following is the company's July 1 Balance Sheet: Balance Sheet July 1 Assets Equities Cash $35,434 Accounts Payable $5,395 Accounts Receivable 5,618 Notes Payable 22,519 Inventory 14,313 Prepayments 3,011 Paid-In Capital 62,008 Equipment 63,027 Retained Earnings 31,481 Total Assets $121,403 Total Equities $121,403 The following were the company's July transactions: borrowed $26,000 from a bank bought equipment costing $10,300, paying the manufacturer $5,600 in cash and signing a note for $4,700 purchased a...
Problem 3-5 (Algo) Balance sheet preparation [LO3-2, 3-3] The following is the ending balances of accounts...
Problem 3-5 (Algo) Balance sheet preparation [LO3-2, 3-3] The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account Title Debits Credits Cash $ 91,000 Short-term investments 73,000 Accounts receivable (net) 288,000 Prepaid expenses (for the next 12 months) 40,000 Land 83,000 Buildings 328,000 Accumulated depreciation—buildings $ 164,000 Equipment 269,000 Accumulated depreciation—equipment 124,000 Accounts payable 177,000 Accrued liabilities 49,000 Notes payable 108,000 Mortgage payable 210,000 Common stock 140,000 Retained earnings 200,000 Totals $ 1,172,000 $...
List and describe the key features of the 3 primary financial statements. Is the balance sheet...
List and describe the key features of the 3 primary financial statements. Is the balance sheet a report over a period of time or at a specific point in time? What about the income statement?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT