Question

In: Economics

Just because a​ project's payback period is relatively long​ doesn't mean it is not profitable in...

Just because a​ project's payback period is relatively long​ doesn't mean it is not profitable in the long run. Consider an investment in LED lights with a price tag of $226,000. The estimated annual savings in electricity and routine maintenance is $40,900 and the life of the LED lights is 21 years. Assume that the payback period of three years or less is desired by the investor.

a. What is the simple payback period for the​ lights? (I already know answer is 5.5 years don't bother doing this.)

b. What is the IRR of this​ investment? (Show work on Chegg or paper but not excel and make sure answer is correct.)

c. What do you conclude from Part ​(a) and Part (b)​?

Solutions

Expert Solution

Initial Investment = $226,000

Annual Savings = $40,900

Life = 21years

a. What is the simple payback period for the​ lights? (I already know answer is 5.5 years don't bother doing this.)

Initial investment = $226,000

Annual Savings = $40,900

Simple payback period = Investment / Annual Savings

Simple payback period = $226,000/$40,900=5.5 years

Desired Payback period = 3 years

As the actual payback period is more than the desired payback period, the project should not be accepted. It must be rejected.

b. What is the IRR of the investment?

Using the trial and error method for the calculation of IRR

Let interest rate is 15%.

At 15% the NPW of the above cash flow series will be

NPW = -$226,000 + $40,900 (P/A, 15%, 21)

NPW = -$226,000 + $40,900 (6.3125) = 32,181

As the NPW is positive, increase the rate of interest to get negative NPW. Increase the rate of interest to 18% and calculate the NPW at 18%.

NPW = -$226,000 + $40,900 (P/A, 18%, 21)

NPW = -$226,000 + $40,900 (5.3837) = -5,807

Using interpolation

IRR = 15% + [32,181 – 0 ÷ 32,181 – (-5,807)]*3% = 17.5%

IRR of the investment will be 17.5%

c. What do you conclude from Part ​(a) and Part (b)​?

From part (a)

Desired Payback period = 3 years

As the actual payback period is more than the desired payback period, the project should not be accepted. It must be rejected.

From part (b)

IRR calculated above = 17.5%

But MARR is not given in the question. Unless MARR we cannot justify whether the project is acceptable or not. However, the simple payback period assumes that the investment should be recovered within three years which the investment is not able to do. By seeing the cash flows of the first three years it can be seen that the PW for the first three years savings will be less than the PW of the cash outflows (initial investment). So project cannot be acceptable.

However, without the MARR, the acceptability of the project cannot be determinable.


Related Solutions

The project's payback period is:
A project has the following cash flows: Year 0 1 2 3 4 Cash flow ($240,000) $60,000 $100,000 $60,000 $80,000 The project's payback period is: a. four years b. three and one-half years c. three and one-quarter years d. none of the above
UK's Current fiscal and monetary policy, it doesn't have to be too long, I just need...
UK's Current fiscal and monetary policy, it doesn't have to be too long, I just need some helpful sources and several notable points, thx
long explanation: Can fundamental analysis be profitable, or market just too efficient to justify the effort?...
long explanation: Can fundamental analysis be profitable, or market just too efficient to justify the effort? Being familiar with P/E ratios by now, what has happened to the values for the other relative valuation ratios – that is, the P/BV, P/CF, and P/S ratios?
Consider the following project. Using Discounted Payback Period method (10% rate), how long will it take...
Consider the following project. Using Discounted Payback Period method (10% rate), how long will it take to recover the investment? Year 0 1 2 3 4 5 6 Investment -4000 Profit 1100 1100 1100 1100 1100 1100
Just because two or more values are different does not mean that they are different in...
Just because two or more values are different does not mean that they are different in a statistically significant manner. Researchers rely on the p values that are generated for each of their statistical tests to determine significance. If the p value is larger than the alpha, then they are not different in a statistically significant manner, and therefore the values are not considered different. In this journal activity, consider these concepts in terms of the differences between null and...
Briefly describe the four following methods for evaluating a long-term project: Payback Period Net Present Value...
Briefly describe the four following methods for evaluating a long-term project: Payback Period Net Present Value (NPV) Internal Rate of Return (IRR) Profitability Index (PI) Why might a manager choose to evaluate a potential investment using Net Present Value (NPV) rather than Payback Period? What are a few weaknesses of Payback Period?
Over a very long period of time, a sheriff determines the mean vehicle speed on a...
Over a very long period of time, a sheriff determines the mean vehicle speed on a road is 67 miles per hour, the standard deviation is 3 miles per hour. Treat this as the population, not a sample. If the speed limit is 60 miles per hour, what percentage of the vehicles exceed the speed limit? The sheriff cracks down on speeders. His deputies ignore any vehicles going less than 63 mph, and issue warnings to those going between 63...
Under monopolistic competition, the long period firm demand curve is theoretically problematical because of interdependency. How...
Under monopolistic competition, the long period firm demand curve is theoretically problematical because of interdependency. How is this problem resolved?
Under monopolistic competition, the long period firm demand curve is theoretically problematical because of interdependency. How...
Under monopolistic competition, the long period firm demand curve is theoretically problematical because of interdependency. How is this problem resolved?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT