Question

In: Statistics and Probability

In the USA, a Flexible Savings Account (FSA) plan allows you to put money into an...

In the USA, a Flexible Savings Account (FSA) 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. As you pay medical expenses during the year, you are reimbursed by the administrator of the FSA until the money 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 FSA 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. Using @RISK build a model in which the output is the amount of money left to you after paying taxes, putting money in an FSA, and paying any extra medical expenses. Experiment with the amount of money put in the FSA, using an appropriate @RISK 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 an FSA than in the symmetric case in part a.

Solutions

Expert Solution


Related Solutions

You put $1,000 into a savings account that pays 4% in annualinterest. How much money...
You put $1,000 into a savings account that pays 4% in annual interest. How much money will you have after 2 years if the account pays only simple interest?
You put $50 in your savings account at the end of each month.
You put $50 in your savings account at the end of each month. The nominal interest rate is 14% annual nominal compounded monthly, and you have at the end $2,221.14. what its your annuity value?
At the beginning of the year, you put $2,000 in a new savings account that has...
At the beginning of the year, you put $2,000 in a new savings account that has a 3% annual interest rate, but the account earns interest at the end of every six months. At the end of the first year, you withdraw $1,000 from the account. 1. How much interest have you earned after six months? Show your work. 2. How much interest have you earned after one year? Show your work. 3. What is the total amount in your...
If you put $6,470.74 in a savings account that pays 4% for one year what is...
If you put $6,470.74 in a savings account that pays 4% for one year what is the amount of money you will have at the end of the one year?
You have just received an endowment and placed this money in a savings account at an...
You have just received an endowment and placed this money in a savings account at an annual rate of 13.58 percent. You are going to withdraw the following cash flows for the next five years. End of year 1.   $7,512 2.   $8,140 3.   $4,455 4.   $3,122 5.   $1,857 How much is the endowment that you received? Round the answer to two decimal places.
1) Please explain the following terms: savings account, basic savings account, interest bearing checking account, money...
1) Please explain the following terms: savings account, basic savings account, interest bearing checking account, money market deposit accounts, and certificate of deposits 2) What is the difference between a bond and a certificate deposit
You have invested money in a savings account that pays a fixed monthly interest on the...
You have invested money in a savings account that pays a fixed monthly interest on the account balance. The following table shows the account balance over the first 5 months. Time in months Savings balance 0 $1500.00 1 $1521.00 2 $1542.29 3 $1563.88 4 $1585.77 5 $1607.97 (a) How much money was originally invested? $   (b) Show that the data are exponential. (Round your answer to three decimal places.) Each successive ratio of new/old is   , which shows that the data...
Suppose that you deposit $1,000 in a savings account at Wells Fargo and plan to leave...
Suppose that you deposit $1,000 in a savings account at Wells Fargo and plan to leave your principal and any interest in the account for four months. The interest rate in the first month is 2%; in the second month, 2%; in the third month, 1%; and in the fourth month, 2%. What is the future value of your account at the end of the holding period? Do not round at intermediate steps in your calculation. Round your final answer...
You plan to deposit $5,500 into a savings account. There are five great banks in your...
You plan to deposit $5,500 into a savings account. There are five great banks in your town offering terrific interest rates. If your goal is to earn the greatest amount of interest, which bank should you choose? Please explain why. Bank KLM: 3.66% compounded continuously Bank HIJ: 3.71% compounded semi-annually Bank DEF: 3.70%, compounded monthly Bank XYZ; 3.64% compounded quarterly Bank ABC: 3.74%, compounded annually
The formula for calculating the amount of money in a savings account that begins with an...
The formula for calculating the amount of money in a savings account that begins with an initial principal value (P) and earns annual interest (i) for (n) years is: P(1 + i)n Note that i is a decimal, not a percent interest rate: .1 NOT 10%              Write a python program that does the following: Prompt the user on three lines for principal, percent interest rate and number of years to invest (using descriptive prompts) Use a while loop to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT