B 22 23 DCF Model 24 Do you wish to exclude year 4? Yes 25 26 Years 0 27 Revenues 28 Missed revenues 29 Expenses 30 Depreciation 31 Incremental EBIT 32 Taxes 33 Net Earnings 34 Depreciation 35 ONWC 36 Change in ONWC 37 CapEx 38 FCF NPV IRR 72 8600 39 40 41 A 888888 $0 $0 $0 $0 $0 $0 $0 $18,025 $18,025 $205,000 --$223,025 $10,643 11.95% E 3 $257,500 $265,225 $273,182 -$60,000 $60,000 -$60,000 $128,750 $132,613 $136,591 $46,250 $46,250 $46,250 $22,500 $26,363 $30,341 $9,000 $10,545 $12,136 $13,500 $15,818 $18,205 $46,250 $46,250 $46,250 $18,566 $19,123 $19,696 $541 $557 $574 $0 $0 $0 $59,209 $61,511 $63,881 F In the model above, a "Yes/No" Data Validation List was inserted in row 24. If "Yes" is selected, year 4 column should not show any value. Year 4 values should be visible otherwise. Which of the following rules identifies the correct conditional formatting to comply with the "Yes/No" List? O formula: =$B$24="Yes" and Applies to "=$F$27" O formula: =$B$24-"Yes" and Applies to "-$F$27:$F$38" O formula: =B$24="Yes" and Applies to "=$F$27:$F$38" O formula: =$B24="Yes" and Applies to "=$F$27" O formula: =$B24="No" and Applies to "=$F$27" B 22 23 DCF Model 24 Do you wish to exclude year 4? Yes 25 26 Years 0 27 Revenues 28 Missed revenues 29 Expenses 30 Depreciation 31 Incremental EBIT 32 Taxes 33 Net Earnings 34 Depreciation 35 ONWC 36 Change in ONWC 37 CapEx 38 FCF NPV IRR 72 8600 39 40 41 A 888888 $0 $0 $0 $0 $0 $0 $0 $18,025 $18,025 $205,000 --$223,025 $10,643 11.95% E 3 $257,500 $265,225 $273,182 -$60,000 $60,000 -$60,000 $128,750 $132,613 $136,591 $46,250 $46,250 $46,250 $22,500 $26,363 $30,341 $9,000 $10,545 $12,136 $13,500 $15,818 $18,205 $46,250 $46,250 $46,250 $18,566 $19,123 $19,696 $541 $557 $574 $0 $0 $0 $59,209 $61,511 $63,881 F In the model above, a "Yes/No" Data Validation List was inserted in row 24. If "Yes" is selected, year 4 column should not show any value. Year 4 values should be visible otherwise. Which of the following rules identifies the correct conditional formatting to comply with the "Yes/No" List? O formula: =$B$24="Yes" and Applies to "=$F$27" O formula: =$B$24-"Yes" and Applies to "-$F$27:$F$38" O formula: =B$24="Yes" and Applies to "=$F$27:$F$38" O formula: =$B24="Yes" and Applies to "=$F$27" O formula: =$B24="No" and Applies to "=$F$27