Would you still be interested in answering the question I posted this morning? I have been away from my computer and did not see you response until now. I think all that need to be done:

1. add another spreadsheet that reflects a10% reduction in price & theNet Present Value of Discounted CashFlow (use WACC number for discount rate) and provide a synopsis evaluation of each project and provide a clear recommendation of which project management will accept for its capital expenditures budget based on textbook decision rules.

2. Add another spreadsheet that reflects10% reduction in sales volume & the Net Present Value of Discounted CashFlow (use WACC number for discount rate) and provide a synopsis evaluation of each project and provide a clear recommendation of which project management will accept for its capital expenditures budget based on textbook decision rules.

You did a great job before, making it easy to follow and understand. I didn't realize I could request you assistance again. I can adjust the deadline if that will help.