Question: (22 Points) A new project will cost $120,000 initially and will last for 4 years, at which time its salvage value will be $35,000. Revenue

(22 Points) A new project will cost $120,000 initially and will last for 4 years, at which time its salvage value will be $35,000. Revenue for the first year is anticipated to be $25,000 with a yearly increase of $1000 (thus, revenue in year 1 = $25000, year 2 = $26000, year 3 = $27000 and year 4 = $28000). For a MARR of 3 percent per year, perform sensitivity analysis by evaluating (a) annual worth versus initial investment (varying initial investment within the range of 20 percent) (b) annual worth versus salvage value (varying salvage value within the range of 20 percent) (c) annual worth varying initial investment and salvage value simultaneously within the range of 20 percent. Note: USE "Data Table" in Excel to solve this

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!