Is there a way to calculate the irr for each alternative

Assignment Help Other Subject
Reference no: EM13898699

Report - Midwestern Hospital Association, Inc.

Midwestern Hospital Association, Inc. is interested in upgrading its nursing tower facilities in response to technological obsolescence, rising energy and maintenance costs, and increasing staffing costs. There are three alternatives under consideration. These alternatives include: remain in existing nursing towers (do nothing), renovate the existing facilities, or build new nursing towers. The estimated costs of the three alternatives are as follows:

Alternative 1- Remain in existing nursing towers Cost, $
Replace air-handling units within 5 years 2,000,000
Re-roof nursing towers - 10 years 250,000
Nursing tower value 0%
Annual energy consumption 850,000
Maintenance/repair costs per year 1,250,000
Nursing staff annual costs 7,776,000


Alternative 2- Renovate nursing towers [200,000 gross square feet (GSF)] Cost, $ 
Renovation construction cost 50/GFS
Re-roof nursing towers in 10 years 250,000
Nursing tower value assumed in 25 years (salvage) 0%
Estimated annual energy costs 750,000
Maintenance/repair costs per year  1,100,000
Nursing staff annual costs 6,480,000


Alternative 3- Build new nursing towers (180,000 GSF) Cost, $
New construction cost 120/GSF
Demolish existing nursing towers 5/GSF
Nursing toer value assumed in 25 years (salvage) 50%
Estimated annual energy costs 650,000
Maintenance/repair costs per year  800,000
Nursing staff annual costs 5,180,000

The hospital's Sr. Vice President of Facilities requested that you, the Construction Manager, provide a recommendation regarding the alternative of choice. You must perform a life cycle cost analysis by computing both the Present Worth (PW) and the Equivalent Annual Worth (EAW) or Costs (EAC). The economic criteria for the analysis are as follows:

  • Project life cycle                25 years
  • Interest Rate                     10% compounded annually
  • Inflation approach              Constant dollars
  • Staffing costs escalation      5% per year

Report shall be exactly five pages (excluding cover) comprehensively addressing your analysis and subsequent decision.  Report can include your spreadsheet analysis and any other graphics that will explain and support your decision. Content copied from Excel should include data blocks and cash flow tables. Other acceptable graphics include charts generated in Excel graphically depicting cash flows or sensitivity analysis The narrative should properly frame the problem, describe the life cycle cost (LCC) analysis processes viewed in terms of both present worth and equivalent annual worth, address the nature of the LCC variables, and the risks introduced by variability. State and defend your recommendation for the selected alternative. Is there a way to calculate the IRR for each alternative? If so, is it meaningful or appropriate? Can benefit/cost ratios be computed for the three alternatives? Can discounted payback periods be computed for the alternatives? Are there other considerations that may not be as easily quantifiable, but should be considered nonetheless?

Verified Expert

The solution is on a hospital's intention to make decision as to whether to construct a new tower, renovate the existing or have the status quo. The project has been done in Microsoft Excel

Reference no: EM13898699

Questions Cloud

Which of the distributions is closest to describing the us : Answer the Question on the basis of the following Census data. Which of the above distributions is closest to describing the United States? A, B, C, or D.
What discount rate would environmental groups argue : Suppose an environmental regulation costs $400,000 today (one time payment) and would save $1 million worth of health costs 20 years from now. a) Would you recommend the program at a discount rate of 0%? 2%? 10%? b) Which discount rate would industry..
Census data indicate : Census data indicate that, as of 2008, the top fifth of all households receive about ________ times as much income as the bottom fifth
Puts out products at an initial price : A local department store puts out products at an initial price, and every week the product goes unsold its price is discounted by 25% of the original price. If it is not sold after 4 weeks, it is sent back to the warehouse.
Is there a way to calculate the irr for each alternative : State and defend your recommendation for the selected alternative. Is there a way to calculate the IRR for each alternative? If so, is it meaningful or appropriate? Can benefit/cost ratios be computed for the three alternatives? Can discounted ..
Production process using two inputs labor and capital : A production process using two inputs, labor and capital, can be written as:  Determine the least cost combination of L and K if the firm decides to produce 1,000 tons per day. What is the total cost of producing $1,000 tons per day?
A good is not depletable : A good is not depletable if:
What would be the nonpecuniary cost of legislation : From California to New York, legislative bodies across the United States are considering eliminating or reducing the surcharges that banks impose on noncustomers, who make $14 million in withdrawals from other banks’ ATM machines. what would be the n..
Relationship between total revenue and average revenue : Define and explain the relationship between total revenue, average revenue, and marginal revenue for a monopolist. What is monopoly profit? Should a monopolist produce quantities of product greater than that which would maximize profits?

Reviews

inf898699

3/22/2017 5:58:33 AM

Please see the Excel for clarification. Please explain the questions asked and return email with explanations. The formula for getting the 0.99 is given there I guess that answers the question what it is and where from. As of the NPV or EAC it is EAC because it is close to impossible to calculate npv without the expected return.

Write a Review

Other Subject Questions & Answers

  Strenghts of cognitive behavioral therapy

Are there limitations and strenghts of Cognitive Behavioral Therapy?

  The culmination of an american space program lasting

This time period saw the landing of a man on the Moon as the culmination of an American space program lasting over two decades. How were domestic and international politics involved in the original decision to land a man on the Moon

  You are a network consultant for the newsroom of the

you are a network consultant for the newsroom of the franklin daily herald a newspaper in a midwestern city. the

  Mission statement for the millersville federal credit union

The Millersville Federal Credit Union has been serving theMillersville, Pennsylvania and adjoining areas for more than 43 years. Established in 1963, they were originallychartered to serve the banking needs of Millersville University faculty, adminis..

  How could the limitations or delimitations be mitigated

Discuss the limitations and delimitations of this study. If you were to decide a follow-up study, how could the limitations or delimitations be mitigated in a future study

  Discuss ethical and legal implications of using technology

Discuss any ethical, legal, and security implications of using technology to create and share numerical data.

  Original persuasive speech-leading with honor

I need an original persuasive speech outline for the topic "Leading with Honor" (cited according). Essentials of Public Speaking chapters 7 and 8 by Cheryl Hamilton is our textbook if this helps.

  Behavioral vs. cognitive-behavioral perspectives

Jake is performing below grade level in school in reading and was just retained at the end of his 3rd grade year. His parents are concerned and want to understand why Jake seems to be “struggling.” They have started to become frustrated and feel t..

  Effect of the sexual counterrevolution

The effect of the sexual counterrevolution was- to keep sex only within marriage. to finally close the historical "double standard. to encourage people to limit their number of sexual partners or, in some cases, to abstain from sex entirely. to disco..

  Calculate total_months_of_age

I need help creating a desk checking table from the following solution: Calculate Total_Months_of_Age. IF Years NOT = 9999 OR Months NOT = 9999 Set TotalMonths to Years * 12 and add it to ‘months’ IF TotalMonths > 500

  Features about the kingdom of god

Explain how each story explains important features about the kingdom of God that Jesus was bringing to the Jewish people.

  Describes the use of social influence to cause

What process describes the use of social influence to cause other people to change their attitudes and behavior?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd