ACT 300 Module 2 Adjusted Trial 

For this assignment, you are required to present the nine correct journal entries in an Excel spreadsheet.

Linda Ace started her own consulting firm, Modine Consulting, on May 1, 2008. The trial balance at May 31 is as detailed below.

MODINE CONSULTING

Trial Balance

May 31, 2008AccountNumber	Debit	Credit
101	Cash	$7,700
112	Accounts Receivable	4,000
126	Supplies	1,500
130	Prepaid Insurance	4,800
149	Office Furniture	9,600
201	Accounts Payable	$3,500
209	Unearned Service Revenue	3,000
301	L. Ace, Capital	19,100
400	Service Revenue	6,000
726	Salaries Expense	3,000
729	Rent Expense	1,000

In addition to those accounts listed on the trial balance, the chart of accounts for Modine Consulting also contains the following accounts and account numbers: No. 150 Accumulated Depreciation – Office Furniture; No. 229 Travel Payable; No. 212 Salaries Payable; No. 717 Depreciation Expense; No. 722 Insurance Expense; No. 736 Travel Expense; and No. 631 Supplies Expense.

Other data:

1. $500 worth of supplies has been used during the month.


2. Travel expenses incurred, but not payed, on May 31, 2008 are $200.


3. The insurance policy is for two years.


4. $1,000 of the balance in the unearned service revenue account remains unearned at the end of the month.


5. May 31 is a Wednesday, and employees are paid on Fridays. Modine Consulting has two employees, who are paid $700 each for a five-day work week.


6. The office furniture has a five-year life with no salvage value. It is being depreciated at $160 per month for 60 months.


7. Invoices representing $1,000 of services performed during the month have not been recorded as of May 31.

Instructions:

In Excel, following the six-column spreadsheet format used for the company Fast Forward in Chapter 3 of textbook, add the company name, the date of the statement, and today’s date and then enter: (a) the debits and credits for the unadjusted trial balance for May 31; (b) the debits and credits adjustments at the end of May 31; and (c) the total debits and credits of the adjusted trial balance for the month of May. Label each adjustment A through G.

 

Course Home Work aims to provide quality study notes and tutorials to the students of ACT 300 Module 2 Adjusted Trial   in order to ace their studies.

Course Home Work – Best Home Work Tutorials

ACT 300 Module 2 Adjusted Trial

Course Home Work, ACT 300 Module 2 Adjusted Trial  , Home Work Tutorials, Home Work Solutions, Home Work Essay, Home Work Questions.ACC 565 Wk 7 Assignment 3, ACC403 week 2 assignment, ACC565 Week 10, ACCT 212 (Financial Accounting),  ACCT 344 (Entire Course) – Devry, ACCT 344 Final Exam Latest 2014 – Devry,  ACCT 346 (Managerial Accounting), ACCT 346 Midterm Exam Updated DeVry, ACCT 504, ACCT 504 Week 8, ACCT 553, ART 101 Week 8, Ashford BUS 401, ASHFORD BUS 640, Ashford HIS 204, ASHFORD MAT 222 Week 3, BA 215 (Business Statistics), BA 215 All Assignments Week 1 -8 – Grantham, BA 225, BA 260, BA 265 (Business Law II), BA 265 (Business Law II) FINAL EXAM, BA 340 All Course Assignments, BA 340 Human Resource, BA 370 (Employment Law), BA 405 Multinational Management, BA 470 Week 3 – 5 – 6 – 7, BA 470 Entrepreneurship, BA350 Principles Of Finance, BIS 155 Final Exam – DeVry, BIS 220 Final Exam, BSOP 429, BSOP 434 Entire Course – Devry, BUS 303 Week 2, BUS 303 Week 3, BUS 303 Week 5, BUS 311 Business Law, BUS 330 Week 1, BUS 330 Week 3, BUS 330 Week 5, BUS 401 Week 4 DQ 1, BUS 401 Week 4 DQ 2, BUS 402 WEEK 4, BUS 405 (Principles of Investment), BUS 475, BUS 475 Final Exam 100 MCQS, BUS 475 Final Exam 600 MCQS, BUS 599 (STRAYER), BUS 599 Assignment, BUS 620 Week 4, BUS 640 Week 1, BUS499 Asignment 4, BUS508 Asignment 1, BUS499 Assignment 3.

ACT 300 Module 2 Adjusted Trial