Equipment needed at a Valero Corporation refinery for the conversion of corn stock to ethanol, a cleaner burning gasoline additive, will cost

$175,000 and have net cash flows of $35,000 the first year, increasing by $10,000 per year over the life of 5 years.

(a) Use a spreadsheet (and tabulated factors, if instructed to do so) to calculate the AW amounts at different MARR values to determine when the project switches from financially justified to unjustified.

(b) Develop a spreadsheet chart that plots AW versus interest rate.