Question
An employer offers its employees a Dependent Care Flexible Spending Account (DCFSA) that allows them to put money in an account at the beginning of
An employer offers its employees a Dependent Care Flexible Spending Account (DCFSA) that allows them to put money in an account at the beginning of the calendar year that can be used for daycare expenses. The amount is not subject to federal tax. As you pay daycare expenses during the year, you are reimbursed by the DCFSA until the money is exhausted. From that point on, you must pay your daycare expenses out of your own pocket. On the other hand, if you put more money into your DCFSA than the daycare expenses you incur, this extra money is lost to you. Your annual salary is $90,000 and your federal income tax rate is 22%. Assume that your annual daycare expenses are triangularly distributed with a minimum of $500, most likely of $2000 and maximum of $6000.
- Using @Risk, build a simulation model where the output is the amount of money left after paying taxes, putting money in an DCFSA and paying any extra daycare expenses. For DCFSA account, consider the range between $1,000 and $5,000 in increments of $500.
- Provide the "output results summary" table. Which amount put in DCFSA would leave you with the largest amount of money (on average)?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started