Question

4. Company A is looking into four
potential projects and will accept them
if the IRR is 10% or above, as shown in
cell E2. What is the formula used in cell *
C2, which can be copied down to cell 03
through C5, to generate the results
shown below?
A
B
C
D
E
1
IRR
Decision rule
10%
2 Project 1
3 Project 2
4 Project 3
5 Project 4
6
12.5%
9.3%
8.2%
11.1%
Accept or Reject
Accept
Reject
Reject
Accept​

Answer 1

Answer:

I don't know

fvjffhuxbhxbhxbfbcdnbbmb.

Answer 2

Answer: =IF(B2>=$E$2,"Accept","Reject")

Explanation: the IRR cell should remain unchanged, that's why we are using the absolute formula for that cell