Miller Hospital Case Suppose you are a new hire in the finance department of Miller Hospital, a not-for-profit hospital located in Southport. You are assigned to prepare a Balance Sheet for year ending (December 31, 2018) using the following information. Please prepare a Balance Sheet for December 31, 2018 for Miller hospital on an Excel spreadsheet. Following are the transaction recorded on December 31, 2018 (in thousands) 100 500 85 Cash in Bank Deposited funds in the Bank Certified checks Gross patient charges by the end of 2018 Courtesy allowance (not included in employee benefits) Received donation (on November 12, 2018) for running free diabetes awareness program in the community in year 2019 Supplies purchased in 2018 + Supplies unused from previous 350,600 300 1,250 year Properties and equipment (not supplies) Certificate of deposits Doubtful account allowance % of Gross patient charges) Accumulated depreciation Addition of a parking garage from long-term bank loan Payment due for supplies Salaries and benefits due for payment Temporary Marketable securities Estimated malpractice cost for 2018 Supplies Used in 2018 Long-term debt current portion of long term liabilities Charity care provided in 2018 Other accrued liabilities 36,500 185,000 115 23.50% 55,000 1,000 20,500 30,600 350 280 25,000 55,600 3,720 1,250 1,640 While you were preparing the Balance Sheet, you found that the following transaction was missing from the above information you received, therefore, you updated the above information with the following information. BMW is one of the major employers in Southport. 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 2018. Miller Hospital Case Suppose you are a new hire in the finance department of Miller Hospital, a not-for-profit hospital located in Southport. You are assigned to prepare a Balance Sheet for year ending (December 31, 2018) using the following information. Please prepare a Balance Sheet for December 31, 2018 for Miller hospital on an Excel spreadsheet. Following are the transaction recorded on December 31, 2018 (in thousands) 100 500 85 Cash in Bank Deposited funds in the Bank Certified checks Gross patient charges by the end of 2018 Courtesy allowance (not included in employee benefits) Received donation (on November 12, 2018) for running free diabetes awareness program in the community in year 2019 Supplies purchased in 2018 + Supplies unused from previous 350,600 300 1,250 year Properties and equipment (not supplies) Certificate of deposits Doubtful account allowance % of Gross patient charges) Accumulated depreciation Addition of a parking garage from long-term bank loan Payment due for supplies Salaries and benefits due for payment Temporary Marketable securities Estimated malpractice cost for 2018 Supplies Used in 2018 Long-term debt current portion of long term liabilities Charity care provided in 2018 Other accrued liabilities 36,500 185,000 115 23.50% 55,000 1,000 20,500 30,600 350 280 25,000 55,600 3,720 1,250 1,640 While you were preparing the Balance Sheet, you found that the following transaction was missing from the above information you received, therefore, you updated the above information with the following information. BMW is one of the major employers in Southport. 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 2018
