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) reek's reading to solve the situations depicted below: 1. Bob's Music Store is doing well in the area. He has some excess cash in the bank account and is looking at different alternatives that might bring more return than the meager rate his bank is offering. He currently receives 2% interest from his bank, which we will use to determine the net present value of each alternative. He has narrowed it down to two options: 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%. Option B: Her second option is to pay for a new website design. It will cost $300 up front and $300 per year in maintenance. She expects this to increase her annual sales by 2% per year. Calculate the net present value of each alternative. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline1Period & 1.00001% & 1.02002% & 1.03003% & 1.04004% & 1.05005% & 1.06006% & 1.07007% & 1,08008% & 1.09009% & 1.100010% \\ \hline 2 & 2.0100 & 20200 & 2.0300 & 2.0400 & 2.0500 & 2.0600 & 2.0700 & 2.0800 & 2.0900 & 2.1 \\ \hline 3 & 3.0301 & 3.0604 & 3.0909 & 3.1216 & 3.1525 & 3.1836 & 32149 & 3.2464 & 3.2781 & 3. \\ \hline & 0604 & 4.1216 & 4.1836 & 4.2465 & 4.3101 & 4.3746 & 4.4399 & 4.5061 & 4.5731 & 4.64 \\ \hline & 5.1010 & 5.2040 & 5.3091 & 5.4163 & 5.5256 & 5.6371 & 5.7507 & 5.8666 & 5.9847 & 6.10 \\ \hline & 6.1520 & 6.3081 & 6.4684 & 6.6330 & 6.8019 & 6.9753 & 7.1533 & 7.3359 & 7.5233 & 7.7 \\ \hline & 7.2135 & 7.4343 & 7.6625 & 7.8983 & 8.1420 & 8. 3938 & 8.6540 & 8.9228 & 9.2004 & 9.4 \\ \hline & 8.2857 & 8.5830 & 8.8923 & 9.2142 & 9.5491 & 9.8975 & 10.260 & 10.637 & 11.028 & 11.4 \\ \hline & 9.3685 & 9.7546 & 10.159 & 10.583 & 11.027 & 11.491 & 11.978 & 12.488 & 13.021 & 13. \\ \hline 10 & 10.462 & 10.950 & 11.464 & 12.006 & 12.578 & 13.181 & 13.816 & 14.487 & 15.193 & 15.937 \\ \hline 11 & 11.567 & 12.169 & 12.808 & 13.486 & 14.207 & 14.972 & 15.784 & 16.645 & 17.560 & 18.531 \\ \hline 12 & 12.683 & 13.412 & 14.192 & 15.026 & 15.917 & 16.870 & 17.888 & 18.977 & 0.141 & 1.3 \\ \hline 13 & 13.309 & 14.680 & 15.618 & 16.627 & 17.713 & 18.882 & 20.141 & 21.495 & 22.953 & 24.523 \\ \hline 14 & 14.947 & 15.974 & 17.086 & 18.292 & 19.599 & 21.015 & 22.550 & 24.215 & 26.019 & 27.975 \\ \hline 15 & 16.097 & 17.293 & 18.599 & 20.024 & 21.579 & 23.276 & 25.129 & 27.152 & 29.361 & 31.772 \\ \hline 16 & 17.258 & 18.639 & 20.157 & 21.825 & 23.657 & 25.673 & 27888 & 30.324 & 3.003 & 35. \\ \hline 17 & 18.430 & 20.012 & 21.762 & 23.698 & 25.840 & 28.213 & 30.840 & 33.750 & 6.974 & 40 \\ \hline 18 & 19.615 & 21.412 & 23.414 & 25.645 & 28.1 & 30.906 & 33.999 & 37.450 & 41.301 & 40,0390 \\ \hline 19 & 20.811 & 22.841 & 25.117 & 27.671 & 30.53 & 33.760 & 37.379 & 41.446 & 46.018 & 51.1 \\ \hline 20 & 22.019 & 24.297 & 26.870 & 29.778 & 3.066 & 36.786 & 40.995 & 45.762 & 1.160 & 57.2 \\ \hline 24 & 26.973 & 30.422 & 34.426 & 39.083 & 44.502 & 50.816 & 77 & 66.765 & 790 & 88.497 \\ \hline 36 & 43.077 & 51,994 & 63.276 & 77.598 & 95.836 & 19.121 & 148.913 & 187.102 & 236.125 & 299.1 \\ \hline \end{tabular} Future Value of an Annuity