The is an excell file about course, Engineering Economy. Ive attached the excell file and time value of money factory tables. Could you have a look at the questions first to see if you have somebody who can solve it in excell? Document Preview: Compound Interest Tables APPENDIX B 559 Values of Interest Factors When N Equals Infinity Single Payment: Uniform Payment Series: (FP, i,8)=8 (AF, i,8) = 0 (PF, i,8) =0 (AP, i,8) = i Arithmetic Gradient Series: (FA, i,8)=8 (AG, i,8) = 1i (PA, i,8) = 1i (PG, i,8) = 1i2 newn42040 appB.qxd 1/5/04 10:52 AM Page 559560 COMPOUND INTEREST TABLES 1/4% Compound Interest Factors 1/4% Single Payment Uniform Payment Series Arithmetic Gradient Compound Present Sinking Capital Compound Present Gradient Gradient Amount Worth Fund Recovery Amount Worth Uniform Present Factor Factor Factor Factor Factor Factor Series Worth Find F Find P Find A Find A Find F Find P Find A Find P Given P Given F Given F Given P Given A Given A Given G Given G n F/P P/F A/F A/P F/A P/A A/G P/G n 1 1.003 .9975 1.0000 1.0025 1.000 0.998 0 0 1 2 1.005 .9950 .4994 .5019 2.003 1.993 0.504 1.005 2 3 1.008 .9925 .3325 .3350 3.008 2.985 1.005 2.999 3 4 1.010 .9901 .2491 .2516 4.015 3.975 1.501 5.966 4 5 1.013 .9876 .1990 .2015 5.025 4.963 1.998 9.916 5 6 1.015 .9851 .1656 .1681 6.038 5.948 2.498 14.861 6 7 1.018 .9827 .1418 .1443 7.053 6.931 2.995 20.755 7 8 1.020 .9802 .1239 .1264 8.070 7.911 3.490 27.611 8 9 1.023 .9778 .1100 .1125 9.091 8.889 3.987 35.440 9 10 1.025 .9753 .0989 .1014 10.113 9.864 4.483 44.216 10 11 1.028 .9729 .0898 .0923 11.139 10.837 4.978 53.950 11 12 1.030 .9705 .0822 .0847 12.167 11.807 5.474 64.634 12 13 1.033 .9681 .0758 .0783 13.197 12.775 5.968 76.244 13 14 1.036 .9656 .0703 .0728 14.230 13.741 6.464 88.826 14 15 1.038 .9632 .0655 .0680 15.266 14.704 6.957 102.301 15 16 1.041 .9608 .0613 .0638 16.304 15.665 7.451 116.716 16 17 1.043 .9584 .0577 .0602 17.344 16.624 7.944 132.063 17 18 1.046 .9561 .0544 .0569 18.388 17.580 8.437 148.319 18 19 1.049 .9537 .0515 .0540 19.434 18.533 8.929 165.492 19 20 1.051 .9513 .0488 .0513 20.482 19.485 9.421 183.559 20 21 1.054 .9489 .0464 .0489 21.534 20.434 9.912 202.531 21 22 1.056 .9465 .0443 .0468 22.587 21.380 10.404 222.435 22 23 1.059 .9442 Attachments: interestTable.pdf Engineering-E.xlsx; The is an excell file about course, Engineering Economy. Ive attached the excell file and time value of money factory tables. Could you have a look at the questions first to see if you have somebody who can solve it in excell? Document Preview: Compound Interest Tables APPENDIX B 559 Values of Interest Factors When N Equals Infinity Single Payment: Uniform Payment Series: (FP, i,8)=8 (AF, i,8) = 0 (PF, i,8) =0 (AP, i,8) = i Arithmetic Gradient Series: (FA, i,8)=8 (AG, i,8) = 1i (PA, i,8) = 1i (PG, i,8) = 1i2 newn42040 appB.qxd 1/5/04 10:52 AM Page 559560 COMPOUND INTEREST TABLES 1/4% Compound Interest Factors 1/4% Single Payment Uniform Payment Series Arithmetic Gradient Compound Present Sinking Capital Compound Present Gradient Gradient Amount Worth Fund Recovery Amount Worth Uniform Present Factor Factor Factor Factor Factor Factor Series Worth Find F Find P Find A Find A Find F Find P Find A Find P Given P Given F Given F Given P Given A Given A Given G Given G n F/P P/F A/F A/P F/A P/A A/G P/G n 1 1.003 .9975 1.0000 1.0025 1.000 0.998 0 0 1 2 1.005 .9950 .4994 .5019 2.003 1.993 0.504 1.005 2 3 1.008 .9925 .3325 .3350 3.008 2.985 1.005 2.999 3 4 1.010 .9901 .2491 .2516 4.015 3.975 1.501 5.966 4 5 1.013 .9876 .1990 .2015 5.025 4.963 1.998 9.916 5 6 1.015 .9851 .1656 .1681 6.038 5.948 2.498 14.861 6 7 1.018 .9827 .1418 .1443 7.053 6.931 2.995 20.755 7 8 1.020 .9802 .1239 .1264 8.070 7.911 3.490 27.611 8 9 1.023 .9778 .1100 .1125 9.091 8.889 3.987 35.440 9 10 1.025 .9753 .0989 .1014 10.113 9.864 4.483 44.216 10 11 1.028 .9729 .0898 .0923 11.139 10.837 4.978 53.950 11 12 1.030 .9705 .0822 .0847 12.167 11.807 5.474 64.634 12 13 1.033 .9681 .0758 .0783 13.197 12.775 5.968 76.244 13 14 1.036 .9656 .0703 .0728 14.230 13.741 6.464 88.826 14 15 1.038 .9632 .0655 .0680 15.266 14.704 6.957 102.301 15 16 1.041 .9608 .0613 .0638 16.304 15.665 7.451 116.716 16 17 1.043 .9584 .0577 .0602 17.344 16.624 7.944 132.063 17 18 1.046 .9561 .0544 .0569 18.388 17.580 8.437 148.319 18 19 1.049 .9537 .0515 .0540 19.434 18.533 8.929 165.492 19 20 1.051 .9513 .0488 .0513 20.482 19.485 9.421 183.559 20 21 1.054 .9489 .0464 .0489 21.534 20.434 9.912 202.531 21 22 1.056 .9465 .0443 .0468 22.587 21.380 10.404 222.435 22 23 1.059 .9442 Attachments: interestTable.pdf Engineering-E.xlsx
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]