I need some help with a balance sheet. I have uploaded the files

Case 2: Suppose you are a new hire in finance department Miller Hospital (from case 1). You are assigned to prepare a Balance Sheet for year ending December 31, 2015. Using the following information. Transactions Deposited funds in the Bank Certified checks Net patient charges by the end of 2015 Courtsey allownce (not included in employee benefits) Received donation for running free diabetes awareness program in the community in the year 2016 Supplies Properties and equipment (not supplies) Certificate of deposits Doubtful acount allowance Accumulated depriciation Addition of a parking garage Payment due for supplies Salaries and benefits due for payment temporary market securities Estimated malpractice cost Long-term debt current portion of long term liabilities Charity care Other accrued liabilities $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ (in thousands) 500.00 85.00 350,600.00 300.00 1,250.00 36,500.00 185,000.00 115.00 23.50% 55,000.00 1,000.00 20,500.00 30,600.00 350.00 280.00 55,600.00 3,720.00 1,250.00 1,640.00 While you were preparing the Balance Sheet, you found that following two transactions were missing from the above information you received. 1. Miller hospital bought an urgent care facility for $1,530,000 in October 2015. 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. 2. 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 2015 Please prepare Balance Sheet for the year 2015 for Miller hospital on an excel spreadsheet