Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Oxford Guide To Financial Modeling

Authors: Thomas S Y Ho, Sang Bin Lee

1st Edition

019516962X, 9780195169621

More Books

Students also viewed these Finance questions