Please include excel functions or file if possible

2. Create graphs in Excel of the policy values of the following three insurance contracts. Show all calculations of the policv values in Excel 20-year endowment insurance with sum insured of $500 000, issued to (50) (Example 500000 450000 400000 350000 300000 250000 200000 150000 100000 50000 10 12 Time, t 16 18 20 Figure 7.3 Policy values for each year of a 20-year endowment insurance, sum insured S500000, issued to (50). b. 20-year term insurance with sum insured of $500 000, issued to (50) 10000 9000 8000 7000 6000 5000 4000 3000 2000 1000 0 S> 10 12 Time, t 14 16 8 20 Figure 7.4 Policy values for each year of a 20-year term insurance, sum insured $500000, issued to (50). c. Create also a graph for the policy values of Example 7.4. Assume that the final age w = 80. 2. Create graphs in Excel of the policy values of the following three insurance contracts. Show all calculations of the policv values in Excel 20-year endowment insurance with sum insured of $500 000, issued to (50) (Example 500000 450000 400000 350000 300000 250000 200000 150000 100000 50000 10 12 Time, t 16 18 20 Figure 7.3 Policy values for each year of a 20-year endowment insurance, sum insured S500000, issued to (50). b. 20-year term insurance with sum insured of $500 000, issued to (50) 10000 9000 8000 7000 6000 5000 4000 3000 2000 1000 0 S> 10 12 Time, t 14 16 8 20 Figure 7.4 Policy values for each year of a 20-year term insurance, sum insured $500000, issued to (50). c. Create also a graph for the policy values of Example 7.4. Assume that the final age w = 80