Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Opening balances- The opening balances for select accounts are provided in the a

ID: 2510824 • Letter: O

Question

Opening balances- The opening balances for select accounts are provided in the appropriate ledger accounts.
2. Record the following transactions in the journal and post to the ledger:
12/02/13- Purchased 10 Units of Software on Account for $1,300
12/02/13- Paid employees Salaries owed
12/02/13- Provided Accounting Service on Account, $3,200
12/05/13- Purchased Computer Equipment on Account, $4,800
Note: The equipment has an estimated useful life of 4 years, residual value of $50 and uses the DDB method.
12/08/13- Purchased Supplies for $800 cash
12/10/13- Received $3,000 payment on account
12/11/13- Sold 15 units of Inventory on Account, $4,500
12/11/13- Made payment on Account, $1,000
12/12/13- Purchased 20 units of Inventory on Account, $2,400
12/14/13- Received a bill for Advertising and paid it, $250
12/15/13- Provided Accounting service for Cash, $8,000
12/16/13- Paid employees salary for Dec. 1-15 12/17/13- Provided Accounting Service on Account, $6,000
12/19/13- Sold 10 units of Inventory on Account, $3,000
12/22/13- Received $2,500 payment on Account
12/23/13- Made payment on Account, $2,500
12/24/13- Received and paid monthly Utility bills, $850
12/27/13- Received $2,000 cash in advance for accounting services
12/29/13- Provided Accounting Service for Cash, $5,000
12/30/13- Issued 1,000 shares of Common Stock at $15 per share
12/31/13- Declared dividends of $1.50 to outstanding shareholders as of 12/31/13.
NOTE: Be sure to debit retained earnings and credit dividends payable.
3. Prepare a trial balance to verify that total debits equal total credits.
4. Record the following adjustments in the journal and in the trial balance. DO NOT post the adjusting entries to the ledger. Instead, post them directly as adjustments to the trial balance.
12/31/13- Employees salary for Dec. 16-31 12/31/13- Depreciation on Building, use SL method (calculate for entire year)
12/31/13- Depreciation on Furnishings, use DDB method (calculate for entire year)
12/31/13- Depreciation on Computer Equipment, use DDB method (calculate for one month)
12/31/13- Supplies on hand equal $1,625
12/31/13- Inventory count shows 33 units, some damaged units were disposed of during the month
12/31/13- $500 of advance payment was earned in December
12/31/13- Uncollectible Account expense for December
5. Prepare an Adjusted trial balance to verify debits equal credits at the end of the month
6. Prepare the 3 main financial statements for the year ending December 31, 2013.
I'm having trouble with the ledger and the trial balance . |?. A . | ??!??|?Merge & Center . | $ . % , 1:s l Conditional Form at |?? | Insert Dele as Cell Formatting Table Styles Styles Alignment sabled. Enable Content 5 Excel 2013: Fltering Data 7 Date Accounts and Explanation Post Re Debit Credit December 2, 2013 1,300.00 rect Accounts Payable 200 300.00 Correct 10 11 December 2, 2013 Salary Payable 215 100 2,50000 Correct 12 13 14 December 2, 2013 Accounts Receivable 15 16 2,500.00 Correct 110 3,200.00 Correct Service Revenue 3,20000 Correct 17 December 5,2013 Office Equipment 160 200 Correct Accounts Payable 18 19 4,800.00 Correct 20 December 8, 2013 Supplies 120 100 800.00 Correct 800.00 Correct Correct 3,000.00 Correct 23 December 10, 2013 Casth 3,000.00 100 110 Accounts Receivable 1104 26 December 11,2013 Accounts Receivable 4.500.00 Correct 4,500.00 Correct 410 Sales Revenue ! Chart of Accounts Journal Ledger TrialBalance Income Stmt stmt of RE Salance Sheet 4

Explanation / Answer

The ledgers are prepared as below:

____

____

____

____

____

____

____

____

____

____

____

____

____

____

____

____

____

The adjusted trial balance is given as follows:

100-Cash Opening Bal. 339,929 2,500 3,000 800 1,000 250 8,000 2,500 2,500 2,500 850 2,000 5,000 15,000 Bal. $365,029