Suppose you are a new hire in the finance department of Miller Hospital, a not-for-profit hospital (from case 1). You are assigned to prepare a Balance Sheet for year ending (December 31, 2017) using the following information. Please prepare a Balance Sheet for the year 2017 for Miller hospital on an Excel spreadsheet.

Transactions	(in thousands)
Cash in Bank	$ 100
Deposited funds in the Bank	$ 500
Certified checks	$ 85
Gross patient charges by the end of 2017	$ 350,600
Courtesy allowance (not included in employee benefits)	$ 300
Received donation (on November 12, 2017) for running free diabetes awareness program in the community in year 2017	$ 1,250
Supplies purchased in 2017 + Supplies from previous year	$ 36,500
Properties and equipment (not supplies)	$ 185,000
Certificate of deposits	$ 115
Doubtful account allowance	23.50%
Accumulated depreciation	$ 55,000
Addition of a parking garage	$ 1,000
Payment due for supplies	$ 20,500
Salaries and benefits due for payment	$ 30,600
Temporary Marketable securities purchased in 2017	$ 350
Estimated malpractice cost for 2017	$ 280
Supplies Used in 2017	$ 25,000
Long-term debt	$ 55,600
current portion of long term liabilities	$ 3,720
Charity care provided in 2017	$ 1,250
Other accrued liabilities	$ 1,640

While you were preparing the Balance Sheet, you found that the following two transactions were missing from the above information you received.

Miller hospital bought an urgent care facility for $1,530,000 in October 2017. The urgent care center is located in the prime shopping area that is 10 miles from the hospital. The actual value of the urgent care center was $1,220,000, but the board decided to pay extra during the negotiation because of the location. The urgent care center will not only attract new patients but will also advertise the hospital brand. The amount was financed by long- term debt from the bank.

BMW is one of the major employers in Newtown. The CEO of BMW plant donated $790,000 worth of medical supplies, and $2,200,000 worth of Da Vinci Robotic Surgery System to the hospital in November 2017