ATax Saver Benefit (TSB) plan allows you to put money into an account at the beginning of the calendar year that can be used for medical expenses. This amount is not subject to federal tax—hence the “Tax Saver.” As you pay medical expenses during the year, the administrator of the TSB reimburses you until the TSB account is exhausted. From that point on, you must pay your medical expenses out of your own pocket. On the other hand, if you put more money into your TSB than the medical expenses you incur, this extra money is lost to you. Your annual salary is

$80,000 and your federal income tax rate is 30%.

a. Assume that your medical expenses in a year are normally distributed with mean $2000 and standard deviation $500. Build an @RISK model in which the output is the amount of money left to you after paying taxes, putting money in a TSB, and paying any extra medical expenses. Experiment with the amount of money put in the TSB by using a RISKSIMTABLE function.

b. Rework part

a, but this time assume a gamma distribution for your annual medical expenses. Use
 16 and   125 as the two parameters of this distribution. These imply the same mean and standard deviation as in part

a, but the distribution of medical expenses is now skewed to the right, which is probably more realistic. Using simulation, see whether you should now put more or less money in a TSB than in part a.