Spreadsheet Help

mbad_6252-10_management_of_information_systems_shah_publication.xlsx

Baseline

Attachment One: Income/Expense Statement				Computer Lab Assignment No. 1
	Shah Ophtalmology Center
Name:
				Actual	Projected
		Values	% Increment	2012	2013	2014	2015
	Income
	Office Visits		4.50%	$600,500	$627,523	$655,762	$685,271
	General Surgery		6.00%	$482,500	$511,450	$542,137	$574,665
	Refractive Surgery	$192,000	22.00%	$0	$0	$192,000
	Total Income
	Expenses
	Salaries
	Dr Casey		10.50%	$140,000	$154,700	$170,944	$188,893
	Dr. Shah			$255,000	$255,000	$255,000	$255,000
	Office Manager		3.00%	$65,000	$66,950	$68,959	$71,028
	Receptionist		3.00%	$40,000	$41,200	$42,436	$43,709
	Medical Technician - 1		3.00%	$50,000	$51,500	$53,045	$54,636
	Medical Technician - 2	$54,000	3.50%	$54,000	$55,890	$57,846	$59,871
	Contract Services		0.45%
	Refractice Surgery equipment lease	$82,000		$82,000	$82,000	$82,000	$82,000
	Equipment Depreciation	$450,000		$450,000	$360,000	$270,000	$180,000
	Interest Expense	$390,000	3.95%	$0	$73,113	$73,113	$73,113
	Insurance	$33,000		$33,000	$33,000	$55,000	$55,000
	Office rent		5.50%	$40,000	$42,200	$44,521	$46,970
	Material & Supplies		4.50%	$22,000	$22,990	$24,025	$25,106
	Telephone & Communications		4.50%	$27,700	$28,947	$30,250	$31,611
	Marketing		4.50%	$15,000	$15,675	$16,380	$17,117
	Miscellaneous Expenses		4.50%	$16,600	$17,347	$18,128	$18,944
	Total Expenses
	Gross Profit (Total Income - Total Expenses)
	Income Taxes		21.00%
	Net Income
	Note: Income/expense statement w/ surgery in next sheet.

MBAD 252 Page &P &D

Attachment One: Income/Expense Statement				Computer Lab Assignment No. 1
	Shah Ophtalmology Center
Name:
				Actual	Projected
		Values	% Increment	2012	2013	2014	2015
	Income
	Office Visits		4.50%	$600,500
	General Surgery		6.00%	$482,500
	Refractive Surgery	$192,000	22.00%
	Total Income
	Expenses
	Salaries
	Dr Casey		10.50%	$140,000
	Dr. Shah			$255,000
	Office Manager		3.00%	$65,000
	Receptionist		3.00%	$40,000
	Medical Technician - 1		3.00%	$50,000
	Medical Technician - 2	$54,000	3.50%
	Contract Services		0.45%
	Refractice Surgery equipment lease	$82,000
	Equipment Depreciation	$450,000
	Interest Expense	$390,000	3.95%
	Insurance	$33,000
	Office rent		5.50%	$40,000
	Material & Supplies		4.50%	$22,000
	Telephone & Communications		4.50%	$27,700
	Marketing		4.50%	$15,000
	Miscellaneous Expenses		4.50%	$16,600
	Total Expenses
	Gross Profit (Total Income - Total Expenses)
	Income Taxes		21.00%
	Net Income

MBAD 252 Page &P &D