Zoho Sheet

How Much Should You Put Into Flexible Spending Account
Copyright: The Finance Buff

This spreadsheet compares total after-tax cost under different FSA contribution amount.
For more information, see
How Much Should You Put Into Flexible Spending Account

Assumptions
Best Estimate	1,000
Plus or Minus	500
Marginal Tax Rate	32%
FSA contributions	1,000

Calculations
After-tax cost of FSA	680
	From	To	Mid-Point	Paid From FSA	Paid From After-Tax Money	Total Cost After-Tax	Custom Probability
	500	600	550	550	0	680	2%
	600	700	650	650	0	680	3%
	700	800	750	750	0	680	10%
	800	900	850	850	0	680	15%
	900	1000	950	950	0	680	20%
	1000	1100	1050	1000	50	730	20%
	1100	1200	1150	1000	150	830	15%
	1200	1300	1250	1000	250	930	10%
	1300	1400	1350	1000	350	1030	3%
	1400	1500	1450	1000	450	1130	2%
					Average	805
					Weighted Avg	757
Expected Total After-Tax Cost
Contribution	Average	Wtd Avg
500	840	840
600	813	809
700	796	781
800	789	759
900	792	749
1,000	805	757
1,100	828	785
1,200	861	831
1,300	904	889
1,400	957	953
1,500	1,020	1,020

Sheet1