PLEASE USE EXCEL FUNCTIONS

A1 X for TABLE 2 B D E F G H I J K L M N 0 P Q R 1 Present Value of $1 2 3 periods 1.00% 1.50% 2.00% 2.50% 3.00% 3.50% 4.00% 4.50% 5.00% 5.50% 6.00% 7.00% 8.00% 9.00% 10.00% 11.00 4 1 0.99010 0.98522 0.98039 0.97561 0.97087 0.96618 0.96154 0.95694 0.95238 0.94787 0.94340 0.93458 0.92593 0.91743 0.90909 0.900 52 0.98030 0.97066 0.96117 0.95181 0.94260 0.93351 0.92456 0.91573 0.90703 0.89845 0.89000 0.87344 0.85734 0.84168 0.82645 0.811 6 3 0.97059 0.95632 0.94232 0.92860 0.91514 0.90194 0.88900 0.87630 0.86384 0.85161 0.83962 0.81630 0.79383 0.77218 0.75131 0.731 74 0.96098 0.94218 0.92385 0.90595 0.88849 0.87144 0.85480 0.83856 0.82270 0.80722 0.79209 0.76290 0.73503 0.70843 0.68301 0.658 8 S 0.95147 0.92826 0.90573 0.88385 0.86261 0.84197 0.82193 0.80245 0.78353 0.76513 0.74726 0.71299 0.68058 0.64993 0.62092 0.59 9 6 0.94205 0.91454 0.88797 0.86230 0.83748 0.81350 0.79031 0.76790 0.74622 0.72525 0.70496 0.66634 0.63017 0.59627 0.56447 0.534 107 0.93272 0.90103 0.87056 0.84127 0.81309 0.78599 0.75992 0.73483 0.71068 0.68744 0.66506 0.62275 0.58349 0.54703 0.51316 0.481 11 8 0.92348 0.88771 0.85349 0.82075 0.78941 0.75941 0.73069 0.70319 0.67684 0.65160 0.62741 0.58201 0.54027 0.50187 0.46651 0.43 129 0.91434 0.87459 0.83676 0.80073 0.76642 0.73373 0.70259 0.67290 0.64461 0.61763 0.59190 0.54393 0.50025 0.46043 0.42410 0.390 13 10 0.90529 0.86167 0.82035 0.78120 0.74409 0.70892 0.67556 0.64393 0.61391 0.58543 0.55839 0.50835 0.46319 0.42241 0.38554 0.351 14 11 0.89632 0.84893 0.80426 0.76214 0.72242 0.68495 0.64958 0.61620 0.58468 0.55491 0.52679 0.47509 0.42888 0.38753 0.35049 0.311 15 12 0.88745 0.83639 0.78849 0.74356 0.70138 0.66178 0.62460 0.58966 0.55684 0.52598 0.49697 0.44401 0.39711 0.35553 0.31863 0.28 16 13 0.87866 0.82403 0.77303 0.72542 0.68095 0.63940 0.60057 0.56427 0.53032 0.49856 0.46884 0.41496 0.36770 0.32618 0.28966 0.251 17 14 0.86996 0.81185 0.75788 0.70773 0.66112 0.61778 0.57748 0.53997 0.50507 0.47257 0.44230 0.38782 0.34046 0.29925 0.26333 0.23 18 15 0.86135 0.79985 0.74301 0.69047 0.64186 0.59689 0.55526 0.51672 0.48102 0.44793 0.41727 0.36245 0.31524 0.27454 0.23939 0.209 0.85282 0.78803 0.72845 0.67362 0.62317 0.57671 0.53391 0.49447 0.45811 0.42458 0.39365 0.33873 0.29189 0.25187 0.21763 0.18 2017 0.84438 0.77639 0.71416 0.65720 0.60502 0.55720 0.51337 0.47318 0.43630 0.40245 0.37136 0.31657 0.27027 0.23107 0.19784 0.169 21 18 0.83602 0.76491 0.70016 0.64117 0.58739 0.53836 0.49363 0.45280 0.41552 0.38147 0.35034 0.29586 0.25025 0.21199 0.17986 0.151 22 19 0.82774 0.75361 0.68643 0.62553 0.57029 0.52016 0.47464 0.43330 0.39573 0.36158 0.33051 0.27651 0.23171 0.19449 0.16351 0.131 23 20 0.81954 0.74247 0.67297 0.61027 0.55368 0.50257 0.45639 0.41464 0.37689 0.34273 0.31180 0.25842 0.21455 0.17843 0.14864 0.124 24 21 0.81143 0.73150 0.65978 0.59539 0.53755 0.48557 0.43883 0.39679 0.35894 0.32486 0.29416 0.24151 0.19866 0.16370 0.13513 0.111 25 24 0.78757 0.69954 0.62172 0.55288 0.49193 0.43796 0.39012 0.34770 0.31007 0.27666 0.24698 0.19715 0.15770 0.12640 0.10153 0.081 26 25 0.77977 0.68921 0.60953 0.53939 0.47761 0.42315 0.37512 0.33273 0.29530 0.26223 0.23300 0.18425 0.14602 0.11597 0.09230 0.07 27 28 0.75684 0.65910 0.57437 0.50088 0.43708 0.38165 0.33348 0.29157 0.25509 0.22332 0.19563 0.15040 0.11591 0.08955 0.06934 0.051 28 29 0.74934 0.64936 0.56311 0.48866 0.42435 0.36875 0.32065 0.27902 0.24295 0.21168 0.18456 0.14056 0.10733 0.08215 0.06304 0.048 29 30 0.74192 0.63976 0.55207 0.47674 0.41199 0.35628 0.30832 0.26700 0.23138 0.20064 0.17411 0.13137 0.09938 0.07537 0.05731 0.04 30 31 0.73458 0.63031 0.54125 0.46511 0.39999 0.34423 0.29646 0.25550 0.22036 0.19018 0.16425 0.12277 0.09202 0.06915 0.05210 0.039 31 40 0.67165 0.55126 0.45289 0.37243 0.30656 0.25257 0.20829 0.17193 0.14205 0.11746 0.09722 0.06678 0.04603 0.03184 0.02209 0.01: 32 33 34 19 16 Future Value of $1 Present Value of $1 Futur ... A1 fic TABLE4 F G H I J K L M 7 0 1 2 3 4 4 5 5 6 7 7 2.50% 0.97561 1.92742 2.85602 3.76197 4.64583 5.50813 6.34939 7.17014 7.97087 8.75206 9.51421 10.25776 10.98319 11.69091 12.38138 13.05500 13.71220 14.35336 14.97889 15.58916 16.18455 18.42438 20.93029 25.10278 B D E 1 Present Value of an Ordinary Annuity of $1 2 3 periods 1.00% 1.50% 2.00% 4 1 0.99010 0.98522 0.98039 5 2 1.97040 1.95588 1.94156 63 2.94099 2.91220 2.88388 3.90197 3.85438 3.80773 8 5 4.85343 4.78264 4.71346 9 6 5.79548 5.69719 5.60143 107 6.72819 6.59821 6.47199 11 8 7.65168 7.48593 7.32548 129 8.56602 8.36052 8.16224 13 10 9.47130 9.22218 8.98259 14 11 10.36763 10.07112 9.78685 15 12 11.25508 10.90751 10.57534 16 13 12.13374 11.73153 11.34837 17 14 13.00370 12.54338 12.10625 18 15 13.86505 13.34323 12.84926 19 16 14.71787 14.13126 13.57771 20 17 15.56225 14.90765 14.29187 21 18 16.39827 15.67256 14.99203 22 19 17.22601 16.42617 15.67846 18.04555 17.16864 16.35143 24 21 18.85698 17.90014 17.01121 25 25 22.02316 20.71961 19.52346 26 30 25.80771 24.01584 22.39646 27 40 32.83469 29.91585 27.35548 28 29 30 31 32 33 34 3.00% 0.97087 1.91347 2.82861 3.71710 4.57971 5.41719 6.23028 7.01969 7.78611 8.53020 9.25262 9.95400 10.63496 11.29607 11.93794 12.56110 13.16612 13.75351 14.32380 14.87747 15.41502 17.41315 19.60044 23.11477 3.50% 0.96618 1.89969 2.80164 3.67308 4.51505 5.32855 6.11454 6.87396 7.60769 8.31661 9.00155 9.66333 10.30274 10.92052 11.51741 12.09412 12.65132 13.18968 13.70984 14.21240 14.69797 16.48151 18.39205 21.35507 4.00% 0.96154 1.88609 2.77509 3.62990 4.45182 5.24214 6.00205 6.73274 7.43533 8.11090 8.76048 9.38507 9.98565 10.56312 11.11839 11.65230 12.16567 12.65930 13.13394 13.59033 14.02916 15.62208 17.29203 19.79277 4.50% 0.95694 1.87267 2.74896 3.58753 4.38998 5.15787 5.89270 6.59589 7.26879 7.91272 8.52892 9.11858 9.68285 10.22283 10.73955 11.23402 11.70719 12.15999 12.59329 13.00794 13.40472 14.82821 16.28889 18.40158 5.00% 0.95238 1.85941 2.72325 3.54595 4.32948 5.07569 5.78637 6.46321 7.10782 7.72173 8.30641 8.86325 9.39357 9.89864 10.37966 10.83777 11.27407 11.68959 12.08532 12.46221 12.82115 14.09394 15.37245 17.15909 5.50% 0.94787 1.84632 2.69793 3.50515 4.27028 4.99553 5.68297 6.33457 6.95220 7.53763 8.09254 8.61852 9.11708 9.58965 10.03758 10.46216 10.86461 11.24607 11.60765 11.95038 12.27524 13.41393 14.53375 16.04612 6.00% 0.94340 1.83339 2.67301 3.46511 4.21236 4.91732 5.58238 6.20979 6.80169 7.36009 7.88687 8.38384 8.85268 9.29498 9.71225 10.10590 10.47726 10.82760 11.15812 11.46992 11.76408 12.78336 13.76483 15.04630 7 8 8 9 9 23 20 10 11 11 1. .. uity of $1 Present Value of Annuity of $1 Bonc ... G21 foc A B F G H 1 J K 1 The Chestnut Street Company plans to issue $825,000, 10-year bonds that pay 7 percent 2 semiannually on March 31st and September 30th. 3 6 8 14 1) 20 4 Information relating to this bond is found below: 5 Face Value: $ 825,000 Number of Years: 10 7 Stated Interest Rate: 7% Number of Payments per Year: 9 10 Required: 11 Calculate or provide the information requested using a formula or cell reference unless 12 you are instructed to use a specific function: 13 Assume the Market Interest Rate is: 8% 15 16 a. How many total payments or periods will this bond pay interest? 17 When calculating the bond selling price, show the factor from 19 the appropriate future or present value table (found in worksheets included in this workbook) that would be used to calculate the 21 bond interest payments. 23 c. Repeat question b. but now use the VLOOKUP function. For the Lookup_value argument, your function should reference 25 the result you calculated in question a. Your function should look for 26 an exact match to the value used in the Lookup_Value argument. 27 Calculate the amount of interest that will be paid on March 31st. 29 30 e. Calculate the value of the interest payments that would be used 31 when determining the bond selling price. sity of $1 Present Value of Annuity of $1 Bond PT 18 b. 20 22 24 13.59033 28 d. $ 28.875 G21 fo