Question

In: Finance

Solve the following problems: Using the balance sheet below: create a balance sheet for 2016 and...

Solve the following problems: Using the balance sheet below:

  • create a balance sheet for 2016 and 2017.
  • make a list of working capital accounts.
  • what is the net working capital for 2016 and 2017?
  • What is the change in net working capital for 2017?

Balance Sheet Accounts of SimpleTec Corporation

Account Balance 12/31/2013 Balance 12/31/2014

Accumulated Depreciation $2,030 $2,680

Accounts Payable $1,810 $2,070

Accounts Receivable $2,490 $2,700

Cash $1,310 $1,100

Common Stock $5,000 $5,000

Inventory $5,810 $6,040

Long-Term Debt $7,810 $8,210

Plant, Property & Equipment $8,410 $9,210

Retained Earnings                             $1,380                                    $1,100

Solutions

Expert Solution

a)

BALANCE SHEET
Assets 2016 2017 Liabilities and equity 2016 2017
cash 1310 1100 Accounts payable 1810 2070
Accounts Receivable 2490 2700
Inventory 5810 6040
Total current asset 9610 9840 Total current liabilities 1810 2070
Plant, Property & Equipment 8410 9210 long term debt 7810 8210
less:Accumulated depreciation (2030) (2680) Total liabilities 9620 10280
Plant, Property & Equipment (net) 6380 6530 stockholders equity
common stock 5000 5000
Retained earning 1370 1090
Total stockholders equity 6370 6090
Total asset 15990 16370 15990 16370

***Retained earning at 2013 = 1370 in place of 1380

at 2014 ,it is = 1090 in place of 1100

Since total asset = total liabilities and equity

b_)Working capital accounts

Assets 2016 2017 Liabilities 2016 2017
cash 1310 1100 Accounts payable 1810 2070
Accounts Receivable 2490 2700
Inventory 5810 6040
Total current asset 9610 9840 Total current liabilities 1810 2070

c)Net working capital : current asset -current liabilities

2013 : 9610-1810 = 7800

2014: 9840 -2070 = 7770

d) change in net working capital for 2017 = 7770-7800 = - 30 decrease


Related Solutions

