accounting 6
ACCOUNTING PROBLEMS NEEDED BY 5/23/12 1. Capitol Healthplans Inc. is evaluating two different methods for providing home health services to its members. Both methods involve contracting out for services and the health outcomes and revenues are not affected by the method chosen. Therefore, the incremental cash flows for the decision are all outflows. Here are the projected flows: Year Method A Method B 0 ($300,000) ($120,000) 1 ($66,000) ($96,000) 2 ($66,000) ($96,000) 3 ($66,000) ($96,000) 4 ($66,000) ($96,000) 5 ($66,000) ($96,000) a. What is each alternative’s IRR? b. If the cost of capital for both methods is 9% which method should be chosen and why? 2. Great Lakes Clinic has been asked to provide exclusive healthcare services for next year’s World Exposition. Although flattered by the request, the clinic’s managers want to conduct a financial analysis of the project. There will be an up front cost of $160,000 to get the clinic in operation. Then a net cash inflow of $1 million is expected from operations in each of the two years of the exposition. However, the clinic has to pay the organizers of the exposition a fee for the marketing value of the opportunity. This fee, which must be paid at the end of the second year is $2 million. a. What are the cash flows associated with the project? b. What is the projects IRR? c. Assuming a project cost of capital of 10% what is the projects NPV? d. What is the projects MIRR? e. SHOW WORK 3. Assume that you are the chief financial officer at Porter Memorial Hospital. The CEO has asked you to analyze two proposed capital investments – Project X and Project Y. Each project requires a net investment outlay of $10,000 and the cost of capital for each project is 12%. The project’s expected net cash flows are as follows: Year Project X Project Y 0 ($10,000) ($10,000) 1 $6,500 $3,000 2 $3,000 $3,000 3 $3,000 $3,000 4 $1,000 $3,000 a. Calculate each project’s payback period? b. Calculate net present value (NPV)? c. Calculate internal rate of return (IRR)? d. Which project (or projects is financially acceptable? e. Explain your answer. 4. The director of capital budgeting for Big Sky Health Systems Inc. has estimated the following cash flows in thousands of dollars for a proposed new service: Year Expected Net Cash Flow 0 ($100) 1 $70 2 $50 3 $20 The project’s cost of capital is 10%. a. What is the project’s payback period? b. What is the project’s NPV? c. What is the project’s IRR? d. What is the project’s MIRR? 5. The managers of Merton Medical Clinic are analyzing a proposed project. The project’s most likely NPV is $120,000 but as evidenced by the following NPV distribution there is considerable risk involved: Probability NPV 0.05 ($700,000) 0.20 ($250,000) 0.50 $120,000 0.20 $200,000 0.05 $300,000 a. What are the project’s expected NPV and standard deviation of NPV? b. Should the base case analysis use the most likely NPV or the expected NPV? c. Explain your answer. 6. Heywood Diagnostic Enterprises is evaluating a project with the following net cash flows and probabilities: Year Prob = 0.2 Prb =0.6 Prob =0.2 0 ($100,000) ($100,000) ($100,000) 1 $20,000 $30,000 $40,000 2 $20,000 $30,000 $40,000 3 $20,000 $30,000 $40,000 4 $20,000 $30,000 $40,000 5 $30,000 $40,000 $50,000 The Year 5 values include salvage value. Heywood’s corporate cost of capital is 10% a. What is the project’s expected (i.e base case) NPV assuming average risk? (the base case net cash flows are the expected cash flows in each year) b. What are the project’s most likely worst case NPV? c. What is the project’s most likely best case NPV? d. What is the project’s expected NPV on the basis of the scenario analysis? e. What is the project’s standard deviation of NPV? f. Assume that Heywood’s managers judge the project to have lower than average risk. The company’s policy is to adjust the corporate cost of capital up or down by 3 % points to account for differential risk. Is the project financially attractive? Why? 7. California Health Center, a for profit hospital is evaluating the purchase of new diagnostic equipment. The equipment which costs $600,000 has an expeSccted life of five years and an estimated pretax salvage value of $200,000 at that time. The equipment is expected to be used 15 times a day for 250 days a year for each year of the project’s life. On average each procedure is expected to generate $90 in collections which is net bad debt losses and contractual allowances in its first year of use. Thus net revenues for Year 1 are estimated at 15x 250 x $80 = $300,000. a. Perform a sensitivity analysis to see how NPV is affected by changes in number of procedures per day, average collection amount and salvage value. b. Conduct a scenario analysis. Suppose that the hospital’s staff concluded that the three most uncertain variables were number of procedures per day, average collection amount and the equipment’s salvage value. The following data were developed: Scenario Probability # of procedure Average collection equip. salvage value Worst 0.25 10 $60 $100,000 Most likely 0.50 15 $80 $200,000 Best 0.25 20 $100 $300,000 c. Assume that California Health Center’s average project has a coefficient of variation of NPV in the range of 1.0 2.0. The coefficient of variation is defined as the standard deviation of NPV divided by the expected NPV. The hospital adjusts for risk by adding or subtracting 3 % points to its 10% corporate cost of capital. After adjusting for differential risk is the project still profitable? d. What type of risk was measured and accounted for in parts b and c? e. Should this be of concern to the hospital’s managers? 8. The managers of United Medtronics are evaluating the following four projects for the coming budget period. The firm’s corporate cost of capital is 14% Project Cost IRR A $15,000 17% B $15,000 16% C $12,000 15% D $20,000 13% a. What is the firm’s optimal capital budget? b. Suppose Medtronics managers want to consider differential risk in the capital budgeting process. Project A has average risk, B has below average risk, C has above average risk and D has average risk. What is the firms optimal capital budget when differential risk is considered? (The firm’s managers lower the IRR of high risk projects by 3% points and raise the IRR of low risk projects by the same amount).