Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please label the answers . . . 1. In Excel, set up a workbook with the following tabs: General Journal (For your journal entries) T-Accounts

please label the answers image text in transcribed
. . . 1. In Excel, set up a workbook with the following tabs: General Journal (For your journal entries) T-Accounts Trial Balance Income Statement Statement of Retained Earnings Balance Sheet 2. Record the following journal entries in the general journal: Apr 1 Received cash for Common Stock (30,000 shares, $1 par value) Received Computer Equipment for Common Stock (2,000 shares, $1 par value) 2 Paid first month's rent 3 Purchased office supplies 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 for dividends $ 30,000 20,000 1,800 1,000 2,400 1,600 8,000 1,600 350 750 1,500 3. Set up the T-accounts and enter the journal entries into the Traccounts. Calculate the balances. 4. Set up the Trial balance and enter the balances. 5. Complete the adjusting entries in the general journal Apr 30 2/3 of a month's insurance has expired Office supplies on hand 600 Depreciation on computer 500 Unpaid salaries Commissions earned but not billed 1,750 6. Enter the adjusting entries into the T-accounts 7 Create adjusted trial balance columns in your Trial Balance tab and update your trial balance 8. Create your income statement, statement of retained earnings, and balance sheet. 9. EXTRA CREDIT: write the closing entries and create a post-closing trial balance 420

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Islamic Accounting

Authors: Nabil Baydoun, Maliah Sulaiman, Roger J. Willett, Shahul Ibrahim

1st Edition

1119023297, 9781119023296

More Books

Students also viewed these Accounting questions

Question

2. Should a disciplinary system be established at Carter Cleaning?

Answered: 1 week ago