B. Using the table below, create the balance sheet of MaineBank assuming the following information (in...
B. Using the table below, create the balance sheet of MaineBank assuming the following information (in millions $$): Reserves = $360, Loans = $1,240, Deposits = $1,800, Debt = $150, Securities = $400, Capital (owner’s equity) = $50. What is the reserve-deposit ratio assuming all reserves are required reserves? What is the leverage ratio? Show your work/calculations. (10 points) MaineBank Balance Sheet Assets Liabilities & Owner’s Equity Reserves                                        Deposits                                     Loans                                             Debt                                            Securities                                      Capital (Owners’ equity)         Total                                              Total                                            Reserve deposit...
Create an income statement and balance sheet using the data below. Important: double the balance of...
Create an income statement and balance sheet using the data below. Important: double the balance of the Net Sales and make the necessary corrections to balance. Inputs Accounts Payable 12,000 Accounts Receivable 10,000 Accruals 10,000 Accumulated Depreciation 100,000 Beginning of year Inventory 50,000 Beginning of year Retained Earnings 120,000 Cash 7,000 Common Stock 121,500 Cost of Goods Sold 200,000 Current Portion - Long Term Debt 1,500 Depreciation Expense 25,000 Dividends 40,000 Gross Property, Plant, and Equipment 400,000 Interest Expense 15,000...
Create a Balance Sheet using the following data:                 Sales   $55,000     ...
Create a Balance Sheet using the following data:                 Sales   $55,000           Accumulated Depreciation   19,000             Cost of good sold   32,000           Accounts Receivable    7,300            Depreciation Expense   3,800           Accounts Payable   6,500            Interest Expense   2,600           Short-term notes payable   2,600            Income taxes   5,985             Marketing, general and admin expenses   4,500   Inventories   4,700           Gross fixed assets   64,800  ...
Using Microsoft Excel, create a balance sheet and an income statement using the relevant information below...
Using Microsoft Excel, create a balance sheet and an income statement using the relevant information below Calculate the Net Working Capital and the Net Operating Working Capital for both years Perform vertical analysis on both statements, for both years Perform Horizontal analysis on both statements for the most current year What was the Net Operating Profit After Taxes for both years? 2016 Accounts Receivable 400 Sales 5000 Accounts Payable 650 Inventory 1400 COGS 3000 Common Stock 1500 Cash 1600 Oper....
Complex Balance Sheet Presented below is the unaudited balance sheet as of December 31, 2016, prepared...
Complex Balance Sheet Presented below is the unaudited balance sheet as of December 31, 2016, prepared by Zeus Manufacturing Corporation's bookkeeper. Zeus Manufacturing Corporation Balance Sheet for the Year Ended December 31, 2016 Assets Liabilities and Shareholders' Equity Cash $225,000 Accounts payable $133,800 Accounts receivable (net) 345,700 Mortgage payable 900,000 Inventories 560,000 Notes payable 500,000 Prepaid income taxes 40,000 Lawsuit liability 80,000 Investments 57,700 Income taxes payable 61,200 Land 450,000 Deferred tax liability 28,000 Building 1,750,000 Accumulated depreciation 420,000 Machinery...
Refer to the information below for XYZ Corporation for the problems below. Balance Sheet 2007               ...
Refer to the information below for XYZ Corporation for the problems below. Balance Sheet 2007                2008 Cash                                                                9,000             500 A/R                                                                 12,500             16,000 Inventories                                                      29,000             45,500 Total Current Assets                                       50,500            62,000 Land                                                                20,000             26,000 Plant & Equipment                                         70,000             100,000 Less Accumulated Depreciation                     (28,000)         (38,000) Total Fixed Assets                                          62,000             88,000 Total Assets                                      ...
Create a balance sheet using the account names and balances below. Make assumptions about the dollar...
Create a balance sheet using the account names and balances below. Make assumptions about the dollar values of each account so that the balance sheet balances. Remember that assets will equal liabilities plus stockholders’ equity. Please make the balance sheet so that it can be pasted into a word document and display any calculation, Thank you so much for your time and I will be sure to give you a 5-star rating for superior work. Cash $32,800                        Accounts Payable $49,000                       ...
The balance sheet for AG Company is shown below. AG Company Balance Sheet 2016 Assets Liabilities...
The balance sheet for AG Company is shown below. AG Company Balance Sheet 2016 Assets Liabilities and Equity Cash…………………… $     60,000 Accounts payable…………….. $   220,000 Accounts receivable…... 240,000 Accrued taxes………………… 30,000 Inventory……………… 350,000 Bonds payable (long-term)…………………… 150,000 Plant and equipment…...    410,000 Common stock……………….. 80,000 Paid-in capital………………… 200,000 Retained earnings……………..     380,000 Total assets………... $1,060,000 Total liabilities and equity… $1,060,000 The Net Sales is 900,000, and Cost of Goods Sold is 400,000 for the year 2016, and the Beginning inventory...
Python: Solve following problems using Linked List Data Structure 2. Create a Queue class. In the...
Python: Solve following problems using Linked List Data Structure 2. Create a Queue class. In the queue class create enqueue, dequeue, first, empty, len and resize methods. The class should support circular queue and have the ability to resize the queue.
He said “you are in luck – no need to create my 2016 Balance Sheet –...
He said “you are in luck – no need to create my 2016 Balance Sheet – my daughter, who is an accountant, created the one attached below in Appendix B1.” You are relieved! “However,” he continued, “she did not have time to complete a cash flow statement. I need you to create one for me. And, could you tell me, (cause I have forgotten) what was paid out to me as a dividend?” Please create a cash flow statement for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT