Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fiesta Foundry is considering a new furnace that will allow them to be more productive. Three alternative furnaces are under consideration. Perform an incremental analysis
Fiesta Foundry is considering a new furnace that will allow them to be more productive. Three alternative furnaces are under consideration. Perform an incremental analysis of these alternatives using the IRR method for each increment of cash flows. The MARR is 12% per year. Click the icon to view the description of the alternatives. Click the icon to view the interest and annuity table for discrete compounding when the MARR is 12% per year. Perform the incremental PW Analysis. Fill-in the table below (Hint: Order alternatives by increasing capital investment). (Round to the nearest dollar.) \begin{tabular}{lrrr} \hline & Furnace A & Furnace B & Furnace C \\ \hline Initial investment & $470,000 & $350,000 & $220,000 \\ Annual revenues * & $60,000 & $70,000 & $60,000 \\ Annual cost* & $12,000 & $13,000 & $5,000 \\ Salvage value & $40,000 & $50,000 & $40,000 \\ Life of asset & 20 years & 20 years & 20 years \end{tabular} *Annual revenue and cost figures are increases over the "do nothing" alternative (DN). \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Discrete Compounding; i=12%} \\ \hline & \multicolumn{2}{|c|}{ Single Payment } & \multicolumn{4}{|c|}{ Uniform Series } \\ \hline & \begin{tabular}{c} Compound \\ Amount \\ Factor \end{tabular} & \begin{tabular}{l} Present \\ Worth \\ Factor \\ \end{tabular} & \begin{tabular}{c} Compound \\ Amount \\ Factor \end{tabular} & \begin{tabular}{l} Present \\ Worth \\ Factor \\ \end{tabular} & \begin{tabular}{c} Sinking Fund \\ Factor \end{tabular} & \begin{tabular}{c} Capital \\ Recovery \\ Factor \\ \end{tabular} \\ \hlineN & \begin{tabular}{c} To Find F \\ Given P \\ F/P \end{tabular} & \begin{tabular}{c} To Find P \\ Given F \\ P/F \end{tabular} & \begin{tabular}{c} To Find F \\ Given A \\ F/A \\ \end{tabular} & \begin{tabular}{c} To Find P \\ Given A \\ P/A \\ \end{tabular} & \begin{tabular}{c} To Find A \\ Given F \\ A/F \end{tabular} & \begin{tabular}{c} To Find A \\ Given P \\ A/P \\ \end{tabular} \\ \hline 1 & 1.1200 & 0.8929 & 1.0000 & 0.8929 & 1.0000 & 1.1200 \\ \hline 2 & 1.2544 & 0.7972 & 2.1200 & 1.6901 & 0.4717 & 0.5917 \\ \hline 3 & 1.4049 & 0.7118 & 3.3744 & 2.4018 & 0.2963 & 0.4163 \\ \hline 4 & 1.5735 & 0.6355 & 4.7793 & 3.0373 & 0.2092 & 0.3292 \\ \hline 5 & 1.7623 & 0.5674 & 6.3528 & 3.6048 & 0.1574 & 0.2774 \\ \hline 6 & 1.9738 & 0.5066 & 8.1152 & 4.1114 & 0.1232 & 0.2432 \\ \hline 7 & 2.2107 & 0.4523 & 10.0890 & 4.5638 & 0.0991 & 0.2191 \\ \hline 8 & 2.4760 & 0.4039 & 12.2997 & 4.9676 & 0.0813 & 0.2013 \\ \hline 9 & 2.7731 & 0.3606 & 14.7757 & 5.3282 & 0.0677 & 0.1877 \\ \hline 10 & 3.1058 & 0.3220 & 17.5487 & 5.6502 & 0.0570 & 0.1770 \\ \hline 11 & 3.4785 & 0.2875 & 20.6546 & 5.9377 & 0.0484 & 0.1684 \\ \hline 12 & 3.8960 & 0.2567 & 24.1331 & 6.1944 & 0.0414 & 0.1614 \\ \hline 13 & 4.3635 & 0.2292 & 28.0291 & 6.4235 & 0.0357 & 0.1557 \\ \hline \end{tabular} \begin{tabular}{ccccccc} 10 & 3.1058 & 0.3220 & 17.5487 & 5.6502 & 0.0570 & 0.1770 \\ \hline 11 & 3.4785 & 0.2875 & 20.6546 & 5.9377 & 0.0484 & 0.1684 \\ 12 & 3.8960 & 0.2567 & 24.1331 & 6.1944 & 0.0414 & 0.1614 \\ 13 & 4.3635 & 0.2292 & 28.0291 & 6.4235 & 0.0357 & 0.1557 \\ 14 & 4.8871 & 0.2046 & 32.3926 & 6.6282 & 0.0309 & 0.1509 \\ 15 & 5.4736 & 0.1827 & 37.2797 & 6.8109 & 0.0268 & 0.1468 \\ \hline 16 & 6.1304 & 0.1631 & 42.7533 & 6.9740 & 0.0234 & 0.1434 \\ 17 & 6.8660 & 0.1456 & 48.8837 & 7.1196 & 0.0205 & 0.1405 \\ 18 & 7.6900 & 0.1300 & 55.7497 & 7.2497 & 0.0179 & 0.1379 \\ 19 & 8.6128 & 0.1161 & 63.4397 & 7.3658 & 0.0158 & 0.1358 \\ 20 & 9.6463 & 0.1037 & 72.0524 & 7.4694 & 0.0139 & 0.1339 \\ \hline 21 & 10.8038 & 0.0926 & 81.6987 & 7.5620 & 0.0122 & 0.1322 \\ 22 & 12.1003 & 0.0826 & 92.5026 & 7.6446 & 0.0108 & 0.1308 \\ 23 & 13.5523 & 0.0738 & 104.6029 & 7.7184 & 0.0096 & 0.1296 \\ 24 & 15.1786 & 0.0659 & 118.1552 & 7.7843 & 0.0085 & 0.1285 \\ 25 & 17.0001 & 0.0588 & 133.3339 & 7.8431 & 0.0075 & 0.1275 \\ \hline 30 & 29.9599 & 0.0334 & 241.3327 & 8.0552 & 0.0041 & 0.1241 \\ 35 & 52.7996 & 0.0189 & 431.6635 & 8.1755 & 0.0023 & 0.1223 \\ 40 & 93.0510 & 0.0107 & 767.0914 & 8.2438 & 0.0013 & 0.1213 \\ 45 & 163.9876 & 0.0061 & 1358.2300 & 8.2825 & 0.0007 & 0.1207 \\ 50 & 289.0022 & 0.0035 & 2400.0182 & 8.3045 & 0.0004 & 0.1204 \\ \hline \end{tabular}
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