On April 1, Jiro Nozomi created a new travel agency, Adventure Travel. The following transactions occurred during the company’s first month. April 2 Nozomi invested $36,000 cash and computer equipment worth $30,000 in the company. April 3 The company rented furnished office space by paying $2,300 cash for the first month’s (April) rent. April 4 The company purchased $1,900 of office supplies for cash. April 10 The company paid $2,700 cash for a 12-month insurance policy. Coverage begins on April 11. April 14 The company paid $1,000 cash for two weeks' salaries earned by employees. April 24 The company collected $8,500 cash for commissions revenue. April 28 The company paid $1,000 cash for two weeks' salaries earned by employees. April 29 The company paid $400 cash for minor repairs to computer equipment. April 30 The company paid $1,100 cash for this month's telephone bill. April 30 Nozomi withdrew $2,400 cash from the company for personal use.   The company's chart of accounts follows:   101 Cash 403 Commissions Revenue 106 Accounts Receivable 612 Depreciation Expense—Computer Equipment 124 Office Supplies 622 Salaries Expense 128 Prepaid Insurance 637 Insurance Expense 167 Computer Equipment 640 Rent Expense 168 Accumulated Depreciation—Computer Equipment 650 Office Supplies Expense 209 Salaries Payable 684 Repairs Expense 301 J. Nozomi, Capital 688 Telephone Expense 302 J. Nozomi, Withdrawals 901 Income Summary Use the following information to prepare adjusting entries: Prepaid insurance of $150 expired this month. At the end of the month, $700 of office supplies are still available. This month’s depreciation on computer equipment is $300. Employees earned $570 of unpaid and unrecorded salaries as of month-end. The company earned $2,150 of commissions revenue that is not yet recorded at month-end. Required: 1. & 2. Prepare journal entries to record the transactions for April and post them to ledger accounts in Req 6B GL tab. The company records prepaid and unearned items in balance sheet accounts. 3. Using account balances from Requirement 6b, prepare an unadjusted trial balance as of April 30. 4. Journalize the adjusting entries for the month, and then post to the ledger on Req 6B tab, using April 30 Adjusted as the date. 5a. Using adjusted account balances from Req 6B GL tab, prepare an adjusted trial balance as of April 30. 5b. Prepare the income statement for the month of April 30. 5c. Prepare the statement of owner's equity for the month of April 30. 5d. Prepare the balance sheet at April 30. 6a. Prepare journal entries to close the temporary accounts and then post to Req 6B GL tab, using April 30 Close as the date. 6b. Post the journal entries to the ledger. 7. Prepare a post-closing trial balance.         Using adjusted account balances from Req 6B GL tab, prepare an adjusted trial balance as of April 30.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter1: Business Transactions (ptrans)
Section: Chapter Questions
Problem 3R: On June 1 of the current year, Wilson Wood opened Woodys Web Services. This sole proprietorship had...
icon
Related questions
icon
Concept explainers
Question

On April 1, Jiro Nozomi created a new travel agency, Adventure Travel. The following transactions occurred during the company’s first month.

April 2 Nozomi invested $36,000 cash and computer equipment worth $30,000 in the company.
April 3 The company rented furnished office space by paying $2,300 cash for the first month’s (April) rent.
April 4 The company purchased $1,900 of office supplies for cash.
April 10 The company paid $2,700 cash for a 12-month insurance policy. Coverage begins on April 11.
April 14 The company paid $1,000 cash for two weeks' salaries earned by employees.
April 24 The company collected $8,500 cash for commissions revenue.
April 28 The company paid $1,000 cash for two weeks' salaries earned by employees.
April 29 The company paid $400 cash for minor repairs to computer equipment.
April 30 The company paid $1,100 cash for this month's telephone bill.
April 30 Nozomi withdrew $2,400 cash from the company for personal use.

 

The company's chart of accounts follows:
 

101 Cash 403 Commissions Revenue
106 Accounts Receivable 612 Depreciation Expense—Computer Equipment
124 Office Supplies 622 Salaries Expense
128 Prepaid Insurance 637 Insurance Expense
167 Computer Equipment 640 Rent Expense
168 Accumulated Depreciation—Computer Equipment 650 Office Supplies Expense
209 Salaries Payable 684 Repairs Expense
301 J. Nozomi, Capital 688 Telephone Expense
302 J. Nozomi, Withdrawals 901 Income Summary


Use the following information to prepare adjusting entries:

  1. Prepaid insurance of $150 expired this month.
  2. At the end of the month, $700 of office supplies are still available.
  3. This month’s depreciation on computer equipment is $300.
  4. Employees earned $570 of unpaid and unrecorded salaries as of month-end.
  5. The company earned $2,150 of commissions revenue that is not yet recorded at month-end.


Required:
1. & 2. Prepare journal entries to record the transactions for April and post them to ledger accounts in Req 6B GL tab. The company records prepaid and unearned items in balance sheet accounts.
3. Using account balances from Requirement 6b, prepare an unadjusted trial balance as of April 30.
4. Journalize the adjusting entries for the month, and then post to the ledger on Req 6B tab, using April 30 Adjusted as the date.
5a. Using adjusted account balances from Req 6B GL tab, prepare an adjusted trial balance as of April 30.
5b. Prepare the income statement for the month of April 30.
5c. Prepare the statement of owner's equity for the month of April 30.
5d. Prepare the balance sheet at April 30.
6a. Prepare journal entries to close the temporary accounts and then post to Req 6B GL tab, using April 30 Close as the date.
6b. Post the journal entries to the ledger.
7. Prepare a post-closing trial balance.
 

 
 
 
Using adjusted account balances from Req 6B GL tab, prepare an adjusted trial balance as of April 30.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Closing Accounts

 

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781305084087
Author:
Cathy J. Scott
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College