Question
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
1. Sensitivity to installation cost variation: 150,000 to 250,000
2. Sensitivity to revenue variation: 45,000 to 75,000
3. Sensitivity to life variation: 4 year to 7 year
Please answer using Microsoft Excel explanation if possible. Thank you.
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