Question

(pts) Your company is considering buying a new, automated welding system. Using an ROR analysis and a MARR of 5% would you re

Use the formula below, and explain every step please. Don't use Excell, use the formula on the page.

Thank you!!

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Initial Investment = 260,000

Annual O&M Cost = 20,000

Annual Benefits = 60,000

Net Annual Benefits = 60,000 – 20,000 = 40,000

Periodic maintenance at every 4 years = 30,000 (at 4th year and at 8th year)

Salvage Value = 20,000

Life = 10 years

MARR = 5%

Calculate the ROR and suggest whether to buy/reject the purchase of wielding machine.

Calculating ROR using Trial and Error Method.

Let the MARR is 5%

Calculate the PW of the investment at MARR of 5%

PW = -260,000 – 30,000 (P/F, 5%, 4) – 30,000 (P/F, 5%, 8) + 40,000 (P/A, 5%, 10) + 20,000 (P/F, 5%, 10)

PW = -260,000 – 30,000 (0.8227) – 30,000 (0.6768) + 40,000 (7.7217) + 20,000 (0.6139) = 16,161

The PW is positive. So, increase the rate of interest to get negative PW.

Increase the MARR to 6% and calculate the PW.

PW = -260,000 – 30,000 (P/F, 6%, 4) – 30,000 (P/F, 6%, 8) + 40,000 (P/A, 6%, 10) + 20,000 (P/F, 6%, 10)

PW = -260,000 – 30,000 (0.7921) – 30,000 (0.6274) + 40,000 (7.3601) + 20,000 (0.5584) = 2,987

The PW is still positive. So, increase the rate of interest to get negative PW.

Increase the MARR to 7% and calculate the PW.

PW = -260,000 – 30,000 (P/F, 7%, 4) – 30,000 (P/F, 7%, 8) + 40,000 (P/A, 7%, 10) + 20,000 (P/F, 7%, 10)

PW = -260,000 – 30,000 (0.7629) – 30,000 (0.5820) + 40,000 (7.0236) + 20,000 (0.5083) = -9,237

Now, use interpolation and calculate the IRR.

IRR = 6% + [2,987 – 0 ÷ 2,987 – (-9,237)] * 1%

IRR = 6.24%

As the IRR is greater than the given MARR, the decision should be to BUY the wielding machine.

Add a comment
Know the answer?
Add Answer to:
Use the formula below, and explain every step please. Don't use Excell, use the formula on...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT