In: Finance
Twin Falls Community Hospital is a 250-bed, not-for-profit hospital located
in the city of Twin Falls, the largest city in Idaho’s Magic Valley region
and the seventh largest in the state. The hospital was founded in 1972 and
today is acknowledged to be one of the leading healthcare providers in the
area.
Twin Falls’ management is currently evaluating a proposed ambulatory
(outpatient) surgery center. Over 80 percent of all outpatient surgery is
performed by specialists in gastroenterology, gynecology, ophthalmology,
otolaryngology, orthopedics, plastic surgery, and urology. Ambulatory surgery
requires an average of about one and one-half hours; minor procedures take
about one hour or less, and major procedures take about two or more hours.
About 60 percent of the procedures are performed under general anesthesia, 30
percent under local anesthesia, and 10 percent under regional or spinal
anesthesia. In general, operating rooms are built in pairs so that a patient
can be prepped in one room while the surgeon is completing a procedure in the
other room.
The outpatient surgery market has experienced significant growth since the
first ambulatory surgery center opened in 1970. This growth has been fueled
by three factors. First, rapid advancements in technology have enabled many
procedures that were historically performed in inpatient surgical suites to
be switched to outpatient settings. This shift was caused mainly by advances
in laser, laparoscopic, endoscopic, and arthroscopic technologies. Second,
Medicare has been aggressive in approving new minimally invasive surgery
techniques, so the number of Medicare patients utilizing outpatient surgery
services has grown substantially. Finally, patients prefer outpatient
surgeries because they are more convenient, and third-party payers prefer
them because they are less costly.
These factors have led to a situation in which the number of inpatient
surgeries has grown little (if at all) in recent years while the number of
outpatient procedures has been growing at over 10 percent annually and now
totals about 22 million a year. Rapid growth in the number of outpatient
surgeries has been accompanied by a corresponding growth in the number of
outpatient surgical facilities. The number currently stands at about 5,000
nationwide, so competition in many areas has become intense. Somewhat
surprisingly, there is no outpatient surgery center in the Twin Falls area,
although there have been rumors that local physicians are exploring the
feasibility of a physician-owned facility.
The hospital currently owns a parcel of land that is a perfect location for
the surgery center. The land was purchased five years ago for $350,000, and
last year the hospital spent (and expensed for tax purposes) $25,000 to clear
the land and put in sewer and utility lines. If sold in today’s market, the
land would bring in $500,000, net of realtor commissions and fees. Land
prices have been extremely volatile, so the hospital’s standard procedure is
to assume a salvage value equal to the current value of the land.
The surgery center building, which will house four operating suites, would
cost $5 million and the equipment would cost an additional $5 million, for a
total of $10 million. The project will probably have a long life, but the
hospital typically assumes a five-year life in its capital budgeting analyses
and then approximates the value of the cash flows beyond Year 5 by including
a terminal, or salvage, value in the analysis. To estimate the terminal
value, the hospital typically uses the market value of the building and
equipment after five years, which for this project is estimated to be $5
million, excluding the land value.
The expected volume at the surgery center is 20 procedures a day. The average
charge per procedure is expected to be $1,500, but charity care, bad debts,
insurer discounts (including Medicare and Medicaid), and other allowances
lower the net revenue amount to $1,000. The center would be open five days a
week, 50 weeks a year, for a total of 250 days a year. Labor costs to run the
surgery center are estimated at $800,000 per year, including fringe benefits.
Supplies costs, on average, would run $400 per procedure, including
anesthetics. Utilities, including hazardous waste disposal, would add another
$50,000 in annual costs. If the surgery center were built, the hospital’s
cash overhead costs would increase by $36,000 annually, primarily for
housekeeping and buildings and grounds maintenance.
One of the most difficult factors to deal with in project analysis is
inflation. Both input costs and charges in the healthcare industry have been
rising at about twice the rate of overall inflation. Furthermore,
inflationary pressures have been highly variable. Because of the difficulties
involved in forecasting inflation rates, the hospital begins each analysis by
assuming that both revenues and costs, except for depreciation, will increase
at a constant rate. Under current conditions, this rate is assumed to be 3
percent. The hospital’s corporate cost of capital is 10 percent.
When the project was mentioned briefly at the last meeting of the hospital’s
board of directors, several questions were raised. In particular, one
director wanted to make sure that a risk analysis was performed prior to
presenting the proposal to the board. Recently, the board was forced to close
a day care center that appeared to be profitable when analyzed but turned out
to be a big money loser. They do not want a repeat of that occurrence.
Another director stated that she thought the hospital was putting too much
faith in the numbers: “After all,” she pointed out, “that is what got us into
trouble on the day care center. We need to start worrying more about how
projects fit into our strategic vision and how they impact the services that
we currently offer.” Another director, who also is the hospital’s chief of
medicine, expressed concern over the impact of the ambulatory surgery center
on the current volume of inpatient surgeries
To develop the data needed for the risk (scenario) analysis, Jules Bergman,
the hospital’s director of capital budgeting, met with department heads of
surgery, marketing, and facilities. After several sessions, they concluded
that only two input variables are highly uncertain: number of procedures per
day and building/equipment salvage value. If another entity entered the local
ambulatory surgery market, the number of procedures could be as low as 15 per
day. Conversely, if acceptance is strong and no competing centers are built,
the number of procedures could be as high as 25 per day, compared to the most
likely value of 20 per day. If real estate and medical equipment values stay
strong, the building/equipment salvage value could be as high as $7 million,
but if the market weakens, the salvage value could be as low as $3 million,
compared to an expected value of $5 million. Jules also discussed the
probabilities of the various scenarios with the medical and marketing staffs,
and after a great deal of discussion reached a consensus of 70 percent for
the most likely case and 15 percent each for the best and worst cases.
Assume that the hospital has hired you as a financial consultant. Your task
is to conduct a complete project analysis on the ambulatory surgery center
and to present your findings and recommendations to the hospital’s board of
directors. To get you started, Table 1 contains the cash flow analysis for
the first three years.
Table 1
Partial Cash Flow Analysis
0 1 2 3
Land opportunity cost ($500,000)
Building/equipment cost (10,000,000)
Net revenues $5,000,000 $5,150,000 $5,304,500
Less: Labor costs 800,000 824,000 848,720
Utilities costs 50,000 51,500 53,045
Supplies 2,000,000 2,060,000 2,121,800
Incremental overhead 36,000 37,080 38,192
Net income $2,114,000 $2,177,420 $2,242,743
Plus: Net land salvage value
Plus: Net building/equipment salvage value
Net cash flow ($10,500,000) $2,114,000 $2,177,420 $2,242,743
5. Conduct a scenario analysis. What is its expected NPV? What is the worst and
best case NPVs? How does the worst case value help in assessing the
hospital’s ability to bear the risk of this investment?
SCENARIO ANALYSIS STUDY | ||||||||
Input Data | ||||||||
Inflation rate | 3% | |||||||
Cost of Capital | 10% | |||||||
Rate per Surgery net of charity care,bad debts etc | 1000 | |||||||
No of days planned to undertake surgeries in a year | 250 | |||||||
Variables for most likely,worst case and best case scenarios | ||||||||
Most Likely | worst case | best case | ||||||
No of surgery cases per day | 20 | 15 | 25 | |||||
Salvage Value Building/Equipment | 5000000 | 3000000 | 7000000 | |||||
Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Remarks | ||
Opportunity cost of Land | (500,000) | |||||||
Building/Equipment cost | (10,000,000) | |||||||
Net Revenues ( Most Likely) | 5,000,000 | 5,150,000 | 5,304,500 | 5,463,635 | 5,627,544 | A1 | ||
=250*20*1000 | =5000000*1.03 | =5150000*1.03 | =5304500*1.03 | =5463635*1.03 | ||||
Net Revenues (Worst Case) | 3,750,000 | 3,862,500 | 3,978,375 | 4,097,726 | 4,220,658 | A2 | ||
=250*15*1000 | =3750000*1.03 | =3862500*1.03 | =3978375*1.03 | =4097726*1.03 | ||||
Net Revenues ( Best Case) | 6,250,000 | 6,437,500 | 6,630,625 | 6,829,544 | 7,034,430 | A3 | ||
=250*25*1000 | =6250000*1.03 | =6437500*1.03 | =6630625*1.03 | =6829544*1.03 | ||||
Labour Costs | 800,000 | 824,000 | 848,720 | 874,181.60 | 900,407.05 | B | ||
=848720*1.03 | =874181.60*1.03 | |||||||
Utilities costs | 50,000 | 51,500 | 53,045 | 54,636.35 | 56,275.44 | C | ||
=53045*1.03 | =54636.35*1.03 | |||||||
Supplies (Most Likely) | 2,000,000 | 2,060,000 | 2,121,800 | 2,185,454.00 | 2,251,017.62 | D1 | ||
=250*20*400 | =2000000*1.03 | =2060000*1.03 | =2121800*1.03 | =2185454*1.03 | ||||
Supplies (Worst Case) | 1,500,000 | 1,545,000 | 1,591,350 | 1,639,091 | 1,688,263 | D2 | ||
=250*15*400 | =1500000*1.03 | =1545000*1.03 | =1591350*1.03 | =1639091*1.03 | ||||
Supplies ( Best Case) | 2,500,000 | 2,575,000 | 2,652,250 | 2,731,818 | 2,813,772 | D3 | ||
=250*25*400 | =2500000*1.03 | =2575000*1.03 | 2652250*1.03 | =2731818*1.03 | ||||
Incremental overheads | 36,000 | 37,080 | 38,192 | 39,337.76 | 40,517.89 | E | ||
=38192*1.03 | =39337.76*1.03 | |||||||
Net Income (Most Likely) | 2,114,000 | 2,177,420 | 2,242,743 | 2,310,025 | 2,379,326 | F1=A1-(B+C+D1+E) | ||
(Worst Case) | 1,364,000 | 889,920 | 916,618 | 944,117 | 972,440 | F2=A2-(B+C+D2+E) | ||
( Best Case) | 2,864,000 | 3,464,920 | 3,568,868 | 3,675,934 | 3,786,212 | F3=A3-(B+C+D3+E) | ||
Land Salvage Value | 500,000 | G | ||||||
Building/Equipment Salvage Value (Most Likely) | 5,000,000 | H1 | ||||||
(Worst Case) | 3,000,000 | H2 | ||||||
(Best Case) | 7,000,000 | H3 | ||||||
Net Cash Flows( Most Likely) | (10,500,000) | 2,114,000 | 2,177,420 | 2,242,743 | 2,310,025 | 7,879,326 | F1+G+H1 | |
Net Cash Flows( Worst Case) | (10,500,000) | 1,364,000 | 889,920 | 916,618 | 944,117 | 4,472,440 | F2+G+H2 | |
Net Cash Flows( Best Case) | (10,500,000) | 2,864,000 | 3,464,920 | 3,568,868 | 3,675,934 | 11,286,212 | F3+G+H3 | |
Discount Factor @ 10% | 1 | 0.9091 | 0.8264 | 0.7513 | 0.6830 | 0.6209 | =1/1+r^n | =1/(1+10%)^n |
DCF (Most Likely) | (10,500,000) | 1,921,818 | 1,799,521 | 1,685,006 | 1,577,778 | 4,892,442 | ||
(Net Cash Flow * Discount Factor) | ||||||||
DCF (Worst Case) | (10,500,000) | 1240000 | 735471.0744 | 688668.6702 | 644844.3003 | 2777033.385 | ||
DCF (Best Case) | (10,500,000) | 2603636.364 | 2863570.248 | 2681343.351 | 2510712.41 | 7007849.725 | ||
NPV | Sum(DCF,Yo to Y5) | |||||||
Most Likely Scenario | 1,376,565 | |||||||
Worst case | (4,413,983) | |||||||
Best Case | 7,167,112 | |||||||
Conclusion: The new Ambulatory surgery facility results in a negative NPV in the worst case scenario. However the chance that worst case scenario occur is only 15%. Hence there is 85% probability that the new facility is financially viable and hence the management may consider going forward with this proposal. |