A firm evaluates all of its projects by applying the NPV decision rule. A proposed project is expected to have the following cash flows:
Year | Cash Flow |
0 | $ (26,000) |
1 | $ 11,000 |
2 | $ 14,000 |
3 | $ 10,000 |
a) At a required return of 11 percent, what is the project's NPV? Should the firm accept this project?
b) At a required return of 24 percent, what is the project's NPV? Should the firm accept this project?
Is there an excel formula to complete these questions?
a
=NPV(0.11,-26000,11000,14000,10000)
= 2328.41 , accept project as NPV is positive
b
=NPV(0.24,-26000,11000,14000,10000)
= -2241.18 , reject project as NPV is negative
A firm evaluates all of its projects by applying the NPV decision rule. A proposed project...
A firm evaluates all of its projects by applying the NPV decision rule. A project under consideration has the following cash flows: Year Cash Flow O $28,700 12,700 15,700 11,700 What is the NPV for the project of the required return is 12 percent? (Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 3216.) NP At a required return of 12 percent, should the firm accept this project? NO Yes What is the NPV for...
A firm evaluates all of its projects by applying the NPV decision rule. A project under consideration has the following cash flows: Year Cash Flow 0 -$28,300 12,300 15,300 11,300 What is the NPV for the project if the required return is 11 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e... 32.16.) NPV At a required return of 11 percent, should the firm accept this project? ONO Yes What is the NPV for...
A firm evaluates all of its projects by applying the NPV decision rule. A project under consideration has the following cash flows: Year O Cash Flow -$27,800 11,800 14,800 10,800 What is the NPV for the project if the required return is 11 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV At a required return of 11 percent, should the firm accept this project? No Yes What is the NPV for...
A firm evaluates all of its projects by applying the NPV decision rule. A project under consideration has the following cash flows: Year 0 Cash Flow -$28,300 12,300 15,300 11,300 2 3 What is the NPV for the project if the required return is 11 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV 3461.37 At a required return of 11 percent, should the firm accept this project? Yes No What is...
A firm evaluates all of its projects by applying the NPV decision rule. A project under consideration has the following cash flows: Year Cash Flow 0 –$ 27,900 1 11,900 2 14,900 3 10,900 What is the NPV for the project if the required return is 10 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV $ At a required return of 10 percent, should the firm accept...
A firm evaluates all of its projects by applying the NPV decision rule. A project under consideration has the following cash flows: Year Cash Flow $27,300 0 11,300 14,300 10,300 1 2 What is the NPV for the project if the required return is 10 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV At a required return of 10 percent, should the firm accept this project? Yes No What is the...
A firm evaluates all of its projects by applying the NPV decision rule. A project under consideration has the following cash flows: Year Cash Flow -$34,000 15,000 17,000 13,000 What is the NPV of the project if the required return is 11 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV At a required return of 11 percent, should the firm accept this project? Yes O No What is the NPV of...
A firm evaluates all of its projects by applying the NPV decision rule. A project under consideration has the following cash flows: YearCash Flow -$34,000 15,000 7,000 13,000 0 :3 What is the NPV of the project if the required return is 11 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV What is the NPV of the project if the required return is 24 percent? (A negative answer should be indicated...
A firm evaluates all of its projects by applying the NPV decision rule. A project under consideration has the following cash flows: Year Cash Flows 0 -3,002 1 1,036 2 2,229 3 1,649 What is the NPV for the project if the required return is 25 percent?
A firm evaluates all of its projects by applying the NPV decision rule. A project under consideration has the following cash flows: Year Cash Flows 0 -4,901 1 1,328 2 2,362 3 1,613 What is the NPV for the project if the required return is 11 percent?