Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SWARS Consulting & Sales and Sales Inc PARTIALLY ADJUSTED TRIAL BALANCE March 31 2018 Adjusting Part Adj T/B March Jes Trial Balance & Bank Rec

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

SWARS Consulting & Sales and Sales Inc

PARTIALLY ADJUSTED TRIAL BALANCE

March 31 2018

Adjusting

Part Adj T/B

March Jes

Trial

Balance

& Bank Rec

Jes

Adusted TB

DR

CR

DR

CR

DR

CR

DR

CR

DR

CR

Cash

$ 253,560.00

$ 9,405.00

Accounts Receivable

$ 146,800.00

$12,100.00

$12,150.00

Allowance for Uncollectible Accounts

$ 2,569.00

$ 2,650.00

$

Supplies

$ 85,650.00

$

Inventory

$ 2,600.00

$ 4,800.00

$ 6,000.00

$

Prepaid Insurance

$ 16,800.00

$

Land

$ 50,000.00

$

Building

$ 125,500.00

Accumulated Depr Building

$ 5,670.00

$

Computer equipment

$ 52,950.00

$

Accumulated Depr Comp Equip

$ 1,750.00

$

Office Furniture

$ 85,960.00

$

Accumulated Depr - Office Furniture

$ 890.00

$

Accounts Payable

$ 48,526.00

$ 4,800.00

$ 54.00

$

Interest Payable

$ 3,200.00

$

Utilities Payable

$ 8,952.00

$

Wages Payable

$ 98,505.00

Long term Note Payable

$ 90,000.00

Mortgage Payable

$ 60,000.00

Common Stock

$ 400,000.00

Retained Earnings

$ 106,468.00

$

Dividends

$ 4,000.00

Service Revenue

$ 345,650.00

Tablet Sales Revenue

$ 210,250.00

$12,100.00

$

Cost of Goods Sold

$ 165,850.00

$ 6,000.00

Bad Debt Expense

Depreciation Expense Building

$ 1,350.00

Depreciation Expense - Computer Equip

$ 890.00

Depreciation Expense - Office Furn

$ 650.00

Interest Expense

$ 3,560.00

Insurance Expense

$ 38,950.00

Supplies expense

$ 72,860.00

Bank fee (expense)

$ 95.00

Utilities Expense

$ 75,900.00

Wage Expense

$ 198,600.00

TOTALS

$1,382,430.00

$1,382,430.00

$22,900.00

$22,900.00

$ 12,150.00

$12,204.00

811 10 Submission 3 -due Saturday June 30 before 5pm -You must submit your Adjusting Journal Entries, the worksheet with the Trial Balance, adjusting journal entries and Bank Reconciliation entries, and Adjusted Trial Balance Columns completed, and the Multistep Income Statement completed, the Bank Reconciliation, worksheet and the financial statements formulas tabs completed. The entire excel file must be submitted to the correct assignments link on the class Canvas site. Your file must be named correctly "Your name (first and last) Project 2 part 3. Failure to name your file correctly will result in a 1 point deduction

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

Financial Accounting The Impact On Decision Makers An Alternative To Debits And Credits

Authors: Gary A. Porter, Curtis L. Norton

4th Edition

0324272669, 978-0324272666

More Books

Students also viewed these Accounting questions

Question

Explain the experimental method as used by clinical psychologists.

Answered: 1 week ago