Solve using Excel Formula

ul luncht, wit would be the equivalent total Social Security benefit collected? (b) If he lives 40 years after retirement, what would be the equivalent total Social Security benefit collected? (c) Suppose he lives forever. What would be the total amount collected? Now, comparing this answer with that in (b), what can you conclude? Comparing Mutually Exclusive Alternatives 5.31 Consider the following two mutually exclusive projects: Net Cash Flow End of Year 0 1 Project A -$1,000 $912 $684 $456 $228 2 Project B -$1,000 $284 $568 $852 $1,136 3 4 (a) At an interest rate of 25%, which project would you recommend choosing? (b) Compute the area of negative project balance, discounted payback period, and area of positive project balance for each project. Which project is ex- posed to a higher risk of loss if either project terminates at the end of year 2? 32 Consider two mutually exclusive investment projects, each with MARR = 12%, as shown in Table P5.32. On the basis of the NPW criterion, wh would be