Question: please answer all qustions if you wont answer leave it to another profisor i need all cleare answers Case Study Exercises Use spreadsheet analysis to


Case Study Exercises Use spreadsheet analysis to determine the following: Case Study Exercises Usespreadsheet analysis to determine the following: A. If the MARR = 12\%, which server should be selected based on PW method to make the selection, (Hint : You have to use LCM for PW calculations) answer the below questions: 1. The PW for server 1LCM cash flow= 2. The PW for server 2 LCM cash flow = 3. The PW for server 3LCM cash flow = 4. Based on the PW analysis which option should be selected? B. The ROR for each option, answer the below questions: ( enter the percentage format exp 28.23\%) 1. The ROR for server 1 over 3 years operation equal = 2. The ROR for server2 over 4 years operation equal = 3. The ROR for server 3 over 5 years operation equal = 4. Based on the ROR for each option which option we should select? C- Use incremental ROR analysis between server 2 and server 3 to decide which is the best option at MARR =12%. Answer the below questions 1. As per the Descartes rule of signs for the NCF between servers 283 , what is the maximum number of real number Deita_ it that exist? 3. The ROR for server 3 over 5 years operation equal = 4. Based on the ROR for each option which option we should select? C- Use incremental ROR analysis between server 2 and server 3 to decide which is the best option at MARR =12%. Answer the below questions 1. As per the Descartes rule of signs for the NCF between servers 283 , what is the maximum number of real. number Delta i* that exist? 2. As per the Norstroms criterion, is there a one real-positive Deita it exist (enter yes or no)? 3. What is the value of Delta i* between server 2&3 if exist? 4. Based on the incremental analysis which option we should select if incremental analysis is apblicable
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
