Please help, Needs to be solved using the present worth analysis method and than if possible how to do it in excel using NVP function.

34 Javier is an IE at Lobos Manufacturing. He has been studying process line G to determine if an automated system would be preferred to the existing laborintensive system. If Lobos wants to earn at least 20\% and uses a 15-year planning horizon, which alternative is preferred? Contributed by Paul R. McCright, University of South Florida