Question

Three mutually exclusive projects are being considered: A                           B      &nb

Three mutually exclusive projects are being considered:

A                           B                          C

Initial cost             $100                     $150                     $200

Annual benefit       $10                      $17.62                   $55.48

Useful life. infinite 20 years 5 years

  1. Construct a choice table for interest rates from 0%-100%. Also – provide a plot of either PW or EAW as a function of i.

b. The firm wants 8% rate of return on investments. Which equipment should be purchased?

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

a.

Please refer to below spreadsheet for choice table for interest rate 0% - 100% and also plot for Net Present worth against interest rate.

G11 (84.13) ($122.03) ($119 59 S (HA.H) (S122.47) ($120.62) S (HASV) ($122.89) ($121.63) 5 (84.85) ($123.30 ($122.61) S (Hii) (S123.70) ($123.57) $1 29) ($124.09) ($124.51) S (Hiii) (124.46) ($125.43) S (Hifi) ($124.83) (S126.32) S (HiV) ($125.18) (S127.20) S (i11) (S125.53) ($128.06) ^ (Hi:) (S125.86) ($128.90) S(WİA!) ($126.19) ($129.73) s(Wi/) ($126.51) ($130.53) $1撰ǐA4) ($126.82) ($131.32) S(H/) ($127.12) ($132.10) S(H/1H) (127.41) (S132.85) S (H/:H) ($127.70) ($133.59) S (H/4) (127.98) (S134.32) $18/Ri] ($128.25) ($135.03) S (H/H) ($128.51) ($135.73) S(H/) ($128.77) ($136.41] s《w.10) ($129.02) ($137.08) S (HHA) ($129.27) ($137.74) S (HHiS) (S129.51) (S138.39) $1KKN1) ($129.75) ($139.02) $1XXǐ ) ($129.98) ($139.64) 5 (88.76) ($130.20 ($140.25) $ (88.89) ($130.42 ($140.85) S(H) ($130.64) (S141.43) $1觀11i) ($130.85) ($142.01) $18925) ($131.05) ($142.57) S (H:«) (S131.26) ($143.13) S(HA) (S131.45) ($143.67) $189!選) ($131.65) ($144.21) $189砌($131.84) ($144.73) 5 (89.80) ($132.02 ($145.25) 63% 64% 72 666( 67% 68% 71% 72% 73% 74% 75% 76% 77% 78% 79% 84 85 81% 82% 83% 84% 85% 86% 87% 89 92 93 94 95 31 100 101 102 103 104 105 91%(89.01 92% 93% 94% 95% 96% 97% 98% ($132.20) ($145.76) 102 108 5 (89.90) 100% (90.00)($132.38) ($146.25)

Formula Reference-

b.

Computation of Net Present worth at 8% of Equipment A , B & C and recommendation

Formula Reference -

Equipment-A has highest NPW thus, A is recommended.

You can also get same answer in choice table constructed above in answer (a).

Add a comment
Know the answer?
Add Answer to:
Three mutually exclusive projects are being considered: A                           B      &nb
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