1. Here are the cashflows on some projects. For each project, draw a graph in Excel...

Transcribed Image Text:

1. Here are the cashflows on some projects. For each project, draw a graph in Excel of the NPV to find the approximate IRR(s) (there may be more than one). Then answer this question: "Do you take this project if the OCC is 11%?" You may restrict yourself to only positive interest rates between 0 and 100%. Project Co C₂ C3 A B C C₁ -100 120 140 990 -220 60 -2240 1254 1. Here are the cashflows on some projects. For each project, draw a graph in Excel of the NPV to find the approximate IRR(s) (there may be more than one). Then answer this question: "Do you take this project if the OCC is 11%?" You may restrict yourself to only positive interest rates between 0 and 100%. Project Co C₂ C3 A B C C₁ -100 120 140 990 -220 60 -2240 1254

Answer rating: 100% (QA)

All articles NPV Learn How to Find the NPV of a Perpetuity in Excel Learn How to Find the NPV of a P... View the full answer