Cambridge Hospital: What is the Operating Margin, Days Cash on Hand, Days in Accounts Receviable, and Current Ratio

Cambridge Hospital Balance Sheet as of December 31, 2012 Current Assets Cash and cash equivalents Marketable securities Accounts receivable less allowances Inventories at cost Other current assets Total Current Asset 2012 $ 278,750 $ 1,200,500 $11,250,000 $ 3,368,000 $ 992,500 $17,089,750 Land and improvements Buildings Fixed equipment Moveable equipment Property, Plant & Equipment Less Accumulated Depreciation Total Plant, Property and Equipment $ 3,250,000 $36,485,750 $ 8,063,250 $ 4,466,750 $52,265,750 $11,580,750 $40,685,000 Total Assets $57,774,750 Liabilities and Net Assets Current Liabilities Current portion of long-term debt Accounts Payable and accrued expenses Estmated due to third party payers Other current liabilities Total Current Liabilities FY 2012 FY 2013 FY 2014 FY 2015 $ 2,151,000 $ 5,400,000 $ 1,423,750 $ 1,500,000 $10,474,750 Sheet3 Sheet2 Type here to search O te we Moveable equipment Property, Plant & Equipment Less Accumulated Depreciation Total Plant, Property and Equipment $ 4,466,750 $52,265,750 $11,580,750 $40,685,000 Total Assets $57,774,750 Liabilities and Net Assets Current Liabilities Current portion of long-term debt Accounts Payable and accrued expenses Estmated due to third party payers Other current liabilities Total Current Liabilities $ 2,151,000 $ 5,400,000 $ 1,423,750 $ 1,500,000 $10,474,750 Long-term debt, net of current portion $37,000,000 Total Liabilities $ 47,474,750 33 Net Assets Unrestricted Temporarily restricted Permanently restricted $ 8,800,000 $ 1,000,000 $ 500,000 Total Net Assets $10,300,000 Total Liabilities and Net Assets FY 2012 FY 2013 FY 2014 FY 2015 $57,774,750 Sheets Sheet2 Type here to search HA x R 278750 ABCDEFG Cambridge Hospital Balance Sheet as of December 31, 2013 Current Assets Cash and cash equivalents Marketable securities Accounts receivable less allowances Inventories at cost Other current assets Total Current Assets 2013 $ 278,750 $ 1,200,500 $11,250,000 $ 3,368,000 $ 992,500 $17,089,750 SENSIB BORBENOWN Land and improvements Buildings Fixed equipment Moveable equipment Property, Plant & Equipment Less Accumulated Depreciation Total Plant, Property and Equipment $ 3,250,000 $36,485,750 $ 8,063,250 $ 4,466,750 $52,265,750 $11,580,750 $40,685,000 Total Assets $57,774,750 21 Liabilities and Net Assets 22 Current Liabilities Current portion of long-term debt Accounts Payable and accrued expenses Estmated due to third party payers Other current liabilities Total Current Liabilities FY 2012 FY 2013 FY 2014 FY 2015 $ 2,151,000 $ 5,400,000 $ 1,423,750 $ 1,500,000 $10,474,750 Sheet3 Sheet2 Type here to search Ow Hile Home Unser Drew PD DUFORMES D REHW VW x f 278750 CDE Moveable equipment Property, Plant & Equipment Less Accumulated Depreciation Total Plant, Property and Equipment $ 4,466,750 $52,265,750 $11,580,750 $40,685,000 Total Assets $57,774,750 21 Liabilities and Net Assets 22 Current Liabilities Current portion of long-term debt Accounts Payable and accrued expenses Estmated due to third party payers Other current liabilities Total Current Liabilities $ 2,151,000 $ 5,400,000 $ 1,423,750 $ 1,500,000 $10,474,750 Long-term debt, net of current portion $37,000,000 Total Liabilities $47,474,750 33 Net Assets Unrestricted Temporarily restricted Permanently restricted $ 8,800,000 $ 1,000,000 $ 500,000 Total Net Assets $10,300,000 Total Liabilities and Net Assets FY 2012 FY 2013 FY 2014 FY 2015 $57,774,750 Sheet3 Sheet2 Type here to search H4 X for 278750 D E F G H Cambridge Hospital Balance Sheet as of December 31, 2014 3 Current Assets Cash and cash equivalents Marketable securities Accounts receivable less allowances Inventories at cost Other current assets Total Current Assets 2014 $ 278,750 $ 1,200,500 $11,250,000 $ 3,368,000 $ 992,500 $17,089,750 Land and improvements UEWE ao co Buildings Fixed equipment Moveable equipment Property, Plant & Equipment Less Accumulated Depreciation Total Plant, Property and Equipment $ 3,250,000 $36,485,750 $ 8,063,250 $ 4,466,750 $52,265,750 $11,580,750 $40,685,000 Total Assets $57,774,750 NON 21 Liabilities and Net Assets 22 Current Liabilities Current portion of long-term debt Accounts Payable and accrued expenses Estmated due to third party payers Other current liabilities Total Current Liabilities FY 2012 FY 2013 FY 2014 FY 2015 $ 2,151,000 $ 5,400,000 $ 1,423,750 $ 1,500,000 $10,474,750 Sheet3 Sheet2 Type here to search Data Review AutoSave " B File Home Insert Drax Page Layout Formulas H4X f278750 A B C D E F Moveable equipment Property, Plant & Equipment Less Accumulated Depreciation Total Plant, Property and Equipment G H $ 4,466,750 $52,265,750 $11,580,750 $40,685,000 Total Assets $57,774,750 21 Liabilities and Net Assets Current Liabilities Current portion of long-term debt Accounts Payable and accrued expenses Estmated due to third party payers Other current liabilities Total Current Liabilities $ 2,151,000 $ 5,400,000 $ 1,423,750 $ 1,500,000 $10,474,750 Long-term debt, net of current portion $37,000,000 Total Liabilities $47,474,750 13 Net Assets Unrestricted Temporarily restricted Permanently restricted $ 8,800,000 $ 1,000,000 $ 500,000 Total Net Assets $10,300,000 Total Liabilities and Net Assets FY 2012 FY 2013 FY 2014 FY 2015 $57,774,750 Sheet2 Sheet3 File Home insert Draw Page Layout Formulas Data Review - XVf278750 B C D E F G Cambridge Hospital Balance Sheet as of December 31, 2015 Current Assets Cash and cash equivalents Marketable securities Accounts receivable less allowances Inventories at cost Other current assets Total Current Assets 2015 $ 278,750 $ 1,200,500 $11,250,000 $ 3,368,000 $ 992,500 $17,089,750 NO Land and improvements Buildings Fixed equipment Moveable equipment Property, Plant & Equipment Less Accumulated Depreciation Total Plant, Property and Equipment $ 3,250,000 $36,485,750 $ 8,063,250 $ 4,466,750 $52,265,750 $11,580,750 $40,685,000 Total Assets $57,774,750 20 21 Liabilities and Net Assets 22. Current Liabilities Current portion of long-term debt Accounts Payable and accrued expenses Estmated due to third party payers Other current liabilities Total Current Liabilities FY 2012 FY 2013 FY 2014 FY 2015 $ 2,151,000 $ 5,400,000 $ 1,423,750 $ 1,500,000 $10,474,750 Sheets Sheet2 o Type here to search Home Insert Draw Page Layout Formu A G X x 278750 B C D E F Moveable equipment Property, Plant & Equipment Less Accumulated Depreciation Total Plant, Property and Equipment $ 4,466,750 $52,265,750 $11,580,750 $40,685,000 Total Assets $57,774,750 Liabilities and Net Assets Current Liabilities Current portion of long-term debt Accounts Payable and accrued expenses Estmated due to third party payers Other current liabilities Total Current Liabilities $ 2,151,000 $ 5,400,000 $ 1,423,750 $ 1,500,000 $10,474,750 Long-term debt, net of current portion $37,000,000 Total Liabilities $47,474,750 Net Assets Unrestricted Temporarily restricted Permanently restricted $ 3,800,000 $ 1,000,000 $ 500,000 Total Net Assets $10,300,000 Total Liabilities and Net Assets 112. FY 2013 PV 2014 FY 2015 $57,774,750 Sheet sheetz O