Land opportunity cost, accounting assignment help

User Generated

zxryyl26

Business Finance

Description

5. WORST CASE SCENARIO

0

1

2

3

4

5

Land opportunity cost

(500,000)

Building

(10,000,000)

Net revenues

3,750,000

3,862,500

3,978,375

4,097,726

4,220,658

Less labor cost

800,000

824,000

848,720

874,182

900,407

Utilities

50,000

51,500

53,045

54,636

56,275

Supplies

1,500,000

1,545,000

1,591,350

1,639,091

1,688,263

Incremental overhead

36,000

37,080

38,192

39,338

40,518

Net income

1,364,000

1,404,920

1,447,068

1,490,480

1,535,194

Plus : net land salvage value

500000

Plus : net bldng/eqp value

3000000

Net cash flow

(10,500,000)

1,364,000

1,404,920

1,447,068

1,490,480

5,035,194

NPV = $ (2,867,228.81)

IRR 0.62%.

Payback period 4.95.

Best case scenario.

best case

0

1

2

3

4

5

Land opportunity cost

(500,000)

Building

(10,000,000)

Net revenues

6,250,000

6,437,500

6,630,625

6,829,544

7,034,430

Less labor costs

800,000

824,000

848,720

874,182

900,407

Utilities

50,000

51,500

53,045

54,636

56,275

Supplies

2,500,000

2,575,000

2,652,250

2,731,818

2,813,772

Incremental overhead

36,000

37,080

38,192

39,338

40,518

Net income

2,864,000

2,949,920

3,038,418

3,129,570

3,223,457

Plus : net land salvage value

500000

Plus : net building/equipment value

7000000

Net cash flow

(10,500,000)

2,864,000

2,949,920

3,038,418

3,129,570

10,723,457

NPV $ 5,620,356.65

IRR 25.11%

Payback period 3.86.

Expected NPV = 70%* 1,376,563.92 + 15%*5,620,356.65 + 15 %*( 2,867,228.81) =$1,376,563.92.

Unformatted Attachment Preview

