IA5 assignment in statistics
iamnickok
IA5_Q1_FSA_template.xlsxFSA
| Flexible Spending Accounts | |||||||||||
| Salary | 70000 | ||||||||||
| FSA contribution | 2000 | ||||||||||
| Pretax Salary | 68000 | Simulation Run | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| Aftertax Salary | 47600 | Contribution | 0 | 500 | 1000 | 1500 | 2000 | 2500 | 3000 | 3500 | 4000 |
| Health care costs | 2000 | Mean Salary after tax and HC costs: | |||||||||
| Out-of-pocket cost | 0 | Standard Dev of Salary after tax and HC costs: | |||||||||
| Salary after tax and health care costs | 47600 | ||||||||||
| Parameters: | |||||||||||
| Tax percentage: | 30% |
