5. (15 pts) A feasibility study is being prepared for the site. Calculate the total capital costs, total remediation cost, and Net Present Value cost for the following three scenarios. Provide the results in a single table. Show your work in Excel. For all scenarios a five-year review report must be completed every five years as long until the site is closed; five-year review report cost is $20,000. A site closeout report should be assumed for all scenarios ($15,000). Assume discount rate (i) of 2%. a. Monitored Natural Attenuation (only groundwater sampling) i. Remedial Design Work Plan: $9500 ii. Cost of $55,000 per year for groundwater sampling (labor and analyses), reporting, and project management. iii. Assume duration of 30 years for site closure. b. In-Situ Chemical Oxidation i. Remedial Design Work Plan: $40,000 ii. Injection event cost $330,000 (assume as capital cost) iii. 3 additional injection events that cost $185,000 performed in future year 1, 2, and 3. iv. Groundwater sampling is conducted in future years 4, 5, 6, and 7 to evaluate performance of the remedy. v. Cost of $65,000 per year for groundwater sampling (labor and analyses), reporting, and project management during years that injections are performed. vi. Cost of $40,000 per year for groundwater sampling (labor and analyses), reporting, and project management in years following the injections. vii. Assume site closure achieve in Future Year 7 C. In-Situ Bioremediation i. Remedial Design Work Plan: $40,000 ii. Injection event cost $250,000 (assume as capital cost) iii. One additional injection event that costs $155,000 performed in future year 5. iv. Cost of $65,000 per year for groundwater sampling (labor and analyses), reporting, and project management during years that injections are performed. V. Cost of $40,000 per year for groundwater sampling (labor and analyses), reporting, and project management in years when injections are no performed. vi. Groundwater sampling is conducted in future years 6, 7, 8, and 9 to evaluate performance of the remedy. vii. Assume site closure achieved in Future Year 9. 5. (15 pts) A feasibility study is being prepared for the site. Calculate the total capital costs, total remediation cost, and Net Present Value cost for the following three scenarios. Provide the results in a single table. Show your work in Excel. For all scenarios a five-year review report must be completed every five years as long until the site is closed; five-year review report cost is $20,000. A site closeout report should be assumed for all scenarios ($15,000). Assume discount rate (i) of 2%. a. Monitored Natural Attenuation (only groundwater sampling) i. Remedial Design Work Plan: $9500 ii. Cost of $55,000 per year for groundwater sampling (labor and analyses), reporting, and project management. iii. Assume duration of 30 years for site closure. b. In-Situ Chemical Oxidation i. Remedial Design Work Plan: $40,000 ii. Injection event cost $330,000 (assume as capital cost) iii. 3 additional injection events that cost $185,000 performed in future year 1, 2, and 3. iv. Groundwater sampling is conducted in future years 4, 5, 6, and 7 to evaluate performance of the remedy. v. Cost of $65,000 per year for groundwater sampling (labor and analyses), reporting, and project management during years that injections are performed. vi. Cost of $40,000 per year for groundwater sampling (labor and analyses), reporting, and project management in years following the injections. vii. Assume site closure achieve in Future Year 7 C. In-Situ Bioremediation i. Remedial Design Work Plan: $40,000 ii. Injection event cost $250,000 (assume as capital cost) iii. One additional injection event that costs $155,000 performed in future year 5. iv. Cost of $65,000 per year for groundwater sampling (labor and analyses), reporting, and project management during years that injections are performed. V. Cost of $40,000 per year for groundwater sampling (labor and analyses), reporting, and project management in years when injections are no performed. vi. Groundwater sampling is conducted in future years 6, 7, 8, and 9 to evaluate performance of the remedy. vii. Assume site closure achieved in Future Year 9