1.
False
Working note:
PW of the savings = 30000*(1-1/1.15^6)/.15 + 8000/1.15^6 - 120000
PW of the savings = -$3006.9
Since PW is negative, so investments is not acceptable and it should not take place.
----
2.
True
Working note:
When MARR decreases from 15% to 14% or less, then PW becomes positive. Then, investment should be accepted.
When MARR = 14%
Then,
PW of the savings = 30000*(1-1/1.14^6)/.14 + 8000/1.14^6 - 120000
PW of the savings = $304.72
---
3.
Yes
Working note:
When salvage value is $20000, then:
PW = 30000*(1-1/1.15^6)/.15 + 20000/1.15^6 - 120000
PW = 2181.03
Now, PW is positive, so project should be accepted.
---
4.
True
Working note:
PW = 30000*(1-1/1.15^10)/.15 + 8000/1.15^10 - 120000
PW = $32540.54
Now, PW is positive, so investment should be accepted.
Nules. Enter the information exactly as below. Factor Annuity (05"/1.ES/"E71/((1+5)*E7-1) =3*G3 30,000.00 Investment Save: 300000 0.10...
PLEASE WITH EXCEL MICROSOFT PROGRAM!!!!!!! Objective: This activity has the purpose of helping students calculate the benefit - cost ratio of each alternative and select the best alternative using the software Microsoft Excel. (Objective 4) Student Instructions: Read example to be used to compute the Benefit - Cost ratio. Textbook problem 10 - 4 (Sullivan W., Wicks E., and Patrick C.), page 468: A retrofitted space- heating system is being considered for a small office building. The system can be...