Analysis of return on investment

Assignment Help Finance Basics
Reference no: EM1366927

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 percent 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.

 

Reference no: EM1366927

Questions Cloud

Influencing the future of public health : How do you think this will affecting the future of public health? What advantages and challenges might develop?
Explain client-server architecture for serving client on pc : When people explain client-server architecture, they are usually referring to a system in which a large server is serving a client on a PC. With X Window, reverse is frequently the case. Explain
Healthcare and the field of pharmacy : Why is privacy such an significant issue in healthcare and the field of pharmacy? How does HIPAA protect a patient's privacy?
Determining demand for housing : The demand for housing is often described as being highly cyclical and very sensitive to housing prices and interest rates. Given these characteristics describe the effect of each of the following terms of whether it would increase or decrease the..
Analysis of return on investment : 60 percent 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 pay.
Show the information about proposal writing : Define a problem within your current work situation that requires action and the research to resolve and if you do not have a current position select something from an old employer or something you see in your community.
Idetifying financial markets : Identify and describe the different financial markets, their functions, primary instruments, and the investor types. But, my initial answer to this question would have not been initially focused on the primary and secondary markets.
Write program that compute the amount person earn : Write a program which computes the amount a person would earn over period of time if his or her salary is one penny the first day, two pennies second day.
Estimating equilibrium price and quantity : What would be the equilibrium quantity and equilibrium price? Assume the Government imposes a $5 per unit tax on the seller, which equation would be affected and how?

Reviews

Write a Review

 

Finance Basics Questions & Answers

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Find the length of prestopinos cash conversion cycle

What is the length of Prestopino's cash conversion cycle and at a steady state in which Prestopino produces 1,500 batteries a day, what amount of working capital must it finance?

  Finance true or false question

The money flow in management such as the LCN is very similar to Corporations where the money flows from the top down.

  Explaining strengthening basis benefits a short hedge

Describe why strengthening basis benefits a short hedge and hurts a long hedge.

  Compute the certainty equivalent npv

evaluate the annualized net present value - compute the certainty equivalent NPV

  Firms business risk

When examining a Company financial structure, would you be concerned with the firm's business risk? Why or why not?

  Determine the financial statement disclosures

Andrews, CPA, has been engaged to audit the financial statements of Broadwall Company for year ended December 31, 20X1.

  Finance and importance to business

Describe how financial statements, cash flow, risk, return, and capital asset pricing model, stocks, stock valuation and stock market equilibrium are significant to one's work profession and business?

  Find unlevered beta

El Capitan Foods has a capital structure of 40 percent debt and 60 percent equity, if its tax rate is 35%, and its beta (leveraged) is 1.25. Based on the Hamada equation,

  Financial forces effecting balance of payments

Describe how financial forces such as tariffs, taxes, inflation, and currency exchanges effect balance of payments.

  Determine which of the prohibited transaction rules

Determine which of the prohibited transaction rules is correct

  Construct an extended du pont equation

The Fern Furniture Corporation, a manufacturer and wholesaler of high-quality home furnishings, has been experiencing low profitability in recent years.

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