Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Mr. Wayne started a new Accounting company that performs accounting services for small to mid-size businesses in his area. The following are a list of

Mr. Wayne started a new Accounting company that performs accounting services for small to mid-size businesses in his area. The following are a list of transactions that occurred in the first month of operations for Batman Accounting Services, Inc. a subchapter S corporation:

May 1

Mr. Wayne deposited $200,000 of his personal money into the business savings account.

2

The Corporation signs an agreement to rent an office space for $1,200 per month, with the first 6 months due at the time of signing

2

Mr. Wayne contributed a computer worth $1,500 and a desk worth $3,500 to the Corporation

2

The Corporation bought $300 worth of miscellaneous office supplies such as pens, pencils and paper

2

The Corporation bought a printer for $800

3

The Corporation paid Robin $500 to produce a commercial promoting the Corporation

4

The Corporation paid $2,300 in airfare for Mr. Wayne to attend a CPA conference in Washington DC

4

The Corporation paid $800 for a hotel in Washington DC for 4 nights so Mr. Wayne could attend the CPA conference.

6

Mr. Wayne spent $120 out of the Corporation's bank account on a pair of shoes

10

The Corporation reimbursed Mr. Wayne $1,300 for meals spent in Washington DC

15

The Corporation hires Mr. Freeze as the Senior Accountant for $25 an hour

15

Mr. Wayne bills Mr. Joker $450 for monthly bookkeeping services

15

Mr. Wayne bills Ms. Ivy $600 for monthly bookkeeping services and payroll preparation

20

Mr. Wayne bills Mr. Face $550 for preparation of his 2015 tax return.

30

The Corporation paid $200 for utilities

30

The Corporation paid $125 for the telephone service

30

The Corporation accepted a credit payment from Mr. Joker for $450, but incurred a $5 credit service fee and received $445 in cash

30

The Corporation received a notice from the Court that Mr. Face was granted bankruptcy and is not mandatory to pay his amount due.

30

The Corporation received an invoice for miscellaneous office supplies for $425

31

The Corporation billed miscellaneous clients in the total amount of $12,500.

31

The Corporation paid wages for the month of May which consisted of the following:

Wages

$2,400

Employer Payroll Taxes to be paid next month

$703

Employee taxes paid by the employer due next month

$476

Cash paid out on the 31st

$1,924

Note: Remember your adjusting entries.

The company elects to use the straight line depreciation method with the computers and printer having a 3 year life and the desk having a 5 year life. (Round to the nearest whole dollar)

Assuming the Corporation is on an Accrual Basis of accounting, prepare a 5 column trial balance. This should include the unadjusted trial balance, adjustments, adjusted trial balance, balance sheet and income statement. Then prepare, in good form (i.e. correct heading titles), the Balance Sheet, Income Statement and Statement of Owners Equity.

All of these should be done in excel with formulas. I have included an excel template you can use. The first tab are the T-accounts that you can enter in the numbers, then you should sum up the balances and link them to the trial balance on tab 2. Then the totals on the trial balance should carry over to the balance sheet, income statement and statement of owners equity tabs. You should not hard key any amounts on tab 2, they should all be linked to the second tab. I have done the first transaction and linked the cash account for your reference.

Finally, write a short evaluation about the company and where you think the company is heading. Include in your evaluation if you think the company is profitable and where do you think the company can save money or ways the company can improve revenue.

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_2

Step: 3

blur-text-image_3

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

Financial Accounting Information For Decisions

Authors: Robert w Ingram, Thomas L Albright

6th Edition

9780324313413, 324672705, 324313411, 978-0324672701

More Books

Students also viewed these Accounting questions