Doing some accounting home work and got stuck on the remainder questions

Webster Consulting experienced the following transactions for 2012, its first year of operations, and 2013.Assume that all transactions involve the receipt or payment of cash.

Transactions for 2012

1.	Acquired $55,000 by issuing common stock.
2.	Received $130,000 cash for providing services to customers.
3.	Borrowed $22,000 cash from creditors.
4.	Paid expenses amounting to $59,000.
5.	Purchased land for $40,000 cash.

Transactions for 2013

Beginning account balances for 2013 are:

Cash	$108,000
Land	40,000
Notes payable	22,000
Common stock	55,000
Retained earnings	71,000

1.	Acquired an additional $20,000 from the issue of common stock.
2.	Received $131,000 for providing services.
3.	Paid $17,000 to creditors to reduce loan.
4.	Paid expenses amounting to $66,000.
5.	Paid a $11,500 dividend to the stockholders.
6.	Determined that the market value of the land is $50,000.

Required:

(a)

Record the effects of each accounting event under the appropriate headings for each year. Record the amounts of revenue, expense, and dividends in the Retained Earnings column. Provide appropriate titles for these accounts in the last column of the table. (Leave no cells blank - be certain to select "0" and "NA" wherever required. Negative amounts and amounts to be deducted should be indicated with minus sign. Omit the "$" sign in your response.)

Webster Consulting Accounting Equation for 2012
		Assets			=	Liabilities	+	Stockholders' Equity
	Event	Cash	+	Land	=	Notes Payable	+	Common Stock	+	Retained Earnings	Acct Title/RE
1.	Issued stk	(Click to select)NA-55,000+55,000		(Click to select)NA+55,000-55,000		(Click to select)-55,000NA+55,000		(Click to select)NA-55,000+55,000		(Click to select)NA+55,000-55,000	(Click to select)NAExpenseService revenueDividends
2.	Revenue	(Click to select)NA-130,000+130,000		(Click to select)NA-130,000+130,000		(Click to select)-130,000NA+130,000		(Click to select)-130,000+130,000NA		(Click to select)+130,000-130,000NA	(Click to select)DividendsExpenseNAService revenue
3.	Loan	(Click to select)-22,000NA+22,000		(Click to select)+22,000-22,000NA		(Click to select)+22,000NA-22,000		(Click to select)-22,000+22,000NA		(Click to select)NA+22,000-22,000	(Click to select)DividendsService revenueNAExpense
4.	Paid Exp.	(Click to select)NA+59,000-59,000		(Click to select)+59,000-59,000NA		(Click to select)+59,000-59,000NA		(Click to select)-59,000+59,000NA		(Click to select)+59,000NA-59,000	(Click to select)DividendsService revenueNAExpense
5.	Pur. Land	(Click to select)NA+40,000-40,000		(Click to select)-40,000NA+40,000		(Click to select)+40,000NA-40,000		(Click to select)+40,000-40,000NA		(Click to select)+40,000NA-40,000	(Click to select)Service revenueNAExpenseDividends
	Totals	(Click to select)0-108,000+108,000	+	(Click to select)0+40,000-40,000	=	(Click to select)0+22,000-22,000	+	(Click to select)+55,0000-55,000	+	(Click to select)+71,000-71,0000

Webster Consulting Accounting Equation for 2013
		Assets			=	Liabilities	+	Stockholders' Equity
	Event	Cash	+	Land	=	Notes Payable	+	Common Stock	+	Retained Earnings	Acct. Title/RE
	Beg. Bal.	(Click to select)NA+108,000-108,000		(Click to select)-40,000+40,000NA		(Click to select)NA-22,000+22,000		(Click to select)+55,000-55,000NA		(Click to select)-71,000+71,000NA
