4

Calculate the Expected Value of Net Present Worth (EV of NPW) for the following project to be undertaken for a life of 10 years. The project has absolutely no salvage value at the end of the useful life. The company uses an interest rate of 12% to evaluate this project. Prepare a table in Excel showing joint probability distribution of NPW. Calculate NPW for all 25 scenarios in a separate column. Calculate Expected value based on your answers in part (a) and (b)