07 Jul Accounting Adjusted Trial Balance
Hi. The assignment needs the excel sheet filled out completely. I’ve provided the template. Here is the problem:
For this assignment, you are required to present the seven 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, 2008
|
Account Number |
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.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.