acctounting homework

copy_of_accounting_services.xlsx

Budget

Accounting, Inc
Anual Budget
2013
	Qtr 1	Qtr 2	Qtr 3	Qtr 4	Totals
Revenue:
Tax Returns	74000	1500	800	14200
Consulting Services	10300	9500	8700	9300
Financial Statement Preparation	7700	7700	7700	7700
Data Entry & Compilation	6200	6200	6200	6200
Payrol Services & reporting	6700	6700	6700	6700
Total Revenue
Expenses:
Wage Expense	30500	18000	18000	28300
Payroll Taxes	3050	1800	1800	2830
Workers Compensation	950	540	540	849
Liability Insurance	1200	1200	1200	1200
Profesional Publications	600	60	60	300
Office Supplies	1200	300	200	800
Computer Support	300	300	300	300
Miscellaneous	2700	2700	2700	2700
Building Rent	6600	6600	6600	6600
Total Expenses
Net Income

Accounting, Inc
Income Statement
1st Quarter, 2013
Revenue:	1st Quarter Actuals
Tax Returns	76000
Consulting Services	9900
Financial Statement Preparation	7900
Data Entry & Compilation	6350
Payrol Services & reporting	6950
Total Revenue
Expenses:
Wage Expense	30850
Payroll Taxes	3085
Workers Compensation	1050
Liability Insurance	1200
Profesional Publications	550
Office Supplies	1250
Computer Support	300
Misc	2450
Building Rent	6600
Total Expenses
Net Income