Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started