Your factory has been offered a contract to produce a part for a
new printer. The contract would be for three years and your cash
flows from the contract would be $5 million per year. Your up-front
setup costs to be ready to produce the part would be $8 million.
Your cost of capital for this contract is 8%. THIS IS AN EXCEL PROJECT, I NEED THE FORMULAS PLEASE ! |
||||
a. | What does the NPV rule say you should do? | |||
b. | What does the IRR rule say you should do? | |||
c. | Does the IRR rule agree with the NPV rule in this case? | |||
Initial investment (million) | $ 8 | |||
Annual cash flow (million) | $ 5 | |||
Number of periods (years) | 3 | |||
Cost of capital | 8% | |||
a. | What does the NPV rule say you should do? | |||
NPV (million) | ||||
Make investment (Yes/No) | ||||
b. | What does the IRR rule say you should do? | |||
IRR | ||||
Make investment (Yes/No) | ||||
c. | Does the IRR rule agree with the NPV rule in this case? | |||
NPV & IRR agree (Yes/No) | ||||
Get Answers For Free
Most questions answered within 1 hours.