Given the data I need help creating a formula for whole life annual payment annuity for male life. Thanks

B c D m F G H 1 2 3 Benefit Amount Interest Rate Age of Insured Gender 100,000 5% 25 male Output = 4 5 6 7 8 Male Female Number of Lives (b) Life Expectancy Number of Lives (b) Life Expectancy 9 10 11 12 WN10 13 14 15 16 17 18 19 20 Exact Death Age Probabilty (a) 0.006304 1 0.000426 2 0.00029 3 0.000229 4 0.000162 5 0.000146 6 0.000136 7 0.000127 8 0.000115 9 0.000103 10 0.000097 11 0.000109 12 0.000151 13 0.000232 14 0.000343 15 0.000465 16 0.000588 17 0.00072 18 0.000858 19 0.000999 20 0.001146 21 0.001288 22 0.001407 23 0.001494 21 Death Propbabilty (a) 0.005229 0.000342 0.000209 0.000162 0.000143 0.000125 0.000113 0.000104 0.000097 0.000093 0.000092 0.000098 0.000113 0.000138 0.000172 0.000211 0.000251 0.000293 0.000336 0.000379 0.000425 0.000472 0.000515 100,000 99,370 99,327 99,298 99,276 99,260 99,245 99,232 99,219 99,208 99,197 99,188 99,177 99,162 99,139 99,105 99,059 99,001 98,929 98,845 98,746 98,633 98,506 98.367 22 75.97 75.45 74.48 73.5 72.52 71.53 70.54 69.55 68.56 67.57 66.57 65.58 64.59 63.6 62.61 61.63 60.66 59.7 58.74 57.79 56.85 55.91 54.98 54.06 100,000 99,477 99,443 99,422 99,406 99,392 99,379 99,368 99,358 99,348 99,339 99,330 99,320 99,309 99,295 99,278 99,257 99,232 99,203 99,170 99,132 99,090 99,044 98.993 80.96 80.39 79.42 78.43 77.45 76.46 75.47 74.47 73.48 72.49 71.5 70.5 69.51 68.52 67.53 66.54 65.55 64.57 63.59 62.61 61.63 60.66 59.69 58.72 23 24 25 26 27 28 29 30 31 32 33 0.000551 A 1 1 Male Exact Death Age Probabilty Number of Lives (b) Life Expectancy Numbe Lives D 13 7597 7545 77448 725 72.52 71.53 70.54 69.55 15 1000 9947 99.44 9942 99.40 992 99.27 9920 992 9934 17 21 67.57 6657 65.58 64.59 636 99.22 99.22 9920 34 12 25 30 31 11 0.006314 1 0.000426 20.00029 0.000229 4 0.000162 5 0.000146 0000126 70.000122 0.00115 9 0,000103 10 0.000097 1110000109 12 0,000151 10000232 0.000343 150.000465 165 0.00072 18 0.000858 0.000999 0.001146 2110001208 220001407 220,001494 240,001556 25 0.00161 26 0,001665 270,001717 28 0.001767 290001817 300001865 0.001911 0.00196 33 0.002014 34 0.002071 0.002138 360.002211 370.002279 380,002242 0.002405 40 0.002492 41 0.002503 0.00271 0.00287 44 0.003064 0.003295 46 0,002529 47 0.003834 100.000 99.220 99227 99298 99.276 99.260 99,245 99.222 99.219 99 200 99.197 99.188 99.177 99. 162 99.139 99-105 99059 99.001 98.929 99.845 98.746 98.623 98.506 98.367 98.220 98.067 97910 974746 97579 97406 97 229 97048 96.862 95.672 95478 95278 96,072 95.860 95.641 95417 95188 94951 94.706 94450 94178 93.890 93581 93250 34 Death Propbabilty (a) 0.005220 O0342 0.000209 0.000162 0.000143 0.000125 0.000112 0.000104 0.000097 0.000093 0.000092 0000098 0,000112 0.000138 0.000172 0.000211 0.000251 0.000292 0.000336 0.000279 0.000425 0.000472 0.000515 0.000551 0.000582 0.000612 0.000646 0.000684 0.000729 0.000779 0.000823 0.000887 0.000929 0.000988 0.001024 0.001095 0.001143 0.0017205 0.001271 0,001345 0.001429 0.001524 0.00163 0.001749 0.001891 0.002029 0.002195 0.002286 61.62 60.66 59.7 58.74 5779 56.95 55.91 5498 5406 52,14 52.22 5121 5029 49.48 49.56 4765 46.74 45.93 9927 9925 9922 9920 99.17 99.1 99.09 99.04 99.99 99.99 99.99 35 30 17 38 20 40 41 99.7 9866 986 99.54 98.45 9821 9927 40 45 46 98.02 9797 51 4401 42,1 42.19 4120 4027 3947 28.56 3765 26.75 25.85 34.95 3406 33.17 3.2.2 97.74 976 974 9724 9720 97.04 95.87 96.68 9649 962 54 E7 SH 37 58 B c D m F G H 1 2 3 Benefit Amount Interest Rate Age of Insured Gender 100,000 5% 25 male Output = 4 5 6 7 8 Male Female Number of Lives (b) Life Expectancy Number of Lives (b) Life Expectancy 9 10 11 12 WN10 13 14 15 16 17 18 19 20 Exact Death Age Probabilty (a) 0.006304 1 0.000426 2 0.00029 3 0.000229 4 0.000162 5 0.000146 6 0.000136 7 0.000127 8 0.000115 9 0.000103 10 0.000097 11 0.000109 12 0.000151 13 0.000232 14 0.000343 15 0.000465 16 0.000588 17 0.00072 18 0.000858 19 0.000999 20 0.001146 21 0.001288 22 0.001407 23 0.001494 21 Death Propbabilty (a) 0.005229 0.000342 0.000209 0.000162 0.000143 0.000125 0.000113 0.000104 0.000097 0.000093 0.000092 0.000098 0.000113 0.000138 0.000172 0.000211 0.000251 0.000293 0.000336 0.000379 0.000425 0.000472 0.000515 100,000 99,370 99,327 99,298 99,276 99,260 99,245 99,232 99,219 99,208 99,197 99,188 99,177 99,162 99,139 99,105 99,059 99,001 98,929 98,845 98,746 98,633 98,506 98.367 22 75.97 75.45 74.48 73.5 72.52 71.53 70.54 69.55 68.56 67.57 66.57 65.58 64.59 63.6 62.61 61.63 60.66 59.7 58.74 57.79 56.85 55.91 54.98 54.06 100,000 99,477 99,443 99,422 99,406 99,392 99,379 99,368 99,358 99,348 99,339 99,330 99,320 99,309 99,295 99,278 99,257 99,232 99,203 99,170 99,132 99,090 99,044 98.993 80.96 80.39 79.42 78.43 77.45 76.46 75.47 74.47 73.48 72.49 71.5 70.5 69.51 68.52 67.53 66.54 65.55 64.57 63.59 62.61 61.63 60.66 59.69 58.72 23 24 25 26 27 28 29 30 31 32 33 0.000551 A 1 1 Male Exact Death Age Probabilty Number of Lives (b) Life Expectancy Numbe Lives D 13 7597 7545 77448 725 72.52 71.53 70.54 69.55 15 1000 9947 99.44 9942 99.40 992 99.27 9920 992 9934 17 21 67.57 6657 65.58 64.59 636 99.22 99.22 9920 34 12 25 30 31 11 0.006314 1 0.000426 20.00029 0.000229 4 0.000162 5 0.000146 0000126 70.000122 0.00115 9 0,000103 10 0.000097 1110000109 12 0,000151 10000232 0.000343 150.000465 165 0.00072 18 0.000858 0.000999 0.001146 2110001208 220001407 220,001494 240,001556 25 0.00161 26 0,001665 270,001717 28 0.001767 290001817 300001865 0.001911 0.00196 33 0.002014 34 0.002071 0.002138 360.002211 370.002279 380,002242 0.002405 40 0.002492 41 0.002503 0.00271 0.00287 44 0.003064 0.003295 46 0,002529 47 0.003834 100.000 99.220 99227 99298 99.276 99.260 99,245 99.222 99.219 99 200 99.197 99.188 99.177 99. 162 99.139 99-105 99059 99.001 98.929 99.845 98.746 98.623 98.506 98.367 98.220 98.067 97910 974746 97579 97406 97 229 97048 96.862 95.672 95478 95278 96,072 95.860 95.641 95417 95188 94951 94.706 94450 94178 93.890 93581 93250 34 Death Propbabilty (a) 0.005220 O0342 0.000209 0.000162 0.000143 0.000125 0.000112 0.000104 0.000097 0.000093 0.000092 0000098 0,000112 0.000138 0.000172 0.000211 0.000251 0.000292 0.000336 0.000279 0.000425 0.000472 0.000515 0.000551 0.000582 0.000612 0.000646 0.000684 0.000729 0.000779 0.000823 0.000887 0.000929 0.000988 0.001024 0.001095 0.001143 0.0017205 0.001271 0,001345 0.001429 0.001524 0.00163 0.001749 0.001891 0.002029 0.002195 0.002286 61.62 60.66 59.7 58.74 5779 56.95 55.91 5498 5406 52,14 52.22 5121 5029 49.48 49.56 4765 46.74 45.93 9927 9925 9922 9920 99.17 99.1 99.09 99.04 99.99 99.99 99.99 35 30 17 38 20 40 41 99.7 9866 986 99.54 98.45 9821 9927 40 45 46 98.02 9797 51 4401 42,1 42.19 4120 4027 3947 28.56 3765 26.75 25.85 34.95 3406 33.17 3.2.2 97.74 976 974 9724 9720 97.04 95.87 96.68 9649 962 54 E7 SH 37 58