Transcribed Image Text
The Mayo Clinic in Rochester is evaluating two differentcomputer systems for handling provider claims. There are noincremental revenues attached to the projects, so the decision willbe made on the basis of the present value of costs. Mayo'scorporate cost of capital is 10 percent. Here are the net cash flowestimates in thousands of dollars:a. Assume initially that the systems both have average risk. Whichone should be chosen?b.Assume that System X is judged to have high risk. Mayo accounts fordifferential risk by adjusting its corporate cost of capital up or down by 2percentage points. Which system should be chosen?Year System X System Y0 -$500 -$2,5001 -$1,500 -$3002 -$1,250 -$3003 -$300 -$300Please show work in Excel