What month was the most profitable for the hospital

Assignment Help Accounting Basics
Reference no: EM131060627

Question 1-

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.

Required:

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.

Question 2-

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:

 

2015

2014

Accounting fees

13,400

970

Audit Fees

9,405

9,495

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

Drug expenses

19,111

72,768

Food expenses

239,035

237,695

Fuel, Light, Power and Water

146,913

123,338

Government Grants

3,423,015

3,422,197

Insurance costs

3,689

63,889

Interest and dividends received

92,012

63,385

Inventories of drugs

40,139

34,333

Lease Expenses

80,109

78,321

Long term loans

240,877

174,900

Long term receivables

87,767

36,478

Maintenance Contracts

34,639

43,560

Medical expenses

80,982

77,529

Motor Vehicle Expenses

41,905

47,613

Motor vehicles

2,000

2,000

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

Other revenue

821,057

683,808

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

Short-term payables

326,708

698,129

State government grants

64,048

74,586

Superannuation

399,074

399,131

Total equity

8,625,318

9,043,651

Workcover insurance

103,930

84,714

 

Cash flow information

 

2015

2014

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

Interest Received

88,727

71,150

Non Salary Labour Costs

36,561

17,644

Operating Grants from Government

3,487,063

3,506,782

Other Capital Receipts

0

33,296

Other Receipts

692,338

810,792

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.

Required:

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.

Verified Expert

We have prepared income statement on cash basis and accrual basis for 3 months and then for 4 months.Also we have prepared Statement of Profit and Loss, Balance sheet and cash flow statement for 2 years. We have also commented on whether hospital would be able to repay its short term borrowings.Also evaluation has been made whether hospital should sell one of its fixed assets which has a book value of 3 million and being offered 5 million.

Reference no: EM131060627

Questions Cloud

Economic decision-making principles : Decide on the course you want to take. Then using at least two economic decision-making principles, explain why you are making this choice.
Review the section entitled turnitin policies : Access the Academic Integrity folder for this course. Review the section entitled Turnitin Policies. You may also want to visit the Turnitin website and review the function of Turnitin and the information provided on how to interpret a Turnitin re..
Passage of adam smith wealth of nations : Some people believe economists are selfish. I think this is associated with how they perceive the following passage of Adam Smith's Wealth of Nations (Book I, Chapter II):
What is required rate of return-constant growth valuation : Constant growth valuation Harrison Clothiers' stock currently sells for $31 a share. It just paid a dividend of $2.5 a share (that is, D0 = 2.5). The dividend is expected to grow at a constant rate of 5% a year. What stock price is expected 1 year fr..
What month was the most profitable for the hospital : 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. What month was the most profitable for the hospital
Examines an ethical issue touched on in the module readings : Search for a current (no more than two months old) news story (article, other piece of writing, or video clip) that examines an ethical issue touched on in the Module readings or discussion which focused on three specific virtues.
Productivity and development : Explaining what variables are important in order to increase productivity and development. Please include the PPF curve concepts, inflation, and two more concepts.
Capita expenditure to grow annually : A township expects its population of 5,000 to grow annually at the rate of 5 percent. The township currently spends $300 per inhabitant, but, as the results of inflation and wage increments, expects the per capita expenditure to grow annually by 7 pe..
Create a media presentation on either aircraft : Create a media presentation on either Aircraft or UAS propellers. Provide information on the advancement being made in the design for the chosen propeller. Provide information on the advancements of aerodynamic efficiency for the chosen propeller.

Reviews

inf1060627

6/24/2017 4:32:56 AM

My expert was super patient and stunning. She helped me with my assignment very well. She didn't do the issue for me, she helped me thought of formulas and plug in the numbers. What's more, to be just about 3 AM, I completed a considerable assignment and I comprehend the issues much better. Much obliged to you!

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd