ACT 300 MODULE 2 ADJUSTED TRIAL
For this assignment, you are required to present the nine correct journal entries in an Excel spreadsheet.
WRITE THIS ESSAY FOR ME
Tell us about your assignment and we will find the best writer for your paper.
Get Help Now!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:
$500 worth of supplies has been used during the month.
Travel expenses incurred, but not payed, on May 31, 2008 are $200.
The insurance policy is for two years.
$1,000 of the balance in the unearned service revenue account remains unearned at the end of the month.
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.
The office furniture has a five-year life with no salvage value. It is being depreciated at $160 per month for 60 months.
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.
Introducing our Online Essay Writing Services Agency, where you can confidently place orders for a wide range of academic assignments. Our reputable homework writing company specializes in crafting essays, term papers, research papers, capstone projects, movie reviews, presentations, annotated bibliographies, reaction papers, research proposals, discussions, and various other assignments. Rest assured, our content is guaranteed to be 100% original, as every piece is meticulously written from scratch. Say goodbye to concerns about plagiarism and trust us to deliver authentic and high-quality work.
WRITE MY ESSAY NOW
