Interest Tables Used to Calculate Present and Future Values (The Time Value of Money) PRESENT VALUE TABLE Present Value of a Lump Sum Payment (Compound Interest) Present Value of a Periodic Payment (Annuity) Alternative A: The first option is to upgrade and customize his computer system. The cost will be $3,000. He expects to save $1,800 per year in labor costs as a result of the additional automation. He also believes he will be able to sell any computer hardware for $500 at the end of the 3year horizon he is looking at before having to upgrade once again. Alternative B: The second option is to expand his current inventory by offering a new line of guitars. The initial outlay of the expansion is $8,000. He expects current annual sales of $80,000 to increase by 5% per year. In addition, he will have to pay $500 to renovate his current sales floor to accommodate the additional inventory. He is using the same 3-year horizon as in the first option. What is the net present value of each alternative? 2. Margo of Margo's Curios is looking for ways to increase her sales and, hopefully, her net income. She is considering two alternatives which she believes will result in increased business. Her current investments earn 4% and she plans to use a 4-year horizon to determine the best approach. Option A: Her first option is to increase her current advertising expense of $1,800 per year by 15%. As a result, she expects her annual sales of $25,000 to increase by 2% and her annual labor cost of $4,800 to also increase by 2%. \begin{tabular}{|c|c|c|c|c|c|} \hline Period & 1% & 2% & 3% & 4% & 5% \\ \hline 6% & 7% & 8% & 9% & 10% & \\ \hline 1 & 1.0000 & 1.0200 & 1.0300 & 1.0400 & 1.0500 \\ \hline 1.0600 & 1.0700 & 1.0800 & 1.0900 & 1.1000 & \\ \hline 2 & 2.0100 & 2.0200 & 2.0300 & 2.0400 & 2.0500 \\ \hline 2.0600 & 2.0700 & 2.0800 & 2.0900 & 2.1000 & \\ \hline 3 & 3.0301 & 3.0604 & 3.0909 & 3.1216 & 3.1525 \\ \hline 3.1836 & 3.2149 & 3.2464 & 3.2781 & 3.3100 & \\ \hline 4 & 4.0604 & 4.1216 & 4.1836 & 4.2465 & 4.3101 \\ \hline 4.3746 & 4.4399 & 4.5061 & 4.5731 & 4.6410 & \\ \hline 5 & 5.1010 & 5.2040 & 5.3091 & 5.4163 & 5.5256 \\ \hline 5.6371 & 5.7507 & 5.8666 & 5.9847 & 6.1051 & \\ \hline 6 & 6.1520 & 6.3081 & 6.4684 & 6.6330 & 6.8019 \\ \hline 6.9753 & 7.1533 & 7.3359 & 7.5233 & 7.7156 & \\ \hline 7 & 7.2135 & 7.4343 & 7.6625 & 7.8983 & 8.1420 \\ \hline 8.3938 & 8.6540 & 8.9228 & 9.2004 & 9.4872 & \\ \hline 8 & 8.2857 & 8.5830 & 8.8923 & 9.2142 & 9.5491 \\ \hline 9.8975 & 10.260 & 10.637 & 11.028 & 11.436 & \\ \hline 9 & 9.3685 & 9.7546 & 10.159 & 10.583 & 11.027 \\ \hline 11.491 & 11.978 & 12.488 & 13.021 & 13.579 & \\ \hline 10 & 10.462 & 10.950 & 11.464 & 12.006 & 12.578 \\ \hline 13.181 & 13.816 & 14.487 & 15.193 & 15.937 & \\ \hline 11 & 11.567 & 12.169 & 12.808 & 13.486 & 14.207 \\ \hline 14.972 & 15.784 & 16.645 & 17.560 & 18.531 & \\ \hline 12 & 12.683 & 13.412 & 14.192 & 15.026 & 15.917 \\ \hline 16.870 & 17.888 & 18.977 & 20.141 & 21.384 & \\ \hline 13 & 13.809 & 14.680 & 15.618 & 16.627 & 17.713 \\ \hline 18.882 & 20.141 & 21.495 & 22.953 & 24.523 & \\ \hline 14 & 14.947 & 15.974 & 17.086 & 18.292 & 19.599 \\ \hline 21.015 & 22.550 & 24.215 & 26.019 & 27.975 & \\ \hline 15 & 16.097 & 17.293 & 18.599 & 20.024 & 21.579 \\ \hline 23.276 & 25.129 & 27.152 & 29.361 & 31.772 & \\ \hline 16 & 17.258 & 18.639 & 20.157 & 21.825 & 23.657 \\ \hline 25.673 & 27.888 & 30.324 & 33.003 & 35.950 & \\ \hline 17 & 18.430 & 20.012 & 21.762 & 23.698 & 25.840 \\ \hline 28.213 & 30.840 & 33.750 & 36.974 & 40.545 & \\ \hline 18 & 19.615 & 21.412 & 23.414 & 25.645 & 28.132 \\ \hline 30.906 & 33.999 & 37.450 & 41.301 & 45.599 & \\ \hline 19 & 20.811 & 22.841 & 25.117 & 27.671 & 30.539 \\ \hline 33.760 & 37.379 & 41.446 & 46.018 & 51.159 & \\ \hline 20 & 22.019 & 24.297 & 26.870 & 29.778 & 33.066 \\ \hline 36.786 & 40.995 & 45.762 & 51.160 & 57.275 & \\ \hline & 26.973 & 30.422 & 34.426 & 39.083 & 44.502 \\ \hline 50.816 & 58.177 & 66.765 & 76.790 & 88.497 & \\ \hline 36 & 43.077 & 51.994 & 63.276 & 77.598 & 95.836 \\ \hline 119.121 & 148.913 & \begin{tabular}{l} 187.102 \\ \end{tabular} & 236.125 & 299.127 & \\ \hline \end{tabular}