89 NOTE this is where the TABLE command comes in handy 90 Part II Sensitivity Test a-d 91 92 Calculating Variance of Returns 93 94 Office Building P X 95 (Return x Deviation (R - Squared (R-Expected Scenario BTIRR Probability (P) Probability) Expected R) Deviation R)sq 96 Pessimistic (20%) 97 Most Likely (15%) 98 Optimistic (10%) 99 100 Expected Return 101 Variance 102 Standard Deviation 103 Coefficient of Variation 104 105 106 Calculating Variance of Returns 107 108 Office Building P X 109 (Return x Deviation (R - Squared (R-Expected Scenario ATIRR Probability (P) Probability) Expected R) Deviation R)sq 110 Pessimistic (20%) + part I a-d part