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

Purchase this Solution

Free BrainMass Quizzes
Introduction to Finance

This quiz test introductory finance topics.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.