Welch's Company
Working Trial Balance
12-31-2016
			12-31-15	12-31-16
101	Cash-Big City National Bank		339,415.00	420,678.00
105	Accounts receivable		124,021.00	235,380.00
106	Allowance for bad debts		(10,485.00)	(4,800.00)
109	Inventory		777,152.00	600,580.00
210	Land		82,250.00	82,250.00
220	Buildings		276,263.00	276,263.00
221	Accum. depn.- buildings		(65,416.00)	(74,625.00)
230	Machinery and equipment		540,845.00	737,045.00
231	Accum. depn.- mach.& equip.		(160,866.00)	(185,939.00)
240	Automotive equipment		99,425.00	118,925.00
241	Accum. depn.- auto. equip.		(52,798.00)	(81,892.00)
250	Office furniture & fixtures		106,433.00	113,233.00
251	Accum. depn.- off. furn.& fix.		(37,581.00)	(43,073.00)
301	Accounts payable		223,161.00	176,790.00
305	Accrued interest		10,625.00	8,750.00
306	Dividends payable		15,725.00	15,725.00
307	Federal income tax payable		23,023.00	25,000.00
308	Notes payable-short term		125,000.00
401	Notes payable-long term			150,000.00
501	Common stock		925,000.00	925,000.00
505	Other contributed capital		95,979.00	95,979.00
601	Retained earnings		429,855.00	600,145.00
605	Dividends		(15,725.00)	(15,725.00)
610	Current net income		186,015.00	212,361.00
701	Sales		3,447,472.00	3,857,549.00
703	Sales Returns & Allowances		(26,530.00)	(28,318.00)
801	Cost of Goods Sold		1,420,933.00	1,651,366.00
820	Wage and Salary Expense		1,418,720.00	1,487,700.00
821	Payroll Tax Expense		99,310.00	105,924.00
822	Depreciation Expense		64,422.00	76,368.00
823	Rent Expense		3,750.00	3,750.00
824	Office Supplies Expense		8,615.00	10,825.00
825	Small Tools Expense		2,988.00	5,650.00
826	Advertising Expense		6,313.00	7,980.00
827	Insurance		15,737.00	22,415.00
828	Repairs and Maintenance		17,869.00	16,222.00
829	Property Tax		13,463.00	17,100.00
830	Utilities		10,670.00	14,325.00
831	Professional Fees		26,875.00	35,875.00
832	Miscellaneous Expense		302.00	1,771.00
833	Provision for Bad Debts		9,925.00	8,650.00
834	Freight Expense		28,150.00	32,386.00
901	Interest Expense		(27,500.00)	(14,063.00)
930	Gain(Loss)Sale of Fixed Assets		18,638.00	(4,500.00)
950	Miscellaneous Income		-	-
940	Federal Income Tax		78,023.00	100,000.00

Using the Welchs Company Trial Balance (provided), prepare an income statement, balance sheet, and statement of cash flow (for fixed assets, assume the change in the asset accounts are the additions and the change in the accumulated depreciation accounts is the depreciation).

Please submit this in excel.