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?
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more