90.2K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer