For the capital budgeting example discussed in conjunction with Figures 70-1 through 70-3, use conditional formatting to highlight in yellow fill each row corresponding to a selected project.

Figure 70.1

Figure 70.2

Figure 70.3

Transcribed Image Text:

123456SHSSHR2272222 5 Do IT? 8 9 10 11 18 19 A 20 B Total NPV 9293 0 Project 1 1 Project 2 1 Project 3 0 Project 4 0 Project 5 1 Project 6 1 Project 7 1 Project 8 1 Project 9 1 Project 10 0 Project 11 0 Project 12 0 Project 13 1 Project 14 1 Project 15 1 Project 16 0 Project 17 0 Project 18 1 Project 19 1 Project 20 C NPV 928 908 801 543 944 848 545 808 638 841 664 546 699 599 903 859 748 668 888 655 D Used Available E 2460 203 150 282 LL 214 224 225 101 255 228 303 133 197 313 152 F 2684 254 271 150 218 202 351 173 427 <= 98 278 211 G 2742 H 876 2500 2800 2900 900 900 900 Cost Year 1 Cost Year 2 Cost Year 3 Labor Year 1 Labor Year 2 Labor Year 3 398 180 368 108 123 151 269 248 86 83 129 189 308 61 23 275 218 220 291 252 228 80 283 285 220 77 113 143 141 160 355 130 33 272 70 240 431 220 214 291 134 111 139 56 54 123 119 54 67 37 130 51 35 43 3 60 60 59 95 66 <= 85 895 70 141 84 04 00 55 72 79 100 90 75 93 90 40 6 75 59 44 101 702 96 59 70 37 42 43 64 62 58 63 71 83 80 41 39 74 74 70