Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started