Forest Park 7-Bed - Financials - PUBLIC.xlsx

	A	B	D	E	F
1		Stanton Team Cash Flow Analysis
2
3	Forest Park 7-Bed, Forest Park GA 30297
4
5
6	Cost Basis		Cash Flow	Monthly	Annual
7	Purchase Price	$ 220,000	Gross Income	$ 4,806.17	$ 57,674.00
8	Improvements	$ -	Revenue/PS Earnings	$ 4,400.00	$ 52,800.00
9	Financed Closing Costs	$ 6,600	Operating Expenses	$ (2,077.27)	$ (24,927.24)
10	Total Cost Basis	$ 226,600	Net Operating Income	$ 2,322.73	$ 27,872.76
11
12	Financing		Debt Service (30 year AM Loan)	$ (1,086.69)	$ (13,040.28)
13	Appraisal Gap	$ -	Total Cash Flow (30 yr AM Loan)	$ 1,236.04	$ 14,832.48
14	LTV	75%
15	Interest Rate	6.90%	Debt Service (I/O Loan)	$ 948.75	$ 11,385.00
16	Term (Years)	30	Total Cash Flow (I/O Loan)	$ 1,373.98	$ 16,487.76
17	Loan Amount	$ 165,000
18	Down Payment	$ 55,000	Performance
19	Monthly Debt Service	$ 1,086.69	Cash Outlay		$61,600
20	Monthly Debt Service (I/O)	$ 948.75	Cap Rate		12.30%
21	Notes		Cash-on-Cash Return (30 yr AM Loan)		24.08%
22			Cash-on-Cash Return (I/O Loan)		26.77%
23
24
25
26
27	Assumes 3% of purchase price in closing costs for financed deals. Reduce to $1,000 -- $2,000 for a cash purchase.
28	Make a copy of this sheet to play with your own numbers. The blue-shaded cells are input fields.
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