Scenario Analysis Question:

For a building project that you$$re currently considering to whether take or not, the initial investment cost is $$700,000.$ The cost of doing this project is $$300,000$ in $1$st year, $$200,000$ in $2$nd year, $$100,000$ in $3$rd year, and no cost at the final year. You have a $15\%$ discount rate!

In the best$-$case scenario, you earn $$800,000$ year $1,$ $$700,000$ year $2,$ $$600,000$ year $3,$ $$500,000$ year $4.$

In the most likely scenario, you earn $$800,000$ year $1,$ then $$100,000$ until year $4.$

In the worst$-$case scenario, you earn $$100,000$ in year $1,$ $$200,000$ year $2,$ $$500,000$ year $3,$ and $$100,000$ year $4.$

Please calculate NPV for each of the above scenarios and make the final decision as to whether take that building project or not.