80.2K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer