Hi,

I need help with this assignment if you could explain to me more.

Thanks

Student Name: Class: Problem 03-07A NOTE: Ledger accounts begin at cell A150, and show all entries that need to be posted. ADVENTURE TRAVEL General Journal Date Account Titles Transactions for April (Part 2): Apr 1 Cash Computer Equipment Common stock Owner invested in the business in exchange for stock. Acct. No. Debit 101 167 307 30,000 20,000 2 Rent Expense Cash Paid one month's rent 640 101 1,800 3 Office Supplies Cash Acquired office supplies 124 101 1,000 10 Prepaid Insurance Cash Paid 12 months' premium in advance. 128 101 2,400 14 Salaries Expense Cash Paid two weeks' salaries. 622 101 1,600 24 Cash Commissions Earned Collected commissions from airlines. 101 405 8,000 28 Salaries Expense Cash Paid two weeks' salaries. 622 101 1,600 29 Repairs Expense Cash Repaired the computer. 684 101 350 30 Telephone Expense Cash Paid the telephone bill. 688 101 750 30 Dividends Cash Owner withdrew cash. 319 101 1,500 637 128 133 650 124 600 Adjusting Entries (Part 4): Apr 30 Insurance Expense Prepaid Insurance To record expired insurance. 30 Office Supplies Expense Office Supplies To record cost of supplies used. Credit 50,000 1,800 1,000 2,400 1,600 8,000 1,600 350 750 1,500 133 400 Student Name: Class: Problem 03-07A 30 Depreciation Expense - Computer Equipment Accumulated Depreciation - Computer Equipment To record depreciation. 612 168 20,000 30 Salaries Expense Salaries Payable To record accrued salaries. 622 209 3,200 30 Accounts Receivable Commissions Earned To record accrued commissions. 106 405 8,000 500 420 1,750 Student Name: Class: Problem 03-07A Closing Entries (Part 6) Apr 30 Commissions Earned Income Summary To close the revenue account. 405 901 8,000 30 Income Summary Depreciation Expense, Computer Equipment Salaries Expense Insurance Expense Rent Expense Office Supplies Expense Repairs Expense Telephone Expense To close the expense accounts. 901 612 622 637 640 650 684 688 9,750 30 Income Summary Retained earnings To close the Income Summary account. 901 318 9,750 30 Retained earnings Dividends To close the Dividends account. 318 319 42,447 9,750 500 3,200 133 1,800 600 350 750 42,447 1,500 ADVENTURE TRAVEL Unadjusted Trial Balance April 30, 2013 Account Titles Cash Accounts receivable Office supplies Prepaid insurance Computer equipment Accumulated depreciation - computer equipment Salaries payable Common stock Retained earnings Dividends Commissions earned Depreciation expense - computer equipment Salaries expense Insurance expense Rent expense Office supplies expense Repairs expense Telephone expense Totals $ $ Debits 19,000 1,000 2,400 20,000 Credits $ - - $ 1,500 50,000 - 3,200 1,800 350 750 50,000 $ Try again! 50,000 Try again! ADVENTURE TRAVEL Adjusted Trial Balance April 30, 2013 Account Titles Cash $ Debits 19,000 Credits Student Name: Class: Problem 03-07A Accounts receivable Office supplies Prepaid insurance Computer equipment Accumulated depreciation - computer equipment Salaries payable Common stock Retained earnings Dividends Commissions earned Depreciation expense - computer equipment Salaries expense Insurance expense Rent expense Office supplies expense Repairs expense Telephone expense Totals 8,000 400 2,267 20,000 500 1,500 - 420 50,000 500 3,200 133 $ 1,800 600 350 750 51,167 Try again! Student Name: Class: Problem 03-07A ADVENTURE TRAVEL Income Statement For Month Ended April 30, 2013 Commissions earned Expenses: Depreciation expense, computer equipment Salaries expense Insurance expense Rent expense Office supplies expense Repairs expense Telephone expense Total expenses Net income ADVENTURE TRAVEL Statement of Retained Earnings For Month Ended April 30, 2013 Retained earnings, April 1, 2013 Add: Net income Less: Dividends Retained earnings, April 30, 2013 ADVENTURE TRAVEL Balance Sheet April 30, 2013 Assets Cash Accounts receivable Office supplies Prepaid insurance Computer equipment Accumulated depreciation - computer equipment Total assets Liabilities Salaries payable Owner's Equity Common stock Retained earnings Total liabilities and equity ADVENTURE TRAVEL Post-Closing Trial Balance April 30, 2013 Account Titles Cash Debits Credits Student Name: Class: Problem 03-07A Accounts receivable Office supplies Prepaid insurance Computer equipment Accumulated depreciation, computer equipment Salaries payable Common stock Retained earnings Totals Student Name: Class: Problem 03-07A ADVENTURE TRAVEL General Ledger Cash Account No. Date Explanation PR Debit Credit Apr 1 2 3 10 14 24 28 29 30 30 Accounts Receivable Date Explanation Apr 30 Adjusting Account No. PR Debit Office Supplies Date Account No. Explanation Apr 3 30 PR Debit Explanation Apr 10 30 Account No. PR Debit Credit Adjusting Computer Equipment Date Credit Adjusting Prepaid Insurance Date Credit Explanation Account No. PR Debit Credit Apr 1 Accumulated Depreciation, Computer Equipment Date Apr 30 Explanation Adjusting Account No. PR Debit Salaries Payable Date Apr 30 Explanation Adjusting Account No. PR Debit Common Stock Date Credit Credit Account No. Explanation PR Debit Credit Apr 1 Retained Earnings Account No. Student Name: Class: Problem 03-07A Date Explanation 30 Closing 30 Closing PR Debit Dividends Date Account No. Explanation Apr 30 30 Credit Closing PR Debit Credit Student Name: Class: Problem 03-07A Commissions Earned Date Explanation Apr 24 30 30 Account No. PR Debit Adjusting Closing Depreciation Expense, Computer equipment Date Apr 30 30 Explanation Adjusting Closing Account No. PR Debit Salaries Expense Date PR Debit Explanation Adjusting Closing Account No. PR Debit Rent Expense Date Explanation PR Debit Explanation Apr 30 30 Account No. PR Debit Account No. Explanation Apr 29 30 PR Debit Credit Closing Telephone Expense Explanation Apr 30 30 Account No. PR Debit Credit Closing Income Summary Date Credit Closing Repairs Expense Date Credit Closing Office Supplies Expense Date Credit Account No. Apr 2 30 Date Credit Adjusting Closing Insurance Expense Apr 30 30 Credit Account No. Explanation Apr 14 28 30 30 Date Credit Explanation Account No. PR Debit Credit Student Name: Class: Problem 03-07A Apr 30 30 30 Closing Closing Closing - Correct! - Correct! - Correct! - Correct! - Correct! - Correct! - Correct! - Correct! - Correct! - Correct! - Try again! - Correct! - Correct! - Correct! - Correct! - Correct! - Correct! - Try again! - Try again! - Correct! - Try again! - Correct! - Correct! - Try again! - Correct! TRAVEL edger 101 Balance 106 Balance 124 Balance 128 Balance 167 Balance 168 Balance 209 Balance 307 Balance 318 Balance 319 Balance 405 Balance 612 Balance 622 Balance 637 Balance 640 Balance 650 Balance 684 Balance 688 Balance 901 Balance Given Data P03-07A: ADVENTURE TRAVEL Apr 1 Nozomi invested cash 1 Nozomi invested computer equipment 2 Paid first month's rent 3 Purchased office supplies for cash 10 Paid annual insurance premium 14 Paid salaries 24 Collected commissions earned 28 Paid salaries 29 Paid for computer repair 30 Paid telephone bill 30 Paid cash dividends $ 30,000 20,000 1,800 1,000 2,400 1,600 8,000 1,600 350 750 1,500 $ 600 500 420 1,750 $ $ $ $ $ 58,000 133 2,197 51,117 51,617 Chart of Accounts 101 Cash 106 Accounts Receivable 124 Office Supplies 128 Prepaid Insurance 167 Computer Equipment 168 Accumulated Depreciation - Computer Equipment 209 Salaries Payable 307 Common stock 318 Retained earnings 319 Dividends 405 Commissions Earned 612 Depreciation expense - Computer Equipment 622 Salaries Expense 637 Insurance Expense 640 Rent Expense 650 Office Supplies Expense 684 Repairs Expense 688 Telephone Expense 901 Income Summary Additional Information: Apr 30 a. 2/3 of a month's insurance expired b. Office supplies on hand c. Depreciation on computer d. Unpaid and unrecorded salaries e. Commissions earned but not billed Check figures: (3) Unadjusted trial balance totals (4a) Debit Insurance Expense (5) Net income Total assets (7) Post-closing trial balance totals