1.	Issued stock	(Click to select)NA+20,000-20,000		(Click to select)-20,000+20,000NA		(Click to select)NA+20,000-20,000		(Click to select)-20,000NA+20,000		(Click to select)NA-20,000+20,000	(Click to select)DividendsNAExpenseService revenue
2.	Revenue	(Click to select)-131,000NA+131,000		(Click to select)-131,000+131,000NA		(Click to select)NA-131,000+131,000		(Click to select)-131,000+131,000NA		(Click to select)-131,000NA+131,000	(Click to select)DividendsNAExpenseService revenue
3.	Paid Loan	(Click to select)NA-17,000+17,000		(Click to select)-17,000+17,000NA		(Click to select)+17,000NA-17,000		(Click to select)-17,000NA+17,000		(Click to select)-17,000+17,000NA	(Click to select)ExpenseService revenueDividendsNA
4.	Paid Exp.	(Click to select)NA+66,000-66,000		(Click to select)+66,000-66,000NA		(Click to select)NA+66,000-66,000		(Click to select)+66,000NA-66,000		(Click to select)+66,000NA-66,000	(Click to select)Service revenueDividendsExpenseNA
5.	Paid Div.	(Click to select)+11,500-11,500NA		(Click to select)-11,500NA+11,500		(Click to select)+11,500NA-11,500		(Click to select)+11,500-11,500NA		(Click to select)NA-11,500+11,500	(Click to select)NADividendsService revenueExpense
6.	Land Val.	(Click to select)-50,000NA+50,000		(Click to select)-50,000NA+50,000		(Click to select)NA+50,000-50,000		(Click to select)NA+50,000-50,000		(Click to select)+50,000-50,000NA	(Click to select)Service revenueExpenseDividendsNA
	Totals	(Click to select)-164,5000+164,500	+	(Click to select)-40,0000+40,000	=	(Click to select)+5,0000-5,000	+	(Click to select)-75,0000+75,000	+	(Click to select)-124,5000+124,500

(b-1)

Prepare an income statement, statement of changes in stockholders' equity, year-end balance sheet, and statement of cash flows for the year 2012. (Amounts to be deducted should be indicated with minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)

Webster Consulting Income Statement For the Period Ended December 31, 2012
Service Revenue	$
Expenses
(Click to select)Net incomeNet loss	$

Webster Consulting Statement of Changes in Stockholders' Equity For the Period Ended December 31, 2012
(Click to select)Beginning common stockDividendsService revenueOffice expensesCommon stock issued	$
(Click to select)Service revenueEnding common stockAdd: Common stock issuedBeginning common stockLess: Common stock issued
(Click to select)Ending common stockNotes payableCommon stock issuedDividendsService revenue		$
(Click to select)CashService revenueExpensesDividendsBeginning retained earnings	$
(Click to select)Cash payment for landRetained earningsLess: Net lossCash payment on debtAdd: Net income
(Click to select)Notes payableExpensesDividendsService revenueEnding retained earnings
Total Stockholders' Equity		$

Webster Consulting Balance Sheet As of December 31, 2012
Assets
(Click to select)Notes payableInventoriesCashPrepaid expensesInvestments	$
(Click to select)Prepaid expensesInvestmentsLandInventoriesAccounts payable
Total Assets		$
Liabilities
(Click to select)Accrued expensesLong-term debtNotes payableTaxes owedAccounts payable		$
Stockholders' Equity
(Click to select)Treasury stockPreferred stockPaid-in capitalCommon stockEquity-fund balance	$
(Click to select)Cash payment for landNet incomeDividendsRetained earningsCash payment on debt
Total Stockholders' Equity
Total Liabilities and Stockholders' Equity		$

