Question

In: Finance

The Mayo Clinic in Rochester is evaluating two different computer systems for handling provider claims. There...

The Mayo Clinic in Rochester is evaluating two different computer systems for handling provider claims. There are no incremental revenues attached to the projects, so the decision will be made on the basis of the present value of costs. Mayo's corporate cost of capital is 10 percent. Here are the net cash flow estimates in thousands of dollars:

a. Assume initially that the systems both have average risk. Which one should be chosen?
b. Assume that System X is judged to have high risk. Mayo accounts for differential risk by adjusting its
    corporate cost of capital up or down by 2 percentage points. Which system should be chosen?

Year System X System Y

0 -$500 -$2,500

1 -$1,500 -$300

2 -$1,250 -$300

3 -$300 -$300

Please show work in Excel

Solutions

Expert Solution

a

System X
Discount rate 0.1
Year 0 1 2 3
Cash flow stream -500 -1500 -1250 -300
Discounting factor 1 1.1 1.21 1.331
Discounted cash flows project -500 -1363.64 -1033.06 -225.394
NPV = Sum of discounted cash flows
NPV System X = -3122.09
Where
Discounting factor = (1 + discount rate)^(Corresponding period in years)
Discounted Cashflow= Cash flow stream/discounting factor
System Y
Discount rate 0.1
Year 0 1 2 3
Cash flow stream -2500 -300 -300 -300
Discounting factor 1 1.1 1.21 1.331
Discounted cash flows project -2500 -272.727 -247.934 -225.394
NPV = Sum of discounted cash flows
NPV System Y = -3246.06
Where
Discounting factor = (1 + discount rate)^(Corresponding period in years)
Discounted Cashflow= Cash flow stream/discounting factor

Choose System X as it has lower cost

b

System X
Discount rate 0.08
Year 0 1 2 3
Cash flow stream -500 -1500 -1250 -300
Discounting factor 1 1.08 1.1664 1.259712
Discounted cash flows project -500 -1388.89 -1071.67 -238.15
NPV = Sum of discounted cash flows
NPV System X = -3198.71
Where
Discounting factor = (1 + discount rate)^(Corresponding period in years)
Discounted Cashflow= Cash flow stream/discounting factor

Choose system X as it still has lower cost compared to System Y @ 10%


Related Solutions

Fraud and Abuse Claims of Mayo Clinic Has the government alleged any fraud and abuse claims...
Fraud and Abuse Claims of Mayo Clinic Has the government alleged any fraud and abuse claims in Mayo Clinic? If so, what are the nature and implications of them?
The annual maximum flow data for two different periods of record for Genesee River at Rochester,...
The annual maximum flow data for two different periods of record for Genesee River at Rochester, NY, are given below. Determine whether there is homogeneity in the sequence of data of two periods, at the 2.5% level of significance. Year                  Discharge (m3/s) Year                  Discharge (m3/s) 1948                           21,600 1949                           16,400 1950                           33,100 1951                           20,200 1952                           17,700 1953                           17,100 1954                           17,500 1955                           19,100 1956                           24,300 1957                           17,000 1958                           14,900 1959                           17,700 1960                           25,800 2001                           20,300 2002                           23,300 2003                           13,800 2004                           28,200 2005                          ...
Foster Airlines is considering two different computer systems: the Standard System and the Custom Travel System....
Foster Airlines is considering two different computer systems: the Standard System and the Custom Travel System. The projected annual revenues, annual costs, capital outlays, and project life for each system (in after-tax cash flows) are as follows: Standard System Custom Travel Annual revenues $540,000 $675,000 Annual operating costs 270,000 360,000 System investment 810,000 945,000 Project life 5 years 5 years Assume that the required rate of return for the company is 12 percent. Required: 1. Calculate the NPV for each...
Disfrutar Travel Agency is considering two different computer systems: the Standard T2 System and the Custom...
Disfrutar Travel Agency is considering two different computer systems: the Standard T2 System and the Custom Travel System. The projected annual revenues, annual costs, capital outlays, and project life for each system (in after-tax cash flows) are as follows: Standard T2 Custom Travel Annual revenues $360,000 $450,000 Annual operating costs 180,000 240,000 System investment 540,000 530,000 Project life 5 years 5 years Assume that the cost of capital for the company is 12 percent. The present value tables provided in...
Research computer-controlled medication systems on the Internet. Describe aspects of at least two such systems that...
Research computer-controlled medication systems on the Internet. Describe aspects of at least two such systems that could actually foster medication errors, along with what procedures or protocols could help prevent such errors.
Research computer-controlled medication systems on the Internet. Describe aspects of at least two such systems that...
Research computer-controlled medication systems on the Internet. Describe aspects of at least two such systems that could actually foster medication errors, along with what procedures or protocols could help prevent such errors.
The Hearts and Hands Clinic has two service departments (Human Resources and Information Systems) and two...
The Hearts and Hands Clinic has two service departments (Human Resources and Information Systems) and two "production" departments (In-patient Treatment and Out-patient Treatment). The service departments service the "production" departments as well as each other, and studies have shown that Information Systems provides the greater amount of service. Which of the following allocations would not occur if Hearts uses the step-down method of cost allocation? Select one: a. Human Resources cost would be allocated to In-patient Treatment. b. In-patient Treatment...
Choose an organization that you interact with regularly and list as many different “systems” (computer-based or...
Choose an organization that you interact with regularly and list as many different “systems” (computer-based or not) as you can that are used to process transactions, provide information to managers and executives, help managers and executives make decisions, aid group decision making, capture knowledge and provide expertise, help design products and/or facilities, and assist people in communicating with one another. At the end of this course you should be able to analyze various organization and list their various “systems” for...
With different types of computer systems available, how can these be used to sustain competitive organizational...
With different types of computer systems available, how can these be used to sustain competitive organizational advantage?
(a) Give an example of two different system functions (two different filters/LTI systems) that have the...
(a) Give an example of two different system functions (two different filters/LTI systems) that have the same magnitude response. (b) Give an example of two different system functions that have the same phase response. (c) Give an example of two different system functions that have the same group delay but have different phase responses. (d) Give an example of two different system functions that have the same ROC.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT