How do I go about doing this?

I need a detailed explanation of what exactly to plug into excel.

thank you

2. The following table is a Annuity Factor (AF) Table (AF for different rates and periods). Remember AF is a PV of several $1 you'll get in the future ( at the end of each period (year)), the equation is 1 1 rr(1+r)^t Use excel to create the table by yourself (i in the table refers to the rate (r)). Present Value Annuity Tables Formula: PV = (1-1/(1+1) 1/1 ni 9% 10% 11% 12% 13% 14% 1 2 3 0.8772 1.6467 2.3216 2.9197 3.4331 3.8887 4.2883 4.6389 4.9464 5.2161 5.4527 5.6603 5.8424 6.0021 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 1% 0.9901 1.9704 2.9410 3.9020 4.8534 5.7955 6.7292 7.6517 8.5660 9.4713 10.3676 11.2551 12.1337 13.0037 13.8651 14.7179 15.5623 16.3983 17.2260 18.0456 18.8570 19.6604 20.4558 21.2434 22.0232 22.7952 23.5596 24.3164 25.0658 25.8077 2% 3% 4% 5% 0.9804 0.9709 0.9615 0.9524 1.9416 1.9135 1.8861 1.8594 2.8839 2.8286 2.7751 2.7232 3.8077 3.7171 3.6299 3.5460 4.7135 45797 4.4518 4.3295 5.6014 5.4172 5.2421 5.0757 6.4720 6.2303 6.0021 5.7864 7.3255 7.0197 6.7327 6.4632 8.1622 7.7861 7.4353 7.1078 8.9826 8.5302 8.1109 7.7217 9.7868 9.2526 8.7605 8.3064 10.5753 9.9540 9.3851 8.8633 11.3484 10.6950 9.9856 9.3936 12.1062 11.2961 10.5631 9.8986 12.8493 11.9379 11.1184 10.3797 13.5777 12.5611 11.6523 10.8378 14.2919 13.1661 12.1657 11 2741 14.9920 13.7535 12.6593 11.6896 15.6785 14.3238 13.1339 12.0853 16.3514 14.8775 13.5903 12.4622 17.0112 15.4150 14.0292 12.8212 17.6580 15.9369 14.4511 13.1630 18.2922 16.4436 14.8568 13.4986 18.9139 16.9355 15.2470 13.7986 19.5235 17.4131 15.6221 14.0939 20.1210 17.8768 15.9928 14.3752 20.7069 18.3270 16.3296 14.6430 21.2813 18.7641 16.6631 14.8981 21.8444 19.1885 16.9837 15.1411 22.3965 19.6004 17.2920 15.3725 6% 7% 8% 0.9434 0.9946 0.9259 1.8334 1.8080 1.7833 2.6730 2.6243 2.5771 3.4651 3.3872 3.3121 42124 4.1002 3.9927 4.9173 4.7665 4.6229 5.5824 5.3893 5.2064 6.2098 5.9713 5.7466 6.8017 6.5152 6.2469 7.3601 7.0236 6.7101 7.8869 7.4987 7.1390 8.3838 7.9427 7.5361 8.8527 8.3577 7.9038 9.2950 8.7455 8.2442 9.7122 9.1079 8.5595 10.1059 9.4466 8.8514 10.4773 9.7632 9.1216 10.8276 10.0591 9.3719 11.1581 10.3356 9.6036 11.4699 10.5940 9.8181 11.7641 10.8355 10.0168 12.0416 11.0612 10.2007 12.3034 11.2722 10.3711 12.5504 11.4693 10.5288 12.7834 11.6536 10.6748 13.0032 11.8258 10.8100 13.2105 11.9867 10.9352 13.4062 12.1371 11.0511 13.5907 12.2777 11.1584 13.7648 12.4090 11.2578 0.9174 1.7591 2.5313 3.2997 3.8897 4.4859 5.0330 5.5348 5.9952 6.4177 6.8052 7.1607 7.4869 7.7862 8.0607 8.3126 8.5436 8.7556 8.9501 9.1285 9.2922 9.4424 9.5802 9.7066 9.8226 9.9290 10.0266 10.1161 10.1983 10.2737 0.9091 1.7355 2.4869 3.1699 3.7909 4.3553 4.8684 5.3349 5.7590 6.1446 6.4951 6.8137 7.1034 7.3667 7.6061 7.8237 8.0216 8.2014 8.3649 8.5136 8.6487 8.7715 8.8832 8.9847 9.0770 9.1609 9.2372 9.3066 9.3696 9.4269 0.9009 1.7125 2.4437 3.1024 3.6959 4.2305 4.7122 5.1461 5.5370 5.8892 6.2065 6.4924 6.7499 6.9819 7.1909 7.3792 7.5488 7.7016 7.8393 7.9633 8.0751 8.1757 8.2664 8.3481 8.4217 8.4891 8.5478 8.6016 8.6501 8.6938 0.8929 1.6901 2.4018 3.0373 3.6048 4.1114 4.5638 4.9676 5.3282 5.6502 5.9377 6.1944 6.4235 6.6282 6.8109 6.9740 7.1196 7.2497 7.3658 7.4694 7.5620 7.6446 7.7184 7.7843 7.8431 7.8957 7.9426 7.9844 8.0218 8.0552 0.8850 1.6681 2.3612 2.9745 3.5172 3.9975 4.4226 4.7988 5.1317 5.4262 5.6869 5.9176 6.1218 6.3025 6.4624 6.6039 6.7291 6.8399 6.9380 7.0248 7.1016 7.1695 7.2297 7.2829 7.3300 7.3717 7.4086 7.4412 7.4701 7.4957 6.1422 6.2651 6.3729 6.4674 6.5504 6.6231 6.6870 15% 0.8696 1.6257 2.2832 2.8550 3.3522 3.7845 4.1604 4.4873 4.7716 5.0188 5.2337 5.4206 5.5831 5.7245 5.8474 5.9542 6.0472 6.1280 6.1982 6.2593 6.3125 6.3587 6.3988 6.4338 6.4641 6.4906 6.5135 6.5335 6.5509 6.5660 6.7429 6.7921 6.8351 6.8729 6.9061 6.9352 6.9607 6.9830 7.0027 Pay attention-You can use a shortcut way to build the whole table. In the following table Column D includes the periods (1, 2, 3..) and Row 6 includes the rates (1%, 2%. 3%..) E F G D 6 periods 1% 2% 3% 0.9709 7 8 9 1 2 3 0.9901 1.9704 2.9410 0.9804 1.9416 2.8839 1.9135 2.8286 You should calculate AF only for one cell - In the above example use E7. In each cell we would like to use row 6 (rates) and column D (periods). Thus you should lock the row 6 by putting dollar sign before the number 6 (for example E$6) and you should lock the column D by putting dollar sign ($) before the letter D (for example $07). The final equation in cell E7 should be 1 (ESO) -(656 (1 +856) 87 (E$6+ (1 + E$6) then you can cross to the right and then drug down (or double click in the corner). 2. The following table is a Annuity Factor (AF) Table (AF for different rates and periods). Remember AF is a PV of several $1 you'll get in the future ( at the end of each period (year)), the equation is 1 1 rr(1+r)^t Use excel to create the table by yourself (i in the table refers to the rate (r)). Present Value Annuity Tables Formula: PV = (1-1/(1+1) 1/1 ni 9% 10% 11% 12% 13% 14% 1 2 3 0.8772 1.6467 2.3216 2.9197 3.4331 3.8887 4.2883 4.6389 4.9464 5.2161 5.4527 5.6603 5.8424 6.0021 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 1% 0.9901 1.9704 2.9410 3.9020 4.8534 5.7955 6.7292 7.6517 8.5660 9.4713 10.3676 11.2551 12.1337 13.0037 13.8651 14.7179 15.5623 16.3983 17.2260 18.0456 18.8570 19.6604 20.4558 21.2434 22.0232 22.7952 23.5596 24.3164 25.0658 25.8077 2% 3% 4% 5% 0.9804 0.9709 0.9615 0.9524 1.9416 1.9135 1.8861 1.8594 2.8839 2.8286 2.7751 2.7232 3.8077 3.7171 3.6299 3.5460 4.7135 45797 4.4518 4.3295 5.6014 5.4172 5.2421 5.0757 6.4720 6.2303 6.0021 5.7864 7.3255 7.0197 6.7327 6.4632 8.1622 7.7861 7.4353 7.1078 8.9826 8.5302 8.1109 7.7217 9.7868 9.2526 8.7605 8.3064 10.5753 9.9540 9.3851 8.8633 11.3484 10.6950 9.9856 9.3936 12.1062 11.2961 10.5631 9.8986 12.8493 11.9379 11.1184 10.3797 13.5777 12.5611 11.6523 10.8378 14.2919 13.1661 12.1657 11 2741 14.9920 13.7535 12.6593 11.6896 15.6785 14.3238 13.1339 12.0853 16.3514 14.8775 13.5903 12.4622 17.0112 15.4150 14.0292 12.8212 17.6580 15.9369 14.4511 13.1630 18.2922 16.4436 14.8568 13.4986 18.9139 16.9355 15.2470 13.7986 19.5235 17.4131 15.6221 14.0939 20.1210 17.8768 15.9928 14.3752 20.7069 18.3270 16.3296 14.6430 21.2813 18.7641 16.6631 14.8981 21.8444 19.1885 16.9837 15.1411 22.3965 19.6004 17.2920 15.3725 6% 7% 8% 0.9434 0.9946 0.9259 1.8334 1.8080 1.7833 2.6730 2.6243 2.5771 3.4651 3.3872 3.3121 42124 4.1002 3.9927 4.9173 4.7665 4.6229 5.5824 5.3893 5.2064 6.2098 5.9713 5.7466 6.8017 6.5152 6.2469 7.3601 7.0236 6.7101 7.8869 7.4987 7.1390 8.3838 7.9427 7.5361 8.8527 8.3577 7.9038 9.2950 8.7455 8.2442 9.7122 9.1079 8.5595 10.1059 9.4466 8.8514 10.4773 9.7632 9.1216 10.8276 10.0591 9.3719 11.1581 10.3356 9.6036 11.4699 10.5940 9.8181 11.7641 10.8355 10.0168 12.0416 11.0612 10.2007 12.3034 11.2722 10.3711 12.5504 11.4693 10.5288 12.7834 11.6536 10.6748 13.0032 11.8258 10.8100 13.2105 11.9867 10.9352 13.4062 12.1371 11.0511 13.5907 12.2777 11.1584 13.7648 12.4090 11.2578 0.9174 1.7591 2.5313 3.2997 3.8897 4.4859 5.0330 5.5348 5.9952 6.4177 6.8052 7.1607 7.4869 7.7862 8.0607 8.3126 8.5436 8.7556 8.9501 9.1285 9.2922 9.4424 9.5802 9.7066 9.8226 9.9290 10.0266 10.1161 10.1983 10.2737 0.9091 1.7355 2.4869 3.1699 3.7909 4.3553 4.8684 5.3349 5.7590 6.1446 6.4951 6.8137 7.1034 7.3667 7.6061 7.8237 8.0216 8.2014 8.3649 8.5136 8.6487 8.7715 8.8832 8.9847 9.0770 9.1609 9.2372 9.3066 9.3696 9.4269 0.9009 1.7125 2.4437 3.1024 3.6959 4.2305 4.7122 5.1461 5.5370 5.8892 6.2065 6.4924 6.7499 6.9819 7.1909 7.3792 7.5488 7.7016 7.8393 7.9633 8.0751 8.1757 8.2664 8.3481 8.4217 8.4891 8.5478 8.6016 8.6501 8.6938 0.8929 1.6901 2.4018 3.0373 3.6048 4.1114 4.5638 4.9676 5.3282 5.6502 5.9377 6.1944 6.4235 6.6282 6.8109 6.9740 7.1196 7.2497 7.3658 7.4694 7.5620 7.6446 7.7184 7.7843 7.8431 7.8957 7.9426 7.9844 8.0218 8.0552 0.8850 1.6681 2.3612 2.9745 3.5172 3.9975 4.4226 4.7988 5.1317 5.4262 5.6869 5.9176 6.1218 6.3025 6.4624 6.6039 6.7291 6.8399 6.9380 7.0248 7.1016 7.1695 7.2297 7.2829 7.3300 7.3717 7.4086 7.4412 7.4701 7.4957 6.1422 6.2651 6.3729 6.4674 6.5504 6.6231 6.6870 15% 0.8696 1.6257 2.2832 2.8550 3.3522 3.7845 4.1604 4.4873 4.7716 5.0188 5.2337 5.4206 5.5831 5.7245 5.8474 5.9542 6.0472 6.1280 6.1982 6.2593 6.3125 6.3587 6.3988 6.4338 6.4641 6.4906 6.5135 6.5335 6.5509 6.5660 6.7429 6.7921 6.8351 6.8729 6.9061 6.9352 6.9607 6.9830 7.0027 Pay attention-You can use a shortcut way to build the whole table. In the following table Column D includes the periods (1, 2, 3..) and Row 6 includes the rates (1%, 2%. 3%..) E F G D 6 periods 1% 2% 3% 0.9709 7 8 9 1 2 3 0.9901 1.9704 2.9410 0.9804 1.9416 2.8839 1.9135 2.8286 You should calculate AF only for one cell - In the above example use E7. In each cell we would like to use row 6 (rates) and column D (periods). Thus you should lock the row 6 by putting dollar sign before the number 6 (for example E$6) and you should lock the column D by putting dollar sign ($) before the letter D (for example $07). The final equation in cell E7 should be 1 (ESO) -(656 (1 +856) 87 (E$6+ (1 + E$6) then you can cross to the right and then drug down (or double click in the corner)