Complete Exercises 9.1, 9.4 and 9.7. Use the Excel document below to record your answers.
Note: For 9.7, provide a short response to the following (9.7j): “Use the measures in 9.7h and i for the final comparison among the three sites, and discuss potential problems at each site or overall for the company. What are your recommendations to correct them?”
The chief at the ultrasound division of the radiology department in a community hospital would like to measure the multi-factor productivity for a complete abdomen procedure. The last three years of data were accumulated, as shown in Table EX. 9.1
TABLE EX 9.1
Measurement Year 1 Year 2 Year 3
Price ($) 880 883 886
Volume 5,583 6,312 6,129
Labor ($) 75,000 77,000 80,000
Materials ($) 2,750 2,900 3,100
6,500 6,700 7,000
a. What are the multi-factor productivity ratios for these years?
b. What can you conclude about the productivity trend for this procedure?
Calculate the case mix index for the following hospitals, which use the same patient classification system, using the data in Table EX. 9.4.
TABLE EX. 9.4
Patient Classification Direct Care
Low-level care 3.0 0.50 0.35 0.30 0.20
Medium-level care 6.0 0.35 0.40 0.30 0.25
High-level care 9.0 0.10 0.15 0.22 0.30
Extreme care 12.0 0.05 0.10 0.18 0.25
The PERFORMSBETTER MEDICAL CENTER (PMC) , a three-site urology group practice, requires productivity monitoring. To create a benchmark for future years and to be able to compare performance to similar peer practices, the data in Table EX 9.7 were gathered for each of the three lacations.
TABLE EX 9.7
Measurements/Sites Location 1 Location 2 Location 3
Annual Visits 135,000 94,000 101,000
Annual Paid Hours 115,000 112,000 125,000
Patient Classification (Based on CPT Coding)
Initial Visit (.55)* .30 .10 .15
Low-Level Decision Making (.50) .40 .20 .15
Medium -Level Decision Making (.75) .20 .40 .35
High -Level Decision Making (1.40) .10 .30 .35
Specialists ($110/hr.)+ .50 .30 .70
General Practitioners ($85/hr.) .30 .50 .30
Nurse Practitioners ($45/hr.) .20 .20 .00
*Represents total hours of direct care required per patient visit within the category
+ Represents hourly compensation including fringe benefits for the skill level
Assume that 1 general practitioner = .75 specialists, and 1 nurse practitioner = .35 specialists for economic measure of skill substitution.
a. Work hours/visits
b. Adjusted work hours /visits
c. Work hours /adjusted visits
d. Adjusted work hours/adjusted visits
e. Total salary expense/visits
f. Total salary expense /adjusted visits
g. Percent of work hours in direct patient care
h. Percent of adjusted work hours in direct patient care
i. Total salary expense/hours of direct patient care
to evaluate their procedures involving the evaluation of long term investment opportunities. You have agreed to provide a detailed report illustrating the use of several techniques for evaluating capital projects including the weighted average cost of capital to the firm, the anticipated cash flows for the projects, and the methods used for project selection. In addition, you have been asked to evaluate two projects, incorporating risk into the calculations.
You have also agreed to provide an 8-10 page report, in good form, with detailed explanation of your methodology, findings, and recommendations.
Wheel Industries is considering a three-year expansion project, Project A. The project requires an initial investment of $1.5 million. The project will use the straight-line depreciation method. The project has no salvage value. It is estimated that the project will generate additional revenues of $1.2 million per year before tax and has additional annual costs of $600,000. The Marginal Tax rate is 35%.
Wheel has just paid a dividend of $2.50 per share. The dividends are expected to grow at a constant rate of six percent per year forever. If the stock is currently selling for $50 per share with a 10% flotation cost, what is the cost of new equity for the firm? What are the advantages and disadvantages of using this type of financing for the firm?
The firm is considering using debt in its capital structure. If the market rate of 5% is appropriate for debt of this kind, what is the after tax cost of debt for the company? What are the advantages and disadvantages of using this type of financing for the firm?
The firm has decided on a capital structure consisting of 30% debt and 70% new common stock. Calculate the WACC and explain how it is used in the capital budgeting process.
Calculate the after tax cash flows for the project for each year. Explain the methods used in your calculations.
If the discount rate were 6 percent calculate the NPV of the project. Is this an economically acceptable project to undertake? Why or why not?
Now calculate the IRR for the project. Is this an acceptable project? Why or why not? Is there a conflict between your answer to part C? Explain why or why not?
Wheel has two other possible investment opportunities, which are mutually exclusive, and independent of Investment A above. Both investments will cost $120,000 and have a life of 6 years. The after tax cash flows are expected to be the same over the six year life for both projects, and the probabilities for each year’s after tax cash flow is given in the table below.
Investment B Investment C
Probability After Tax Cash Flow Probability After Tax Cash Flow
0.25 $20,000 0.30 $22,000
0.50 32,000 0.50 40,000
0.25 40,000 0.20 50,000
What is the expected value of each project s annual after tax cash flow? Justify your answers and identify any conflicts between the IRR and the NPV and explain why these conflicts may occur.
Assuming that the appropriate discount rate for projects of this risk level is 8%, what is the risk-adjusted NPV for each project? Which project, if either, should be selected? Justify your conclusions.