2022 NoVa Lifestyle Calculator

	A	B	C	D	E	F	G	H	J	K	L	M	N
1								You?				Taxable	-25,900
2	Spouse 1	50,000	62,416	75,000	87,500	125,000		0
3	Spouse 2	50,000	62,416	75,000	87,500	125,000		0
4	Gross Pay	100,000	124,831	150,000	175,000	250,000		0				AGI	0
5
6	401(k) Pre-tax	6,000	7,490	9,000	10,500	41,000	6% Match minimum	0				Std Ded	25,900
7	Dental	500	500	500	500	500		0	10%	0	20,550	2,055	-2590
8	Medical	6,000	6,000	6,000	6,000	6,000		0	12%	20,551	83,550	7,560	0
9	Vision	50	50	50	50	50		0	22%	40,526	178,150	30,277	0
10	Health FSA	1,000	1,000	1,000	1,000	1,000		0	24%	178,151	340,100	38,868	0
11	Dependent FSA	5,000	5,000	5,000	5,000	5,000		0	32%	340,101	431900	29,376	0
12									35%	431901	647850	75,582	0
13	OASDI	5,050	6,497	7,964	9,421	12,180	6.20%	0	37%	647851	100000000000		0
14	Medicare	1,181	1,519	1,863	2,203	2,849	1.45%	0
15	Federal Withholding	2,655	5,456	10,195	16,615	26,755	Adj for child tax credit	0
16	State Tax - VA	2,582	3,147	3,720	4,289	5,365		611
17
18	Roth IRA	0	0	0	6,931	12,000	Priority after 401K employer match	0
19	VA529	0	0	0	0	8,000		0
20
21	Net Pay	69,982	88,171	104,709	112,491	129,301		-611
22
23		Median, single-family attached $433K	Overall Median Value	Median detached SFH	Median detached SFH	Median Dranesville SFH		Your Home
24	Home Price	433,314	553,970	670,464	670,464	934,931		0
25	Down Payment	10%	10%	10%	10%	20%		0%
26	Loan Amount	389,983	498,573	603,418	603,418	747,945		0
27	Rate	3.0%	3.0%	3.0%	3.0%	3.0%		0.0%
28	Months	360	360	360	360	360		360
29
30		28%	29%	29%	27%	29%	you shouldn’t spend more than 28% of your gross income (what you take home before taxes) on your mortgage payment (principal and interest).	0%
31	Payment	1,644	2,102	2,544	2,544	3,153		0
32	Taxes	428	468	566	566	789	1.013/$100	0
33	Insurance	90	115	140	140	195		0
34	Mnthly Mortgage	2,162	2,685	3,250	3,250	4,137		0
35
36	PITI	25,944	32,221	38,996	38,996	49,649		0
37	PMI	1,440	1,440	1,440	1,440	0		0
38	HOA	1,200	1,200	1,200	1,200	1,200		0
39	Pest	360	360	360	360	360		0
40	Home Improvement	4,333	5,540	6,705	6,705	9,349		0
41	Housing Cost	33,277	40,760	48,701	48,701	60,558	Range of median home values by type	0
45	Childcare	11,000	14,000	14,000	17,000	19,000	Net of Dependent FSA reimbursement	0
65	Transportation	13,396	15,967	15,967	15,967	18,598	Two cars, Ins, R&M, Gas, Tolls	0
66	Food	8,252	10,132	10,132	12,589	12,589	Official USDA Food Plans - 1/22	0
67	Travel	2,000	3,000	3,000	3,000	5,000	US Avg 1-week vacationfor two people: $3,116	0
75	Util/Phone/Cable	4,840	6,300	6,700	7,100	7,500		0
76	Student Loan	0	0	0	0	0		0
83	Recurring	1,809	2,234	2,234	2,234	2,234		0
93	Discretionary	3,850	5,900	5,900	5,900	5,900		0
94
95	Total Expenses	78,423	98,293	106,634	112,491	131,379		0
96
97	Net Income	-8,442	-10,122	-1,925	0	-2,078		-611
98
99	Savings	6,000	7,490	9,000	17,431	53,000		0
100	Savings Rate	7%	7%	7%	12%	26%	Aim to save 15% of your pre-tax income	0%
101							Savings/(Gross-Tax)
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144