Prepare a Statement of Operations .

Not all accounts listed may be used in solving this problem. Be sure to show Excel textbox and Excel formulas.

Cash	$22,700,000.00
Revenue from Oncology department	$54,640,000.00
Revenue from Ancillary operations	$ 3,600,000.00
Revenue from Ambulatory services	$11,200,000.00
Inventory (asset)	$ 4,800,000.00
Inventory Expense	$ 5,100,000.00
Investments	$ 14,700,000.00
Insurance Expense	$4,900,000.00
Prepaid Insurance	$6,200,000.00
Supplies	$7,100,000.00
Supply Expense	$7,450,000.00
Accounts Payable	$8,630,000.00
Wage Expense	$16,850,000.00
Wages Payable	$2,478,000.00
Unearned Revenue	$7,300,000.00
Net Assets without donor restrictions	$35,741,000.00
Net Assets with donor restrictions	$31,369,000.00