Property ARV Calculator.xlsx

	A	B	C	D	E	F	G	H	I
1		TO USE, SIMPLY COPY OR DOWNLOAD THIS DOCUMENT TO YOUR COMPUTER!
2
3
4			ARV CALCULATOR
5			ARV CALCULATOR
6
7			Subject	House 1	House 2	House 3		Calculations
8		Sq Ft	2558	3500	1660	1456		Sq Ft	$25
9		Bed	5	5	4	3		Bed	$10,000
10		Full Bath	3	5	3	3		FullBath	$8,000
11		Half Bath	1	1				Half Bath	$5,000
12		Fin. Basement	Yes	Yes	no	Yes		Basement	$15,000
13		Garage Spots	2	0	2	2		Garage	$7,500
14		Sold Price		$236,000.00	$260,000.00	$250,000.00
15
16				Adjustments
17
18		House 1	Adjustment	House 2	Adjustment	House 3	Adjustment
19	Sq Ft	942	$23,550.00	-898	-$22,450.00	1102	$27,550.00
20	Bed	0	$0.00	-1	-$10,000.00	2	$20,000.00
21	Full Bath	2	$16,000.00	0	$0.00	0	$0.00
22	Half Bath	0	$0.00	-1	-$5,000.00	1
23	Basement Adj.		$0.00		-$15,000.00
24	Garage Spots	-2	-$15,000.00	0	$0.00	-2	-$15,000.00
25
26	Total Adjustment		$39,550.00		-$52,450.00		$47,550.00
27
28	Adjusted Price:		$196,450.00		$312,450.00		$202,450.00
29
30			Avg Adjusted Price
31				$237,116.67
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