Webster Consulting Statement of Cash Flows For the Year Ended December 31, 2012
Cash Flows From Operating Activities:
(Click to select)Net decrease in cashCash payment on debtCash payments for expensesCash receipts from customersNet increase in cash	$
(Click to select)Net decrease in cashCash receipts from customersNet increase in cashCash payments for expensesCash payment on debt
Net Cash Flow From Operating Activities		$
Cash Flows From Investing Activities:
(Click to select)Cash receipts from customersCash payment for landCash payments for expensesCash receipts from borrowed fundsCash receipts from stock issue	$
Net Cash Flow from Investing Activities
Cash Flows From Financing Activities:
(Click to select)Cash payments for expensesCash receipts from stock issueCash receipts from customersCash receipts from borrowingCash payment for land	$
(Click to select)Cash receipts from customersCash payment for landCash receipts from stock issueCash payments for expensesCash receipts from borrowing
Net Cash Flow from Financing Activities
(Click to select)Net increase in cashAdd: Beginning cash balanceLess: Beginning cash balanceNet incomeNet decrease in cash
(Click to select)Net decrease in cashNet increase in cashNet incomeAdd: Beginning cash balanceLess: Beginning cash balance
Ending Cash Balance		$

(b-2)

Prepare an income statement, statement of changes in stockholders' equity, year-end balance sheet, and statement of cash flows for the year 2013. (Amounts to be deducted should be indicated with minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)

Webster Consulting Income Statement For the Period Ended December 31, 2013
Service Revenue	$
Expenses
(Click to select)Net lossNet income	$

Webster Consulting Statement of Changes in Stockholders' Equity For the Period Ended December 31, 2013
(Click to select)Office expensesBeginning common stockDividendsCommon stock issuedService revenue	$
(Click to select)Beginning common stockAdd: Common stock issuedEnding common stockLess: Common stock issuedService revenue
(Click to select)Service revenueNotes payableDividendsEnding common stockCommon stock issued		$
(Click to select)ExpensesCashDividendsBeginning retained earningsService revenue
(Click to select)Less: Net lossRetained earningsAdd: Net incomeCash payment on debtCash payment for land
(Click to select)Cash payment on debtCash payment for landLess: DividendsRetained earningsAdd: Dividends
(Click to select)Ending retained earningsDividendsService revenueNotes payableExpenses
Total Stockholders' Equity		$

Webster Consulting Balance Sheet As of December 31, 2013
Assets
(Click to select)InventoriesInvestmentsPrepaid expensesAccounts payableCash	$
(Click to select)InvestmentsInventoriesAccounts payableLandPrepaid expenses
Total Assets		$
Liabilities
(Click to select)Taxes owedNotes payableAccrued expensesLandLong-term debt		$
Stockholders' Equity
(Click to select)Preferred stockTreasury stockCommon stockEquity-fund balancePaid-in capital	$
(Click to select)Retained earningsCash payment for landNet incomeCash payment on debtDividends
Total Stockholders' Equity
Total Liabilities and Stockholders' Equity		$

Webster Consulting Statement of Cash Flows For the Year Ended December 31, 2013
Cash Flows From Operating Activities:
(Click to select)Cash payments for expensesCash receipts from customersNet increase in cashNet decrease in cashCash payment on debt	$
(Click to select)Cash payments for expensesNet decrease in cashCash payment on debtCash receipts from customersNet increase in cash
Net Cash Flow from Operating Activities		$
Cash Flows From Investing Activities
Cash Flows From Financing Activities:
(Click to select)Cash receipts from stock issueCash payments for expensesCash payment for dividendsCash payment on debtCash receipts from customers
(Click to select)Cash payment for dividendsCash receipts from customersCash receipts from stock issueCash payments for expensesCash payment on debt
(Click to select)Cash payments for expensesCash payment for dividendsCash receipts from customersCash payment on debtCash receipts from stock issue
Net Cash Flow from Financing Activities
(Click to select)Add: Beginning cash balanceNet incomeNet increase in cashLess: Beginning cash balanceNet decrease in cash
(Click to select)Net incomeAdd: Beginning cash balanceNet increase in cashLess: Beginning cash balanceNet decrease in cash
Ending Cash Balance		$

(c)

Determine the amount of cash that is in the retained earnings account at the end of 2012 and 2013.

	2012: $71000, 2013: $124500
	2012: $108000, 2013: $164500
	Retained earnings cannot be traced to cash.