Question
Monteiro Industries is evaluating whether to invest in solar panels to provide some of the electrical needs of its main office building in Newark, New
Monteiro Industries is evaluating whether to invest in solar panels to provide some of the electrical needs of its main office building in Newark, New Jersey. The solar panel project would cost $700,000 and would provide cost savings in its utility bills of $70,000 per year. It is anticipated that the solar panels would have a life of 20 years and would have no residual value.
1. | Calculate the payback period in years of the solar panel project. |
2. | If the company uses a discount rate of 8%, what is the net present value of this project? |
3. | If the company has a rule that no projects will be undertaken that have a payback period of more than five years, would this investment be accepted? If not, what arguments could the energy manager make to try to obtain approval for the solar panel project? |
4. | What would you do if you were in charge of approving capital investment proposals? |
Present Value of $1 | |||||||||||||
Periods | 1% | 2% | 3% | 4% | 5% | 6% | 8% | 10% | 12% | 14% | 16% | 18% | 20% |
1 | 0.990 | 0.980 | 0.971 | 0.962 | 0.952 | 0.943 | 0.926 | 0.909 | 0.893 | 0.877 | 0.862 | 0.847 | 0.833 |
2 | 0.980 | 0.961 | 0.943 | 0.925 | 0.907 | 0.890 | 0.857 | 0.826 | 0.797 | 0.769 | 0.743 | 0.718 | 0.694 |
3 | 0.971 | 0.942 | 0.915 | 0.889 | 0.864 | 0.840 | 0.794 | 0.751 | 0.712 | 0.675 | 0.641 | 0.609 | 0.579 |
4 | 0.961 | 0.924 | 0.888 | 0.855 | 0.823 | 0.792 | 0.735 | 0.683 | 0.636 | 0.592 | 0.552 | 0.516 | 0.482 |
5 | 0.951 | 0.906 | 0.863 | 0.822 | 0.784 | 0.747 | 0.681 | 0.621 | 0.567 | 0.519 | 0.476 | 0.437 | 0.402 |
6 | 0.942 | 0.888 | 0.837 | 0.790 | 0.746 | 0.705 | 0.630 | 0.564 | 0.507 | 0.456 | 0.410 | 0.370 | 0.335 |
7 | 0.933 | 0.871 | 0.813 | 0.760 | 0.711 | 0.665 | 0.583 | 0.513 | 0.452 | 0.400 | 0.354 | 0.314 | 0.279 |
8 | 0.923 | 0.853 | 0.789 | 0.731 | 0.677 | 0.627 | 0.540 | 0.467 | 0.404 | 0.351 | 0.305 | 0.266 | 0.233 |
9 | 0.914 | 0.837 | 0.766 | 0.703 | 0.645 | 0.592 | 0.500 | 0.424 | 0.361 | 0.308 | 0.263 | 0.225 | 0.194 |
10 | 0.905 | 0.820 | 0.744 | 0.676 | 0.614 | 0.558 | 0.463 | 0.386 | 0.322 | 0.270 | 0.227 | 0.191 | 0.162 |
11 | 0.896 | 0.804 | 0.722 | 0.650 | 0.585 | 0.527 | 0.429 | 0.350 | 0.287 | 0.237 | 0.195 | 0.162 | 0.135 |
12 | 0.887 | 0.788 | 0.701 | 0.625 | 0.557 | 0.497 | 0.397 | 0.319 | 0.257 | 0.208 | 0.168 | 0.137 | 0.112 |
13 | 0.879 | 0.773 | 0.681 | 0.601 | 0.530 | 0.469 | 0.368 | 0.290 | 0.229 | 0.182 | 0.145 | 0.116 | 0.093 |
14 | 0.870 | 0.758 | 0.661 | 0.577 | 0.505 | 0.442 | 0.340 | 0.263 | 0.205 | 0.160 | 0.125 | 0.099 | 0.078 |
15 | 0.861 | 0.743 | 0.642 | 0.555 | 0.481 | 0.417 | 0.315 | 0.239 | 0.183 | 0.140 | 0.108 | 0.084 | 0.065 |
20 | 0.820 | 0.673 | 0.554 | 0.456 | 0.377 | 0.312 | 0.215 | 0.149 | 0.104 | 0.073 | 0.051 | 0.037 | 0.026 |
25 | 0.780 | 0.610 | 0.478 | 0.375 | 0.295 | 0.233 | 0.146 | 0.092 | 0.059 | 0.038 | 0.024 | 0.016 | 0.010 |
30 | 0.742 | 0.552 | 0.412 | 0.308 | 0.231 | 0.174 | 0.099 | 0.057 | 0.033 | 0.020 | 0.012 | 0.007 | 0.004 |
40 | 0.672 | 0.453 | 0.307 | 0.208 | 0.142 | 0.097 | 0.046 | 0.022 | 0.011 | 0.005 | 0.003 | 0.001 | 0.001 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started