Refer to the data provided below for Proposal A and also provided in an Excel file in this link to answer the following questions.

a$.$ Prepare a table in Excel to compute the net present value for Proposal A and consider this the likely scenario. Next, prepare an optimistic and pessimistic scenario. For the optimistic

scenario, increase each cash inflow by $10\%$ and for the pessimistic scenario, decrease each net cash inflow by $10\%.$

Note: Round your answers to the nearest whole dollar. Use a negative sign to indicate a cash outflow.