Engineering Economics (Finance) using microsoft excel
Asfar123333Assignment: ( Using microsoft 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. A machine costing $30,000 to buy and $2,750 per year to operate will save mainly labor expenses in packaging over eight years. The anticipated salvage value of the machine at the end of eight years is $2,500.
a. If a 9% return on investment (rate of return) is desired, what is the minimum required annual savings in labor from this machine?
b. If the service life is seven years instead of eight, what is the minimum required annual savings in labor for the firm to realize a 10% return on investment?
c. If the annual operating cost increases by 20%, from $2,750 to $3,300, what would the minimum required annual savings to get the 10% return on investment?
2. A company is looking at purchasing new vehicles to enhance their fleet. Which of the following vehicles would be the best in terms of lowest annual cost if the interest rate = 10% if the vehicles had a service life of 4 years? 5 years? 6 years?
Vehicle Initial Cost Annual Operating Cost Salvage Value
A $32,000 $4,250 $6,000
B $28,000 $5,000 $4,000
C $30,000 $4,750 $5,000
D $34,500 $5,000 $7,000
- 8 years ago
- 20
- A small nation of ten people idolizes the TV show American Idol
- MAT 540 Final Exam
- About 40% of the general population donate time and energy
- Electric field and electric potential
- COM200 Interpersonal Communication WEEK 3 ASSIGNMENT 2 Interpersonal Communication in Relationships Outline
- BUS330 Principles of Marketing Week 2 - Discussion 1 and 2
- acclimatization physiology
- writing
- College Algebra Help
- Women as change agent in America