Question

In: Finance

In the month of January, Memorial Hospital provided $270,000 in services. If the hospital has a...

In the month of January, Memorial Hospital provided $270,000 in services. If the hospital has a pattern of debt collections of 20% collected in the first month, 30% collected in the second month, 25% collected in the third month, 15% collected in the fourth month, 5% collected in the fifth month, and 5% written off as bad debt in the sixth month, at the end of March (3 months out), how much money will Memorial Hospital have collected?

Solutions

Expert Solution

Solution:

The total amount collected at the end of march = Amount collected in the month of January + Amount collected in the month of February + Amount collected in the month of March

As per the information given in the question

Amount of Services provided = $ 270,000

(a)

20 % of the Debt collection are made in the First Month. This implies that 20 % of the Debt collection are made in January.

Thus collection made in the month of January = 20 % * Amount of Services provided

= 20 % * $ 270,000 = $ 54,000

(b)

30 % of the Debt collection are made in the Second Month. This implies that 30 % of the Debt collection are made in February.

Thus collection made in the month of February = 30 % * Amount of Services provided

= 30 % * $ 270,000 = $ 81,000

(c )

25 % of the Debt collection are made in the Third Month. This implies that 25 % of the Debt collection are made in March

Thus collection made in the month of March = 25 % * Amount of Services provided

= 25 % * $ 270,000 = $ 67,500

The total amount collected by Memorial Hospital at the end of march = $ 54,000 + $ 81,000 + $ 67,500

= $ 202,500


Related Solutions

Hilltop Memorial Hospital George Long went to the outpatient department of Hilltop Memorial Hospital (HMH), which...
Hilltop Memorial Hospital George Long went to the outpatient department of Hilltop Memorial Hospital (HMH), which is an acute care general hospital in Windsor County for diagnosis and treatment of back pain. HMH is the safety-net hospital for uninsured, underinsured, and Medicaid patients in its region, and it relies heavily on its insured patients to subsidize its indigent care and its losses on Medicaid patients. Long had been treated at HMH many times for his back pain and mental health...
Hoover Company signs a four month promissory note for $ 270,000 on January​ 31, 2016. The...
Hoover Company signs a four month promissory note for $ 270,000 on January​ 31, 2016. The company is required to pay $ 67, 500 on the note each month. The first payment is on February​ 1, 2016, and the final payment is on May​ 1, 2016. How will this note be reported on the balance sheet at January​ 31, 2016?
Please show in excel with formulas. The staff of Jefferson Memorial Hospital has estimated the following...
Please show in excel with formulas. The staff of Jefferson Memorial Hospital has estimated the following net cash flows for a satellite food services operation that it may open in its outpatient clinic: Expected Net Year Cash Flow 0 -$100,000 1 $30,000 2 $30,000 3 $30,000 4 $30,000 5 $30,000 5 Salvage value $20,000 The Year 0 cash flow is the investment cost of the new food service, while the final amount is the terminal cash flow. (The clinic is...
Assume that you are the chief financial officer at Porter Memorial Hospital. The CEO has asked...
Assume that you are the chief financial officer at Porter Memorial Hospital. The CEO has asked you to analyze the proposed capital investments-Project X and Project Y. Each project requires a net investment outlay of $10,000, and the cost of capital for each project is 12 percent. The project’s expected net cash flows are: Year          Project X                     Project Y 0                (10,000)                       (10,000) 1                6,500                           3,000 2                3,000                           3,000 3                3,000                           3,000 4                1,000                           3,000 Calculate each project’s payback period and...
Many medical and hospital services in Canada are provided at zero prices to Canadians and are...
Many medical and hospital services in Canada are provided at zero prices to Canadians and are financed out of general government revenues. 1.What would be the marginal value of such services consumed by each Canadian if the government provided the necessary resources to satisfy all demand? Suppose the government maintains the zero price on medical services but restricts the supply to less than the quantity demanded. What is likely to happen in this market?
Riverside Memorial Hospital has experienced the following cash flows for the 2019 financial period (in thousands):...
Riverside Memorial Hospital has experienced the following cash flows for the 2019 financial period (in thousands): o Cash flows from operating activities: $11,196 o Cash flows from investing activities: ($6,293) o Cash flows from financing activities: ($5,735) • The nursing department is requesting additional funding (estimated $10,000) for additional, hospital-based continuing education programs. • The Women’s Center expansion project is estimated to cost roughly $1,000,000, and will require 4 years for build-out. • Due to the Patient Protection and Affordable...
Grey-Sloan Memorial Hospital has decided to implement an ERP system. GSMH's implementation team has decided to...
Grey-Sloan Memorial Hospital has decided to implement an ERP system. GSMH's implementation team has decided to implement multiple ERP modules from the vendor but they decided not to implement the HR module that comes with the ERP system. They decided to stay with the HR application they are currently using. Additional information: The HR module GSMH is currently using is located in the upper right quadrant of the Gartner Quadrant. GSMH can state that they have a "________ ___ ________"...
Jason Michaels has just been hired as CEO of Redstone Memorial Hospital, a 200 bed community...
Jason Michaels has just been hired as CEO of Redstone Memorial Hospital, a 200 bed community hospital in an affluent suburban location. Redstone has an excellent reputation in its community, but the hospital has not changed its business strategy or strategic focus or services in 20 years. As a result, although the hospital excels at “bread and butter” inpatient care (e.g., normal deliveries, appendectomies), it has not developed the medical staff, technology etc. necessary to provide state-of-the-art service for “big...
For D.W. McMillan Memorial Hospital, a 49-bed community hospital located in Brewton, Alabama, implementing an EHR...
For D.W. McMillan Memorial Hospital, a 49-bed community hospital located in Brewton, Alabama, implementing an EHR was not without its hurdles. However, the organization successfully on boarded a new system and is attesting for MU stage 2 during this fiscal year. Following are several key strategies that contributed to the hospital’s successful EHR implementation. D.W. McMillan was an early adopter of EHR technology among smaller rural and critical access hospitals, starting implementation in October 2012. The hospital began the journey...
Fargo Memorial Hospital has annual net patient service revenues of $14.4 million. The hospital's patient accounts...
Fargo Memorial Hospital has annual net patient service revenues of $14.4 million. The hospital's patient accounts manager estimates that 10 percent of third party payers pay on Day 30, 60 percent pay on Day 60, and 30 percent pay on Day 90. a. What is Fargo's average collection period? (Assume 360 days per year throughout this problem.) b. What is the firm's current receivables balance? c. What would be the firm's new receivables balance if a newly proposed electronic claims...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT