Maximum Allowable Offer

	A	B	C	E	F	H	I	J
1	Please enjoy the spreadsheet used by Win Win Financial Solutions to evaluate rehab and resell opportunities. Nothing in this spreadsheet guarantees an offer or a deal. The calculations are not certified nor are the results guaranteed. To seek an official offer, please call 317.777.0767 or email BradReed@WinWinFinancialSolutions.com
2
3
4		You may ONLY change the numbers in the Yellow Boxes
5	Maximum Allowable Offer =	$80,427.70	MAO must be less than Est Purchase Price in B12	Cash Needed To Close	$11,520
6	Maximum Allowable Offer =	$80,427.70		Cash Needed To Close	$11,520
7	Risk Tolerance =	$23,428		Down Pymt	$8,100
8	Risk Tolerance / Mo =	$3,905		HML Pts	$0
9	Total Costs (before gap costs) =	$136,572.31		Aq Close Cost	$1,620
10	ARV	$160,000	Raw Numbers	Insurance	$1,500			15
11	Rehab Cost+Buffer	$29,851	$29,851	Utilities	$300			25
12	Est Purchase Price	$81,000	$81,000	HOA per Mo	$0			35
13	Down Paymt	$8,100	$8,100					45
14	Min Risk Tolerance %age	15	$24,000	Cash Need Before Sale	$35,361	Sq Ft	2060
15	Sell Close Cost %	3	$4,800	Cash Need Before Sale	$35,361	Rehab Cost / sqft	45
16	Realtor %age	6	$9,600	Utilities	$1,500	Total Rehab Cost	92700
17	# of Months Held	6	0	Interest	$4,010
18	Annual Taxes	$1,500	$750	Rehab + Buffer	$29,851	*Might need to include cost of marketing / staging / etc.
19	Insurance	$1,500	$1,500	HOA	$0
20	Utilities per Mo	$300	$1,800			Need to fix this...
21	HOA per Mo	$0	$0	Cash Received At Close	$42,099
22	Lender Pts	0	$0	Cash Received At Close	$42,099
23	Lender Int %age	11	$5,651	Sale Price	$160,000
24	Aq Close Cost %	2	$1,620	Sale Close Costs	$4,800
25				Realtor %age	$9,600
26	HML Borrowed =	$102,751		Property Taxes	$750
27	Total Cash Needed =	$18,671		Pay Back Loans	$102,751
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