Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

On June 1 of the current year, Wilson Wood opened Woody's Web Services, Inc. The corporation had the following transactions during June. a. Opened a

On June 1 of the current year, Wilson Wood opened Woody's Web Services, Inc. The corporation had the following transactions during June.

a. Opened a business checking account and made a deposit, $4,000. In exchange, Wilson was issued 200 shares of $20 par value stock.

b. Paid rent for June for office space and computer equipment, $2,000.

c. Purchased office supplies (stamps, pens, etc.) on account, $680.

d. Received cash for services rendered, $3,500.

e. Paid creditor for office supplies purchased on account, $500.

f. Purchased office supplies for cash, $190.

g. Billed clients for consultations performed on account, $4,400.

h. Paid the monthly internet service bill of $180.

i. Paid the secretary's salary of $2,400.

j. Declared and paid dividends of $500.

k. Received cash from clients previously billed, $1,500.

l. Returned $150 of office supplies purchased in transaction f above. Received a full refund.

REQUIRED

1) You are to record these transactions using a spreadsheet format. Click the Answer tab and enter your name in cell C5. Then click the Worksheet tab and enter your name in cell C1 of the worksheet. There are six formulas needed to complete the worksheet. Enter the formulas in the appropriate cells. Then enter the increases and decreases resulting from each transaction on the worksheet. For example, the first transaction increases the cash account by $8,000 and also increases the common stock account by $8,000. This transaction has already been recorded on the worksheet. Enter negative numbers with a minus sign (-). The worksheet will automatically total each column as values are entered in that column. When you are finished, check line 27 to make sure that total assets equal total liabilities and equity.

2) It has been determined that the cost of the supplies used during the month was $300. Record the increase or decrease in the appropriate columns on the worksheet. This is Transaction m. Save the completed file as FTRANS2. Print the worksheet. Also print your formulas. Check figure: Ending cash balance (cell B22), $2,020

3) How does Transaction m differ from Transactions a through I? In other words, why is it treated as a special item?

4) Prepare an income statement, a statement of retained earnings, and a balance sheet in good form for Woody's Web Services, Inc for the month of June.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sound Investing, Chapter 8 - Revenue Hoaxes

Authors: Kate Mooney

3rd Edition

007171930X, 9780071719308

More Books

Students also viewed these Accounting questions

Question

What is Accounting?

Answered: 1 week ago

Question

Define organisation chart

Answered: 1 week ago

Question

What are the advantages of planning ?

Answered: 1 week ago

Question

Explain the factors that determine the degree of decentralisation

Answered: 1 week ago

Question

What Is acidity?

Answered: 1 week ago