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

pls show the excel function Question 6: Assume that you are investigating

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!