90.2K

Verified Solution

Link Copied!

*Prepare a Classified Balance Sheet on the proper worksheet as of 12/31/17. Your Statement should be formatted. You should use formulas in all cells, not constant numbers.

The balance sheet that I have created doesn't balance and am looking for someone to correct whatever mistake I made. I would really appreciate help on this. I have attached the Adjusted Trial Balance and The Balance Sheet I have attempted.

DeeDee Double Entry, Incorporated
End of Period Worksheet
For the Year Ended December 31, 2017
	Unadjusted				Adjusted
Account Title	Trial Balance		Adjustments		Trial Balance
	DR	CR	DR	CR	DR	CR
Cash	240,300	-		27,000	213,300
Restricted Cash			27,000		27,000
Accounts Receivable	925,000	-			925,000
Allowance for Doubtful Accounts	-	49,000	67,000	107,000		89,000
Interest Receivable	-		688		688
Merchandise Inventory	187,500	-	3,700		191,200
Prepaid Insurance	9,000	-		5,211	3,789
Prepaid Advertising	-	-	12,000		12,000
Prepaid Rent	-	-	7,500		7,500
Office Supplies	7,800	-		2,941	4,859
Note Receivable	75,000	-			75,000
Available for Sale Securities	380,000	-		89,000	291,000
Office Building	4,250,000	-			4,250,000
Accumulated Depreciation - Office Building	-	221,500		82,566		304,066
Storage Building	1,650,000	-			1,650,000
Accumulated Depreciation - Storage Building	-	-		48,645		48,645
Land	450,000	-			450,000
Leasehold Improvements	190,000	-	5,459		195,459
Accumulated Depreciation - Leasehold Improvements	-	-		26,061		26,061
Office Equipment	125,000	-			125,000
Accumulated Depreciation - Office Equipment	-	42,000		16,600		58,600
Patent	250,000	-			250,000
Accumulated Amortization				5,208		5,208
Accounts Payable	-	145,000				145,000
Sales Tax Payable	-	-		19,821		19,821
Salaries Payable	-	-		39,249		39,249
Payroll Taxes Payable	-	-		3,251		3,251
Interest Payable	-	-		68,396		68,396
Income Tax Payable	-	-		222,357		222,357
Unearned Rent Revenue	-	96,000	25,263			70,737
Loan Payable - Onstar Bank	-	500,000				500,000
Loan Payable - Coldstar Bank	-	2,250,000				2,250,000
Common Stock	-	425,000				425,000
Additional Paid in Capital	-	2,800,000				2,800,000
Retained Earnings	-	1,379,420				1,379,420
Accumulated Other Comprehensive Income	-	8,500	89,000		80,500
Dividends	280,000	-			280,000
Sales	-	4,380,250	34,821			4,345,429
Sales Returns and Allowances	19,500	-			19,500
Sales Discounts	14,600	-			14,600
Cost of Goods Sold	1,817,900	-		3,700	1,814,200
Amortization Expense			5,208		5,208
Sales Salaries Expense	676,400	-	25,500		701,900
Office Salaries Expense	434,000	-	17,000		451,000
Advertising Expense	54,000	-		12,000	42,000
Depreciation Expense - Office Building	-	-	82,566		82,566
Depreciation Expense - Storage Building			48,645		48,645
Depreciation Expense - Leasehold Improvements	-	-	26,061		26,061
Depreciation Expense - Office Equipment	-	-	16,600		16,600
Leasing Expense - Stores	132,000	-			132,000
Miscellaneous Selling Expense	16,950	-		5,459	11,491
Rent Expense - Storage Facility	18,000	-		7,500	10,500
Insurance Expense	2,000	-	5,211		7,211
Office Supplies Expense	28,500	-	2,941		31,441
Warranty Expense	5,000		5,709		10,709
Miscellaneous Administrative Expense	9,220	-			9,220
Rent Revenue	-	-		25,263		25,263
Interest Revenue on Note Receivable	-	-		688		688
Dividend Revenue on AFS Securities	-	18,000				18,000
Warranty Liability				5,709		5,709
Income Tax Expense			222,357		222,357
Interest Expense			68,396		68,396
Bad Debt Expense	67,000	-	92,000	67,000	92,000
	12,314,670	12,314,670	890,625	890,625	12,849,900	12,849,900

DeeDee Double Entry, Incorporated
Balance Sheet
December 31, 2017
	Assets:
	Current Assets
	Cash		213300
	Restricted Cash		27000
	Accounts Receivable		925000
	Allowance for Doubtful Accounts		89000
	Interest Receivable		688
	Merchandise Inventory		191200
	Prepaid Insurance		3789
	Prepaid Advertising		12000
	Prepaid Rent		7500
	Office Supplies		4859
	Note Receivable		75000
	Available for Sale Securities		291000
	Total Current Assets			1840336
	Property, Plant and Equipment
	Office Building		4250000
	Less: Accumulated Depreciation - Office Building	-304066
	Storage Building		1650000
	Less: Accumulated Depreciation - Storage Building	-48645
	Land		450000
	Leasehold Improvements		195459
	Less: Accumulated Depreciation - Leasehold Improvements	-26061
	Office Equipment		125000
	Less: Accumulated Depreciation - Office Equipment	-58600
	Intangible Assets
	Patent		250000
	Less: Accumulated Amortization	-5208
	Total Fixed Assets			6477879
	Total Assets			8318215
	Liabilities and Stockholders Equity:
	Current Liabilities
	Accounts Payable		145000
	Sales Tax Payable		19821
	Salaries Payable		39249
	Payroll Taxes Payable		3251
	Interest Payable		68396
	Income Tax Payable		222357
	Unearned Rent Revenue		70737
	Total Current Liabilities			568811
	Long Term Liabilities
	Loan Payable - Onstar Bank		500000
	Loan Payable - Coldstar Bank		2250000
	Total Long-Term Liabilities			2750000
	Stockholders Equity
	Common Stock		425000
	Additional Paid in Capital		2800000
	Retained Earnings		1379420
	Accumulated Other Comprehensive Income		80500
	Less: Dividends	-280000
	Total Stockholders Equity			4404920
	Total Liabilities and Stockholders Equity			7723731

Answer & Explanation Solved by verified expert

See Answer