Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A new equipment will cost 200,000 to install, 5,000 annually maintenance, and have a life of 5 years. The revenue generated by this equipment is
A new equipment will cost 200,000 to install, 5,000 annually maintenance, and have a life of 5 years. The revenue generated by this equipment is estimated to be 60,000 per year. The MARR is 10% per year compounded monthly. Examine the sensitivity of present worth to variation in individual parameters estimates, while others remain constant
- Sensitivity to installation cost variation: 150,000 to 250,000
- Sensitivity to revenue variation: 45,000 to 75,000
- Sensitivity to life variation: 4 year to 7 year
Plot the above result on graphs (each analysis should have its own graph). Please show on Excel.
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