Hampton Accounting Service Inc. is a public corporation that has been in business for 1 year. The company provides accounting services and sells accounting software. Hampton Accounting Service Inc. is authorized to issue 100,000 shares of $1 par value common stock. The current inventory consists of 30 units of software at a cost of $40.00 each. Inventory is cost using LIFO and the perpetual inventory system. The company uses an allowance method to account for uncollectible accounts. It is estimated that 1% of net sales on account will be uncollectible. Employees are paid $1,500 salary twice a month, on the 16th for the first half of the month and on the 2nd of the following month for the last half of the month.
Opening balances- The opening balances for select accounts are provided in the appropriate ledger accounts.
Record the following transactions in the journal and post to the ledger:
01/01/15- Issued 1,000 shares of common stock for $5,000
01/02/15- Paid for 3 months of Building Rent, $3,000
01/02/15- Paid employees Salaries owed
01/02/15- Provided Accounting Service on Account, $4,500
01/05/15- Purchased Computer Equipment on Account, $6,800
Note: The equipment has an estimated useful life of 4 years and residual value of $50.
01/08/15- Purchased Supplies for $800 cash
01/10/15- Received $300 payment on account
01/11/15- Sold 15 units of Inventory on Account, $1,500
01/11/15- Made payment on Account, $1,000
01/12/15- Purchased 20 units of Inventory on Account, $900
01/14/15- Paid for Advertising, $450
01/15/15- Provided Accounting service for Cash, $2,500
01/16/15- Paid employees salary for Jan 1-15
01/17/15- Received $1,400 payment on Account
01/19/15- Sold 10 units of Inventory on Account, $1,000
01/22/15- Received $1,500 payment on Account
01/23/15- Made payment on Account, $2,500
01/25/15- Paid monthly Utility bills, $850
01/27/15- Received $2,000 cash in advance for Accounting service
01/29/15- Paid for Advertising, $350
01/31/15- Declared and paid $2/share cash dividend
Prepare a trial balance to verify that total debits equal total credits. Use Excel formulas to calculate balances.
Record the necessary adjustments in the worksheet, journal and ledger for the following items:
01/31/15- Employees salary for Jan 16-31.
01/31/15- Depreciation on Computer Equipment, use DDB method (calculate for 1 month)
01/31/15- January’s Rent
01/31/15- Supplies on hand equal $625
01/31/15- Inventory count shows 23 units, some damaged units were disposed of during the month
01/31/15- $500 of advance payment was earned in January
01/31/15- Uncollectible Account expense
Prepare an Adjusted trial balance to verify debits equal credits at the end of the month
Prepare the 3 main Financial statements for the month of January. For the income statement, use a Multi- step format. For the balance sheet, prepare a classified balance sheet. Enter Excel formulas for all calculations. The format of all 3 statements should be neat and consistent.
Extra Credit (10 points)
Use Cell referencing between the worksheets
The ledger balances will automatically calculate with the formulas that are present. If your trial balance is not in balance, you must go back and check your postings to the ledger and the posting of ledger balances to the worksheet. All numerical fields should be formatted for currency using whole dollars. Decimal points and cents are not required.
Why Work with Us
Top Quality and Well-Researched Papers
We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.
Professional and Experienced Academic Writers
We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.
Free Unlimited Revisions
If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.
Prompt Delivery and 100% Money-Back-Guarantee
All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.
Original & Confidential
We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.
24/7 Customer Support
Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
Admission Essays & Business Writing Help
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.