1. You are an actuary in charge of the life product development area of Storrs Life Insurance Company (SLIC). Storrs Life has been selling a 10-year Yearly Renewable Term (YRT) product for some time now, and has a considerable record of company experience for this product. You have an excel file on HuskyCT which contains our current pricing assumptions for a Female Age 50 Non-smoker. On this file you will find our best estimate mortality rates, the Statutory mortality rates, and the current YRT premiums that we charge a female age 50 non-smoker. (All other assumptions-such as face amount, earned interest rate etc. are the same as what we used in class for a Male age 50). You should build these assumptions into your model to produce our pricing assumptions for a Female age 50 non-smoker for our current YRT product. You should notchange these YRT premiums or any of the assumptions. These are the rates and assumptions for the product we currently sell, based on years of experience with this product, and we are not intending to change them at this time.

2. You have been asked to recommend whether or not Storrs Life should introduce a 10 year Level Premium Term product, and if yes, at what price. Your major competitors have introduced Level Premium Term life products, and the popularity of this design has been cited as a cause for the declining sales numbers at SLIC. Your actuarial students have developed a model for this product (already done in class!). You, as the head of the product development department, need to decide whether or not to recommend that Storrs Life begin to sell this level premium term product, and, if so, at what premium rate per $1000 (for this assignment, for a Female non-smoker issue age 50). You will do this by comparing the risks of selling a Level Premium Term product with the risks of selling the YRT design. You must submit a report discussing your sensitivity and scenario tests performed on all of the risks incurred in selling these policies. In particular, since your chief actuary is already familiar with your YRT product, but your company has never sold a level premium term design, you must point out all significant differences in the risks of these two products, as determined by your testing.Of course, you must also explain, as best as you are able, what is causing these differences.Based on this analysis, you should recommend whether or not SLIC should sell the level premium term product, and, if yes, at what price.

3. Storrs Life’s pricing goal is a minimum Risk-Adjusted IRR of 15.0%. In other words, your target IRR is based on distributable earnings including the allocation of Benchmark Surplus. Your decisions should be based on this Risk-AdjustedIRR profitability measure. Note: Storrs Life has an opportunity cost of capital of 13%. If you choose to also discuss the net present value of your results, you should calculate the NPV using an interest rate of 13% (not 15%).

4. As noted above, you must perform sensitivity tests and at least one scenario test for each product. You may also include Break-even tests. (If you do, Break-even tests should be based on the 13% Opportunity Cost of Capital, not the hurdle rate of 15%). You should start by listing all of your pricing assumptions. In your sensitivity tests you should testall of the risks associated with selling these products, by testing changes toall of the pricing assumptions. In particular, as noted above, because your chief actuary is familiar with the YRT design, but is not familiar with the Level Premium Term design it is essentialthat you identify any risks that are significantly different in the two designs. (That is identify andexplain assumptions that affect one policy significantly more or differently than the other). These assumptions need special attention in your report, and you should explain these differences as best as you are able. In fact, based on your results and analysis you may even decide to change the pricing assumptions you are using for the level premium term product. If you do this, be sure to explain your reasoning.
On the other hand, ifchanges to an assumption produces similar results for the two products, and does not pose much risk, a brief mention is all that is required. (An example for this situation is provided in the Helpful Hints document)

5. Note that you should not change the statutory reserve assumptions. These are set by the regulators, and cannot be changed- so do not perform sensitivity tests on them.

6. For both products, you should perform at least one scenario test- changing two related, or dependent variables. Explain why you think these two assumptions are related to each other. That is, explain why a change in one assumption would cause you to believe the other assumption would change in the direction and magnitude you tested.

7. For this assignment, please do not try to model major changes in the way we do business. (For example, do not model reinsurance!)

8. On or before the due date, you must send me via email an excel file(or Numbers file for you Mac users!) with your base line pricing results for both the YRT and Level Premium Term policy and a word file with your report. Once your model is completely working, including the calculation of reserves and benchmark surplus, you may find it helpful to save 2 copies- one for your YRT pricing and one for your Level Premium policy. This will make it easier to compare sensitivity and scenario tests. Name your files with your lastname first-something like lastnameYRT or lastnamereport. (e.g. TrimbleYRT)

