Question: Please show work on Excel! Thank you! Comparison between the three option is presented in the table below: Initial cost Annual benefit O&M Life in
Please show work on Excel! Thank you!
Comparison between the three option is presented in the table below: Initial cost Annual benefit O&M Life in years Salvage Interest rate A B $52,000 $63,000 $67,000 $38,000 $31,000 $37,00 $15,000 $9,000 $12,000 4 6 12 13,000 19,000 22,000 12% Based on the information given above, answer the following question. Please note you need to show the steps for getting full credit. Just selecting the correct option without showing the steps will result in getting zero points. 2.1. The NPW of alternative A is A) $93,497 B) $55,846 C) $53,255 D) None of the Options 2.2.The NPW of alternative B is A) $93,497 B) $55,846 C) $53,255 D) None of the Options 2.3.The NPW of alternative C is A) $93,497 B) $55,846 C) $53,255 D) None of the Options 2.4.By using the PW analysis determine the best alternatives among the three given alternatives is A) Alt. A B) Alt. B C) Alt. C D) Either alt. B or alt. C
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
