Bevs Dry Cleaners is owned and operated by Beverly Zahn. A building and equipment are currently being rented, pending expansion to new facilities. The actual work of dry cleaning is done by another company for a fee. The assets and the liabilities of the business on November 1, 2019, are as follows: Cash, $16,590; Accounts Receivable, $33,970; Supplies, $3,160; Land, $39,500; Accounts payable, $14,220. Business transactions during November are summarized as follows:

Beverly Zahn invested additional cash in the business with a deposit of $33,000 in the business bank account.

Purchased land adjacent to land currently owned by Bevs Dry Cleaners to use in the future as a parking lot, paying cash of $16,500.

Paid rent for the month, $20,150.

Charged customers for dry cleaning revenue on account, $6,040.

Paid creditors on account, $2,820.

Purchased supplies on account, $14,910.

Received cash from cash customers for dry cleaning revenue, $32,230.

Received cash from customers on account, $40,290.

Received monthly invoice for dry cleaning expense for November (to be paid on December 10), $16,120.

Paid the following: wages expense, $8,860; truck expense, $3,220; utilities expense, $3,420; miscellaneous expense, $1,530.

Determined that the cost of supplies on hand was $2,220; therefore, the cost of supplies used during the month was $3,760.

Withdrew $9,300 cash for personal use.

Required:

1. Determine the amount of Beverly Zahns capital as of November 1.

$

2. Use the attached spreadsheet to complete part 2. Click on the Spreadsheet icon above to open and save the Excel file to your computer. Your input into the spreadsheet will not be included in your grade in CengageNOW on this problem.

Enter the assets, liabilities, and owner's equity as of November 1 in equation form similar to that shown in this chapter. In tabular form below the equation, indicate increases and decreases resulting from each transaction and the new balances after each transaction.

3. Using the balances from the spreadsheet, prepare an income statement for November, a statement of owner's equity for November, and a balance sheet as of November 30. Use a minus sign to indicate a net loss if applicable.

Income Statement

1

2

3

$

4

5

6

7

8

9

10

11

$

Statement of Owner's Equity

1

$

2

$

3

4

5

6

$

Balance sheet as of November 30:

When entering assets, enter them in order of liquidity.

Balance Sheet

1

2

$

$

3

4

5

6

$

$

4. Prepare a statement of cash flows for November:

Use the minus sign to indicate cash outflows, decreases in cash, and cash payments.

Statement of Cash Flows

1 Cash flows from operating activities:

2

$

3

4 Net cash flow from operating activities $

5 Cash flows used for investing activities:

6

7 Cash flows from financing activities:

8

$

9

10 Net cash flow from financing activities

11 Net Increase in cash during November $

12 Cash balance, November 1, 2019

13 Cash balance, November 30, 2019 $