please show how to complete using excel

You own a 2000-square-foot home and your usual power costs (payable to CPS Energy) are $2000 per year. Of these total power costs, 40% 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 50 light bulbs at your home right away. The choice is to either buy and continue using incandescent light bulbs (each costs \$2) 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 of your overall bill by 30% of the initial lighting costs. These new bulbs have a life of 4 years. On the other hand, incandescent bulbs last 2 years and will need to be replaced every 2 years. a. What is the NPV and IRR of the light bulb replacement project if your required return on your investment is 20% 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 IN 3013 Assignment 3 UTSA $40% of the initial lighting costs. d. What is the payback period of the replacement project