In: Finance
Click on the following icon
in order to copy its contents into a spreadsheet.)
Balance Sheet Accounts of Athens Corporation |
||
Account |
Balance 12/31/2016 |
Balance 12/31/2017 |
Accumulated depreciation |
$4,232 |
$4,863 |
Accounts payable |
$2,894 |
$3,205 |
Accounts receivable |
$3,167 |
$3,640 |
Cash |
$1,214 |
$1,490 |
Common stock |
$4,781 |
$7,280 |
Inventory |
$4,348 |
$5,166 |
Long-term debt |
$3,598 |
$2,437 |
Plant, property, and equipment |
$8,682 |
$9,850 |
Retained earnings |
$1,906 |
$2,361 |
Balance sheet. From the following balance sheet accounts in the popup window,
,a. construct a balance sheet for 2016 and 2017.
b. list all the working capital accounts.
c. find the net working capital for the years ending 2016 and 2017.
d. calculate the change in net working capital for the year 2017.
a. construct a balance sheet for 2016 and 2017.
Complete the balance sheet for 2016 below: (Round to the nearest dollar.)
Athens Corporation |
|||||||||
Balance Sheet as of December 31, 2016, and December 31, 2017 |
|||||||||
ASSETS |
2016 |
2017 |
LIABILITIES |
2016 |
2017 |
||||
Current assets |
Current liabilities |
||||||||
$ |
$ |
||||||||
$ |
Total current liabilities |
$ |
|||||||
$ |
$ |
||||||||
Total current assets |
$ |
Total liabilities |
$ |
||||||
Fixed assets |
OWNERS’ EQUITY |
||||||||
$ |
$ |
||||||||
$ |
$ |
||||||||
$ |
Total owners’ equity |
$ |
|||||||
TOTAL LIABILITIES AND |
|||||||||
TOTAL ASSETS |
$ |
OWNERS’ EQUITY |
$ |
Solution: | |||
a. | Balance Sheet | ||
2016 | 2017 | ||
Assets | |||
Current Assets | |||
A | Cash | 1214 | 1490 |
B | Accounts Receivable | 3167 | 3640 |
C | Inventory | 4348 | 5166 |
D=A+B+C | Total Current Assets | 8729 | 10296 |
Long-Term Assets: | |||
E | Plant, Prop. & Equip | 8682 | 9850 |
F | Less: Accum. Depreciation | -4232 | -4863 |
G=E-F | Net P P & E | 4450 | 4987 |
H=D+G | Total Assets | 13179 | 15283 |
Liabilities | |||
Current Liabilities | |||
I | Accounts Payable | 2894 | 3205 |
Long-Term Liabilities | |||
J | Long-term Debt | 3598 | 2437 |
K=I+J | Total Liabilities | 6492 | 5642 |
Owner’s Equity | |||
L | Common Stock | 4781 | 7280 |
M | Retained Earnings | 1906 | 2361 |
N=L+M | Total Owner’s Equity | 6687 | 9641 |
O=K+N | Total Liab. & O.E | 13179 | 15283 |
b. | List of all working capital accounts | ||
Cash | |||
Accounts Receivable | |||
Inventory | |||
Accounts Payable | |||
Notes: | |||
Working capital is computed as difference of current assets and current laibilities and current assets & liabilities are those assets and liabilities which have to paid/ receivable within next 12 months of balance sheet date. | |||
c. | |||
net working capital |
2016 | 5835 | ||
2017 | 7091 | ||
Notes: |
Net working capital is computed as difference between current assets and current laibilities . It computed to know how much net capital is invested by the company as working capital. | |||
2016 | 2017 | ||
A | Cash | 1214 | 1490 |
B | Accounts Receivable | 3167 | 3640 |
C | Inventory | 4348 | 5166 |
D=A+B+C | Total Current Assets | 8729 | 10296 |
Current Liabilities | |||
F | Accounts Payable | 2894 | 3205 |
G=F | Current Liabilities | 2894 | 3205 |
H=D-G | Net working capital | 5835 | 7091 |
D. |
change in net working capital for the year 2017 is $ 1,256 | |||
[increase in net working capital $1,256] | |||
Notes: | change in net working capital for the year 2017 | ||
=Net working capital 2017 - Net working capital 2016 | |||
=7,091 - 5,835 | |||
=1,256 | |||
Please feel free to ask if anything about above solution in comment section of the question. | |||