img:focus { margin: auto; } Unformatted Attachment Preview Modine Option #1- Mod 2- CT Templaplate for your Journal # Acct # A Account Name Debit Journal Entires Credit B C D E F G Modine Worksheet Unadj Trial Balance Debit 101 112 126 130 149 150 201 209 212 229 Cash Accounts Receivable Supplies Prepaid Insurance Office Furniture Accumulated Depreciation Accounts Payable Unearned Revenue Salaries Payable Travel Payable Credit Adjustments Debit Credit Adj trial Balance Debit Credit 301 Ace, Capital 400 Service Revenue- Journal D Service Revenue- Journal G 736 Travel Expense 631 Supplies Expense 717 Depreciation Expense 722 Insurance Expense 726 Salaries Expense 736 Rent Expense TOTALS Adjusted Trial Balance: The Modine Consulting Case For this assignment, you are required to present the seven correct journal entries in an Excel spreadsheet. Assignment Template attached below 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 101 112 126 130 149 201 209 301 400 726 729 Cash Accounts Receivable Supplies Prepaid Insurance Office Furniture Accounts Payable Unearned Service Revenue L. Ace, Capital Service Revenue Salaries Expense Rent Expense Debit $7,700 4,000 1,500 4,800 9,600 Credit $3,500 3,000 19,100 6,000 3,000 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: A. B. C. D. E. F. G. $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. Purchase answer to see full attachment User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.

August 6, 2023/in Uncategorized /by online_admin

Description

Please take a look at attach files for instructions.

2 attachmentsSlide 1 of 2attachment_1attachment_1attachment_2attachment_2.slider-slide > img { width: 100%; display: block; }
.slider-slide > img:focus { margin: auto; }

Unformatted Attachment Preview

Modine
Option #1- Mod 2- CT Templaplate for your
Journal # Acct #
A
Account Name
Debit
Journal Entires
Credit
B
C
D
E
F
G
Modine
Worksheet
Unadj Trial Balance
Debit
101
112
126
130
149
150
201
209
212
229
Cash
Accounts Receivable
Supplies
Prepaid Insurance
Office Furniture
Accumulated Depreciation
Accounts Payable
Unearned Revenue
Salaries Payable
Travel Payable
Credit
Adjustments
Debit
Credit
Adj trial Balance
Debit
Credit
301 Ace, Capital
400 Service Revenue- Journal D
Service Revenue- Journal G
736 Travel Expense
631 Supplies Expense
717 Depreciation Expense
722 Insurance Expense
726 Salaries Expense
736 Rent Expense
TOTALS
Adjusted Trial Balance: The Modine Consulting Case
For this assignment, you are required to present the seven correct journal entries in an Excel spreadsheet.
Assignment Template attached below
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
101
112
126
130
149
201
209
301
400
726
729
Cash
Accounts Receivable
Supplies
Prepaid Insurance
Office Furniture
Accounts Payable
Unearned Service Revenue
L. Ace, Capital
Service Revenue
Salaries Expense
Rent Expense
Debit
$7,700
4,000
1,500
4,800
9,600
Credit
$3,500
3,000
19,100
6,000
3,000
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:
A.
B.
C.
D.
E.
F.
G.
$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.

Purchase answer to see full
attachment

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.

https://www.onlinefreelancersnetwork.com/wp-content/uploads/2020/08/logoOFN.png 0 0 online_admin https://www.onlinefreelancersnetwork.com/wp-content/uploads/2020/08/logoOFN.png online_admin2023-08-06 10:34:262023-08-06 10:34:26Description Please take a look at attach files for instructions. 2 attachmentsSlide 1 of 2attachment_1attachment_1attachment_2attachment_2.slider-slide > img { width: 100%; display: block; } .slider-slide > img:focus { margin: auto; } Unformatted Attachment Preview Modine Option #1- Mod 2- CT Templaplate for your Journal # Acct # A Account Name Debit Journal Entires Credit B C D E F G Modine Worksheet Unadj Trial Balance Debit 101 112 126 130 149 150 201 209 212 229 Cash Accounts Receivable Supplies Prepaid Insurance Office Furniture Accumulated Depreciation Accounts Payable Unearned Revenue Salaries Payable Travel Payable Credit Adjustments Debit Credit Adj trial Balance Debit Credit 301 Ace, Capital 400 Service Revenue- Journal D Service Revenue- Journal G 736 Travel Expense 631 Supplies Expense 717 Depreciation Expense 722 Insurance Expense 726 Salaries Expense 736 Rent Expense TOTALS Adjusted Trial Balance: The Modine Consulting Case For this assignment, you are required to present the seven correct journal entries in an Excel spreadsheet. Assignment Template attached below 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 101 112 126 130 149 201 209 301 400 726 729 Cash Accounts Receivable Supplies Prepaid Insurance Office Furniture Accounts Payable Unearned Service Revenue L. Ace, Capital Service Revenue Salaries Expense Rent Expense Debit $7,700 4,000 1,500 4,800 9,600 Credit $3,500 3,000 19,100 6,000 3,000 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: A. B. C. D. E. F. G. $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. Purchase answer to see full attachment User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Write my essay for me?

LEGAL

CONTACT INFORMATION

WE ACCEPT

Bookmarks