PLEASE BE DESCRIPTIVE AND SHOW ALL WORK (INCLUDING FORMULAS).

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 inflows associated with each project. The following table shows these estimates. P12-4 Project A Project B Initial investment (CF0) -$12,200 -$12,200 Annual cash inflows (CF) Outcome $ 850 $1,550 Pessimistic Most likely 1,650 1,650 Optimistic 2,450 1,750 a. Determine the range of annual cash inflows 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 NPV8 for each project Include the range of NPV8 for each project. c. Do parts a and b provide consistent views of the two projects? Explain d. Which project do you recommend? Why