60.1K

Verified Solution

Link Copied!

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}

Answer & Explanation Solved by verified expert

See Answer