9. This project is due on March 10, 2016, at the end of our class time. You must submit a hard copywritten report, and email your excel files to me by that time.
I would also like you to email me a copy of your written report, in addition to the hard copy.

This is a strict due date. No projects will be accepted after class ends on March 10, 2016.

Your models were supposed to be fully working by class on February 18. You should send me by email the results of your sensitivity tests by the end of the day on February 25.(These tests should be based on the pricing assumptions provided on HuskyCT and used in class- don’t change any of them for either model at this time). Be sure to tell me what level premium rate you used. If you do this, I will review the sensitivity test results you performed(in the order I receive them) and let you know of any errors. This helps insure that you base your reports and findings on properly working models. No analysis is required at this time- just a simple table of some results for me to check. If I find errors, I’ll help you correct them-but only if you turn in these results by February 25.
As for working with others, you are all subject to the Code of Conduct for Candidates (SOA) and Code of Professional Ethics for Candidates (CAS).
Here are guidelines for what is and what is not allowed on this project:
You may work with current classmates to get your models working properly. For example, if you run a sensitivity test and get what appears to be an incorrect or strange result, you may ask a current classmate if they are getting the same result for the change you are testing. You may not consult with former students who are not currently taking this class. And you certainly cannot use a former students’ model or template.
You must build and run your own model. You must run and discuss your own sensitivity tests- not copy a model or results from somebody else.
You may discuss with other current classmates what scenario tests may make sense- that is what variables may be related, and why. However, you may not consult with former students, and you must run your own scenario test(s) and discuss the results in your paper on your own.
You may not discuss this with other faculty members or actuaries to get advice on what to run, or for help explaining results. This is your work, and your analysis. When in doubt, ask me for assistance.
Finally, as daunting as it may sound, have some fun with this. It’s a close as I can come to replicating what you’ll really be doing on the job as a pricing actuary. So, enjoy it!

1. You are an actuary in charge of the life product development area of Storrs Life Insurance Company (SLIC). Storrs Life has been selling a 10-year Yearly Renewable Term (YRT) product for some time now, and has a considerable record of company experience for this product. You have an excel file on HuskyCT which contains our current pricing assumptions for a Female Age 50 Non-smoker. On this file you will find our best estimate mortality rates, the Statutory mortality rates, and the current YRT premiums that we charge a female age 50 non-smoker. (All other assumptions-such as face amount, earned interest rate etc. are the same as what we used in class for a Male age 50). You should build these assumptions into your model to produce our pricing assumptions for a Female age 50 non-smoker for our current YRT product. You should notchange these YRT premiums or any of the assumptions. These are the rates and assumptions for the product we currently sell, based on years of experience with this product, and we are not intending to change them at this time.

2. You have been asked to recommend whether or not Storrs Life should introduce a 10 year Level Premium Term product, and if yes, at what price. Your major competitors have introduced Level Premium Term life products, and the popularity of this design has been cited as a cause for the declining sales numbers at SLIC. Your actuarial students have developed a model for this product (already done in class!). You, as the head of the product development department, need to decide whether or not to recommend that Storrs Life begin to sell this level premium term product, and, if so, at what premium rate per $1000 (for this assignment, for a Female non-smoker issue age 50). You will do this by comparing the risks of selling a Level Premium Term product with the risks of selling the YRT design. You must submit a report discussing your sensitivity and scenario tests performed on all of the risks incurred in selling these policies. In particular, since your chief actuary is already familiar with your YRT product, but your company has never sold a level premium term design, you must point out all significant differences in the risks of these two products, as determined by your testing.Of course, you must also explain, as best as you are able, what is causing these differences.Based on this analysis, you should recommend whether or not SLIC should sell the level premium term product, and, if yes, at what price.

