Key Code:
Enter the appropriate amounts/formulas in the answer cells, or select from the drop-down list. In part 2, place
a plus sign or minus sign in the small box beside the amount. Row (a) has been completed as an example.
An asterisk (*) will appear to the right of incorrect entries in outlined answer cells.
Enter a zero where you would otherwise leave an amount cell blank.
1.
=Liabilities +
Accounts Accounts Capital Retained
Cash + Receivable + Supplies + Land = Payable + Stock Earnings 3. a.
Retained
+ + + = + + Earnings
= + Retained Earnings Dry cleaning sales
Expenses:
= Retained Earnings
2. Liabilities
Dry Dry
Accounts Accounts Capital Retained Cleaning Cleaning Wages Supplies Rent Truck Utilities Misc. Total expenses
Cash
Supplies Land Payable Stock Dividends Earnings – Revenue Expense Expense Expense Expense Expense Expense Expense Net income
Bal. 39,000 80,000 11,000 50,000 31,500 50,000 98,500 – – – – – – – – –
a. + 21,000 – – – –
21,000 – – – – – – – – – –
Bal. 60,000 80,000 11,000 50,000 31,500 71,000 98,500 – – – – – – – – – b.
b.
Bal.
c.
Bal. Retained earnings, November 1, 2014
d.
Bal.
e.
Bal. Retained earnings, November 30, 2014
f.
Bal.
g.
Bal. c.
h.
Bal.
i.
Bal. Assets
j.
Bal.
k.
Bal.
l. Total stockholders’ equity
Bal. Total assets Total liabilities and stockholders’ equity
4.
Cash flows from operating activities:
Cash flows from investing activities:
Cash flows from financing activities:
Increase in cash
Cash balance, November 1, 2014
Cash balance, November 30, 2014
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Retained Earnings Statement