In: Accounting
T. P. Jarmon Company Balance Sheet for 12/31/2017 and 12/31/2018 |
||||
Assets |
||||
2017 |
2018 |
|||
Cash |
$15,000 |
$14,000 |
||
Marketable securities |
6,000 |
6,200 |
||
Accounts receivable |
42,000 |
33,000 |
||
Inventory |
51,000 |
84,000 |
||
Prepaid rent |
1,200 |
1,100 |
||
Total current assets |
$115,200 |
$138,300 |
||
Net plant and equipment |
$286,000 |
$270,000 |
||
Total assets |
$401,200 |
$408,300 |
||
Liabilities and Equity |
||||
2017 |
2018 |
|||
Accounts payable |
$48,000 |
$57,000 |
||
Accruals |
6,000 |
5,000 |
||
Notes payable |
15,000 |
13,000 |
||
Total current liabilities |
$69,000 |
$75,000 |
||
Long-term debt |
$160,000 |
$150,000 |
||
Common stockholders' equity |
$172,200 |
$183,300 |
||
Total liabilities and equity |
$401,200 |
$408,300 |
T. P. Jarmon Company Income Statement for Years Ended 12/31/2018 |
||||
Sales |
$600,000 |
|||
Less cost of goods sold |
460,000 |
|||
Gross profit |
$140,000 |
|||
Operating and interest expenses |
||||
General and administrative |
$30,000 |
|||
Interest |
10,000 |
|||
Depreciation |
30,000 |
|||
Total operating and interest expenses |
$70,000 |
|||
Earnings before taxes |
$70,000 |
|||
Taxes |
27,100 |
|||
Net income available to common stockholders |
$42,900 |
|||
Cash dividends |
31,800 |
|||
Change in retained earnings |
$11,100 |
b. Complete a statement of cash flows for the period.
c. Compute the changes in the balance sheets from 2017 to 2018.
b)
Statement of Cash flows | ||
Cash flows from Operating Activities | ||
Net Income | 42,900.00 | |
Adjustments | ||
Depreciation | 30,000.00 | |
Increase in Marketable Securities | - 200.00 | |
Decrease in Account Receivable | 9,000.00 | |
Increase in Inventories | - 33,000.00 | |
Decrease in Prepaid Rent | 100.00 | |
Increase in Accounts Payable | 9,000.00 | |
Decrease in Accruals | - 1,000.00 | 13,900.00 |
Net Cash flow from Operating Activities | 56,800.00 | |
Cash from flow from investing Activities | ||
Purchase of plant and equipment | - 14,000.00 | |
Cash flow from Investing Activities | ||
Repayment of Notes Payable | - 2,000.00 | |
Repayment of Long-term debt |
- 10,000.00 | |
Cash Dividends | - 31,800.00 | |
Net Cash flow from Investing Activities | - 43,800.00 | |
Net Decrease in Cash | - 1,000.00 | |
Opening Cash Balance | 15,000.00 | |
Closing Cash Balance | 14,000.00 |
c)
2017 | 2018 | Increase (Decrease) | Percentage Increase (Decrease) | |
Cash | 15,000.00 | 14,000.00 | - 1,000.00 | -6.67% |
Marketable securities |
6,000.00 | 6,200.00 | 200.00 | 3.33% |
Accounts receivable | 42,000.00 | 33,000.00 | - 9,000.00 | -21.43% |
Inventory |
51,000.00 | 84,000.00 | 33,000.00 | 64.71% |
Prepaid rent | 1,200.00 | 1,100.00 | - 100.00 | -8.33% |
Total current assets | 115,200.00 | 138,300.00 | 23,100.00 | 20.05% |
Net plant and equipment | 286,000.00 | 270,000.00 | - 16,000.00 | -5.59% |
Total assets | 401,200.00 | 408,300.00 | 7,100.00 | 1.77% |
Accounts payable | 48,000.00 | 57,000.00 | 9,000.00 | 18.75% |
Accruals | 6,000.00 | 5,000.00 | - 1,000.00 | -16.67% |
Notes payable | 15,000.00 | 13,000.00 | - 2,000.00 | -13.33% |
Total current liabilities | 69,000.00 | 75,000.00 | 6,000.00 | 8.70% |
Long-term debt | 160,000.00 | 150,000.00 | - 10,000.00 | -6.25% |
Common stockholders' equity | 172,200.00 | 183,300.00 | 11,100.00 | 6.45% |
Total liabilities and equity | 401,200.00 | 408,300.00 | 7,100.00 | 1.77% |