Jonesboro 9-Bed - Financials - PUBLIC.xlsx

	A	B	D	E	F
1		Stanton Team Cash Flow Analysis
2
3	Jonesboro 9-Bed, Jonesboro GA			249000 List Price
4
5					based on T6
6	Cost Basis		Cash Flow	Monthly	Annual
7	Purchase Price	$ 249,000	Gross Income	$ 4,798.67	$ 57,584.00
8	Improvements	$ -	Revenue/PS Earnings	$ 4,255.33	$ 51,064.00
9	Financed Closing Costs	$ 7,470	Operating Expenses	$ (1,872.50)	$ (22,470.00)
10	Total Cost Basis	$ 256,470	Net Operating Income	$ 2,382.83	$ 28,594.00
11
12	Financing		Debt Service	$ (1,229.94)	$ (14,759.23)
13	Appraisal Gap	$ -	Total Cash Flow	$ 1,152.90	$ 13,834.77
14	LTV	75%
15	Interest Rate	6.90%	Performance
16	Term (Years)	30	Cash Outlay		$69,720
17	Loan Amount	$ 186,750	Cap Rate		11.15%
18	Down Payment	$ 62,250	Cash-on-Cash Return		19.84%
19	Monthly Debt Service	$ 1,229.94
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