Problem 13-24 Internal Rate of Return; Sensitivity Analysis (LO2] Dr. Heidi Black is the managing partner of the Crestwood Dental Clinic. Black is trying to determine whether or not the clinic should move patient files and other items out of a spare room in the clinic and use the room for dental work. She has determined that it would require an investment of $142,950 for equipment and related costs of getting the room ready for use. Based on receipts being generated from other rooms in the clinic, Black estimates that the new room would generate a net cash inflow of $35,390 per year. The equipment purchased for the room would have a seven-year estimated useful life. 20 points eBook Required: (Ignore income taxes.) References 1. Compute the IRR on the equipment for the new room to the nearest whole percentage point. Verify your answer by computing the net present value of the equipment using the IRR you have computed as the discount rate. (Hint: Use Microsoft Excel to calculate the discount factor(s).) (Do not round intermediate calculations and round your final answers to the nearest whole value. Negative amount should be indicated by a minus sign.) IRR Net present value 2. Assume that Black will not purchase the new equipment unless it promises a return of at least 14%. Compute the amount of annual cash inflow that would provide this return on the $142,950 investment. (Hint: Use Microsoft Excel to calculate the discount factor(s).) (Do not round intermediate calculations and round your final answers to the nearest dollar amount.) Annual cash inflow 3-a. Although seven years is the average life for dental equipment, Black knows that due to changing technology, this life can vary substantially. Compute the IRR to the nearest whole percentage point if the life of the equipment were (a) five years and (b) nine years, rather than seven years. (Hint: Use Microsoft Excel to calculate the discount factor(s).) (Do not round intermediate calculations and round your final answers to the nearest whole number. IRR 20 points Five years Nine years % eBook References 3-b. Is there any information provided by these computations that you would be particularly anxious to show Black? Yes O No 4. Black is unsure about the estimated $35,390 annual cash inflow from the room. She thinks that the actual cash inflow could be as much as 10% greater or less than this figure. a. Assume that the actual cash inflow each year is 10% greater than estimated. Recompute the IRR to the nearest whole percentage point using the seven-year life. (Hint: Use Microsoft Excel to calculate the discount factor(s).) (Do not round intermediate calculations and round your final answers to the nearest whole number.) IRR b. Assume that the actual cash inflow each year is 10% less than estimated. Recompute the IRR to the nearest whole percentage point using the seven-year life. (Hint. Use Microsoft Excel to calculate the discount factor(s).) (Do not round intermediate calculations and round your final answers to the nearest whole number.) IRR 5. Refer to the original data. Assume that the equipment is purchased and that the room is opened for dental use. However, due to an increasing number of dentists in the area, the clinic is able to generate only $30,000 per year in net cash receipts from the new room. At the end of five years, the clinic closes the room and sells the equipment to a newly licensed dentist for a cash price of $61,375. Compute the IRR to the nearest whole percentage point that the clinic earned on its investment over the five-year period. (Hint. Use Microsoft Excel to calculate the discount factor(s). A useful way to proceed is to find the discount rate that will cause the net present value of the investment to be equal to, or near, zero). (Do not round intermediate calculations and round your final answers to the nearest whole number.) IRR I %
