The Glendale Corp. is considering a real estate development project that will cost $5 million to undertake and is expected to produce annual inflows between $1 million and $4 million for two years. Management feels that if the project turns out really well the inflows will be $3 million in the first year and $4 million in the second. If things go very poorly, on the other hand, inflows of $1 million followed by $2.5 million are more likely. Develop a range of NPVs for the project if Glendale’s cost of capital is 12%.
Please do in excel with calculation.