Excel Problem: Post-Closing Trial Balance
Name:
Using cell addresses, properly place each account's balance in either the debit
column or the credit column, assuming each account has a normal balance.
Input a simple formula to determine the credit balance of "Account X" that
will correctly complete the trial balance.
Use the SUM function to produce the total for each column.
Submit in Black Board
I. DATA
	Account	Balance		Account	Balance
	Cash	2,200		Prepaid Rent	400
	Accounts Receivable	900		Notes Payable	250
	Accounts Payable	480		Retained Earnings	660
	Equipment	700		Common Stock	600
	Unearned Revenue	65		Account X
	Accumulated Depreciation	190
II. Post-Closing Trial Balance
		Debit	Credit
	Cash
	Accounts Receivable
	Prepaid Rent
	Equipment
	Accumulated Depreciation
	Unearned Revenue
	Accounts Payable
	Notes Payable
	Retained Earnings
	Common Stock
	Account X
	TOTALS: