Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Young Industries is evaluating whether to invest in solar panels to provide some of the electrical needs of its main panel project would cost $650.000

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Young Industries is evaluating whether to invest in solar panels to provide some of the electrical needs of its main panel project would cost $650.000 and would provide cost savinas in its utility bills of $35.000 per vear. It is antici Reference Present Value of $1 m you tha Periods 1% 2% 3% 4% 5% 6% 8% 10% 12% 14% 15% 18% 20% Period 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 Period 2 0.980 0.961 0.943 0.925 0.907 0.890 0.857 0.825 0.797 0.789 0.743 0.718 0 694 Period 3 0971 0.942 0.915 0.889 0.864 0.840 0.794 0.751 0.712 0.675 0.641 0.609 0.579 Period 4 0.961 0.924 0.888 0.855 0.823 0.792 0.735 0.683 0.636 0592 0.552 0.516 0.482 Period 5 0.951 0.906 0.863 0.822 0.784 0.747 0.681 0.821 0.567 0.519 0.476 0.437 0.402 Period 6 0.942 0.888 0.837 0.790 0.746 0.705 0.630 0.564 0.507 0.458 0.410 0.370 0.335 Period 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 Period 8 0.923 0.853 0.789 0.731 0.677 0.6270.540 0.467 0.4040 3510.305 0.2680.233 Period 9 0.914 0.837 0.766 0.703 0.6450.592 0.500 0.424 0.361 | 0.308 0.263 0.225 0.194 Period 10 0.9050 820 0.744 0678 0.614 0.558 0.463 0.386 0.322 0.270 0227 0.191 0.162 Period 110.896 0.804 0.722 0.650 0.585 0.527 0.429 0.350 0.287 0.237 0.196 0.162 0.136 Period 12 0.887 0.788 0.701 0.625 0.5570.497 0.397 0.319 0.257 0 208 0.168 0.1370.112 Period 130.879 0.773 0.881 0 601 0.530 0.469 0358 0.290 0229 0.182 0.145 0.116 0.093 Period 14 0.870 0.758 0.661 0577 0.505 0.442 0.340 0.263 0.206 0.160 0.125 0.099 0.079 Period 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 Period 20 0.820 0.673 0.554 0456 0.377 0.312 0215 0.149 0.104 0.073 0.051 0.037 0.026 Period 25 0.780 0.610 0.478 0 375 0.295 0233 0.146 0.092 0059 0.038 0.024 0.0160.010 Period 30 0.742 0.552 0.412 03080231 0.174 0.099 0.0570033 0.0200.012 0.007 0.004 Period 40 0.672 0453 0.307 0.208 0.142 0.097 0.048 0.022 0.011 0.005 0.003 0001 0.001 field Print Done mal places.) Reference -X Per Per Per Peri Peric Perio th ob Perlo perio Period Period Period Present Value of Annuity of $1 Periods 1% 2% 3% 4% 5% 6% 8% 10% 12% 14% 16% 18% 20% Period 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 Period 2 1970 1.942 1.913 1.886 1.859 1.833 1.783 1736 1690 1.647 1.605 1.566 1528 Period 3 2.941 2.884 2 829 2.775 2.723 2.673 2.577 2487 2402 2.322 2246 2.174 2106 Period 4 3.902 3.808 3.717 3.630 3.546 3.465 3.312 3.170 3.037 2914 2.798 2.690 2589 Period 5 4.853 4.713 4580 4.452 4.3294212 3.993 3.791 3.605 3.433 3.274 3.127 2.991 Period 6 5.795 5.601 5.417 5.242 50764.917 4.623 4.355 4.111 3.889 3.685 3.498 3.326 Period 7 6.728 6.472 6230 6.002 5.786 5.5825.206 4.868 4,5644 288 4039 3.812 3.505 Periodo 7.652 7325 7020 6.733 6.463 6.210 5.7475 335 4968 4.639 4344 4,078 3.837 period 9 8566 8.16277867435 7 108 6,8026.24757595.3284946 4507 4303 4033 Period 10 9.471 8.983 | 8.530 8.111 7.722 7.360 6.710 6.145 5.650 5216 4.833 4.494 Period 11 10.358 9.7879 253 8.750 8.3067887 7.139 6495 5938 5.453 5029 4656 4327 Period 12 11.255 10.575 9.9549,385 8.86383847.536 5.8146 194 5860 5 197 4.793 4439 period 13 12 134 11 348 10 635 9.986 9.3948853 7.90471036424 5.842 5.342 4.910 4533 Period 14 13.004 12 106 11,296 10.563 9.899 9.2958.24473676.6286.002 5463 5008 4511 Period 15 13 865 12 84911 938 11. 119 10380 9.712 8.559 7.506 6.811 6142 5.576 6092 4675 5929 Period 20 18.046 16 35 14.877 13 590 12 462 11470 9.818 8.5147469 5.623 5353 4870 8097 5.487 4.948 period 25 22 023 19.523 17 413 15 622 14.094 12 783 10 675 9.077 78436873 8117 Perlod 30 25 808 22 396 19.600 17.292 15.372 13.785 112580.427 3.0657003 6.517 4979 7105 Perlod 40 32 835 27 355 23.11519 793 17 159 15 046119250.7798.244 8.233 6.548 4997 Period Period Period Period fie Print Done This Test: 156 pts possible Reference Future Value of $1 1 300 Periods Period 1 Period 2 period 3 Period 4 Period 5 15 010 1028 1.030 041 1051 2% 1020 1040 1061 t082 1104 39 1.030 051 1093 1126 1.159 4% 1040 1082 1125 1170 1211 1126 1149 Period Period 7 Period 8 Period 9 Period 10 062 1,072 083 1094 11105 7.172 1195 1.219 5% 6% 89 10% 12% 14% 10 1050 1050 1080 1 100 1120 1.140 1103 1.124 1.166 1210 1 254 13 1158 1191 1.250 1 331 1 405 1482 1216 1.262 1360 1.464 1 574 1689 18 1275 1338 1469 1 611 1762 192521 1340 1419 1.587 1772 1974 2 19524 1407 1504 1714 1949 2211 252 25 1477 1594 1851 2144 2476 32 1551 1589 1999 2358 2773 3.252 38 1629 1791 2.159 2594 3105 3.707 44 17101898 2332 2853 3479 4 225 1.790 2012 2518 3.138 3.896 480 50 1.385 2133 2720 3452 4353 5492 1980 2251 2937 3.797 4807 6261 70 2079 2397 3.172 4177 5.474 7.130 2653 3207 4651 8.727 9646 13 74319 3388 4292 6848 10.836 17 000 25.46245 4322 5743 10.0631744929960509505 70401020621725 45 250 03.051188094378 1116 11121 1194 1265 1230 1316 1287 1369 1305 1,423 1344 1430 1394 1539 1425 1501 1459 1.685 1513 1732 1558 1801 1 806 2191 2094 2 556 2427 3.243 3 252 4801 128 1149 Period 11 Period 12 Period 13 Period 14 Period 15 period 20 Period 25 Period 30 Period 40 1161 243 1268 1264 319 326 1498 1541 1311 2208 220 1282 7349 1489 Print Done TOM PM 4/15201 20 of 21 (0 complete) Reference - Future Value of Annuity of $1 Periods 1% 2% 3% 4% 5% 6% 8% 10% 12% 14% 16% 18% 20% Period 1 1.000 1.000 1.000 1.000 1 000 1.000 1.000 1 000 1.000 1.000 1.000 1.000 1000 Period 2 2010 2020 2030 2000 2.050 2060 2.080 2.100 2.120 2.140 2.160 2.180 2200 Period 3 3.030 3.060 3.091 3.122 3.153 3.194 3.248 3.310 3.374 3.440 3.506 3.572 3.640 Period 4 4.060 4.122 4.184 4.246 4310 4.375 4.506 4641 4.779 4.921 5.086 5.215 5.368 Period 5 5.101 5.204 5.309 5.416 6.526 5.637 5.867 6.105 6.353 6.610 6.877 7.154 7.442 Period 6 6.152 6.308 6.468 6,633 6.902 6.975 7336 7.716 8. 115 8.536 8977 9.442 9.930 Period 7 7214 7434 7.662 7.898 8.142 8.394 8.923 9.487 10.089 10.730 11.414 12 142 12.916 period 8 8.286 8.583 8,892 9214 9.549 9.897 10.637 11436 12.300 13 233 14240 15.327 16.499 Period 9 9.369 9.755 10.159 10.583 11.027 11.491 12 488 13.579 14.776 16.085 17.519 19,086 20.799 Period 10 10.462 10.950 11464 12.006 12.578 13.18114 48715.937 17.549 19.337 21.321 23.521 25.959 Period 11 11.567 12.16912808 13,488 14 207 14.972 16.645 18.53120655 23.045 25.733 29 755 32 150 Period 12 12.583 13.412 14192 15.026 15.917 16.870 18.977 21 384 24 133 27 271 30.350 34.931 39,581 Period 13 13.80914.68015518 16.627 17.713 18.882 21 495 24.523 28.029 32.009 36.788 42.219 48.497 Period 14 14.947 15 974 17.086 18.292 19 599 21.015 24 215 27 97532.393 37581 43 672 50 818 59.198 Period 15 16 097 17.29318.59920.024 21.579 23.278 27.152 31.772 37.200 43.842 51.880 60.985 72 035 period 2022019 24 297 26.870 29.778 33,066 36.785 45.762 57 275 72.052 91025 115.380 145.628 188,888 Period 25 28 243 3203038 459 41 646 47 727 54.865 73.105 98.347 133 334 181.871 249.214 342.603 471981 Period 30 34 785 40 558 47 575 56,085 56,439 79.058 113.283 166.494 241,333 356.787 630.312 790.948 1.181 382 Period 40 48.888 6040275 401 05.026120.800 154.782259,057 442.593 767 091 1,342 0252360767 4,163 2137.343.858 3 3 Pe 7 8 2 0 Pe Pe Per Per Per Per Peri 13 79 20 05 Print Done peri Peri Young Indontries in 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 projed would cost 3650,000 and would provide cost savings in its utility bills of $35,000 per year. It is anticipated that the solar panels would have a like of 20 years and would have no residual value Read the surements 1 Hegalement 1. Calculate the payback period in years of the solar panel project (Round your awarto wo decimal places) The payback period in years of the solar panel project is Roqulcement 2. the company uses a discount rate of 8%, what is the rat present value of this project? (Round your awer to the nearest whole dallat. Use parentes or The net present value of the projects Requirement 3. In 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 wt because the payback period is than five years Select arguments the energy manager could make Requirement 4. What would you do if you were in charge of approving capital investment proposals? (If an input field is not used in the table, love the input field empty, do not

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Process Modeling Simulation And Design

Authors: Manuel Laguna, Johan Marklund

3rd Edition

1138061735, 978-1138061736

More Books

Students also viewed these Accounting questions