1. Using Microsoft Excel, create a balance sheet and an income statement using the relevant information below
2. Calculate the Net Working Capital and the Net Operating Working Capital for both years
3. Perform vertical analysis on both statements, for both years
4. Perform Horizontal analysis on both statements for the most current year
5. 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. Expenses before depreciation 900 Accruals 150 Depreciation Expense 250 Gross Fixed Assets 3200 Retained Earnings 3505 Interest Expense 100 Accumulated Depreciation 400 Notes Payable (short term) 395

2015 Accounts Receivable 700 Sales 3800 Accounts Payable 400 Inventory 1000 COGS 2100 Common Stock 1500 Cash 1300 Oper. Expenses before depreciation 600 Accruals 50 Depreciation Expense 250 Gross Fixed Assets 3200 Retained Earnings 3050 Interest Expense 200 Accumulated Depreciation 150 Notes Payable (short term) 1050

Additional Information:

• No Dividends were paid either year
• The tax rate for each year was 30%