Assignment:

Must use  Excel

Complete the following problems. You must show your work on the math problems to get full credit. Every student is responsible for completing their own responses to the following problems.

1. Eastern Engineering has the following base-case estimates for a new small engine assembly project:

              Capital Investment = $15,000,000
              Fixed Costs = $3,250,000
              Variable Costs = $600 per unit
              Price per Unit = $1,000
              Demand = 20,000 units per year
              Service Life = 12 years
              Salvage Value = $500,000
              MARR = 20%

A) Find the net present worth, equivalent annual worth, and rate of return of this base-case scenario.
B) If demand for Eastern Engineering’s small engines were to be 17,000 instead of 20,000, how would the net present worth, equivalent annual worth, and rate of return compare to the base-case scenario? What if the demand was 23,000?
C) If the fixed costs were to be 20% lower, how would it affect the net present worth, equivalent annual worth, and rate of return of the project? What if the fixed costs were 20% higher?
D) If the variable costs were to be 15% lower, how would it affect the net present worth, equivalent annual worth, and rate of return of the project? What if the variable costs were 15% higher?