Net Present Value (NPV) and Economic Value Added (EVA): Scenario creation and analysis by using an excel spreadsheet.

Assume that you work at a nonprofit healthcare organization, and you are one of the decision-makers of capital assets acquisition of costly medical equipment. In two separate worksheets in Excel, please create two distinct scenarios in one using Net-Present Value (NPV) calculations and in other using the Economic Value Added (EVA) measures. One of them must yield results that will reject moving forward with acquiring the capital asset, and the other must produce a result embracing moving forward with the acquisition. Please show all of your work, including formulas in Excel.