A-2 Appendix A Mathematical Tables Table A-1 Present Value of $1 Due at the End of n Periods Equation: PVIE , = + ) N Financial Calculator Keys: 0 1.0 O PV PMT FV Table Value Period 19 2% 3% 5% 7% 8% 9% 9346 19 90% .82% 8734 .9901 9803 9706 .9610 9515 9804 9612 9423 9238 9057 9709 9426 9151 .8885 .8626 .9615 .9246 .8890 8548 .8219 9524 9070 .8638 .8227 .7835 9434 .8900 8396 .7921 17473 9259 .8573 .7938 .7350 .6806 .8163 .7629 .7130 . 9174 8417 .7722 .7084 .6199 .751 .620 .6663 .564 9420 9327 9235 9143 9053 .8880 .8706 .8535 8368 .8203 513 .8375 .8131 .7894 .7664 7441 -7903 .7599 .7307 .7026 .6756 .7462 .7107 .6768 .6446 .6139 .7050 6651 .6274 5919 .6227 5820 .6302 .5835 .5403 -5002 1632 .5963 .5470 5019 4604 .4224 .46 5439 .5083 424 385 -5584 .7224 6496 .8043 7885 7014 .6246 .4289 3971 8963 .8874 8787 .8700 8613 -7730 .5847 5568 5303 -5051 .4810 5268 .4970 .4688 4423 4173 350 318 .289 .6810 .6611 .6419 4751 .4440 .4150 3878 3624 .6006 5775 .5553 3677 3875 -3555 3262 2992 2745 ..7579 .7430 3405 .3152 263 239 .8528 8444 .8360 .8277 .217 197 .7284 .7142 .7002 .6864 .6730 .6232 -6050 5874 5703 .5537 5339 .5134 4936 4746 .4564 .4581 .4363 .4155 3957 3769 3936 3714 3503 3305 3118 3387 3166 2959 2765 2581 2919 2703 .2502 .2317 .2145 2519 2311 .2120 .1945 1784 .179 163 8195 .1481 .8114 8034 .7954 .7876 -7798 .6598 .6468 6342 .135. .122 5375 .5219 5067 4919 .4776 .4388 4220 4057 3901 3751 3589 3418 .3256 3101 2953 .2942 .2775 2618 2470 .2330 .2415 .2257 2109 .1971 .1842 1987 .1839 .1703 1577 .1460 .1637 .1502 .1378 .1264 1160 .6217 .101 .0923 .6095 .4637 .4502 0835 .0763 .7720 .7644 .7568 .7493 .7419 5976 5859 .5744 5631 5521 1371 .4243 3607 3468 3335 3207 3083 .2812 2678 2551 .2429 .2314 2198 2074 - .1956 .1816 .1741 .1722 .1609 .1504 1406 .1314 .1352 .1252 .1159 .1073 .0994 .1064 .0976 .0895 .0822 0754 0693 0630 0573 .4120 0356 -7059 .6717 .6391 .6080 .5785 .5000 .4529 .4102 .3715. 3365, 3554 .3066 2644 2281 .1968 -2534 2083 .1712 1407 1157 .1813 .1420 .1113 0872 0683 .1301 .0972 .0727 0543 .0406 .0937 .0668 .0476 .0339 0242 .0676 .0160 .0313 .0213 .0145 .0490 .0318 ,0207 .0134 .0087 20221 0137 0085 0053 - Feasibility Analyses Tools Given the scenario listed below please derive the shadowed cells. Use the spreadsheet provided to place formulas needed to derive values in place of letters A-W. In place of cell X, write in the result and provide an explanation of how you derived your answer. Year 0 Year 1 Year 2 Year 3 Totals $0 $40,000 $45,000 $45,000 Net Economic Benefit Discount Rate (5%) PV of Benefits NPV of Benefits $0 $0 A D B E C F | | One-time Costs $30,000 $0 $15,000 $15,000 $15,000 Recurring Costs Discount Rate (5%) PV of Recurring Costs NPV of all Costs $0 G K H L I M J Overall NPV Overall ROI III Break-Even Analysis Yearly NPV Cash Flow Overall NPV Cash Flow - Project break-even occurs between years