3. Storrs Life’s pricing goal is a minimum Risk-Adjusted IRR of 15.0%. In other words, your target IRR is based on distributable earnings including the allocation of Benchmark Surplus. Your decisions should be based on this Risk-AdjustedIRR profitability measure. Note: Storrs Life has an opportunity cost of capital of 13%. If you choose to also discuss the net present value of your results, you should calculate the NPV using an interest rate of 13% (not 15%).

4. As noted above, you must perform sensitivity tests and at least one scenario test for each product. You may also include Break-even tests. (If you do, Break-even tests should be based on the 13% Opportunity Cost of Capital, not the hurdle rate of 15%). You should start by listing all of your pricing assumptions. In your sensitivity tests you should testall of the risks associated with selling these products, by testing changes toall of the pricing assumptions. In particular, as noted above, because your chief actuary is familiar with the YRT design, but is not familiar with the Level Premium Term design it is essentialthat you identify any risks that are significantly different in the two designs. (That is identify andexplain assumptions that affect one policy significantly more or differently than the other). These assumptions need special attention in your report, and you should explain these differences as best as you are able. In fact, based on your results and analysis you may even decide to change the pricing assumptions you are using for the level premium term product. If you do this, be sure to explain your reasoning.
On the other hand, ifchanges to an assumption produces similar results for the two products, and does not pose much risk, a brief mention is all that is required. (An example for this situation is provided in the Helpful Hints document)

5. Note that you should not change the statutory reserve assumptions. These are set by the regulators, and cannot be changed- so do not perform sensitivity tests on them.

6. For both products, you should perform at least one scenario test- changing two related, or dependent variables. Explain why you think these two assumptions are related to each other. That is, explain why a change in one assumption would cause you to believe the other assumption would change in the direction and magnitude you tested.

7. For this assignment, please do not try to model major changes in the way we do business. (For example, do not model reinsurance!)

8. On or before the due date, you must send me via email an excel file(or Numbers file for you Mac users!) with your base line pricing results for both the YRT and Level Premium Term policy and a word file with your report. Once your model is completely working, including the calculation of reserves and benchmark surplus, you may find it helpful to save 2 copies- one for your YRT pricing and one for your Level Premium policy. This will make it easier to compare sensitivity and scenario tests. Name your files with your lastname first-something like lastnameYRT or lastnamereport. (e.g. TrimbleYRT)

9. This project is due on March 10, 2016, at the end of our class time. You must submit a hard copywritten report, and email your excel files to me by that time.
I would also like you to email me a copy of your written report, in addition to the hard copy.

This is a strict due date. No projects will be accepted after class ends on March 10, 2016.

Your models were supposed to be fully working by class on February 18. You should send me by email the results of your sensitivity tests by the end of the day on February 25.(These tests should be based on the pricing assumptions provided on HuskyCT and used in class- don’t change any of them for either model at this time). Be sure to tell me what level premium rate you used. If you do this, I will review the sensitivity test results you performed(in the order I receive them) and let you know of any errors. This helps insure that you base your reports and findings on properly working models. No analysis is required at this time- just a simple table of some results for me to check. If I find errors, I’ll help you correct them-but only if you turn in these results by February 25.
As for working with others, you are all subject to the Code of Conduct for Candidates (SOA) and Code of Professional Ethics for Candidates (CAS).
Here are guidelines for what is and what is not allowed on this project:
You may work with current classmates to get your models working properly. For example, if you run a sensitivity test and get what appears to be an incorrect or strange result, you may ask a current classmate if they are getting the same result for the change you are testing. You may not consult with former students who are not currently taking this class. And you certainly cannot use a former students’ model or template.
You must build and run your own model. You must run and discuss your own sensitivity tests- not copy a model or results from somebody else.
You may discuss with other current classmates what scenario tests may make sense- that is what variables may be related, and why. However, you may not consult with former students, and you must run your own scenario test(s) and discuss the results in your paper on your own.
You may not discuss this with other faculty members or actuaries to get advice on what to run, or for help explaining results. This is your work, and your analysis. When in doubt, ask me for assistance.
Finally, as daunting as it may sound, have some fun with this. It’s a close as I can come to replicating what you’ll really be doing on the job as a pricing actuary. So, enjoy it!