Your company is evaluating the prospect of purchasing a new plant from a competitor. Because of the risk involved with the endeavor, the company wants you to evaluate the value of the

project adjusting for certainty in cash flow payments likely to arise from the purchase. Evaluate the net present value of the following cash flows applying a $95$ percent certainty

equivalent and a $7$ percent risk$-$free rate.

a$.$ $$1,762,946$

b$.$ $$3,000,000$

c$.$ $$963,774$

d$.$ $$1,424,799$

PLEASE DO WITH EXCEL