To complete assignment 1 include the following in your worksheet(s). Remember to carefully plan the layout of the requested schedules to provide a professional, clear and easily understood presentation. You can create new worksheets for the schedules if you wish. Worksheet requirements: 1. Using the trial balances data on the following pages complete the following in Excel using two worksheets: a. For worksheet 1: i. Enter the data as provided ii. Use the SUM() function to check your data entry iii.Format the columns using appropriate formats b. For worksheet 2 you will be performing a financial statement analysis: i. Create a comparative Income statement and Balance Sheet for the three years using formulas to refer to your input data in worksheet 1 ii. Format the columns in the financial statements using appropriate formats iii.Prepare a trend analysis (use the columns immediately to the right of your financial statements) to show a year over year change and a year over year percentage change. Be sure to format your numbers appropriately. iv. Prepare a common sized income statement and balance sheet (Use the rows below your income statement and balance sheet) for your common sized financial statements. Be sure to format your numbers appropriately. v. Below the financial statements prepare the following ratios: 1. Gross Profit 2. Current Ratio 3. Acid Test

Data:

	Adjusted Trial Balance December 31, 2013		Adjusted Trail Balance December 31,2014		Adjusted Trial Balance December 31, 2015
	Debit	Credit	Debit	Credit	Debit	Credit
Accounts Payable	$0	$18,080	$0	$49,590	$0	$69,850
Accounts Recievable	6,780	0	9,690	0	21,780	0
Accumulated Depreciation	0	9,040	0	18,240	0	29,700
Advertising Expense	7,910	0	20,520	0	13,750	0
Cash	5,650	0	7,980	0	20,680	0
Common Stock	0	1,130	0	1,288	0	1,100
Cost of Good Sold	129,950	0	222,300	0	247,500	0
Depreciation Expense	9,040	0	9,120	0	12,100	0
Equiptment	96,050	0	96,900	0	107,800	0
Income Tax Expense	6,780	0	4,560	0	8,030	0
Income Tax Payable	0	6,780	0	1,140	0	1,650
Interest Expense	4,520	0	1,710	0	3,080	0
Inventory	7,345	0	10,488	0	20,460	0
Marketing Expense	5,650	0	3,420	0	8,690	0
Notes Payable-Equiptment	0	10,170	0	9,120	0	7,700
Notes Payable-Other	0	20,340	0	17,100	0	13,200
Payroll Liabilities	0	2,260	0	3,990	0	4,730
Prepaid Expenses	791	0	570	0	1,650	0
Retained Earnings	0	15,820	0	53,110	0	31,772
Salary Expense	56,500	0	96,900	0	97,240	0
Sales	0	293,800	0	371,962	0	466,638
Short-Term Investments	2,260	0	3,990	0	6,380	0
Supplies	2,034	0	2,622	0	7,370	0
Supplies Expense	5,198	0	7,980	0	12,980	0
Utilities Expense	8,362	0	9,690	0	11,880	0
Wages Expense	22,600	0	17,100	0	24,970	0
	$377,420	$377,420	$525,540	$525,540	$626,340	$626,340