BLANK MAO - JV Deal.xlsx

	B	D	F	H	J	K	L
1
2	No Flipping Excuses MAO Calculator
3
4	Subject Property Details				After Repair Value
5	Subject Property Details				After Repair Value
6
7	Property Street Address				$62,944.44
8	14886 Fawn Hollow Ln, Noblesville, IN 46060				$62,944.44
9
10	City		State	Zip Code	Wholesale Fee	NOI	Cap Rate
11					$20,000	$0.00	#DIV/0!
12
13	Bedrooms	Bath	SQFT	Asking Price	Taxes	Closing Costs	Misc
14			1100		$4,000.00	$1,500.00	$200.00
15
16	Income (mo)	Expenses (mo)	Est. Repairs		Maximum Allowable Offer
17			$8,000.00		Maximum Allowable Offer
18
19	Property Comps				65%	$7,213.89
20	Property Comps				65%	$7,213.89
21
22	Comp 1 - Street Address				70%	$10,361.11
23	Comp 1 - Street Address
24	123 Candy Lane
25
26	Bed/Bath	Rent (mo)	Expenses (mo)	Sold Price	75%	$13,508.33
27				$50,000.00	75%	$13,508.33
28
29	SQFT	Price per SQFT	NOI	Cap Rate	80%	$16,655.56
30	1000	$50.00	$0.00	0.00%	80%	$16,655.56
31
32					Profits Calculator
33	Comp 2 - Street Address
34
35
36	Bed/Bath	Rent (mo)	Expenses (mo)	Sold Price	Purchase Price	Marketing Costs	Misc
37				$90,000.00
38
39	SQFT	Price per SQFT	NOI	Cap Rate	Sales Price	Profit:	$0.00
40	1200	$75.00	$0.00	0.00%		Profit:	$0.00
41
42					How to use the NFE MAO Calculator:
43	Comp 3 - Street Address				How to use the NFE MAO Calculator:
44					Step 1. Clear any field highlighted in YELLOW and fill it in as appropraite
45
46	Bed/Bath	Rent (mo)	Expenses (mo)	Sold Price
47				$42,000.00	Step 2. Check the fields highlighted in GREEN for suggested offers and profits
48
49	SQFT	Price per SQFT	NOI	Cap Rate
50	900	$46.67	$0.00	0.00%	NOTE ONLY EDIT FIELDS HIGHLIGHTED IN YELLOW
51
52	Average Price Per SQFT		Average Rent
53	57.22222222		$0.00
54
55	Average Sold Price		Average Cap Rate
56	$60,666.67		0.00%
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