I need help creating a model to price whole life for male and female based off the data provided using the formula for gross premium.

Set inputs are: Interest rate- 5% Age of insured- 25 Gender- male Initial expense of 1st year- 50% Renewal premium- 5% Termination expense- 0.1% of benefit Thanks

A B D E F G H 1 7 8 Male Female Number of Lives (b) Life Expectancy Number of Lives (b) 9 10 Life Expectancy 80.96 *(a) Prob 12 *(b)= Num 13 75.97 75.45 74.48 73.5 72.52 71.53 14 15 80.39 79.42 78.43 77.45 76.46 75.47 74.47 16 6 17 18 19 73.48 72.49 21 71.5 22 Exact Death Age Probabilty (a) 0 0.006304 1 0.000426 2 0.00029 3 0.000229 4 0.000162 5 0.000146 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 0.001556 25 0.00161 70.5 23 **%B89&8 = 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 0.000551 0.000582 0.000612 69.51 100.000 99.370 99.327 99298 99,276 99.260 99,245 99.232 99.219 99 208 99.197 99.188 99.177 99.162 99.139 99105 99.059 99.001 98.929 98 845 98.746 98633 98506 98 367 98.220 98.067 100.000 99.477 99.443 99,422 99.406 99 392 99,379 99.368 99.358 99 348 99.339 99330 99320 99309 99.295 99.278 99.257 99232 99.203 99.170 99.132 99090 99.044 98993 98938 98880 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 5498 54.06 53.14 52.22 24 25 30 68.52 67.53 66.54 65.55 64.57 63.59 62.61 61.63 60.66 59.69 58.72 57.75 56.78 31 32 33 24 A B D E F G H 1 7 8 Male Female Number of Lives (b) Life Expectancy Number of Lives (b) 9 10 Life Expectancy 80.96 *(a) Prob 12 *(b)= Num 13 75.97 75.45 74.48 73.5 72.52 71.53 14 15 80.39 79.42 78.43 77.45 76.46 75.47 74.47 16 6 17 18 19 73.48 72.49 21 71.5 22 Exact Death Age Probabilty (a) 0 0.006304 1 0.000426 2 0.00029 3 0.000229 4 0.000162 5 0.000146 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 0.001556 25 0.00161 70.5 23 **%B89&8 = 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 0.000551 0.000582 0.000612 69.51 100.000 99.370 99.327 99298 99,276 99.260 99,245 99.232 99.219 99 208 99.197 99.188 99.177 99.162 99.139 99105 99.059 99.001 98.929 98 845 98.746 98633 98506 98 367 98.220 98.067 100.000 99.477 99.443 99,422 99.406 99 392 99,379 99.368 99.358 99 348 99.339 99330 99320 99309 99.295 99.278 99.257 99232 99.203 99.170 99.132 99090 99.044 98993 98938 98880 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 5498 54.06 53.14 52.22 24 25 30 68.52 67.53 66.54 65.55 64.57 63.59 62.61 61.63 60.66 59.69 58.72 57.75 56.78 31 32 33 24