Question

In: Finance

Click on the following icon    in order to copy its contents into a​ spreadsheet.) Balance...

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

$

Solutions

Expert Solution

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.

Related Solutions

Click on the following icon    in order to copy its contents into a​ spreadsheet.) Balance...
Click on the following icon    in order to copy its contents into a​ spreadsheet.) Balance Sheet Accounts of Roman Corporation Account Balance ​12/31/2016 Balance ​ 12/31/2017 Accumulated depreciation   $2,030 $2,668 Accounts payable   $1,797 $2,070 Accounts receivable   $2,479 $2,690 Cash   $1,307 $1,095 Common stock   $4,990 $4,990 Inventory   $5,807 $6,038 ​Long-term debt   $7,799 $8,192 ​Plant, property, and equipment $8,407 $9,195 Retained earnings $1,384 $1,098 Balance sheet. From the following balance sheet accounts in the popup​ window, ​,a. construct a balance sheet...
Harmony Corporation reported these​ figures: ​(Click the icon to view the balance​ sheet.)                       LOADING... ​(Click the...
Harmony Corporation reported these​ figures: ​(Click the icon to view the balance​ sheet.)                       LOADING... ​(Click the icon to view the income​ statement.) Harmony Corporation has 2,000,000 shares of common stock outstanding. Its stock has traded recently at $ 33.30 per share. You would like to gain a better understanding of Harmony Corporation​'s financial position. Assume all sales are on credit.Read the requirement LOADING... . a. Inventory turnover Enter the formula on the first​ line, then calculate the inventory turnover on...
Present value of an annuity   Consider the following case.  ​(Click on the icon located on the​...
Present value of an annuity   Consider the following case.  ​(Click on the icon located on the​ top-right corner of the data table below in order to copy its contents into a​ spreadsheet.) Amount of annuity Interest rate Period​ (years) ​$58,000 5​% 6 a.  Calculate the present value of the annuity assuming that it is ​1) An ordinary annuity. ​(2) An annuity due. b.  Compare your findings in parts a​(1) and a​(2). All else being​ identical, which type of annuitylong dash—ordinary...
The budgets of four companies yield the following​ information: LOADING... ​(Click the icon to view the...
The budgets of four companies yield the following​ information: LOADING... ​(Click the icon to view the budget information for the four​ companies.)Read the requirements LOADING... . Requirement 1. Fill in the blanks for each missing value. ​(Round the contribution margin per unit to the nearest cent. Use a minus sign or parentheses to enter an operating​ loss.) Up Net Sales Revenue $992,000 Variable Costs Fixed Costs Operating Income (Loss) $42,500 Units Sold 155,000 Contribution Margin per Unit $3.20 Contribution Margin...
BrooklynBrooklyn Corporation has the following activities for the past​ year: LOADING... ​(Click the icon to view...
BrooklynBrooklyn Corporation has the following activities for the past​ year: LOADING... ​(Click the icon to view the​ data.) Requirement Prepare the operating activities section of BrooklynBrooklyn ​Corporation's statement of cash flows for the year ended December​ 31, using the indirect method for operating cash flows. ​(Use parentheses or a minus sign for numbers to be​ subtracted.) Brooklyn Corporation Statement of Cash Flows—Operating Activities Section (Indirect Method) For the Year Ended December 31 Operating Activities: Adjustments to reconcile net income to...
Determine the​ t-value in each of the cases. Click the icon to view the table of...
Determine the​ t-value in each of the cases. Click the icon to view the table of areas under the​ t-distribution. ​(a) Find the​ t-value such that the area in the right tail is 0.10 with 10 degrees of freedom.
Determine the​ t-value in each of the cases. Click the icon to view the table of...
Determine the​ t-value in each of the cases. Click the icon to view the table of areas under the​ t-distribution. ​(a) Find the​ t-value such that the area in the right tail is 0.10 with 5 degrees of freedom. __ ​(Round to three decimal places as​ needed.) ​(b) Find the​ t-value such that the area in the right tail is 0.025 with 29 degrees of freedom.__ ​(Round to three decimal places as​ needed.) ​(c) Find the​ t-value such that the...
Determine the​ t-value in each of the cases. LOADING... Click the icon to view the table...
Determine the​ t-value in each of the cases. LOADING... Click the icon to view the table of areas under the​ t-distribution. ​(a) Find the​ t-value such that the area in the right tail is 0.25 with 6 degrees of freedom. nothing ​(Round to three decimal places as​ needed.) ​(b) Find the​ t-value such that the area in the right tail is 0.025 with 19 degrees of freedom. nothing ​(Round to three decimal places as​ needed.) ​(c) Find the​ t-value such...
The budget for the Manchester University Printing Company for 20X1 ​follows: LOADING... ​(Click the icon to...
The budget for the Manchester University Printing Company for 20X1 ​follows: LOADING... ​(Click the icon to view the budget​ data.) Edith Gable​, the sales​ manager, has placed a £24,000 bid on a particularly large order with a cost of £5,800 direct material and £6,200 direct labor. The customer informs her that she can have the business for £19,500​, take it or leave it. If GableGable accepts the​ order, total sales for 20X1 will be £1,110,450. Gable refuses the​ order, saying,​...
Copy and paste, or type, the following into cells A1:D5 of an Excel spreadsheet: Input data...
Copy and paste, or type, the following into cells A1:D5 of an Excel spreadsheet: Input data fixed cost 16,000 Units 1,050 variable cost per unit 4.75 revenue =D2*B4 sell price per unit 6.5 expenses =B2+(B3*D2) profit =D3-D4 Use Excel's Goal Seek to answer the following question. Assuming that demand is fixed at 1,050 units, what is the sell price per unit that results in break even? Enter only the numerical solution. Do
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT