Data table (Payback period and NPV calculations) Plato Energ oil and gas deposits. The firm is considering two differe The Barnett Shale project requires a much larger initial Shale project also results in additional expenditures in y the wells in order to increase the flow of oil and gas fror x hpany drills shallow wells in hopes of finding significant gion of central Texas and the other is in the Gulf Coast. t opportunity. In addition, the longer life of the Barnett ure involves pumping either water CO2 down into -O s, what does the payback period not consider that is a. What is the payback period for each of the two proje b. Based on the payback periods, which of the two pro important in determining the value creation potential of c. If Plato's management uses a discount rate of 18.6 d. What is your estimate of the value that will be create posed investments? Year Barnett Shale Gulf Coast 0 $(5,200,000) $(1,400,000) 1 2,080,000 900,000 2 2,080,000 900,000 3 (1,040,000) 375,000 4 2,080,000 120,000 5 1,680,000 6 1,680,000 7 1,680,000 8 850,000 9 650,000 10 80,000 (Click on the icon in order to copy its contents into a spreadsheet.) a. Given the cash flow information in the table, the pay Print Done