Career Portfolio Assignment:Financial Statements

Instructions

The following is a sample trial balance for the A & E Management Consulting firm. Refer to the information presented in this trial balance to complete the spreadsheet file attached. You must use formulas for calculations. Upload your completed spreadsheet consisting of a Trial Balance, Income Statement and Balance Sheet using appropriate columnar formatting) to the drop box.

(The sample trial is below)

A & E Management Consulting

Adjusted Trial Balance

June 30, 20--

	ACCOUNT NAME	DEBIT	CREDIT
	Cash	16,170.00
	Accounts Receivable	1,264.00
	Prepaid Insurance	850.00
	Spa Equipment	7,393.00
	Accumulated Depreciation, Spa Equipment		64.88
	Office Equipment	1,150.00
	Accumulated Depreciation, Office Equipment		60.00
	Accounts Payable		3,248.00
	Wages Payable		369.50
	A. Valli, Capital		18,158.00
	A. Valli, Drawing	1,850.50
	Income from Services		18,347.00
	Wages Expense	7,759.00
	Rent Expense	1,650.00
	Office Supplies Expense	368.00
	Spa Supplies Expense	492.00
	Laundry Expense	84.00
	Advertising Expense	397.00
	Utilities Expense	473.00
	Insurance Expense	160.00
	Depreciation Expense, Spa Equipment	64.88
	Depreciation Expense, Office Equipment	10.00
	Miscellaneous Expense	112.00
		??????	??????