can someone show me step by step how to calculate net present value given this information please and thank you!

Item Initial Investment Working capital Investment Road Construction Annual Net Cash Inflows Working Capital Released Salvage Value Years Now Now 3 1-4 4 4 Cash Flow 15% Factor PV of Cash Flows $0 $0 $0 $0 $0 $0 $0 Present Value of an Annuity Payment Years Annual Rate Present Value Factor $0 #DIV/0! Present Value of a Lump Sum Future Value Years Annual Rate Present Value PV Factor $0 1.0000 Present Value of $1 Periods 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 1% 0.990 0.980 0.971 0.961 0.951 0.942 0.933 0.923 0.914 0.905 0.896 0.887 0.879 0.870 0.861 0.853 0.844 0.836 0.828 0.820 0.811 0.803 0.795 0.788 0.780 0.772 0.764 0.757 0.749 0.742 0.735 0.727 0.720 0.713 0.706 0.699 0.692 0.685 0.678 0.672 0.665 0.658 0.652 0.645 0.639 0.633 0.626 0.620 0.614 0.608 2% 0.980 0.961 0.942 0.924 0.906 0.888 0.871 0.853 0.837 0.820 0.804 0.788 0.773 0.758 0.743 0.728 0.714 0.700 0.686 0.673 0.660 0.647 0.634 0.622 0.610 0.598 0.586 0.574 0.563 0.552 0.541 0.531 0.520 0.510 0.500 0.490 0.481 0.471 0.462 0.453 0.444 0.435 0.427 0.418 0.410 0.402 0.394 0.387 0.379 0.372 3% 0.971 0.943 0.915 0.888 0.863 0.837 0.813 0.789 0.766 0.744 0.722 0.701 0.681 0.661 0.642 0.623 0.605 0.587 0.570 0.554 0.538 0.522 0.507 0.492 0.478 0.464 0.450 0.437 0.424 0.412 0.400 0.388 0.377 0.366 0.355 0.345 0.335 0.325 0.316 0.307 0.298 0.289 0.281 0.272 0.264 0.257 0.249 0.242 0.235 0.228 4% 0.962 0.925 0.889 0.855 0.822 0.790 0.760 0.731 0.703 0.676 0.650 0.625 0.601 0.577 0.555 0.534 0.513 0.494 0.475 0.456 0.439 0.422 0.406 0.390 0.375 0.361 0.347 0.333 0.321 0.308 0.296 0.285 0.274 0.264 0.253 0.244 0.234 0.225 0.217 0.208 0.200 0.193 0.185 0.178 0.171 0.165 0.158 0.152 0.146 0.141 5% 0.952 0.907 0.864 0.823 0.784 0.746 0.711 0.677 0.645 0.614 0.585 0.557 0.530 0.505 0.481 0.458 0.436 0.416 0.396 0.377 0.359 0.342 0.326 0.310 0.295 0.281 0.268 0.255 0.243 0.231 0.220 0.210 0.200 0.190 0.181 0.173 0.164 0.157 0.149 0.142 0.135 0.129 0.123 0.117 0.111 0.106 0.101 0.096 0.092 0.087 6% 0.943 0.890 0.840 0.792 0.747 0.705 0.665 0.627 0.592 0.558 0.527 0.497 0.469 0.442 0.417 0.394 0.371 0.350 0.331 0.312 0.294 0.278 0.262 0.247 0.233 0.220 0.207 0.196 0.185 0.174 0.164 0.155 0.146 0.138 0.130 0.123 0.116 0.109 0.103 0.097 0.092 0.087 0.082 0.077 0.073 0.069 0.065 0.061 0.058 0.054 7% 0.935 0.873 0.816 0.763 0.713 0.666 0.623 0.582 0.544 0.508 0.475 0.444 0.415 0.388 0.362 0.339 0.317 0.296 0.277 0.258 0.242 0.226 0.211 0.197 0.184 0.172 0.161 0.150 0.141 0.131 0.123 0.115 0.107 0.100 0.094 0.088 0.082 0.076 0.071 0.067 0.062 0.058 0.055 0.051 0.048 0.044 0.042 0.039 0.036 0.034 8% 0.926 0.857 0.794 0.735 0.681 0.630 0.583 0.540 0.500 0.463 0.429 0.397 0.368 0.340 0.315 0.292 0.270 0.250 0.232 0.215 0.199 0.184 0.170 0.158 0.146 0.135 0.125 0.116 0.107 0.099 0.092 0.085 0.079 0.073 0.068 0.063 0.058 0.054 0.050 0.046 0.043 0.039 0.037 0.034 0.031 0.029 0.027 0.025 0.023 0.021 9% 0.917 0.842 0.772 0.708 0.650 0.596 0.547 0.502 0.460 0.422 0.388 0.356 0.326 0.299 0.275 0.252 0.231 0.212 0.194 0.178 0.164 0.150 0.138 0.126 0.116 0.106 0.098 0.090 0.082 0.075 0.069 0.063 0.058 0.053 0.049 0.045 0.041 0.038 0.035 0.032 0.029 0.027 0.025 0.023 0.021 0.019 0.017 0.016 0.015 0.013 10% 0.909 0.826 0.751 0.683 0.621 0.564 0.513 0.467 0.424 0.386 0.350 0.319 0.290 0.263 0.239 0.218 0.198 0.180 0.164 0.149 0.135 0.123 0.112 0.102 0.092 0.084 0.076 0.069 0.063 0.057 0.052 0.047 0.043 0.039 0.036 0.032 0.029 0.027 0.024 0.022 0.020 0.018 0.017 0.015 0.014 0.012 0.011 0.010 0.009 0.009 11% 0.901 0.812 0.731 0.659 0.593 0.535 0.482 0.434 0.391 0.352 0.317 0.286 0.258 0.232 0.209 0.188 0.170 0.153 0.138 0.124 0.112 0.101 0.091 0.082 0.074 0.066 0.060 0.054 0.048 0.044 0.039 0.035 0.032 0.029 0.026 0.023 0.021 0.019 0.017 0.015 0.014 0.012 0.011 0.010 0.009 0.008 0.007 0.007 0.006 0.005 12% 0.893 0.797 0.712 0.636 0.567 0.507 0.452 0.404 0.361 0.322 0.287 0.257 0.229 0.205 0.183 0.163 0.146 0.130 0.116 0.104 0.093 0.083 0.074 0.066 0.059 0.053 0.047 0.042 0.037 0.033 0.030 0.027 0.024 0.021 0.019 0.017 0.015 0.013 0.012 0.011 0.010 0.009 0.008 0.007 0.006 0.005 0.005 0.004 0.004 0.003 13% 0.885 0.783 0.693 0.613 0.543 0.480 0.425 0.376 0.333 0.295 0.261 0.231 0.204 0.181 0.160 0.141 0.125 0.111 0.098 0.087 0.077 0.068 0.060 0.053 0.047 0.042 0.037 0.033 0.029 0.026 0.023 0.020 0.018 0.016 0.014 0.012 0.011 0.010 0.009 0.008 0.007 0.006 0.005 0.005 0.004 0.004 0.003 0.003 0.003 0.002 14% 0.877 0.769 0.675 0.592 0.519 0.456 0.400 0.351 0.308 0.270 0.237 0.208 0.182 0.160 0.140 0.123 0.108 0.095 0.083 0.073 0.064 0.056 0.049 0.043 0.038 0.033 0.029 0.026 0.022 0.020 0.017 0.015 0.013 0.012 0.010 0.009 0.008 0.007 0.006 0.005 0.005 0.004 0.004 0.003 0.003 0.002 0.002 0.002 0.002 0.001 15% 0.870 0.756 0.658 0.572 0.497 0.432 0.376 0.327 0.284 0.247 0.215 0.187 0.163 0.141 0.123 0.107 0.093 0.081 0.070 0.061 0.053 0.046 0.040 0.035 0.030 0.026 0.023 0.020 0.017 0.015 0.013 0.011 0.010 0.009 0.008 0.007 0.006 0.005 0.004 0.004 0.003 0.003 0.002 0.002 0.002 0.002 0.001 0.001 0.001 0.001 16% 0.862 0.743 0.641 0.552 0.476 0.410 0.354 0.305 0.263 0.227 0.195 0.168 0.145 0.125 0.108 0.093 0.080 0.069 0.060 0.051 0.044 0.038 0.033 0.028 0.024 0.021 0.018 0.016 0.014 0.012 0.010 0.009 0.007 0.006 0.006 0.005 0.004 0.004 0.003 0.003 0.002 0.002 0.002 0.001 0.001 0.001 0.001 0.001 0.001 0.001 17% 0.855 0.731 0.624 0.534 0.456 0.390 0.333 0.285 0.243 0.208 0.178 0.152 0.130 0.111 0.095 0.081 0.069 0.059 0.051 0.043 0.037 0.032 0.027 0.023 0.020 0.017 0.014 0.012 0.011 0.009 0.008 0.007 0.006 0.005 0.004 0.004 0.003 0.003 0.002 0.002 0.002 0.001 0.001 0.001 0.001 0.001 0.001 0.001 0.000 0.000 18% 0.847 0.718 0.609 0.516 0.437 0.370 0.314 0.266 0.225 0.191 0.162 0.137 0.116 0.099 0.084 0.071 0.060 0.051 0.043 0.037 0.031 0.026 0.022 0.019 0.016 0.014 0.011 0.010 0.008 0.007 0.006 0.005 0.004 0.004 0.003 0.003 0.002 0.002 0.002 0.001 0.001 0.001 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 19% 0.840 0.706 0.593 0.499 0.419 0.352 0.296 0.249 0.209 0.176 0.148 0.124 0.104 0.088 0.074 0.062 0.052 0.044 0.037 0.031 0.026 0.022 0.018 0.015 0.013 0.011 0.009 0.008 0.006 0.005 0.005 0.004 0.003 0.003 0.002 0.002 0.002 0.001 0.001 0.001 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 20% 0.833 0.694 0.579 0.482 0.402 0.335 0.279 0.233 0.194 0.162 0.135 0.112 0.093 0.078 0.065 0.054 0.045 0.038 0.031 0.026 0.022 0.018 0.015 0.013 0.010 0.009 0.007 0.006 0.005 0.004 0.004 0.003 0.002 0.002 0.002 0.001 0.001 0.001 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 21% 0.826 0.683 0.564 0.467 0.386 0.319 0.263 0.218 0.180 0.149 0.123 0.102 0.084 0.069 0.057 0.047 0.039 0.032 0.027 0.022 0.018 0.015 0.012 0.010 0.009 0.007 0.006 0.005 0.004 0.003 0.003 0.002 0.002 0.002 0.001 0.001 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 22% 0.820 0.672 0.551 0.451 0.370 0.303 0.249 0.204 0.167 0.137 0.112 0.092 0.075 0.062 0.051 0.042 0.034 0.028 0.023 0.019 0.015 0.013 0.010 0.008 0.007 0.006 0.005 0.004 0.003 0.003 0.002 0.002 0.001 0.001 0.001 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 23% 0.813 0.661 0.537 0.437 0.355 0.289 0.235 0.191 0.155 0.126 0.103 0.083 0.068 0.055 0.045 0.036 0.030 0.024 0.020 0.016 0.013 0.011 0.009 0.007 0.006 0.005 0.004 0.003 0.002 0.002 0.002 0.001 0.001 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 24% 0.806 0.650 0.524 0.423 0.341 0.275 0.222 0.179 0.144 0.116 0.094 0.076 0.061 0.049 0.040 0.032 0.026 0.021 0.017 0.014 0.011 0.009 0.007 0.006 0.005 0.004 0.003 0.002 0.002 0.002 0.001 0.001 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 25% 0.800 0.640 0.512 0.410 0.328 0.262 0.210 0.168 0.134 0.107 0.086 0.069 0.055 0.044 0.035 0.028 0.023 0.018 0.014 0.012 0.009 0.007 0.006 0.005 0.004 0.003 0.002 0.002 0.002 0.001 0.001 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 30% 0.769 0.592 0.455 0.350 0.269 0.207 0.159 0.123 0.094 0.073 0.056 0.043 0.033 0.025 0.020 0.015 0.012 0.009 0.007 0.005 0.004 0.003 0.002 0.002 0.001 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 35% 0.741 0.549 0.406 0.301 0.223 0.165 0.122 0.091 0.067 0.050 0.037 0.027 0.020 0.015 0.011 0.008 0.006 0.005 0.003 0.002 0.002 0.001 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 40% 0.714 0.510 0.364 0.260 0.186 0.133 0.095 0.068 0.048 0.035 0.025 0.018 0.013 0.009 0.006 0.005 0.003 0.002 0.002 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 50% 0.667 0.444 0.296 0.198 0.132 0.088 0.059 0.039 0.026 0.017 0.012 0.008 0.005 0.003 0.002 0.002 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 Present Value of an annuity $1 Periods 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 1% 0.990 1.970 2.941 3.902 4.853 5.795 6.728 7.652 8.566 9.471 10.368 11.255 12.134 13.004 13.865 14.718 15.562 16.398 17.226 18.046 18.857 19.660 20.456 21.243 22.023 22.795 23.560 24.316 25.066 25.808 26.542 27.270 27.990 28.703 29.409 30.108 30.800 31.485 32.163 32.835 33.500 34.158 34.810 35.455 36.095 36.727 37.354 37.974 38.588 39.196 2% 0.980 1.942 2.884 3.808 4.713 5.601 6.472 7.325 8.162 8.983 9.787 10.575 11.348 12.106 12.849 13.578 14.292 14.992 15.678 16.351 17.011 17.658 18.292 18.914 19.523 20.121 20.707 21.281 21.844 22.396 22.938 23.468 23.989 24.499 24.999 25.489 25.969 26.441 26.903 27.355 27.799 28.235 28.662 29.080 29.490 29.892 30.287 30.673 31.052 31.424 3% 0.971 1.913 2.829 3.717 4.580 5.417 6.230 7.020 7.786 8.530 9.253 9.954 10.635 11.296 11.938 12.561 13.166 13.754 14.324 14.877 15.415 15.937 16.444 16.936 17.413 17.877 18.327 18.764 19.188 19.600 20.000 20.389 20.766 21.132 21.487 21.832 22.167 22.492 22.808 23.115 23.412 23.701 23.982 24.254 24.519 24.775 25.025 25.267 25.502 25.730 4% 0.962 1.886 2.775 3.630 4.452 5.242 6.002 6.733 7.435 8.111 8.760 9.385 9.986 10.563 11.118 11.652 12.166 12.659 13.134 13.590 14.029 14.451 14.857 15.247 15.622 15.983 16.330 16.663 16.984 17.292 17.588 17.874 18.148 18.411 18.665 18.908 19.143 19.368 19.584 19.793 19.993 20.186 20.371 20.549 20.720 20.885 21.043 21.195 21.341 21.482 5% 0.952 1.859 2.723 3.546 4.329 5.076 5.786 6.463 7.108 7.722 8.306 8.863 9.394 9.899 10.380 10.838 11.274 11.690 12.085 12.462 12.821 13.163 13.489 13.799 14.094 14.375 14.643 14.898 15.141 15.372 15.593 15.803 16.003 16.193 16.374 16.547 16.711 16.868 17.017 17.159 17.294 17.423 17.546 17.663 17.774 17.880 17.981 18.077 18.169 18.256 6% 0.943 1.833 2.673 3.465 4.212 4.917 5.582 6.210 6.802 7.360 7.887 8.384 8.853 9.295 9.712 10.106 10.477 10.828 11.158 11.470 11.764 12.042 12.303 12.550 12.783 13.003 13.211 13.406 13.591 13.765 13.929 14.084 14.230 14.368 14.498 14.621 14.737 14.846 14.949 15.046 15.138 15.225 15.306 15.383 15.456 15.524 15.589 15.650 15.708 15.762 7% 0.935 1.808 2.624 3.387 4.100 4.767 5.389 5.971 6.515 7.024 7.499 7.943 8.358 8.745 9.108 9.447 9.763 10.059 10.336 10.594 10.836 11.061 11.272 11.469 11.654 11.826 11.987 12.137 12.278 12.409 12.532 12.647 12.754 12.854 12.948 13.035 13.117 13.193 13.265 13.332 13.394 13.452 13.507 13.558 13.606 13.650 13.692 13.730 13.767 13.801 8% 0.926 1.783 2.577 3.312 3.993 4.623 5.206 5.747 6.247 6.710 7.139 7.536 7.904 8.244 8.559 8.851 9.122 9.372 9.604 9.818 10.017 10.201 10.371 10.529 10.675 10.810 10.935 11.051 11.158 11.258 11.350 11.435 11.514 11.587 11.655 11.717 11.775 11.829 11.879 11.925 11.967 12.007 12.043 12.077 12.108 12.137 12.164 12.189 12.212 12.233 9% 0.917 1.759 2.531 3.240 3.890 4.486 5.033 5.535 5.995 6.418 6.805 7.161 7.487 7.786 8.061 8.313 8.544 8.756 8.950 9.129 9.292 9.442 9.580 9.707 9.823 9.929 10.027 10.116 10.198 10.274 10.343 10.406 10.464 10.518 10.567 10.612 10.653 10.691 10.726 10.757 10.787 10.813 10.838 10.861 10.881 10.900 10.918 10.934 10.948 10.962 10% 0.909 1.736 2.487 3.170 3.791 4.355 4.868 5.335 5.759 6.145 6.495 6.814 7.103 7.367 7.606 7.824 8.022 8.201 8.365 8.514 8.649 8.772 8.883 8.985 9.077 9.161 9.237 9.307 9.370 9.427 9.479 9.526 9.569 9.609 9.644 9.677 9.706 9.733 9.757 9.779 9.799 9.817 9.834 9.849 9.863 9.875 9.887 9.897 9.906 9.915 11% 0.901 1.713 2.444 3.102 3.696 4.231 4.712 5.146 5.537 5.889 6.207 6.492 6.750 6.982 7.191 7.379 7.549 7.702 7.839 7.963 8.075 8.176 8.266 8.348 8.422 8.488 8.548 8.602 8.650 8.694 8.733 8.769 8.801 8.829 8.855 8.879 8.900 8.919 8.936 8.951 8.965 8.977 8.989 8.999 9.008 9.016 9.024 9.030 9.036 9.042 12% 0.893 1.690 2.402 3.037 3.605 4.111 4.564 4.968 5.328 5.650 5.938 6.194 6.424 6.628 6.811 6.974 7.120 7.250 7.366 7.469 7.562 7.645 7.718 7.784 7.843 7.896 7.943 7.984 8.022 8.055 8.085 8.112 8.135 8.157 8.176 8.192 8.208 8.221 8.233 8.244 8.253 8.262 8.270 8.276 8.283 8.288 8.293 8.297 8.301 8.304 13% 0.885 1.668 2.361 2.974 3.517 3.998 4.423 4.799 5.132 5.426 5.687 5.918 6.122 6.302 6.462 6.604 6.729 6.840 6.938 7.025 7.102 7.170 7.230 7.283 7.330 7.372 7.409 7.441 7.470 7.496 7.518 7.538 7.556 7.572 7.586 7.598 7.609 7.618 7.627 7.634 7.641 7.647 7.652 7.657 7.661 7.664 7.668 7.671 7.673 7.675 14% 0.877 1.647 2.322 2.914 3.433 3.889 4.288 4.639 4.946 5.216 5.453 5.660 5.842 6.002 6.142 6.265 6.373 6.467 6.550 6.623 6.687 6.743 6.792 6.835 6.873 6.906 6.935 6.961 6.983 7.003 7.020 7.035 7.048 7.060 7.070 7.079 7.087 7.094 7.100 7.105 7.110 7.114 7.117 7.120 7.123 7.126 7.128 7.130 7.131 7.133 15% 0.870 1.626 2.283 2.855 3.352 3.784 4.160 4.487 4.772 5.019 5.234 5.421 5.583 5.724 5.847 5.954 6.047 6.128 6.198 6.259 6.312 6.359 6.399 6.434 6.464 6.491 6.514 6.534 6.551 6.566 6.579 6.591 6.600 6.609 6.617 6.623 6.629 6.634 6.638 6.642 6.645 6.648 6.650 6.652 6.654 6.656 6.657 6.659 6.660 6.661 16% 0.862 1.605 2.246 2.798 3.274 3.685 4.039 4.344 4.607 4.833 5.029 5.197 5.342 5.468 5.575 5.668 5.749 5.818 5.877 5.929 5.973 6.011 6.044 6.073 6.097 6.118 6.136 6.152 6.166 6.177 6.187 6.196 6.203 6.210 6.215 6.220 6.224 6.228 6.231 6.233 6.236 6.238 6.239 6.241 6.242 6.243 6.244 6.245 6.246 6.246 17% 0.855 1.585 2.210 2.743 3.199 3.589 3.922 4.207 4.451 4.659 4.836 4.988 5.118 5.229 5.324 5.405 5.475 5.534 5.584 5.628 5.665 5.696 5.723 5.746 5.766 5.783 5.798 5.810 5.820 5.829 5.837 5.844 5.849 5.854 5.858 5.862 5.865 5.867 5.869 5.871 5.873 5.874 5.875 5.876 5.877 5.878 5.879 5.879 5.880 5.880 18% 0.847 1.566 2.174 2.690 3.127 3.498 3.812 4.078 4.303 4.494 4.656 4.793 4.910 5.008 5.092 5.162 5.222 5.273 5.316 5.353 5.384 5.410 5.432 5.451 5.467 5.480 5.492 5.502 5.510 5.517 5.523 5.528 5.532 5.536 5.539 5.541 5.543 5.545 5.547 5.548 5.549 5.550 5.551 5.552 5.552 5.553 5.553 5.554 5.554 5.554 19% 0.840 1.547 2.140 2.639 3.058 3.410 3.706 3.954 4.163 4.339 4.486 4.611 4.715 4.802 4.876 4.938 4.990 5.033 5.070 5.101 5.127 5.149 5.167 5.182 5.195 5.206 5.215 5.223 5.229 5.235 5.239 5.243 5.246 5.249 5.251 5.253 5.255 5.256 5.257 5.258 5.259 5.260 5.260 5.261 5.261 5.261 5.262 5.262 5.262 5.262 20% 0.833 1.528 2.106 2.589 2.991 3.326 3.605 3.837 4.031 4.192 4.327 4.439 4.533 4.611 4.675 4.730 4.775 4.812 4.843 4.870 4.891 4.909 4.925 4.937 4.948 4.956 4.964 4.970 4.975 4.979 4.982 4.985 4.988 4.990 4.992 4.993 4.994 4.995 4.996 4.997 4.997 4.998 4.998 4.998 4.999 4.999 4.999 4.999 4.999 4.999 21% 0.826 1.509 2.074 2.540 2.926 3.245 3.508 3.726 3.905 4.054 4.177 4.278 4.362 4.432 4.489 4.536 4.576 4.608 4.635 4.657 4.675 4.690 4.703 4.713 4.721 4.728 4.734 4.739 4.743 4.746 4.749 4.751 4.753 4.755 4.756 4.757 4.758 4.759 4.759 4.760 4.760 4.760 4.761 4.761 4.761 4.761 4.761 4.761 4.761 4.762 22% 0.820 1.492 2.042 2.494 2.864 3.167 3.416 3.619 3.786 3.923 4.035 4.127 4.203 4.265 4.315 4.357 4.391 4.419 4.442 4.460 4.476 4.488 4.499 4.507 4.514 4.520 4.524 4.528 4.531 4.534 4.536 4.538 4.539 4.540 4.541 4.542 4.543 4.543 4.544 4.544 4.544 4.544 4.545 4.545 4.545 4.545 4.545 4.545 4.545 4.545 23% 0.813 1.474 2.011 2.448 2.803 3.092 3.327 3.518 3.673 3.799 3.902 3.985 4.053 4.108 4.153 4.189 4.219 4.243 4.263 4.279 4.292 4.302 4.311 4.318 4.323 4.328 4.332 4.335 4.337 4.339 4.341 4.342 4.343 4.344 4.345 4.345 4.346 4.346 4.346 4.347 4.347 4.347 4.347 4.347 4.347 4.348 4.348 4.348 4.348 4.348 24% 0.806 1.457 1.981 2.404 2.745 3.020 3.242 3.421 3.566 3.682 3.776 3.851 3.912 3.962 4.001 4.033 4.059 4.080 4.097 4.110 4.121 4.130 4.137 4.143 4.147 4.151 4.154 4.157 4.159 4.160 4.161 4.162 4.163 4.164 4.164 4.165 4.165 4.165 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.167 4.167 4.167 25% 0.800 1.440 1.952 2.362 2.689 2.951 3.161 3.329 3.463 3.571 3.656 3.725 3.780 3.824 3.859 3.887 3.910 3.928 3.942 3.954 3.963 3.970 3.976 3.981 3.985 3.988 3.990 3.992 3.994 3.995 3.996 3.997 3.997 3.998 3.998 3.999 3.999 3.999 3.999 3.999 4.000 4.000 4.000 4.000 4.000 4.000 4.000 4.000 4.000 4.000 30% 0.769 1.361 1.816 2.166 2.436 2.643 2.802 2.925 3.019 3.092 3.147 3.190 3.223 3.249 3.268 3.283 3.295 3.304 3.311 3.316 3.320 3.323 3.325 3.327 3.329 3.330 3.331 3.331 3.332 3.332 3.332 3.333 3.333 3.333 3.333 3.333 3.333 3.333 3.333 3.333 3.333 3.333 3.333 3.333 3.333 3.333 3.333 3.333 3.333 3.333 35% 0.741 1.289 1.696 1.997 2.220 2.385 2.508 2.598 2.665 2.715 2.752 2.779 2.799 2.814 2.825 2.834 2.840 2.844 2.848 2.850 2.852 2.853 2.854 2.855 2.856 2.856 2.856 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 2.857 40% 0.714 1.224 1.589 1.849 2.035 2.168 2.263 2.331 2.379 2.414 2.438 2.456 2.469 2.478 2.484 2.489 2.492 2.494 2.496 2.497 2.498 2.498 2.499 2.499 2.499 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 50% 0.667 1.111 1.407 1.605 1.737 1.824 1.883 1.922 1.948 1.965 1.977 1.985 1.990 1.993 1.995 1.997 1.998 1.999 1.999 1.999 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2.000 Present Value Calculations (PVIF & PVIFA) Rate (annual rate) Number of periods (in years) PVIF PVIFA PVIFA/Monthly 20.00% 20.00% 20.00% 4 4 4 ($120,000) ($120,000) 0 0 Payment (annual payment- annuity only - enter as a negative number) Future Value (amount to be discounted - enter as a negative number) ($65,000) Type (normally blank - use 0 or 1 for annuity due) Present Value $31,346 $310,648 $460,648 Present Value (using formula) $31,346 $310,648 $460,648