*use excel and 1ll 10 accounting steps*

On April 1, 2011, Jiro Nozorni created a new travel agency, Adventure Travel. The following transactions

occurred during the company’s first month.

April 1 Nozomi invested $32,000 cash and computer equipment worth $26,000 in the company in

exchange for its common stock.

2 The company rented furnished office space by paying $1,300 cash for the first month’s (April) rent.

3 The company purchased $2,500 of office supplies for cash.

10 The company paid $2,502 cash for the premium on a 12-month insurance policy. Coverage begins

on April 11.

14 The company paid $2,300 cash for two weeks’ salaries earned by employees.

24 The company collected $16,000 cash on commissions from airlines on tickets obtained for


28 The company paid $2,400 cash for two weeks’ salaries earned by employees.

29 The company paid $750 cash for minor repairs to the company’s computer.

30 The company paid $550 cash for this month’s telephone bill.

30 The company paid $1,200 cash for dividends.

The company’s chart of accounts follows:

101 Cash

106 Accounts Receivable

124 Office Supplies

128 Prepaid Insurance

167 Computer Equipment

168 Accumulated Depreciation-Computer Equip.

209 Salaries Payable

307 Common Stock

318 Retained Earnings

319 Dividends

405 Commissions Earned

612 Depreciation Expense-Computer Equip.

622 Salaries Expense

637 Insurance Expense

640 Rent Expense

650 Office Supplies Expense

684 Repairs Expense

688 Telephone Expense

90 I Income Summary


I. Use the balance column format to set up a ledger account for each account listed in its chart of


1. Prepare journal entries to record the April transactions and post them to the ledger accounts. The

company records prepaid and unearned items in balance sheet accounts.

3. Prepare an unadjusted trial balance as of April 30.

4. Use the following information to journalize and post adjusting entries for the month.

a. Two-thirds of one month’s insurance coverage has expired.

b. At the end of the month, $700 of office supplies are still available.

c. This month’s depreciation on the computer equipment is $500.

d. Employees earned $720 of unpaid and unrecorded salaries as of month-end.

e. The company earned $3,050 of commissions that are not yet billed at month-end.

s. Prepare the income statement and the statement of retained earnings for the month of April and the

balance sheet as of April 30, 2011.

6. Prepare journal entries to close the temporary accounts and post these entries to the ledger.

7. Prepare a post-closing trial balance.