In column D, a 1 indicates that the project will be selected and a 0 otherwise. If you want to find the cost weighted average IRR of just those projects that are selected, which array formula in B7 would be correct?
a) =SUM(B2:B5 *$D2:$D5)/B6
b) {=SUM(B2:B5/B6*C2:C5*$D2:$D5)}
c) =SUM(B2:B5/B6*C2:C5*$D2:$D5)
d) {=SUM(B2:B5/B6*$D2:$D5) }
b) {=SUM(B2:B5/B6*C2:C5*$D2:$D5)}
Business
You might also like to view...
Mobile ad copy should occupy only 50 percent of the screen
Indicate whether the statement is true or false
Business
Discuss the attributes of human capital. Give examples of how firms work to develop and retain it.
What will be an ideal response?
Business
Explain cannibalization. How does a line extension strategy increase the risk of cannibalization?
What will be an ideal response?
Business
Regardless of whether the setting is B2C or B2B, most costs are associated with the purchase price.
Answer the following statement true (T) or false (F)
Business