Copyright  2013 6/15/12 Case 5 Twin Falls Community Hospital (Capital Investment Analysis) 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. 1 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. 2 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 Land opportunity cost Building/equipm ent cost Net revenues Less: Labor costs Utilities costs Supplies Increm ental overhead Net incom e Plus: Net land salvage value Plus: Net building/equipm ent salvage value Net cash flow 0 ($500,000) (10,000,000) ($10,500,000) 3 1 2 3 $5,000,000 800,000 50,000 2,000,000 36,000 $2,114,000 $5,150,000 824,000 51,500 2,060,000 37,080 $2,177,420 $5,304,500 848,720 53,045 2,121,800 38,192 $2,242,743 $2,114,000 $2,177,420 $2,242,743 QUESTIONS 1. Complete Table 1 by adding the cash flows for Years 4 and 5. 2. What is the project’s payback, NPV, and IRR? Interpret each of these measures. 3. Suppose that the project would be allocated $10,000 of existing overhead costs. Should these costs be included in the cash flow analysis? Explain. 4. It is likely that many of the procedures at the outpatient surgery center would have otherwise been performed at the hospital’s inpatient surgery unit. How should the analysis incorporate the cannibalization of inpatient surgeries? Would the handling of cannibalization change if you believed that the local physicians were going to open an outpatient surgery center of their own? (Only discuss the issues here---no numbers required.) 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? 6. Now assume that the project is judged to have high risk. Furthermore, the hospital’s standard procedure is to use a 3 percentage point risk adjustment. What is the project’s NPV after adjusting for the assessment of high risk? 7. What is your final recommendation regarding the proposed outpatient surgery center? 4 Case Study 5 - Group 3 Partial Cash Flow Analysis 0 Land Opportunity Cost ($500,00) Building / Equipment Cost ($1,000,000) Net Revenues Less: Labor Costs Utilities Costs Supplies Incremental Overhead Net Income 1 2 3 4 5 5,000,000 5,150,000 5,304,500 5,463,635 5,627,544 800,000 824,000 848,720 874,182 900,407 50,000 51,500 53,045 54,636 56,275 2,000,000 2,060,000 2,121,800 2,185,454 2,251,018 36,000 37,080 38,192 39,338 40,518 2,114,000 2,177,420 2,242,743 2,310,025 2,379,326 Plus: Net land salvage value 500,000 Plus: Net building / equipment salvage value Net Cash Flow 5,000,000 (10,500,000) (8,386,000) (6,208,580) (3,965,837) (1,655,812) 7,879,326 2. Payback = (Net Cash Flow Year 4 / Net Cash Flow Year 5) Payback = 1,655,812 / 7,879,326 = .2, Since we start making an actual profit after payback in between years 4 and 5, the payback is 4.2 years. NPV Year 1: 2,114,000 X .909 = 1,921,626 Year 2: 2,177,420 X .826 = 1,798,549 Year 3: 2,242,743 X .751 = 1,684,300 Year 4: 2,310,025 X .683 = 1,577,747 Year 5: 2,379,326 X .621 = 1,477,561 (Salvage value) 5,500,000 X .621 = 3,415,500 11,875,283 - 10,500,000 = 1,375,283 The greater the NPV, the more financially appealing the project becomes. Since our NPV is a high, positive value, the proposed outpatient surgery project seems as if it will be very profitable. IRR The internal rate of return measures the percentage profitability and helps determine whether the project is financially attractive or not. The IRR calculated is 17%, which means that the project will generate a 17% rate of return on its initial investment. Since the internal rate of return of 17% exceeds the 10% cost of capital, there is an expected surplus after payback. This leads to the belief that the proposed outpatient surgery center will enhance Twin Falls’ financial condition. 3. If we allocate 10,000 of existing overhead cost then we should not consider that value in our NPV calculation since that cost is irrelevant in case of project evaluation. This overhead cost has already occurred and could not be recovered known as sunken cost. 4. To handle the cannibalization of inpatient surgeries, the net loss in the inpatient surgeries should be taken into account. Though the inpatient surgery’s financials will be negatively impacted the overall impact on the hospital will still be positive, as the demand of outpatient surgeries is higher. Hence we need to incorporate the loss figures of inpatient surgery, due to shifting of the patient from the inpatient surgery to the physician’s facility. If the local physicians were going to open an outpatient surgery center of their own, then cannibalization would need analysis on a much deeper level to pinpoint which physicians are cannibalizing our business the most, and have outpatient surgery facilities. Hence, we need to assess extent of cannibalization and related losses to the hospital, individually for physicians that have their outpatient surgery center in place. If the hospital is sure about cannibalization and there is no competitor then cannibalization cost need to be considered while project evaluation but if the competitor is about to launch similar project then cannibalization cost should not be considered since this cannibalization will happen anyway by means of competition and should not affect the evaluation of the project. 5. Could have 25 procedures(best) per day but could have 15(worst) but on average 20 procedures(most likely) would be done per day. Will have a negative number for the worst case scenario and will probably have a high number for the best case scenario 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? Partial Cash Flow Analysis (Expected) 0 Land Opportunity Cost ($500,00) 1 2 3 4 5 Building / Equipment Cost ($1,000,000) Net Revenues Less: Labor Costs Utilities Costs Supplies Incremental Overhead Net Income 5,000,000 5,150,000 5,304,500 5,463,635 5,627,544 800,000 824,000 848,720 874,182 900,407 50,000 51,500 53,045 54,636 56,275 2,000,000 2,060,000 2,121,800 2,185,454 2,251,018 36,000 37,080 38,192 39,338 40,518 2,114,000 2,177,420 2,242,743 2,310,025 2,379,326 Plus: Net land salvage value 500,000 Plus: Net building / equipment salvage value 5,000,000 Net Cash Flow (10,500,000) (8,386,000) (6,208,580) (3,965,837) (1,655,812) 7,879,326 Partial Cash Flow Analysis (Best Case Scenario) 0 Land Opportunity Cost ($500,00) Building / Equipment Cost ($1,000,000) Net Revenues Less: Labor Costs Utilities Costs Supplies Incremental Overhead Net Income Plus: Net land salvage value Plus: Net building / equipment salvage value 1 2 3 4 5 5,000,000 5,150,000 5,304,500 5,463,635 5,627,544 800,000 824,000 848,720 874,182 900,407 50,000 51,500 53,045 54,636 56,275 2,000,000 2,060,000 2,121,800 2,185,454 2,251,018 36,000 37,080 38,192 39,338 40,518 2,114,000 2,177,420 2,242,743 2,310,025 2,379,326 500,000 5,000,000 Net Cash Flow (10,500,000) (8,386,000) (6,208,580) (3,965,837) (1,655,812) 7,879,326 Partial Cash Flow Analysis (Worst Case Scenario) 0 Land Opportunity Cost ($500,00) Building / Equipment Cost ($1,000,000) Net Revenues Less: Labor Costs Utilities Costs Supplies Incremental Overhead Net Income 1 2 3 4 5 5,000,000 5,150,000 5,304,500 5,463,635 5,627,544 800,000 824,000 848,720 874,182 900,407 50,000 51,500 53,045 54,636 56,275 2,000,000 2,060,000 2,121,800 2,185,454 2,251,018 36,000 37,080 38,192 39,338 40,518 2,114,000 2,177,420 2,242,743 2,310,025 2,379,326 Plus: Net land salvage value 500,000 Plus: Net building / equipment salvage value Net Cash Flow 5,000,000 (10,500,000) (8,386,000) (6,208,580) (3,965,837) (1,655,812) 7,879,326
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Running head: NPV CALCULATIONS FOR BEST AND WORST CASE SCENARIOS

Calculations
Student’s Name:
Prof’s Name:
University Affiliation:
Course Title:
Date:

1

NPV CALCULATIONS FOR BEST AND WORST CASE SCENARIOS

Worst case scenario
NPV= Total PV – Initial cost outlay
Present value (PV) = Discounting rate or return * the present net income
Discounting rate of return= the proportion of the present income to the previous net income.
PV Year 1: 1,364,000 * 90.9% = 1,239,876
Year 2: 1,404,920 * 82.6% = 1,160,464

Year 3: 1,447,068 * 75.1% =1,086,748
Year 4: 1,490,480 * 68.3% = 1,017,998
Year 5: 1,535,194 * 62.1% = 953,356
Salvage value: (500,000 + 3,000,000) *...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags