Question: Please use excel and demonstrate the formulae used. A new project will cost $32,356 initially and will last for 7 years, at which time its
Please use excel and demonstrate the formulae used.
A new project will cost $32,356 initially and will last for 7 years, at which time its salvage value will be $2,500. Annual revenues are anticipated to be $15,000 per year. For a MARR of 6% percent every year, plot a sensitivity graph for annual worth versus initial cost, annual revenue, and salvage value, varying only one parameter at a time, each within the range of +/- 50% increments of 10%.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
