Purchase Solution

return on investment analysis

Not what you're looking for?

Ask Custom Question

Create a spreadsheet to address the following problem:

A. A hospital has an average accounts receivable balance of $20,000,000 and a collection period of 60 days.

B. 60% of receivables are not collected on time. The bills for those receivables must be reworked by the patient billing department and resubmitted to insurance companies for payment. Assume that the insurance companies did not pay the first submission because of data errors in the bills. The reworked bills adversely impact the average accounts receivable collection period.

C. The receivables that are not reworked (40% of the total) are all processed consistently without problems.

D. Fairview Health sells a system that will gradually reduce the number of data errors in the billing process. Assume that the system will have no impact in year 1 (during the implementation period), and that data errors are projected to be reduced by 25%, 50%, 70%, and 90% in years 2 through 5 respectively. The system will cost the hospital $2,000,000 in year 1 and $300,000 per year in years 2 through 5.

E. How would you project the financial benefits that the system could deliver to the hospital over 5 years and the return on investment for the system? If you need some additional information, identify what you need and then assume a value so that you can arrive at answers.

Purchase this Solution

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.