5812 meadowbrook flip Spreadsheet

	A	B	C	D	E	F	H	I	J	K	L	M	N	O
1	Property Details and Analysis						After Repair Value(ARV) Calculation
2	Place picture to the left						Comp analysis	Subject	Comp 1	Adj.	Comp 2	Adj.	Comp 3	Adj.
3					Address	7917 Bronco ln, sherwood, AR	Address	7917 Bronco ln, sherwood, AR	8202 n Claremont		1809 Corral		8 Christopher Ct
4							Distance from property		0.5 mi away		350 ft away		0.4 mi away
5					Central Arkansas		MLS #
6					Square Feet	1040	Date of Sale		6/25/2015		7/22/2015		8/25/2015
7							Price	$ 20,000	$ 85,900		$ 85,000		$ 87,500
8					Lot Size	6752	Price Per SQFT	$ 19	$ 92		$ 61		$ 65
9					No. Bedrooms	3	Age	1970	1971		1969		1968	$ -
10					Basement		Condition	poor	Remodeled		Good		Fair
11							SQFT	1040	945	$ 1,000	1300	$ (2,500)	1292	$ (500)
12					Ground Parter	TopLine Discounts LLC	Lot Size	6752	6969		7840	$ (1,000)	.28 acres	$ (1,500)
13					Year Built	1970	Beds	3	3	$ -	3		3	$ -
14					No. Baths	1.5	Bath	1.5	1.5		1	$ (500)	1	$ (500)
15					Garage/Parking	No	Garage	No	No		No		No
16							Porch/Decks	no	No	$ -	Yes	$ (1,000)	No
17	The Ground Partner should fill in this colored fields.						Shop/Storage Area	no	No		yes	$ (1,000)	Yes	$ (1,000)
18							Pool	No	No	$ -	No	$ -	No
19	Property Inputs			Total Cost to acquire and rehab as % ARV		50%	Storm Cellar	No	No		No		No
20	Purchase Price		$ 20,000	Sales Analysis			Fireplaces	no	No	$ -	No		Yes
21	ARV		$ 75,484	Sales Price		$ 75,484	Next to lake	No	No		No	$ -	No	$ -
22	Estimated Rehab Cost		$ 15,000	Selling Costs			Back Yard, fenced	Yes	Yes		Yes, big lot		Yes, big lot
23	Estimated Hold Time(in month)		3	1.6%	Closing Costs at time of sale	$ 1,208
24	Purchase Costs				Staging / Concessions	$ -	Total Adjustment			$ 1,000		$ (6,000)		$ (3,500)
25	Appraisal		$ 500	6.0%	Commissions	$ 4,529	Adjusted ARV	$ 75,484	$ 86,900		$ 79,000		$ 84,000
26	Closing Costs	0.5%	$ 700	Total Selling Costs		$ 5,737
27	Total Purchase Costs		$ 1,200	Gross Flip Profit		$ 32,375	Note: When the comp has a more desirable feature than the subject, the adjustment is negative
28	Holding Cost Analysis			Payout Analysis			When the comp has a less desirable feature, the adjustment is positive
29	Insurance		$ 500	5%	Investor Payout	$ 5,606
30	Utilities		$ 300		Net Flip Profit	$ 26,769
31	Property Taxes		$ 372	45%	Payout to JV Partner	$ 12,046
32	Total Holding Costs		$ 1,172	45%	Payout to Ground Partner	$ 12,046
33	Total Cost to acquire and rehab		$ 37,372	10%	Fix & Flip Reserves	$ 2,677
34	Total Funds Needed		$ 37,372		Cash on Cash return JV Partner	47.23%
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