In: Accounting
T. P. Jarmon Company Balance Sheet for 12/31/2014 and 12/31/2015 |
||||
Assets |
||||
2014 |
2015 |
|||
Cash |
$15,000 |
$14,000 |
||
Marketable securities |
6,000 |
6,200 |
||
Accounts receivable |
42,000 |
33,000 |
||
Inventory |
51,000 |
83,300 |
||
Prepaid rent |
1,200 |
1,100 |
||
Total current assets |
$115,200 |
$137,600 |
||
Net plant and equipment |
$286,000 |
$270,200 |
||
Total assets |
$401,200 |
$407,800 |
||
Liabilities and Equity |
||||
2014 |
2015 |
|||
Accounts payable |
$48,000 |
$57,000 |
||
Accruals |
6,000 |
5,200 |
||
Notes payable |
15,000 |
12,900 |
||
Total current liabilities |
$69,000 |
$75,100 |
||
Long-term debt |
$160,000 |
$150,500 |
||
Common stockholders' equity |
$172,200 |
$182,200 |
||
Total liabilities and equity |
$401,200 |
$407,800 |
T. P. Jarmon Company Income Statement for Years Ended 12/31/2015 |
||||
Sales |
$599,800 |
|||
Less cost of goods sold |
459,900 |
|||
Gross profit |
$139,900 |
|||
Operating and interest expenses |
||||
General and administrative |
$30,200 |
|||
Interest |
10,000 |
|||
Depreciation |
30,200 |
|||
Total operating and interest expenses |
$70,400 |
|||
Earnings before taxes |
$69,500 |
|||
Taxes |
27,800 |
|||
Net income available to common stockholders |
$41,700 |
|||
Cash dividends |
31,700 |
|||
Change in retained earnings |
$10,000 |
a. How much is the firm's net working capital and what is the debt ratio?
b. Complete a statement of cash flows for the period.
c. Compute the changes in the balance sheets from 2014 to 2015.
a. Net working capital = current assets - current liabilities
For 2014 firm's net working capital = 115200-69000
=$46200.
For 2015 firm's net working capital = 137600-75100
= $62500
Debt ratio = total liabilities/total assets.
For 2014 firm's debt ratio = 229000/401200 = 0.57
For 2015 firm's debt ratio = 225600/407800
= 0.55
b. Cash flow statement for 2015
A. Cash flow from operating activities | |
Net income after tax | 41700 |
Adj. For : |
|
Add : depriciation | 30200 |
Interest | 10000 |
Decrease in accounts receivable | 9000 |
Decrease in prepaid rent | 100 |
Increase in accounts payable | 9000 |
Less : increase in inventory | (32300) |
Decrease in accruals | (800) |
Decrease in notes payable | (2100) |
Net cash proceeds from operating activities (A) | 64800 |
B . Cash flow from investing activities | |
Purchase of plant and equipment (working note) | (14400) |
Cash used in investing activities (B) | (14400) |
C . Cash flow from financing activities | |
Repayment of Deb. | (9500) |
Payment of int. | (10000) |
Payment of div. | (31700) |
Cash used in financing activities (C) | (51200) |
Net cash flow during the year (A+B+C) | (800) |
Beginning Cash and cash equivalent (15000+6000) | 21000 |
Ending Cash and cash equivalent (14000+6200) | 20200 |
Working g note :-
Plant account
To Bal b/d (beginning bal. On 2015) | 286000 | by dep. | 30200 |
To cash (bal. Fig.) | 14400 | By bal c/d (ending bal) | 270200 |
C. Changes in the balance sheet from the period 2014 to 2015 are as follows
Assets | |||
2014 | 2015 | percentage change | |
Cash | 15000 | 14000 | (6.67%) |
Marketable securities | 6000 | 6200 | 3.33% |
Accounts receivable | 42000 | 33000 | (21.43%) |
Inventory | 51000 | 83300 | 63.33% |
Prepaid rent | 1200 | 1100 | (8.33%) |
Total current assets | 115200 | 137600 | 19.44% |
Net plant and equipment | 286000 | 270200 | (5.52%) |
Total assets | 401200 | 407800 | 1.65% |
Liabilities & equities | |||
2014 | 2015 | percentage change | |
Accounts payable | 48000 | 57000 | 18.75% |
Accruals | 6000 | 5200 | (13.33%) |
Notes payable | 15000 | 12900 | (14%) |
Total current liabilities | 69000 | 75100 | 8.84% |
Long term debt | 160000 | 150500 | (5.94%) |
Common stockholder equity | 172200 | 182200 | 5.81% |
Total liabilities & equity | 401200 | 407800 | 1.65% |