Lost, need equations and how to place this into excel

P124 Basic scenario analysis Prime Paints is in the process of evaluating two mutually exclusive additions to its processing capacity. The firm's financial analysts have developed pessimistic, most likely, and optimistic estimates of the annual cash inows associated with each project. The following table shows these estimates. Project A Project B Initial investment (CFO) $12,200 $12,200 Outcome Annual cash inows (CF) Pessimistic $ 850 $1,550 Most likely 1,650 1,65 0 Optimistic 2,450 1,750 a. Determine the range of annual cash inows for each project. b. Assume that the firm's cost of capital is 9.3% and that both projects have 15-year lives. Construct a table similar to this one for the NPVs for each project. Include the range of NPVs for each project. c. Do parts a and b provide consistent views of the two projects? Explain. (1. Which project do you recommend? Why