i need help getting my balance sheet to balance
Book7 Page Layout Formulas View Data Review = = EEEE ") 12 A A Dra. Ar General $ -% 9 6 00 Copyright K L M XYZ Company Balance Sheet As of Dec. 31, 2018 10000 12000 15000 25000 24000 12000 98000 100000 50000 50000 200000 Assets Current Assets: Cash Short-Term Marketable Securities Accounts Receivables Inventory Prepaid Rent Prepaid Insurance Total Current Assets Investments: Land Held for Future Use Long-Term Marketable Securities Debt Servie Fund Total Investments Property. Plant, Equipment Land in Use Buildings Machinery and Equipment Accumulated Depreciation-Buildings Accumulated Depreciation Machinery and Equipment Copper Mine Accumulated Depletion-Copper Mine Total Property, Plant, & Equipment Intangibles Copyright Franchise Trademark Patent Total Intangibles Other Assets Long-Term Deferred Asset Long-Term Pension Assets Total Other Assets Total Assets 120000 700000 250000 -200000 -50000 300000 -25000 1045000 30000 25000 10000 75000 140000 60000 100000 160000 1642000 DR CR Cash 10000 Accounts Receivable 15000 Short-Term Marketable Securities 12000 Inventory 25000 Prepaid Rent 24000 Prepaid Insurance 12000 Long-Term Marketable Securities 50000 Land Held for Future Use 100000 Debt Service Fund 50000 Land in Use 120000 Buildings 700000 Accumulated Depreciation - Buildings 200000 Machinery and Equipment 1250000 Accumulated Depreciation - Mach and Equip 50000 Copper Mine 300000 Accumulated Depletion - Copper Mine 75000 Franchise 25000 Copyright 30000 Trademark 10000 Patent 750001 Long-term Deferred Tax Asset 600001 Long-term Pension Asset 1000001 Accounts Payable 17000 Income Taxes Payable 63000 Note Payable (due in 6 months) 50000 Interest Payable 25000 Mortgage Payable (1/20 due this year) 400000 Note Payable (due in 2 years) 150000 Common Stock 100000 Paid-in Capital in Excess of Par-Common 300000 Preferred Stock 50000 Paid in Capital in Excess of Par - Preferred 100000 Retained Earnings 200000 Other Accumulated Comprehensive Income 25000 Treasury Stock 10000 Sales Revenue 778000 Sales Discounts 5000l Sales Expenses 150000 General Administrative Expenses 250000 Cost of Goods Sold 200000 Interest Revenue Dividend Revenue 15000 interest Expense 22000 Gain on Sale of Equipment 7000 Loss on Sale of investments S000 Discontinued Operations (net of tax) 15000 Totals 2625000 2625000 17000 63000 25000 36600 250000 50000 400000 841600 Liabilities and Shareholders' Equity Current Liabilities: Accounts Payable Income Tax Payable Interest Payable Income Taxes Expense General Administrative Expenses Note Payable (due in 6 months) Mortgage Paybale (1/20 due this year) Total Current Liabilities Shareholders' Equity Common Stock Preferred Stock Paid-in Capital in Excess of Par-Common Paid-in Capital in Excess of Par-Preferred Treasury Stock Retained Earings Other Accumulated Comprhensive Income Total Shareholders' Equity Total Liabilities and Shareholders' Equity 100000 50000 300000 100000 -10000 331400 10000 881400 1723000 XYZ Compnay Income Statement For Year Ending Dec. 31, 2018 778000 200000 578000 150000 250000 400000 178000 Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: Sales Expenses General Administrative Expenses Total operating expenses Operating Income Other income (expense): Interest Revenue Gain on Saleng Equipment Interest Expenses Total other income, net Income before income taxes Income tax expenses Net Income 20000 7000 -22000 5000 183000 36600 146400 XYZ Company Statement of Retained Earnings For Year Ended Dec. 31, 2018 Retained Earnings Plus: Net Income Less: Dividends Ending Retained Earnings 200000 146400 - 15000 331400 Book7 Page Layout Formulas View Data Review = = EEEE ") 12 A A Dra. Ar General $ -% 9 6 00 Copyright K L M XYZ Company Balance Sheet As of Dec. 31, 2018 10000 12000 15000 25000 24000 12000 98000 100000 50000 50000 200000 Assets Current Assets: Cash Short-Term Marketable Securities Accounts Receivables Inventory Prepaid Rent Prepaid Insurance Total Current Assets Investments: Land Held for Future Use Long-Term Marketable Securities Debt Servie Fund Total Investments Property. Plant, Equipment Land in Use Buildings Machinery and Equipment Accumulated Depreciation-Buildings Accumulated Depreciation Machinery and Equipment Copper Mine Accumulated Depletion-Copper Mine Total Property, Plant, & Equipment Intangibles Copyright Franchise Trademark Patent Total Intangibles Other Assets Long-Term Deferred Asset Long-Term Pension Assets Total Other Assets Total Assets 120000 700000 250000 -200000 -50000 300000 -25000 1045000 30000 25000 10000 75000 140000 60000 100000 160000 1642000 DR CR Cash 10000 Accounts Receivable 15000 Short-Term Marketable Securities 12000 Inventory 25000 Prepaid Rent 24000 Prepaid Insurance 12000 Long-Term Marketable Securities 50000 Land Held for Future Use 100000 Debt Service Fund 50000 Land in Use 120000 Buildings 700000 Accumulated Depreciation - Buildings 200000 Machinery and Equipment 1250000 Accumulated Depreciation - Mach and Equip 50000 Copper Mine 300000 Accumulated Depletion - Copper Mine 75000 Franchise 25000 Copyright 30000 Trademark 10000 Patent 750001 Long-term Deferred Tax Asset 600001 Long-term Pension Asset 1000001 Accounts Payable 17000 Income Taxes Payable 63000 Note Payable (due in 6 months) 50000 Interest Payable 25000 Mortgage Payable (1/20 due this year) 400000 Note Payable (due in 2 years) 150000 Common Stock 100000 Paid-in Capital in Excess of Par-Common 300000 Preferred Stock 50000 Paid in Capital in Excess of Par - Preferred 100000 Retained Earnings 200000 Other Accumulated Comprehensive Income 25000 Treasury Stock 10000 Sales Revenue 778000 Sales Discounts 5000l Sales Expenses 150000 General Administrative Expenses 250000 Cost of Goods Sold 200000 Interest Revenue Dividend Revenue 15000 interest Expense 22000 Gain on Sale of Equipment 7000 Loss on Sale of investments S000 Discontinued Operations (net of tax) 15000 Totals 2625000 2625000 17000 63000 25000 36600 250000 50000 400000 841600 Liabilities and Shareholders' Equity Current Liabilities: Accounts Payable Income Tax Payable Interest Payable Income Taxes Expense General Administrative Expenses Note Payable (due in 6 months) Mortgage Paybale (1/20 due this year) Total Current Liabilities Shareholders' Equity Common Stock Preferred Stock Paid-in Capital in Excess of Par-Common Paid-in Capital in Excess of Par-Preferred Treasury Stock Retained Earings Other Accumulated Comprhensive Income Total Shareholders' Equity Total Liabilities and Shareholders' Equity 100000 50000 300000 100000 -10000 331400 10000 881400 1723000 XYZ Compnay Income Statement For Year Ending Dec. 31, 2018 778000 200000 578000 150000 250000 400000 178000 Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: Sales Expenses General Administrative Expenses Total operating expenses Operating Income Other income (expense): Interest Revenue Gain on Saleng Equipment Interest Expenses Total other income, net Income before income taxes Income tax expenses Net Income 20000 7000 -22000 5000 183000 36600 146400 XYZ Company Statement of Retained Earnings For Year Ended Dec. 31, 2018 Retained Earnings Plus: Net Income Less: Dividends Ending Retained Earnings 200000 146400 - 15000 331400
