I am in a accounting class a was given the following information: I need to impute the data on a income statement and a balance sheet which I did but I feel like I'm missing something. Please review my attached excel and let me know what the mistakes are.

Nybrostrand Company
31-Dec-14
Trial Balance (accounts in alphabetical order)
	Debit	Credit
Accounts payable		$ 78,000
Accounts receivable	$ 36,500
Cash	30,000
Common stock		10,000
Depreciation expense	24,350
Cost of goods sold	307,000
Equipment (net of depreciation)	415,000
Insurance	1,400
Inventory	34,000
Long-term debt		127,000
Marketing	4,500
Paid-in capital		50,000
Property taxes	16,900
Rent	28,000
Retained earnings		?
Revenues		586,000
Salaries	78,500
Utilities	6,700
Total	982,850	982,850

Category Accounts payable Accounts receivable Cash Common stock Depreciation expense Cost of goods sold Equipment (net of depreciation) Insurance Inventory Long-term debt Marketing Paid-in capital Property taxes Rent Retained earnings Revenues Salaries Utilities Total Retained earnings Gross Profit Gross Profit Margin Expenses Net Profit Debit $0 ($36,500) ($30,000) $0 ($24,350) ($307,000) ($415,000) ($1,400) ($34,000) $0 ($4,500) $0 ($16,900) ($28,000) Credit $78,000 $0 $0 $10,000 $0 $0 $0 $0 $0 $127,000 $0 $50,000 $0 $0 Notes Balance Sheet Liabilites Balance Sheet Assets Balance Sheet Assets Balance Sheet Equity Income Statement Debit Income Statement Debit ???? IDK is this goes under into the income statement Income Statement Debit Balance Sheet Assets Balance Sheet Liabilites Income Statement Debit Balance Sheet Equity Income Statement Debit Income Statement Debit Balance Sheet Equity, Retained earning is found by previous sum (851, 000) diferance of 982,850 for balace $0 $586,000 Income Statement Cedit ($78,500) $0 Income Statement Debit ($6,700) $0 Income Statement Debit ($982,850) $982,850 Previous Totals used find missing Value in Retained earnings Answer found Balance Sheet Equity, Retained earning is found by previous sum (851, 000) diferance of 982,850 for balace Gross Profit =Sales - Cost of Goods Sold Gross Profit Margin = Revenue divided by Cost og Goods Expenses= Operating expenses: Salaries, rent, utilites, depreciation Net Profit = Revenue - Cost of Goods Sold - Expenses $0 $131,850 Nybrostrand Company Income Statement For the year ended December 31, 2014 Account Debit Credit Revenue (Sales) $0 $586,000.00 Cost of goods sold ($307,000) $0 Gross Profit $279,000 Gross Profit Margin 47.61% Expenses ($575,350) $0 Marketing ($4,500) $0 Depreciation Expense ($24,350) $0 Equipment Depreciation ($415,000) Insurance ($1,400) $0 Property taxes ($16,900) $0 Rent ($28,000) $0 Salaries ($78,500) $0 Utilities ($6,700) $0 Net Profit $1,468,350 Nybrostrand Company Balance Sheet As of December 31, 2014 Assets Liabilities Current Assets Current Liabilities Cash ($30,000) Accounts payable Accounts Receivable ($36,500) Inventory ($34,000) Long Term Liabilities Long-term debt Fixed Assets Total Liabilities Equipment $0 Owners' Equity Land $0 Retained earnings Common Stock Paid-in capital Total Equity Total Assets ($100,500) Total Liabilities and Equity $78,000 $127,000 $205,000 $131,850 $10,000 $50,000 $191,850 $296,350