Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. A project has the following cash flows C 0 C 1 C 2 C 3 ($1000) $300 $400 $600 What is the projects payback
2. A project has the following cash flows
C0 C1 C2 C3
($1000) $300 $400 $600
What is the projects payback period?
Year | 0 | 1 | 2 | 3 |
Cash Flow | ($1000) | $300 | $400 | $600 |
Cumulative | ($1000) | ($700) | ($300) | 300 |
a. Calculate the projects NPV at 10%.
b. Calculate the projects PI at 10%.
c. Calculate an IRR for the project in question 2
How would you answer a,b, and c in excel? I am getting 2,054.09 for NPV and not sure if that is correct.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started