Home and School Shopping Data 2016 editable

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Family profile	Annual gross income	Savings (for down payment)	Own a car?	Monthly debt payments	Max monthly housing costs	If buying, maximum home price	Choice 1 location	Choice 1 cost	Choice 2 location	Choice 2 cost	School 1 Percent at Goal	School 2 Percent at Goal
2	Cara	$30,000	$5,000	No	$ 200 credit card	$700	$126,146	East Hartford	119,900			60.5
3	Jessica	$30,000	$5,000	Yes	$ 200 car payment	$700	$126,146	Meriden		129,900		83.1
4	Nico	$42,000	$2,000	No	none	$1,260	$221,488	Manchester	149,900	Wethersfield	169,900	65.7
5	Michelle	$42,000	$5,000	Yes	$ 200 car payment	$1,060	$188,973	West Hartford	180000	Glastonbury	184000	86	91.5
6	James	$42,000	$5,000	Yes	$ 200 car + $200 student loan	$860	$154,069	West Hartford	125000			86
7	Lilly	$54,000	$2,000	No	none	$1,620	$284,316	West Hartford	249,000	West Hartford	224,995	86	86
8	Vianna	$54,000	$5,000	Yes	$ 300 car payment	$1,320	$234,349	West Hartford	$224,995	Wethersfield	$219,000	86	83.1
9	Courtney	$54,000	$10,000	Yes	$ 300 car + $400 student loan	$920	$168,523	New Britain				49.7
10	Lisa	$66,000	$10,000	Yes	$ 300 car + $600 student loan	$1,080	$196,446	Wethersfield	179,900	Manchester	164,500	83.10%	72.30%
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100