Please show the full solution by hand showing every equation that you have used. Also, don't do things in excel, everything should be seen. Show all steps taken to reach the answer. Thank you very much.

Question 2 You are a water lter manufacturer trying to decide if you should invest in an automatic or manually operated machinery. Both alternatives' present costs are pegged at $5000, however, they lead to different revenue patterns thereafter. The automatic machine allows for higher production levels and thus more revenues immediately, however more energy costs over time than the manual machine means that net revenues diminish over time. The manual machine does not produce as many lters initially but has no energy cost, so its net revenues increase over time. The expected net revenues of the automatic machine are: $3200, $1500, $690, and $310 by the ends of years one to four, respectively. The expected net revenues for the manual machine are $280, $710, $1900, and $3000 by the ends of years one to four, respectively. 1. Calculate the Internal Rate of Return of each alternative and compare them. Do you think it is possible to decide based on individual IRR comparisons? If so, Which is more feasible? 2. Knowing the MARR is 8%, use NPW analysis to compare these alternatives and nd out which one is better. 3. Calculate the benet cost ratio of the both alternatives