1/26/2016 Math 172B - Class Project 1 Objective: Download mortality tables from the Internal Revenue Service website and utilize mortality rates to calculate life expectancies Steps: 1. Search for Internal Revenue Bulletin Notice 2008-85 2. Click on STATIC MORTALITY TABLE FOR YEARS 2009 THROUGH 2013 or scroll down to the tables 3. The table represents q's 4. Copy and paste the table assigned to you below based on the last 3 digits of your student ID number < 100 100's 200's 300's 400's 500's 600's 700's 800's 900's 2009 Female Annuitant Table 2010 Female Annuitant Table 2011 Female Annuitant Table 2012 Female Annuitant Table 2013 Female Annuitant Table 2009 Male Annuitant Table 2010 Male Annuitant Table 2011 Male Annuitant Table 2012 Male Annuitant Table 2013 Male Annuitant Table 5. Using Excel and l1 = 10,000,000, calculate lx , dx , px, qx, ex for all ages. 6. For someone who is just about to turn 70 years old, calculate the expected number of birthdays he/she will celebrate in his/her 70's (including the 70th birthday). 7. For a newborn, calculate the expected number of birthdays he/she will celebrate during his/her 70's (including the 70th birthday). 8. Briefly comment on the difference between 6 and 7. 9. Submit your Excel worksheet to jonggulkim@gmail.com by midnight on 2/9/2016. Age FEMALE 2013 Annuitant lx dx px 1 0.000324 10,000,000 3240 2 0.000211 9,996,760 2109.31636 3 0.000158 9,994,651 1579.15481 4 0.000118 9,993,072 1179.18244 5 0.000107 9,991,892 1069.13248 6 0.0001 9,990,823 999.082321 7 0.000094 9,989,824 939.043468 8 0.000083 9,988,885 829.077462 9 0.00008 9,988,056 799.044481 10 0.00008 9,987,257 798.980557 11 0.000081 9,986,458 808.903097 12 0.000084 9,985,649 838.794523 13 0.000088 9,984,810 878.663305 14 0.000097 9,983,932 968.441368 15 0.000108 9,982,963 1078.16002 16 0.000116 9,981,885 1157.89866 17 0.000124 9,980,727 1237.61016 18 0.000127 9,979,490 1267.39517 19 0.000124 9,978,222 1237.29954 20 0.000122 9,976,985 1217.19215 21 0.000119 9,975,768 1187.11635 22 0.00012 9,974,581 1196.94966 23 0.000125 9,973,384 1246.67295 24 0.000132 9,972,137 1316.32207 25 0.000139 9,970,821 1385.94406 26 0.000153 9,969,435 1525.3235 27 0.000159 9,967,909 1584.89758 28 0.000168 9,966,324 1674.3425 29 0.000177 9,964,650 1763.74306 30 0.000199 9,962,886 1982.61438 31 0.000245 9,960,904 2440.42141 32 0.00028 9,958,463 2788.36972 33 0.000306 9,955,675 3046.43652 34 0.000328 9,952,628 3264.46214 35 0.000348 9,949,364 3462.37868 36 0.000367 9,945,902 3650.1459 37 0.000384 9,942,251 3817.82457 38 0.000403 9,938,434 4005.18877 39 0.000424 9,934,428 4212.19767 40 0.000462 9,930,216 4587.75992 41 0.000507 9,925,629 5032.29366 42 0.000558 9,920,596 5535.69269 43 0.000614 9,915,061 6087.84717 44 0.000674 9,908,973 6678.64759 45 0.000721 9,902,294 7139.554 46 0.000815 9,895,154 8064.5509 47 0.000956 9,887,090 9452.05797 48 0.001145 9,877,638 11309.8954 49 0.001381 9,866,328 13625.3989 50 0.001664 9,852,703 16394.8971 51 0.001781 9,836,308 17518.464 52 0.001997 9,818,789 19608.1221 53 0.002274 9,799,181 22283.3378 54 0.002609 9,776,898 25507.9262 55 0.003007 9,751,390 29322.4292 56 0.00348 9,722,067 33832.7946 57 0.003967 9,688,235 38433.2267 58 0.004452 9,649,801 42960.9157 59 0.005003 9,606,840 48063.0228 60 0.005609 9,558,777 53615.1827 61 0.006259 9,505,162 59492.8106 62 0.006956 9,445,669 65704.0767 63 0.007697 9,379,965 72197.5935 64 0.008499 9,307,768 79106.7183 65 0.009375 9,228,661 86518.6974 66 0.010324 9,142,142 94383.4778 67 0.011344 9,047,759 102637.777 68 0.012457 8,945,121 111429.374 69 0.013708 8,833,692 121092.246 70 0.015145 8,712,599 131952.319 71 0.016472 8,580,647 141340.42 72 0.018322 8,439,307 154624.978 73 0.019959 8,284,682 165353.963 74 0.022121 8,119,328 179607.65 75 0.023935 7,939,720 190037.202 76 0.026371 7,749,683 204366.889 77 0.029635 7,545,316 223605.442 78 0.032667 7,321,711 239178.321 qx 0.999676 0.999789 0.999842 0.999882 0.999893 0.9999 0.999906 0.999917 0.99992 0.99992 0.999919 0.999916 0.999912 0.999903 0.999892 0.999884 0.999876 0.999873 0.999876 0.999878 0.999881 0.99988 0.999875 0.999868 0.999861 0.999847 0.999841 0.999832 0.999823 0.999801 0.999755 0.99972 0.999694 0.999672 0.999652 0.999633 0.999616 0.999597 0.999576 0.999538 0.999493 0.999442 0.999386 0.999326 0.999279 0.999185 0.999044 0.998855 0.998619 0.998336 0.998219 0.998003 0.997726 0.997391 0.996993 0.99652 0.996033 0.995548 0.994997 0.994391 0.993741 0.993044 0.992303 0.991501 0.990625 0.989676 0.988656 0.987543 0.986292 0.984855 0.983528 0.981678 0.980041 0.977879 0.976065 0.973629 0.970365 0.967333 ex 0.000324 0.000211 0.000158 0.000118 0.000107 0.0001 0.000094 0.000083 0.00008 0.00008 0.000081 0.000084 0.000088 0.000097 0.000108 0.000116 0.000124 0.000127 0.000124 0.000122 0.000119 0.00012 0.000125 0.000132 0.000139 0.000153 0.000159 0.000168 0.000177 0.000199 0.000245 0.00028 0.000306 0.000328 0.000348 0.000367 0.000384 0.000403 0.000424 0.000462 0.000507 0.000558 0.000614 0.000674 0.000721 0.000815 0.000956 0.001145 0.001381 0.001664 0.001781 0.001997 0.002274 0.002609 0.003007 0.00348 0.003967 0.004452 0.005003 0.005609 0.006259 0.006956 0.007697 0.008499 0.009375 0.010324 0.011344 0.012457 0.013708 0.015145 0.016472 0.018322 0.019959 0.022121 0.023935 0.026371 0.029635 0.032667 82.093228 81.1198348 80.1369547 79.1496183 78.1589591 77.167323 76.1750405 75.1822016 74.1884423 73.1943778 72.2002338 71.2060825 70.2120643 69.2182435 68.2249584 67.2323274 66.2401273 65.2483421 64.2566297 63.2645985 62.2723177 61.279729 60.2870835 59.2946203 58.3024482 57.3105534 56.3193232 55.3282794 54.3375761 53.3471956 52.3578138 51.3706446 50.3850324 49.400455 48.4166636 47.4335185 46.450933 45.468777 44.4871083 43.5059788 42.5260879 41.5476595 40.5708561 39.5957819 38.6224874 37.6503544 36.6810644 35.7161651 34.757107 33.8051729 32.8615185 31.9201493 30.9840213 30.0546396 29.1332573 28.2211252 27.3196777 26.4284865 25.5466723 24.6751249 23.8143084 22.9643009 22.1251595 21.2967778 20.4793307 19.6731414 18.8783656 18.0949791 17.3232315 16.5639988 15.8187183 15.0836482 14.3651688 13.6577223 12.9666792 12.2846472 11.6173802 10.9721756 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 0.036066 0.039866 0.044124 0.048916 0.054313 0.060405 0.068664 0.078137 0.088916 0.099037 0.112205 0.124002 0.136171 0.148426 0.163744 0.175624 0.186875 0.197318 0.210976 0.21951 0.226803 0.232763 0.244834 0.254498 0.266044 0.279055 0.293116 0.307811 0.322725 0.337441 0.351544 0.364617 0.376246 0.386015 0.393507 0.398308 0.4 0.4 0.4 0.4 0.4 1 7,082,532 6,827,094 6,554,925 6,265,695 5,959,203 5,635,540 5,295,126 4,931,541 4,546,205 4,141,975 3,731,766 3,313,043 2,902,219 2,507,021 2,134,914 1,785,335 1,471,787 1,196,747 960,607 757,942 591,566 457,397 350,932 265,012 197,567 145,005 104,541 73,898 51,152 34,644 22,954 14,884 9,457 5,899 3,622 2,197 1,322 793 476 285 171 103 255438.61 272168.917 289229.501 306492.75 323662.167 340414.815 363584.5 385335.822 404230.383 410208.762 418722.812 410823.991 395198.1 372107.124 349579.366 313547.618 275040.207 236139.696 202665.056 166375.871 134168.996 106465.153 85920.1057 67445.0183 52561.5041 40464.4973 30642.6274 22746.719 16507.9038 11690.2074 8069.16531 5427.08157 3558.25377 2277.10235 1425.24194 874.945403 528.683983 317.21039 190.326234 114.19574 68.5174442 102.776166 0.963934 0.960134 0.955876 0.951084 0.945687 0.939595 0.931336 0.921863 0.911084 0.900963 0.887795 0.875998 0.863829 0.851574 0.836256 0.824376 0.813125 0.802682 0.789024 0.78049 0.773197 0.767237 0.755166 0.745502 0.733956 0.720945 0.706884 0.692189 0.677275 0.662559 0.648456 0.635383 0.623754 0.613985 0.606493 0.601692 0.6 0.6 0.6 0.6 0.6 0 0.036066 0.039866 0.044124 0.048916 0.054313 0.060405 0.068664 0.078137 0.088916 0.099037 0.112205 0.124002 0.136171 0.148426 0.163744 0.175624 0.186875 0.197318 0.210976 0.21951 0.226803 0.232763 0.244834 0.254498 0.266044 0.279055 0.293116 0.307811 0.322725 0.337441 0.351544 0.364617 0.376246 0.386015 0.393507 0.398308 0.4 0.4 0.4 0.4 0.4 1 10.3427078 9.72968463 9.13367366 8.55529134 7.99530571 7.45449468 6.93373175 6.44493045 5.99120201 5.57590519 5.18882817 4.84462423 4.53040558 4.24456296 3.9843736 3.76453813 3.56653048 3.38620197 3.21860958 3.079229 2.94525106 2.80918583 2.66143164 2.52430015 2.38604074 2.25093159 2.12219599 2.00218422 1.89253978 1.79434465 1.70820358 1.63426289 1.572091 1.5203702 1.47623346 1.43404865 1.38336 1.3056 1.176 0.96 0.6 0 #6 for someone who is just about to turn 70 years old, calculate the expected number of birthdays he/she will celebrate in his/her 70's (including the 70th birthday) 8.15634022 e_(70: angle(9)) + 1 = 8.15634022+1 = 9.15634022 the expected number of birthsdays he/she will celebrate in his/her 70's is 9.15634022 #7 For a newborn, calculate the expected number of birthdays he/she will celebrate during his/her 70's (including the 70th birthday). #8 Briefly comment on the difference between 6 and 7 th birthday)