<

Davenport University: ACCT202 Project - Part II

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: $35,000; Inventory: $836,000; Office Supplies: $5,000; A/P: $924,200. 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.

work sheet

<

	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

<

Auto Zone
Income Statement
Revenues:
Sales		1,067,500
Cost of Goods Sold		641,700
Gross Profit		425,800
Operating Expenses:
Wage Expense (hourly workers)	10,000
Salaries Expense (Exempt Staff)	32,100
Marketing Expense	64,000
Travel and Entertainment Expense	1,250
Bad Debt Expense	2,415
Property Tax Expense	1,455
Office Maintenance & Repair Expense	0
Legal Expenses	6,340
Insurance Expense	3,500
Utilities Expense	2,000
Office Supplies Expense	735
Telecommunications Expense	754
Depreciation Expense - Equip & Furniture - Warehouse	775
Depreciation Expense - Equip & Furniture - Office	825	126,149
Operating Income		299,651
Other Income (Expenses):
Rent Revenue	2,143
Interest Expense	-12,220	-10,077
Net Income		289,574

<

Auto Zone
Statement of Retained Earnings
Retained Earnings, beginning	20,500
Add: Net Income	289,574
Total	310,074
Less: Dividends	0
Retained Earnings, ending	310,074

<

Auto Zone
Balance Sheet
ASSETS
Current Assets:
Cash		250,000
Accounts Receivable	280,000
Allowance for Doubtful Accounts	-14,915	265,085
Merchandise Inventory		740,000
Office Supplies		1,565
Prepaid Insurance		3,500
Total Current Assets			1,260,150
Property, Plant and Equipments:
Land		1,628,803
Building	1,000,000
Accumulated Depreciation - Building	-700,000	300,000
Equipment & Furniture - Warehouse	7,900
Accumulated Depreciation - Equip & Furn. - Warehouse	-6,418	1,482
Equipment & Furniture - Office	7,421
Accumulated Depreciation - Equip & Furn. - Office	-2,825	4,596
Total Property, Plant and Equipments			1,934,881
Total Assets			3,195,031
Liabilities and Stockholders' Equity
Liabilities
Current Liabilities:
Accounts Payable		800,000
Interest Payable		2,500
Unearned Rent		5,257
Total Current Liabilities			807,757
Long Term Liabilities:
Notes Payable		200,000
Bonds Payable		90,000
Mortgage (Warehouse) Payable		197,000
Total Long Term Liabilities			487,000
Total Liabilities			1,294,757
Stockholders' Equity
Common Stock		30,200
Paid In Capital in Excess of Par		1,560,000
Total Paid In Capital		1,590,200
Retained Earnings		310,074
Total Paid In Capital and Retained Earnings		1,900,274
Less: Treasury Stock		0
Total Stockholders' Equity			1,900,274
Total Liabilities and Stockholders' Equity			3,195,031

whats the cash flow table