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

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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