Using the excel sheet calculate the following

a. Working Capital on December 31, 20x1

b. Working Capital on December 31, 20x2

c. Dollar difference in working capital from 20x1 to 20x2

d. Percent difference in working capital from 20x1 to 20x2

Hint: to calculate working capital, you must know total current assets and total current liabilities.

Transcribed Image Text:

A 1 2 Assets 3 Cash 4 Marketable Securities 5 Accounts Receivable 6 Inventory 7 Prepaid Expenses 8 Equipment 9 Accumulated Depreciation 10 Total Assets 11 12 Liabilities 13 Accounts Payable 14 Accrued Expenses 15 Dividends Payable 16 Mortgage Payable (Current) 17 Mortgage Payable (long-term) 18 Total Liabilites 19 20 Owner's Equity 21 Common Stock 22 Treasury Stock 23 Retained Earnings 24 Total Liabilities and Owner's Equity 25 76 B C 20X1 D 20X2 $15,000 $30,000 $25,000 $30,000 $24,000 $26,000 $20,000 $18,000 $10,000 $25,000 $420,000 $555,000 ($180,000) ($200,000) $334,000 $484,000 $15,000 $13,000 $10,000 $15,000 $23,000 $26,000 $20,000 $25,000 $150,000 $195,000 $218,000 $274,000 $120,000 $140,000 ($20,000) ($30,000) $16,000 $100,000 $334,000 $484,000 !!! E A 1 2 Assets 3 Cash 4 Marketable Securities 5 Accounts Receivable 6 Inventory 7 Prepaid Expenses 8 Equipment 9 Accumulated Depreciation 10 Total Assets 11 12 Liabilities 13 Accounts Payable 14 Accrued Expenses 15 Dividends Payable 16 Mortgage Payable (Current) 17 Mortgage Payable (long-term) 18 Total Liabilites 19 20 Owner's Equity 21 Common Stock 22 Treasury Stock 23 Retained Earnings 24 Total Liabilities and Owner's Equity 25 76 B C 20X1 D 20X2 $15,000 $30,000 $25,000 $30,000 $24,000 $26,000 $20,000 $18,000 $10,000 $25,000 $420,000 $555,000 ($180,000) ($200,000) $334,000 $484,000 $15,000 $13,000 $10,000 $15,000 $23,000 $26,000 $20,000 $25,000 $150,000 $195,000 $218,000 $274,000 $120,000 $140,000 ($20,000) ($30,000) $16,000 $100,000 $334,000 $484,000 !!! E

Answer rating: 100% (QA)

To calculate the working capital for each year we need to subtract total current liabilities from to... View the full answer