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 $32,000 cash and computer equipment worth $25,000 in the company. April 3 The company rented furnished office space by paying $2,100 cash for the first month’s (April) rent. April 4 The company purchased $1,000 of office supplies for cash. April 10 The company paid $2,800 cash for a 12-month insurance policy. Coverage begins on April 11. April 14 The company paid $1,500 cash for two weeks' salaries earned by employees. April 24 The company collected $9,000 cash for commissions revenue. April 28 The company paid $1,500 cash for two weeks' salaries earned by employees. April 29 The company paid $500 cash for minor repairs to computer equipment. April 30 The company paid $1,150 cash for this month's telephone bill. April 30 Nozomi withdrew $2,200 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 $156 expired this month. At the end of the month, $700 of office supplies are still available. This month’s depreciation on computer equipment is $500. Employees earned $380 of unpaid and unrecorded salaries as of month-end. The company earned $2,200 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.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter21: Cash Budgeting (cashbud)
Section: Chapter Questions
Problem 1R: On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is...
icon
Related questions
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 $32,000 cash and computer equipment worth $25,000 in the company.
April 3 The company rented furnished office space by paying $2,100 cash for the first month’s (April) rent.
April 4 The company purchased $1,000 of office supplies for cash.
April 10 The company paid $2,800 cash for a 12-month insurance policy. Coverage begins on April 11.
April 14 The company paid $1,500 cash for two weeks' salaries earned by employees.
April 24 The company collected $9,000 cash for commissions revenue.
April 28 The company paid $1,500 cash for two weeks' salaries earned by employees.
April 29 The company paid $500 cash for minor repairs to computer equipment.
April 30 The company paid $1,150 cash for this month's telephone bill.
April 30 Nozomi withdrew $2,200 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 $156 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 $500.
  4. Employees earned $380 of unpaid and unrecorded salaries as of month-end.
  5. The company earned $2,200 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.

AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

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
CONCEPTS IN FED.TAX., 2020-W/ACCESS
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:
9780357110362
Author:
Murphy
Publisher:
CENGAGE L