Creating a two-dimensional data table. Do some additional sensitivity analysis by creating a two-dimensional data table. Create a Data Table showing what the NPV would be with discount rates of 8%, 10%, 12%, 14%, and 16% and with initial CAPX of $80,000, $90,000, $100,000, $110,000, and $120,000. Enter the discount rates in a row (e.g. in C33:G33) and the initial CAPX values in a column just to the left (e.g. in B34:B38). In the cell in between these two (e.g. B33) enter the reference for the cell containing the NPV (e.g. B30). Then to create the Data Table, highlight a block that includes all the cells you just entered and go to Data | What-if Analysis | Data Table1. The row input cell is the cell where you would input the discount rate, and the column input cell is the cell where you would in put the initial CAPX. Click on OK and you will have a table showing the NPV under different combinations of assumptions.

Q: According to your table, what would the NPV be if the discount rate were 14% and initial CAPX were $110,000? ____________

Please attach screenshot of formulas in excel. Thankyou