Project A has the following cash flows. Year 1 Year 2 Year 3 Year 4 Year 5 Initial Investment $75,000 Cash Inflow $ 20,000 $
Project A has the following cash flows.
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||
Initial Investment | $75,000 | |||||
Cash Inflow | $ 20,000 | $ 25,000 | $ 30,000 | $ 36,000 | $ 50,000 | |
Required Rate of Return | 8% |
Calculate the following measures
- NPV of the project A
- The project payback period and Profitability Index (showing a decimal figure).
- Suppose you want to consider inflation rate in NPV. If the annual inflation rate
is 5%, what is the new NPV?
- Project B has the following cash flow:
PROJECT B | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Initial Investment | $50,000 | |||||
Cash Inflow | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | |
Required Rate of Return | 10% |
Compare the NPV between Project A and Project B. Which project is more profitable?
What is the difference in NPV between the two projects?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Nov Mirosoft Excel Home Insert Paye Layuut Formulas Data Review View Cut E AutoSum Calibri 10 A A Wr...
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
Authors: Eugene F. Brigham and Michael C. Ehrhardt
12th Edition
978-0030243998, 30243998, 324422695, 978-0324422696
