50.1K

Verified Solution

Link Copied!

Part II

Worksheet Completion & Financial Statement Creation

a. Within this workbook there is a workbook labeled "Worksheet". The unadjusted trial balance information, as well as the adjustment data, have already been entered into the worksheet. You need to complete the worksheet in its entirety.

b. After you've completed the worksheet from requirement "a" you need to create a Multi-Step Income Statement, Statement of Retained Earnings, Classified Balance Sheet and Statement of Cash Flows. These financial statements are being prepared for the fiscal month ending May 31st. Additional information folows:

-For the Statement of Retained Earnings, assume a beginning balance in the Retained Earnings account of $366,000. Also assume that $345,500 of dividends were declared.

-For the Classified Balance Sheet, assume that the company only has common stock and that the value of common stock at par value equals $30,200. Further assume that the value of paid-in-capital excess of par on the common stock has a value of $1,560,000.

-For the Statement of Cash Flow assume that the company purchased equipment with $200,000 cash. The company sold land and received $429,000 in cash. Also assume the following ending balances from the last financial period: Cash: $345,091; A/R: $525,000; Inventory: $836,000; Office Supplies: $5,000; A/P: $675,800. Additionally, the company paid cash dividends during the period of $345,500. Create the Statement of Cash Flow using the Indirect Method.

-There are blank workbook forms for each of your financial statements. Build your financial statements within these workbook spaces.

	Unadjusted				Adjusted		Income		Bal. Sheet
	Trial Balance		Adjustments		Trial Balance		Statement		Stmt. Own. Equity
Account Title	Dr.	Cr.	Dr.	Cr.	Dr.	Cr.	Dr.	Cr.	Dr.	Cr.
Cash	250,000				250,000				250,000
Accounts Receivable	280,000				280,000				280,000
Allowance for Doubtful Accounts		12,500		2,415		14,915				14,915
Merchandise Inventory	745,000			5,000	740,000				740,000
Office Supplies	2,300			735	1,565				1,565
Prepaid Insurance	7,000			3,500	3,500				3,500
Land	1,628,803				1,628,803				1,628,803
Building	1,000,000				1,000,000				1,000,000
Accumulated Depreciation - Building		700,000				700,000				700,000
Equipment & Furniture - Warehouse	7,900				7,900				7,900
Accumulated Depreciation - Equip & Furn. - Warehouse		5,643		775		6,418				6,418
Equipment & Furniture - Office	7,421				7,421				7,421
Accumulated Depreciation - Equip & Furn. - Office		2,000		825		2,825				2,825
Accounts Payable		800,000				800,000				800,000
Wages Payable		0				0				0
Interest Payable		2,500				2,500				2,500
Dividends Payable		0				0				0
Unearned Rent		7,400	2,143			5,257				5,257
Notes Payable		200,000				200,000				200,000
Bonds Payable		90,000				90,000				90,000
Mortgage (Warehouse) Payable		197,000				197,000				197,000
Common Stock, $1 Par, 100,000 Authorized; 60,000 shares Issued/Outstanding		30,200				30,200				30,200
Paid In Capital - Excess of Par		1,560,000				1,560,000				1,560,000
Retained Earnings		20,500				20,500				20,500
Treasury Stock		0			0				0
Sales		1,067,500				1,067,500		1,067,500
Cost of Goods Sold	636,700		5,000		641,700		641,700
Wage Expense (hourly workers)	10,000				10,000		10,000
Salaries Expense (Exempt Staff)	32,100				32,100		32,100
Marketing Expense	64,000				64,000		64,000
Travel and Entertainment Expense	1,250				1,250		1,250
Bad Debt Expense	0		2,415		2,415		2,415
Property Tax Expense	1,455				1,455		1,455
Office Maintenance & Repair Expense	0				0		0
Legal Expenses	6,340				6,340		6,340
Insurance Expense	0		3,500		3,500		3,500
Utilities Expense	2,000				2,000		2,000
Office Supplies Expense	0		735		735		735
Telecommunications Expense	754				754		754
Depreciation Expense - Equip & Furniture - Warehouse	0		775		775		775
Depreciation Expense - Equip & Furniture - Office	0		825		825		825
Rent Income		0		2,143		2,143		2,143
Interest Expense	12,220				12,220		12,220
Total	4,695,243	4,695,243	15,393	15,393	4,699,258	4,699,258	780,069	1,069,643	3,919,189	3,629,615
							289,574			289,574
Net Income (Loss)							1,069,643	1,069,643	3,919,189	3,919,189

Answer & Explanation Solved by verified expert

See Answer