Question: pls show the excel function Question 6: Assume that you are investigating buying one of three different robots. Use a MARR of 14%. Calculate the
pls show the excel function

Question 6: Assume that you are investigating buying one of three different robots. Use a MARR of 14%. Calculate the ROR to make the economic decision between the robots. \begin{tabular}{|l|c|c|c|} \hline & Robot A & Robot B & Robot C \\ \hline First cost, \$ & ($185,000) & ($160,000) & ($145,000) \\ \hline Annual cost, \$/year & ($10,000) & ($17,000) & ($20,000) \\ \hline Salvage Value, \$ & $15,000 & $10,000 & $9,000 \\ \hline \begin{tabular}{l} Annual Savings, \\ $/year \end{tabular} & $105,000 & $99,000 & $95,000 \\ \hline Life, years & 8 & 8 & 8 \\ \hline \end{tabular} select based upon the IRR? b) What is the incremental IRR between Robot B and C? c) What is the incremental IRR between Robot A and B? d) If you had enough money to buy all 3 of the robots (the robots are independent), which would you select based on a MARR of e) What is the IRR of Robot A? f) What is the IRR of Robot B? g) What is the IRR of Robot C? Answer IRR to one decimal place (in percents, but no % symbol Question 6: Assume that you are investigating buying one of three different robots. Use a MARR of 14%. Calculate the ROR to make the economic decision between the robots. \begin{tabular}{|l|c|c|c|} \hline & Robot A & Robot B & Robot C \\ \hline First cost, \$ & ($185,000) & ($160,000) & ($145,000) \\ \hline Annual cost, \$/year & ($10,000) & ($17,000) & ($20,000) \\ \hline Salvage Value, \$ & $15,000 & $10,000 & $9,000 \\ \hline \begin{tabular}{l} Annual Savings, \\ $/year \end{tabular} & $105,000 & $99,000 & $95,000 \\ \hline Life, years & 8 & 8 & 8 \\ \hline \end{tabular} select based upon the IRR? b) What is the incremental IRR between Robot B and C? c) What is the incremental IRR between Robot A and B? d) If you had enough money to buy all 3 of the robots (the robots are independent), which would you select based on a MARR of e) What is the IRR of Robot A? f) What is the IRR of Robot B? g) What is the IRR of Robot C? Answer IRR to one decimal place (in percents, but no % symbol
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
