1 Net Present Value Economic Analysis for Building Operation and Maintenance 2 16 17 18 19...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1 Net Present Value Economic Analysis for Building Operation and Maintenance 2 16 17 18 19 20 year install energy 21 cost savings 3 Analysis of conservation measure with a positive impact on worker productivity 4 5 life cycle of investment (years) 6 installation cost ($) 7 first year energy savings ($) 8 annual maintenance/repair costs ($) 9 annual personnel cost ($) 10 # of employees 11 salary escalation rate (%) 12 energy escalation rate (%) 13 repair/maintenance escalation rate (%) 14 discount rate (%) 15 change in work productivity (%) 15 -55,000 7,500 -500 75,000 20 3 5 2 7 0 Cash Flow in Year of Occurrence change in repair & worker maintenance productivity cash flow compund interest n 1 yearly 12 monthly 52 weekly 365 daily total annual present value total annual daily weekly monthly yearly cumlative year 22 $ $ $ $ 23 24 25 26 27 28 29 0123456 -55,000 0 0 0 0 $ -55,000 value $ -55,000 -55,000 0 -55,000 -55,000 -55,000 -55,000 0 0 0 0 0 30 7 0 31 8 0 32 9 0 33 10 0 34 11 0 35 12 0 36 13 0 37 14 0 38 15 0 39 40 net presents value of life-cycle cah flows: 41 Enter EMULATED VALUES NPV + Accessibility: Investigate + 100% Use the spreadsheet you have developed to evaluate the Net Present Value of the economic case below. Each element of what is listed below must be entered at the appropriate location on the spreadsheet. 1. An energy conservation option has a first cost of $55,000. It requires $500 per year in maintenance and saves $7,500 in utilities. 2. The option will last 15 years with no salvage value. The following interest rates apply: energy cost escalation of 5% annually maintenance cost escalation of 2% annually salary escalation of 3% annually 3. The discount rate for the NPV analysis is 7% and is compounded daily. 4. The energy conservation option is in a building with 20 occupants who have an average personnel cost of $75,000 annually. Assume initially that the investment has no impact on worker productivity. Step 3 - Investigate different scenarios for worker productivity Investigate the importance of worker productivity on economic payback by using the spreadsheet to look at three scenarios: 0% change in worker productivity (energy conservation measure has no impact on worker productivity) +0.2% (energy conservation measure improves worker productivity) -0.2% (energy conservation measure hurts worker productivity) 1 Net Present Value Economic Analysis for Building Operation and Maintenance 2 16 17 18 19 20 year install energy 21 cost savings 3 Analysis of conservation measure with a positive impact on worker productivity 4 5 life cycle of investment (years) 6 installation cost ($) 7 first year energy savings ($) 8 annual maintenance/repair costs ($) 9 annual personnel cost ($) 10 # of employees 11 salary escalation rate (%) 12 energy escalation rate (%) 13 repair/maintenance escalation rate (%) 14 discount rate (%) 15 change in work productivity (%) 15 -55,000 7,500 -500 75,000 20 3 5 2 7 0 Cash Flow in Year of Occurrence change in repair & worker maintenance productivity cash flow compund interest n 1 yearly 12 monthly 52 weekly 365 daily total annual present value total annual daily weekly monthly yearly cumlative year 22 $ $ $ $ 23 24 25 26 27 28 29 0123456 -55,000 0 0 0 0 $ -55,000 value $ -55,000 -55,000 0 -55,000 -55,000 -55,000 -55,000 0 0 0 0 0 30 7 0 31 8 0 32 9 0 33 10 0 34 11 0 35 12 0 36 13 0 37 14 0 38 15 0 39 40 net presents value of life-cycle cah flows: 41 Enter EMULATED VALUES NPV + Accessibility: Investigate + 100% Use the spreadsheet you have developed to evaluate the Net Present Value of the economic case below. Each element of what is listed below must be entered at the appropriate location on the spreadsheet. 1. An energy conservation option has a first cost of $55,000. It requires $500 per year in maintenance and saves $7,500 in utilities. 2. The option will last 15 years with no salvage value. The following interest rates apply: energy cost escalation of 5% annually maintenance cost escalation of 2% annually salary escalation of 3% annually 3. The discount rate for the NPV analysis is 7% and is compounded daily. 4. The energy conservation option is in a building with 20 occupants who have an average personnel cost of $75,000 annually. Assume initially that the investment has no impact on worker productivity. Step 3 - Investigate different scenarios for worker productivity Investigate the importance of worker productivity on economic payback by using the spreadsheet to look at three scenarios: 0% change in worker productivity (energy conservation measure has no impact on worker productivity) +0.2% (energy conservation measure improves worker productivity) -0.2% (energy conservation measure hurts worker productivity)
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
What is the spring cloud API Gateway and how do you set it up to make a call to the product service via eureka service discovery server? Give me the complete code in detailed steps.
-
Compute the least-squares regression line for predicting power (y) from wind speed (x).
-
At what stage in U.S. trade history did protectionism reach its high point?
-
Which of the following statements regarding passive activity losses is true? a. A net passive activity loss may lx? deducted against wages. b. Losses on rental property are always considered passive....
-
What is the expectations gap?
-
Presented below are account balances for Monterey Hospital. In addition, cash transactions for the year ended December 31, 2012, are summarized in the T-account. Required: Using the information above...
-
Map the EER model of the following databases, to a relational model. Show all integrity types(Clarify your answer by underline the Primary key, and dotted line the Foreign Key. ( Member SSN {PK}...
-
State at least 10 reasons of Software Failure?
-
What are the consequences of the logic of branding to our identities and they way we connect with others?
-
How do we squeeze multiple messages onto a single medium all at the same time? Explain in your own words how that can be done.
-
How might learning about mortgages and taxes help people's daily lives, and if they are in the market for a home, how might the information help them make an informed decision?
-
Briefly define servant leadership as posited by at least one leadership scholar. Explain why you believe servant leadership has been found to foster such significant development and...
-
Imagine violating an interpersonal communication norm (not making any eye contact during a conversation) with individuals with whom you have 3 different levels of relationships. (stranger, friend,...
-
Three months after her divorce from Alex, Blanca has become depressed and increasingly withdrawn. Her son Carlos, age 7, has become a terror around the house and a discipline problem at school. From...
-
On October 1, 2021, Adoll Company acquired 2,600 shares of its $1 par value stock for $38 per share and held these shares in treasury. On March 1, 2023, Adoll resold all the treasury shares for $34...
-
Ray and Maria Gomez have been married 3 years. They live at 1610 Quince Ave., McAllen, TX 78701. Ray works for Palm Oil Corporation and Maria works for the City of McAllen. Maria's Social Security...
-
Jerry made the following contributions during 2012: His synagogue (by check).....................................................$680 The Democratic Party (by check)...
-
Yolanda earns $112,000 in 2012. Calculate the FICA tax that must be paid by: Yolanda:.....................Soc.Sec..................$__________...
-
______________ occur(s) when the speaker should pause but instead fills the silence (umm, ahh).
-
Identify an election (federal, state, or local) for which a debate was broadcast. Analyze how the different speakers were able to adapt their messages based on the moderators questions and their...
-
___________ refers to your credibility as a presenter as well as the credibility of the information delivered in your presentation.
Study smarter with the SolutionInn App