Question

In: Finance

Two energy saving project have been identified by Company ABC. These potential projects are known as...

Two energy saving project have been identified by Company ABC. These potential projects are known as project
A and 8 . The projects require different investments and costs as indicated in the Table below ..

Financial item OPTION A (million) OPTION B (million)
First cost 5000 700
Economic life in years 10 5
Salvage value 100 150
Annual operating costs 5 10
Major overhaul costs in year 5 20 0
Increase in annual operating costs from year and thereafter 1.5 2
Penalty costs due to environmental
pollution
2 from year five and thereafter 1 annually from year 2 to 5 and thereafter
Savings in annual energy costs 250 300

Company ABC would like to know which project is worth pursuing. Use an internal rate of return method to
establish the most viable project

Solutions

Expert Solution

Cash flow = Savings in annual energy costs - first cost - annual operating cost - penalty cost - major overhaul cost + salvage value

Option A cash flows:

Year (n) 0                     1 2 3 4 5 6 7 8 9 10
First cost          (5,000)
Savings in annual energy costs                250                250                250                250                250                250                250                250                250                250
Annual operating cost with increases            (5.00)            (6.50)            (8.00)            (9.50)          (11.00)          (12.50)          (14.00)          (15.50)          (17.00)          (18.50)
Penalty costs                  (2)                  (2)                  (2)                  (2)                  (2)                  (2)
Major overhaul costs                (20)
Salvage value                100
Cash flow (CF)          (5,000)                245                244                242                241                217                236                234                233                231                330
IRR -10.98%

Option B cash flows:

Year (n) 0                     1 2 3 4 5
First cost              (700)
Savings in annual energy costs                300                300                300                300                300
Annual operating cost with increases          (10.00)          (12.00)          (14.00)          (16.00)          (18.00)
Penalty costs                  (1)                  (1)                  (1)                  (1)
Salvage value                150
Cash flow (CF)              (700)                290                287                285                283                431
IRR 29.80%

IRR for project A = -10.98%

IRR for project B = 29.80%

Project B is the only viable project.

Note: It is not mentioned from year the annual operating costs are increasing. It has been assumed that operating costs start increasing from year 2 onwards.


Related Solutions

Without using excel, solve : A company has identified two mutually exclusive cost saving projects. However,...
Without using excel, solve : A company has identified two mutually exclusive cost saving projects. However, the equipment that will be required to realize the cost savings need an upfront investment of $250 million for both the projects. The annual cost savings expected from project 1 is 15% of the annual revenues and from project 2 is 12% of the annual revenues. The equipment used in both the projects have a useful life of 4 years. The firm has decided...
Two possible projects have beenidentified for potential selection (i.e., Project 1 or Project 2).These...
Two possible projects have been identified for potential selection (i.e., Project 1 or Project 2). These projects should be evaluated based on the following criteria: Strategic fit; Probability of technical success; Financial risk; Potential profit; Strategic leverage; and Recommendations. Using the weighted scoring model and the information provided below, determine which project you should pursue:The weighted project score forProject 1 was calculated to be68.25 (you should check this value to verify that your method is correct).Using the information, evaluate the...
You have two potential investment projects, Project A and Project B. You can take one, but...
You have two potential investment projects, Project A and Project B. You can take one, but not both. The annual cash flows for the two projects are: Year 0 1 2 3 Project A Cash Flow -$50,000 $45,000 $5,000 $5,000 Project B Cash Flow -$50,000 $5,000 $5,000 $50,000 a. Compute the IRR for each project. b) Compute the NPV for each project if the appropriate discount rate is 5%.   Which project would you take, and why? c)  Compute the NPV for each...
You are the CFO of ABC, LLC. You have been given data for two different projects....
You are the CFO of ABC, LLC. You have been given data for two different projects. You can only choose one. Calculate the Net Present Value, Internal Rate of Return, Profitability Index and Pay Back Period for each of the projects. Make a recommendation based on your findings. You must do all calculations in Excel and use formulas. You must also explain why you chose the project. All of this should be on one tab of an excel spreadsheet. Here...
ABC Company is evaluating whether to invest in a projects. The project is a robot that...
ABC Company is evaluating whether to invest in a projects. The project is a robot that will stack the finished goods product on pallets for shipment. Currently, the product is being stacked manually. The robot will cost $1,000,000. The cash inflows for the project are Tear 1: $230,000; Year 2: $180,000; Year 3: $150,000; and Years 4-10: $100,000. Evaluate the investment using the capital budgeting method "Payback Period". The cost of capital for ABC Co. is 8%. Discuss your findings...
ABC Company is considering investing in two mutually exclusive projects, L and S. The two projects’...
ABC Company is considering investing in two mutually exclusive projects, L and S. The two projects’ forecasted cash flows are shown as below. WACC is 10%. Year 0 1 2 3 4 Project L CF ($) -1,000    700 500 200 0 Project S CF ($) -1,200 100 300 800 1,000 a. Calculate the NPVs for both projects. b. Calculate the IRRs for both projects. c. Calculate the Discounted Paybacks for both projects. [Draw a timeline] d. Based on your...
Your firm has identified three potential investment projects. The projects and their cash flows are shown​...
Your firm has identified three potential investment projects. The projects and their cash flows are shown​ here:  ​( Project Cash Flow Today ​(millions) Cash Flow in One Year ​(millions) A −$6 $17 B $3 $6 C $16 −$5 Suppose all cash flows are certain and the​ risk-free interest rate is 7%. a. What is the NPV of each​ project? b. If the firm can choose only one of these​ projects, which should it​ choose? c. If the firm can choose...
Your firm has identified three potential investment projects. The projects and their cash flows are shown​...
Your firm has identified three potential investment projects. The projects and their cash flows are shown​ here: Project Cash Flow Today ​(millions) Cash Flow in One Year ​(millions) A −$7 $17 B $6 $6 C $15 −$14 Suppose all cash flows are certain and the​ risk-free interest rate is 7%. a. What is the NPV of each​ project? b. If the firm can choose only one of these​ projects, which should it​ choose? c. If the firm can choose any...
You are considering an investment in the stock market and have identified two potential stocks
Risk and return You are considering an investment in the stock market and have identified two potential stocks, they are Rio Tinto (NYSE: RIO) and Amazon (NASDAQ: AMZN). The year-end historical prices for the years 2010 to 2018 are shown in the table below. YearRio TintoAmazon201048.51125.41201169.48169.64201260.46194.44201356.47264.27201453.15358.69201544.13354.53201624.65587.00201744.79823.48201856.111450.891. Which stocks would you prefer to own? Would every rational investor make the same choice? Explain your answer(s). 2. Calculate the covariance and correlation coefficient between the two stocks. Does it appear that a portfolio consisting of...
You are considering an investment in the stock market and have identified two potential stocks, they...
You are considering an investment in the stock market and have identified two potential stocks, they are Rio Tinto (NYSE: RIO) and Amazon (NASDAQ: AMZN). The historical prices for the past 10 years are shown in the table below. Year Rio Tinto Amazon 2010 48.51 125.41 2011 69.48 169.64 2012 60.46 194.44 2013 56.47 264.27 2014 53.15 358.69 2015 44.13 354.53 2016 24.65 587.00 2017 44.79 823.48 2018 56.11 1450.89 1. Which stocks would you prefer to own? Would everyone...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT