Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

*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

*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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions