You own a 2000 square foot home and your usual power costs (payable to CPS Energy) are $150 per month. Of these total power costs, 50% of the billing costs are due to lighting with incandescent bulbs and the rest of the costs are attributable to air-conditioning, appliance use and so on. You need to replace all the 50 light bulbs at your home right away. The choice is to either buy and continue using incandescent light bulbs (each costs $1) or buy the newer energy efficient bulbs that cost $10 each. The newer energy efficient bulbs will reduce the CPS power bill costs for the lighting component by 40%. These new bulbs have a life of 10 years. On the other hand, incandescent bulbs last 5 years and will need to be replaced again after 5 years. a. What is the NPV and IRR of the light bulb replacement project if your required return on your investment is 8% a year (opportunity cost if you had placed this money in a balanced mutual fund)? b. Draw an NPV profile that illustrates the NPV and IRR of the project. c. How will the NPV change if your estimated savings on the lighting part of the power are 20% instead of 40% for the lighting component? E F D Walmart Target 59.84 68.20 63.34 59.00 65.83 60.35 65.78 65.12 64.40 60.67 65.46 59.84 63.55 63.93 59.89 67.30 63.47 56.66 62.74 61.01 64.84 51.64 65.89 48.94 69.23 72.38 49.53 48.91 70.16 46.88 74.15 50.80 72.37 48.88 72.89 53.50 81.45 90.70 53.52 54.30 59.77 92.12 68.90 99.97 84.41 83.44 69.07 64.12 83.45 67.05 77.87 67.32 A 1 Date 2 1-Apr-16 3 1-May-16 4 1-Jun-16 5 1-Jul-16 6 1-Aug-16 7 1-Sep-16 1-Oct-16 9 1-Nov-16 10 1-Dec-16 11 1-Jan-17 12 1-Feb-17 13 1-Mar-17 14 1-Apr-17 15 1-May-17 16 1-Jun-17 17 1-Jul-17 18 1-Aug-17 19 1-Sep-17 20 1-Oct-17 21 1-Nov-17 22 1-Dec-17 23 1-Jan-18 24 1-Feb-18 25 1-Mar-18 26 1-Apr-18 27 1-May-18 28 1-Jun-18 29 1-Jul-18 30 1-Aug-18 31 1-Sep-18 32 1-Oct-18 33 1-Nov-18 34 1-Dec-18 35 1-Jan-19 36 1-Feb-19 37 1-Mar-19 38 1-Apr-19 39 1-May-19 40 1-Jun-19 41 1-Jul-19 42 1-Aug-19 43 1-Sep-19 44 1-Oct-19 45 1-Nov-19 46 1-Dec-19 47 1-Jan-20 48 1-Feb-20 49 1-Mar-20 50 1-Apr-20 51 1-May-20 52 1-Jun-20 53 1-Jul-20 54 1-Aug-20 55 1-Sep-20 B S&P500 2,065.30 2,096.95 2,098.86 2,173.60 2,170.95 2.168.27 2,126.15 2,198.81 2,238.83 2,278.87 2,363.64 2,362.72 2,384.20 2,411.80 2,423.41 2,470.30 2,471.65 2,519.36 2,575.26 2,647.58 2,673.61 2,823.81 2,713.83 2,640.87 2,648.05 2,705.27 2,718.37 2,816.29 2,901.52 2,913.98 2.711.74 2,760.17 2,506.85 2,704.10 2,784.49 2,834.40 2,945.83 2,752.06 2,941.76 2,980.38 2,926.46 2,976.74 3,037.56 3,140.98 3,230.78 3,225.52 2,954.22 2,584.59 2,912.43 3,044.31 3,100.29 3.271.12 3,500.31 3,363.00 81.31 70.90 75.15 84.71 91.00 81.50 82.81 89.67 95.75 78.51 93.24 66.61 62.56 88.94 92.00 69.10 95.04 68.76 93.63 76.64 73.93 99.26 97.91 76.82 107.21 107.11 83.45 83.25 110.87 103.14 103.80 115.73 114.34 103.80 121.38 116.13 115.88 125.22 108.16 112.14 105.47 100.60 111.29 91.32 119.58 107.79 122.05 120.16 118.36 118.43 127.87 124.30 137.21 138.82 149.31 156.22 Sheet1 + B C D E 156.22 138.82 137.67 151.05 151.60 178.16 3,363.00 3,269.96 3,621.63 3,756.07 3,714.24 3,811.15 3,943.34 143.03 139.91 129.38 175.90 180.53 182.79 131.82 188.04 55 1-Sep-20 56 1-Oct-20 57 1-Nov-20 58 1-Dec-20 59 1-Jan-21 60 1-Feb-21 61 1-Mar-21 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 Sheet1