The first picture is the answer sheet. I need help creating the formula for the discount value, annuity value, and annuity factor. Thanks

of 189 AV Read aloud Draw Life Annuity Annuity Value Annuity Factor 50 Current Age Annual Payment Interest Rate 12,000 6.00% Excel Formula VB Function Annuity Value 169,435 169,435 Annuity Factor 14.1196 14.1196 Excel Calculation Age 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 Qx 0.002579 0.002872 0.003213 0.003584 0.003979 0.004425 0.004949 0.005581 0.006300 0.007090 0.007976 0.008986 0.010147 0.011471 0.012940 0.014535 tpx 0.997421 1.000000 0.997128 0.997421 0.996787 0.994556 0.996416 0.991361 0.996021 0.987808 0.995575 0.983877 0.995051 0.979524 0.994419 0.974676 0.993700 0.969236 0.992910 0.963130 0.992024 0.956302 0.991014 0.948674 0.989853 0.940149 0.988529 0.930610 0.987060 0.919935 0.985465 0.908031 Discount value 1.0000 0.9410 0.8852 0.8324 0.7824 0.7352 0.6905 0.6482 0.6081 0.5701 0.5340 0.4997 0.4672 0.4363 0.4069 0.3789 H D A B 2 Life Annuity Annuity Value Annuity Factor 50 3 4 5 6 12,000 Current Age Annual Payment Interest Rate 6.00% Annuity Value Annuity Factor 7 8 Excel Formula VB Function 19 TV 11 Excel Calculation Discount value 12 13 114 15 116 17 18 19 20 21 22 Age 50 51 52 53 54 55 56 57 58 59 Qx tpx 0.002579 0.997421 1.000000 0.002872 0.997128 0.997421 0.003213 0.996787 0.994556 0.003584 0.996416 0.991361 0.003979 0.996021 0.987808 0.004425 0.995575 0983877 0.004949 0.995051 0.979524 0.005581 0.994419 0.974676 0.006300 0.993700 0.969236 0.007090 0.992910 0.963130 Optional Annuity PV Flead be here to search