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

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

jeff jeffy answered 1 year ago

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...

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...

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 ...

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 ...

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...

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...

Based on the Trial Balance below and the Statement of Retained Earnings create a Balance Sheet...

Based on the Trial Balance below and the Statement of Retained Earnings create a Balance Sheet Statement: ACCT # Account Name Debit Credit 1000 Cash $402,575 1030 Treasury Bills $100,000 1031 Municiple Bonds $104,425 1032 Investments $770,500 1210 Accounts Receivable $30,000 1400 Inventory $20,000 1500 Furniture and Fixtures $0 1599 Accumulated Depreciation $30,000 2000 Accounts Payable $40,000 3000 Common Stock $0 3500 Retained Earnings $65,000 4000 Gross Sales $3,900,000 4100 Sales Returns $20,000 5000 Cost of Goods Sold $1,080,000 6000...

Create an income statement and balance sheet using the data below Inputs Accounts Payable 12,000 Accounts...

Create an income statement and balance sheet using the data below 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 Long Term Debt (excluding current portion) 120,000 Net Sales 400,000 Operating Expenses (excluding depreciation) 40,000...