1133 Oak Knoll Ter SE, Atlanta, GA 30315 - Deal Analysis - 07-15-24.xlsx

	A	D	E	G	H	I	J	K	L	M	N
1

2		Flip	Flip - lowball	Rental Comparables
3	Bedroom	3	3		Address	Sold Price	SQF	PP-SQF	Sold Date	Bed	Bath
4	Bathroom	2.0	2.0	Comp 1				#DIV/0!
5	SQF	1,323	1,323	Comp 2				#DIV/0!
6	ARV	$ 335,000.00	$ 335,000.00	Comp 3				#DIV/0!
7
8	Purchase Price	$ 135,000.00	$ 110,000.00					#DIV/0!
9	Seller Paid Commission	$ 4,625.00	$ 4,625.00
10	Buyer Paid Commission	$ -	$ -
11	Closing Costs	$ 4,625.00	$ 4,625.00
12	Renovations	$ 120,000.00	$ 120,000.00
13	Furniture/ Set Up (STR)	$ -	$ -
14	Management Set up Fee (STR)	$ -	$ -
15	Total initial investment	$ 259,625.00	$ 234,625.00
16				Flip Comparables
17	Rent Amount	$ 2,100.00	$ 2,100.00		Address	Sold Price	SQF	PP-SQF	Sold Date	Bed	Bath
18				Comp 1	1107 Oak Knoll Ter SE	$335,900	1,400	$239.93	04/30/24	3	2
19	Annual Income			Comp 2	1129 Oak Knoll Ter SE	$305,000	1,500	$203.33	04/30/24	3	2
20	Gross Revenue	$ 25,200.00	$ 25,200.00	Comp 3	136 Claire Dr SE	$353,500	1,479	$239.01	03/04/24	3	2
21	Vacancy 10%	$ (2,520.00)	$ (2,520.00)
22	Total Income	$ 22,680.00	$ 22,680.00					$227.42
23
24	Annual Expenses
25	Management Fee's	$ 1,140.00	$ 1,140.00		Notes:
26	HOA Fees	$ -	$ -		(A): There are no interior photos. This home is a total interior renovation;
27	Property Tax	$ 500.00	$ 500.00		plumbing and electrical are intact but the house will need a new HVAC. The roof is under 10 years old.
28	Insurance	$ 620.00	$ 620.00		There was an isolated fire upstairs that the previous resident did not repair.
29	Maintenance	$ 750.00	$ 750.00
30	Misc.	$ 750.00	$ 750.00
31	STR Expenses	$ -	$ -
32	Total Expenses	$ 3,760.00	$ 3,760.00
33	NOI before debt	$ 18,920.00	$ 18,920.00		Added SQF:	$0.00
34	CAP Rate (All Cash)	7.3%	8.1%
35	Cost vs ARV percentage	78%	70%
36
37	Mortgage Calculator
38	Principal	$ 101,250.00	$ 82,500.00
39	Down Payment (Cash Basis)	$ 33,750.00	$ 27,500.00
40	Interest Rate (%)	7.50%	7.50%
41	Life Loan (In Years)	30	30
42	Number of Payments per year	12	12
43	Total # of Payments	360	360
44	Payment per period (Actual payment)	$ 707.95	$ 576.85
45	Debt Service	$ 8,495.46	$ 6,922.22
46	NOI after debt	$ 10,424.54	$ 11,997.78
47	Cash on Cash Return	6.58%	7.89%
48
49	Cash Needed to Close (Purchase)	$43,000.00	$36,750.00
50	Cash needed to Reno/Set Up	$120,000.00	$120,000.00
51	All in Cash for the deal	$163,000.00	$156,750.00
52
53	Date Inspected:
54	Inspector:
55	Approximate Renovation Costs:
56	Inspection Notes:
57
58
59	Value at 10% CAP	$ 189,200.00	$ 189,200.00
60	Value at 9% CAP	$ 210,222.22	$ 210,222.22
61	Value at 8% CAP	$ 236,500.00	$ 236,500.00
62	Value at 7% CAP	$ 270,285.71	$ 270,285.71
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