Question
Net Cash Flows and NPVs for different discount rate for projects S and L are given below (35 points) Net Cash Flows ($) Discount Rate
Net Cash Flows and NPVs for different discount rate for projects S and L are given below (35 points)
| Net Cash Flows ($) |
| Discount Rate (%) | NPVS | NPVL | |
Year (t) | Project S | Project L |
| 0% | $800 | $1100 |
0 | $(3000) | $(3000) |
| 5 | 454.85 | 554.32 |
1 | 1500 | 400 |
| 10 | 161.33 | 108.59 |
2 | 1200 | 900 |
| 15 | (90.74) | (259.24) |
3 | 800 | 1300 |
| 20 | (309.03) | (565.97) |
4 | 300 | 1500 |
| 25 |
|
|
e)What is the cross-over rate? (Write down the equation for cross-over rate and then Use an excel worksheet to calculate IRR (5 points)
Equation:
Answer:
g) If projects are mutually exclusive, which project would you accept? (5 points)
i) at 10%
ii) at 25%
f) If projects are independent (not mutually exclusive), which project(s) would you accept? (5 points)
i) at 10%
ii) at 25%
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