College Park 9-Bed Financials - PUBLIC.xlsx

	A	B	D	E	F
1		Stanton Team Cash Flow Analysis
2
3	College Park 9-Bed, College Park GA 30349
4
5					*based on stabalized 10 months
6	Cost Basis		Cash Flow	Monthly	Annual
7	Purchase Price	$ 280,000	Gross Income	$ 5,210.61	$ 62,527.26
8	Improvements	$ -	Revenue/PS Earnings	$ 4,475.91	$ 53,710.94
9	Financed Closing Costs	$ 8,400	Operating Expenses	$ (1,856.20)	$ (22,274.45)
10	Total Cost Basis	$ 288,400	Net Operating Income	$ 2,619.71	$ 31,436.50
11
12	Financing		Debt Service	$ (1,383.06)	$ (16,596.72)
13	Appraisal Gap	$ -	Total Cash Flow	$ 1,236.65	$ 14,839.77
14	LTV	75%
15	Interest Rate	6.90%	Performance
16	Term (Years)	30	Cash Outlay		$78,400
17	Loan Amount	$ 210,000	Cap Rate		10.90%
18	Down Payment	$ 70,000	Cash-on-Cash Return		18.93%
19	Monthly Debt Service	$ 1,383.06
20
21	Notes
22	Assumes 3% of purchase price in closing costs for financed deals. Reduce to $1,000 -- $2,000 for a cash purchase.
23	Make a copy of this sheet to play with your own numbers. The blue-shaded cells are input fields.
24
25
26
27
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