Good evening I have to create a balance sheet for question number 1 and and income statement for question number 2. I'm not sure where to even start.

Attachment 2 is for question number 1. Attachment 3 is for question number 2. It has to be put into an excel spreadsheet.

Balance sheet. From the following balance sheet accounts, Question Number 1

• a. construct a balance sheet for 2013 and 2014.
• b. list all the working capital accounts.
• c.findthenetworkingcapitalfortheyearsending2013and2014

d.calculate the change in net working capital for the year 2014.

2.

Income statement. From the following income statement accounts,

• a.produce the income statement for the year
• b.produce the operating cash flow for the year

ACCOUNT Balance 12/31/2013 Accumulated Depreciation Accounts Payable Accounts Receivable Cash Common Stock Inventory Long Term Debt Plant, Property, Equipment Retained Earnings 2020 1800 2480 1300 4990 5800 7800 8400 1370 Balance 12/31/2014 2670 2060 2690 1090 4990 6030 8200 9200 1090