a) Calculate the NPV for both projects using the =NPV() formula.b) Create a plot of the NPV curves.c) Identify the switching point of the projects.Project/Year 0 1 2 3Project A -100 50 40 30Project B -100 30 45 50Discount Rate 10%NPV of A =NPV of B =NPV CurvesDisRateNPV ofANPV ofB2%4%6%8%10%12%14%16%
Question
a) Calculate the NPV for both projects using the =NPV() formula.b) Create a plot of the NPV curves.c) Identify the switching point of the projects.Project/Year 0 1 2 3Project A -100 50 40 30Project B -100 30 45 50Discount Rate 10%NPV of A =NPV of B =NPV CurvesDisRateNPV ofANPV ofB2%4%6%8%10%12%14%16%
Solution
To calculate the NPV (Net Present Value) for both projects, we will use the NPV formula in Excel. The NPV formula in Excel is =NPV(rate, value1, [value2], ...). The rate is the discount rate and the values are the cash flows.
a) Calculate the NPV for both projects using the =NPV() formula.
For Project A: =NPV(10%, 50, 40, 30) = 92.42
For Project B: =NPV(10%, 30, 45, 50) = 92.56
b) Create a plot of the NPV curves.
To create a plot of the NPV curves, you would need to calculate the NPV for each project at different discount rates (2%, 4%, 6%, 8%, 10%, 12%, 14%, 16%). Then, plot these values on a graph with the discount rate on the x-axis and the NPV on the y-axis.
c) Identify the switching point of the projects.
The switching point of the projects is the discount rate at which the NPV of both projects is the same. Looking at the graph, you can identify this point where the two curves intersect.
Please note that the actual NPV values and the switching point will depend on the specific cash flows and discount rates of your projects. The values provided here are just examples.
Similar Questions
Use the discount factor to find the NPV of both projects using the following table.Project/Year 0 1 2 3Project A Cash Flow -100 50 40 30Project B Cash Flow -100 30 45 50Discount factor (10%)Discounted Cash Flow of ADiscounted Cash Flow of BNPV of A (10%) =NPV of B (10%) =
You have two mutually exclusive projects. Both projects require initial investment of $20 million. Project 1 generated $4 million per year in perpetuity.Project 2 generated $3 million at the end of the first year and its revenue will grow 3% per year thereafter.The cash flows of both projects start at the end of the first year. <a> IRR<b> NPV, assume the cost of capital is 6%
There are two projects: project A and project B. Each of the project has the cost of Rs 100,000 and cost of capital for each project is 12 percent. The project's expected net cash flows are as follows: Year Project A Project B 0 Rs (100,000) Rs (100,000) 1 65,000 35,000 2 30,000 30,000 3 30,000 30,000 4 10,000 10,000 a. Calculate NPV for each project. Which project or projects should be accepted if they are independent? b. Calculate IRR for each project. Which project should be accepted if they are mutually exclusive?
sing the table below to identify the switching point of two mutually exclusive projects. Assume the discount rate is 10%.Project/ Year0123Project A-1000475475475Project B-500256256256Selected Answer: [None Given]Answers: 10.00%24.96% 15.00%20.04%
Calculate the NPV of a $100,000 investment project with cash inflows of $30,000 in year 1, $50,000 in year 2, and $80,000 in year 3, 120,000 in year 4. The cost of capita is 7%
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.