NPV and Sensitivity Analysis
Not what you're looking for?
The following is an extract from a 2015 advertisement by a pensions company seeking investments in a "managed fund".
annual discount rate 0.10
Initial invest -40,000.00
return - I yr 12,000.00
return - 2nd year 13,000.00
return - 3rd year 12,500.00
NPV ?
Set up a spreadsheet to calculate the NPV of the investment. Also perform sensitivity analysis for the following cases:
i) Vary the rate between 9% and 10%(in steps of 0.1)
ii) Vary the Initial investment between 25,000 and 50,000 ( in steps of 5000)
iii) Simultaneously varying both rate and initial investment (Two variable sensitivity analysis)
Purchase this Solution
Solution Summary
The solution here helps arrive at the NPV and also calculate NPV for different discount rates and investments
Education
- BPharm, Mumbai ,India
- MMS, Mumbai, India
- PhD, Madras, India
Recent Feedback
- "Thank you so much"
- "GREAT JOB...THANK YOU"
- "GREAT JOB...THANK YOU"
- "great job"
- "thank you"
Purchase this Solution
Free BrainMass Quizzes
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Operations Management
This quiz tests a student's knowledge about Operations Management