The Sydney Hospital provides a range of health care services and its payment terms are net 30 days, meaning payment from patients is due 30 days after their discharge from hospital. Suppose the following transactions take place:
March 5 – Patients receive health care services of $60,000
March 10 – Patients receive health care services of $250,000 on terms of net 30 days.
March 15 – Patients pay $60,000 for health care services received on March 5.
March 30 – hospital pays $50,000 for salaries for work done in March
April 1 -The hospital purchases drugs for $160,000 on terms of net 30 days. In April the hospital uses $35,000 worth of drugs. In May $65,000 of drugs are used and in June $60,000 of drugs are used.
April 6 – Patients receive health care services of $250,000 on terms of net 30 days.
April 7 – phone bill received for $1,000 for telephone services in March.
April 10 – Patients pay $250,000 for services received in March.
April 30 – Hospital pays $55,000 for salaries for work done in April
May 1 – Hospital pays phone bill for $1,000 received on April 7.
May 5 – The hospital pays $160,000 for drugs received in April.
May 6 – Patients pay $250,000 for services received in April.
May 15 – Patients receive health services of $200,000 on terms of net 30 days.
May 30 – Hospital pays $45,000 for salaries for work done in May.
June 5 – Patients receive $55,000 in services and pay for them on the same day.
June 29 – Patients pay $200,000 for services received in May.
June 30 – Hospital pays $40,000 for salaries for work done in June.
a) Calculate this Hospital's profit or loss for each of the months of March, April and May on both a cash accounting and accrual accounting basis. Make sure you show your calculations. You need to do a separate profit and loss statement for each month.
b) What month was the most profitable for the hospital? Explain your answer.
c) Calculate the Hospital's profit or loss for the four months ending June on both a cash accounting and accrual accounting basis. If you get the same answer for both methods explain why this is so. If you get a different answer for the cash and accrual methods explain why this happened.
Items from the Prince Harry Hospital's balance sheet, revenue and expense (income) statement and cash flow statement for the 2014/15 and 2013/14 financial years (ending 30 June) were accidentally listed in alphabetical order as follows:
|Bad & Doubtful Debts||0||407|
|Capital Purpose Income||271,521||339,864|
|Car park revenue||42,507||99,723|
|Cash and Cash Equivalents||4,536,985||3,127,657|
|Depreciation and Amortisation||730,304||709,452|
|Domestic Service expenses||167,802||146,659|
|Fuel, Light, Power and Water||146,913||123,338|
|Interest and dividends received||92,012||63,385|
|Inventories of drugs||40,139||34,333|
|Long term loans||240,877||174,900|
|Long term receivables||87,767||36,478|
|Motor Vehicle Expenses||41,905||47,613|
|Non Salary Labour Costs||36,561||17,644|
|Other Administrative Expenses||920,244||903,036|
|Other Current Assets||20,428||108,328|
|Other current liabilities||3,869,052||2,753,096|
|Patient Fees revenue||2,740,239||2,510,626|
|Patient Transport expenses||810||4,531|
|Private practice fee revenue||286,996||306,927|
|Property, Plant & Equipment||8,293,627||8,959,514|
|Repairs & Maintenance||71,237||48,672|
|Salary and wages||5,060,578||4,887,643|
|Short term receivables||1,180,862||1,310,776|
|Short term staff benefits||1,099,853||909,310|
|State government grants||64,048||74,586|
|Cash flow information|
|Capital Grants from Government||33,429||108,029|
|Cash at beginning of period||1,243,626||1,125,445|
|Cash at end of period||1,537,993||1,243,626|
|Donations and Bequests Received||33,128||38,724|
|Employee Expenses Paid||5,186,520||5,130,345|
|GST Received from ATO||8,020||172|
|Non Salary Labour Costs||36,561||17,644|
|Operating Grants from Government||3,487,063||3,506,782|
|Other Capital Receipts||0||33,296|
|Patient and Resident Fees Received||2,930,781||2,257,929|
|Payments for Non-Financial Assets||63,571||264,621|
|Payments for Supplies & Consumables||1,692,467||1,328,683|
|Proceeds from sale of Non-Financial Assets||0||32,600|
*The cash balances at the beginning and end of the period do not correspond to the figures in the balance sheet as this hospital also holds cash in trust for other organisations and/or individuals.
a. Prepare balance sheets for these two financial years. Arrange these statements like the balance sheets for the Barwon Health that are in the course materials – ie the statements for the two years should be side by side. Make sure to distinguish between current and non-current assets and liabilities.
b. Prepare income (profit and loss) statements for these two years for this hospital.
c. Identify two significant changes that occurred during this period. Do you think that this hospital is in a good position to pay its short term debts? Explain your answer.
d. Prepare a cash flow statement showing operating, investing and financing cash flows for these two financial years.
e. One of the hospital's surplus buildings has a book value of $3 million and it has been offered $5 million for this property. Do you think that the hospital should accept this offer? Explain what factors the management should consider before accepting this offer.