Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
Bartleby Related Questions Icon

Related questions

bartleby

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
Check Mark
Still need help?
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Closing Accounts

 

Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Closing Accounts

 

Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Knowledge Booster
Background pattern image
Accounting
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
Text book image
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Text book image
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:9780357110362
Author:Murphy
Publisher:CENGAGE L
Text book image
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Text book image
PAYROLL ACCT., 2019 ED.(LL)-TEXT
Accounting
ISBN:9781337619783
Author:BIEG
Publisher:CENGAGE L