Question
The management of Dunson ltd. is evaluating five investment projects whose expected cash flows (Sh., 000) are shown below: Project 1.1.2021 31.12.2021 31.12.2022 31.12.2023 A
The management of Dunson ltd. is evaluating five investment projects whose expected cash flows (Sh., 000) are shown below:
Project | 1.1.2021 | 31.12.2021 | 31.12.2022 | 31.12.2023 |
A | -60,000 | 30,000 | 25,000 | 25,000 |
B | -30,000 | -20,000 | 25,000 | 45,000 |
C | -40,000 | -50,000 | 60,000 | 70,000 |
D | 0 | -80,000 | 45,000 | 55,000 |
E | -50,000 | 10,000 | 30,000 | 40,000 |
All the projects are divisible and non can be delayed or brought forward. The required rate of return on investments is 15%.
Using Excel program: Assuming that the capital available on 1.1.2021 is limited to Shs.100 million, use the Net Present Value (NPV) approach to determine which projects(s) should be undertaken.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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