Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started