Using the information in your data sheet, you are required toi. use an accounting worksheet to...

Question

Using the information in your data sheet, you are required toi. use an accounting worksheet to analyse transactions and balance-day adjustments for the month’s activities, then record it in an excel worksheet.
ii. By using the analysis archived in your assignment worksheet to prepare financial statements: Income Statement, Balance Sheet, and Classified Statement of Cash Flows.
iii. Provide a short justification (less than 120 words) on the possibility to comprehend financial performance of the proprietor that you analysed.

capture-j0nx0nuc.png data-sheet-real-estate-nlrf1zyi.pdf acc-acf-5903-assignment-qcbwoghe.pdf assignment-worksheet-r2zxnpvu.xlsx

Nitish Lath · Accepted Answer

Assignment worksheet
		BALANCE SHEET													INCOME STATEMENT		NOTES
	DATE	ASSETS								LIABILITIES			EQUITY		INCOME 	EXPENSE
		Cash	Pre-payments	Furniture	Furniture Acc. Dep'n	Vehicles	Vehicle Acc. Dep'n	Supplies	A/Rec	A/Pay	Bank loan	Accrued expenses	Capital	Drawings
	o/balances	$11,674		$23,407		$35,313		$503	$16,961	$7,679	$28,425		$51,754
	01-June	-$408														$408	Motor Vehicle expenses
	01-June	-$2,627	$2,627
	03-June	-$3,724	$3,724
	04-June								$1,442						$1,442		Rental Commission
	05-June	$703													$703		Advertising placement fee
	05-June	-$840												$840
	08-June	-$644						$644
	08-June	$1,994													$1,994		Rental Commission
	09-June	$1,857													$1,857		Auction Commission
	10-June	$1,966							-$1,966
	11-June								$854						$854		Advertising placement fee
	11-June								$758						$758		Auction Commission
	11-June									$1,182						$1,182	Advertising expenses
	12-June	$1,833													$1,833		Auction Commission
	13-June								$896						$896		Auction Commission
	13-June								$1,370						$1,370		Rental Commission
	13-June								$801						$801		Advertising placement fee
	15-June	-$2,517														$2,517	Staff Wages
	17-June	-$1,346								-$1,346
	19-June	$775													$775		Advertising placement fee
	20-June	-$283														$283	Sundry expenses
	22-June	$1,563							-$1,

Using the information in your data sheet, you are required toi. use an accounting worksheet to analyse transactions and balance-day adjustments for the month’s activities, then record it in an excel...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment