Spring Forest.xlsx

	C	D	E	F	G	H	I	J	K	L	M	O
1												SPREAD OVER 10 YEARS
2
3
4							Financial Information
5							Purchase Price			$485,000
6							Down Payment		25%	$121,250
7							LTV (1st Loan)		75%	$363,750
8							Mortgage Rate - Payment		5.75%	$2,123
9							Amortization Term (years)		30	412,250.00
10							Property Taxes			$185
11							Insurance			$50
12							HOA Fees			$13
13							Property Management			$147
14							Other Expenses
15							Total Monthly Expenses			$2,517
16										Low	High
17							Rent Range			2,400	2,450
18							Net Cash Flow (pre - tax)			($117)	($67)
19
20							Annualized
21	Property Address						Cash Return on Investment			($803)	-0.7%
22	Spring Forest						Principal Reduction			$4,557	3.8%
23	Map Link:						Tax Reduction - Based on 25% Tax Bracket			$3,301	2.7%
24	Property Information						Appreciation (Rate used is 8.00%)			$38,800	32.0%
25	Type Dwelling:	Single Family					Total ROI			$45,856	37.8%
26	Square Footage:	2,232
27	Year Built:	2021					Financial Indicators
28	Sales Details						Debt Coverage Ratio:			0.97x
29	Full Brick with Hardee accents						Going-In Cap Rate:			5.09%
30							Appreciation (annual)			8.00%
31							Closing Cost			1.50%
32							Vacancy			0.00%
33							Income Growth (annual)			3.00%
34							Maintenance Growth			0.00%
35
36
37	ANNUAL INCOME ANALYSIS	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
38	Operating Income	$29,400	$30,282	$31,190	$32,126	$33,090	$34,083	$35,105	$36,158	$37,243	$38,360
39	(-) Mortgage Payments	25,473	25,473	25,473	25,473	25,473	25,473	25,473	25,473	25,473	25,473
40	(-) Vacancy/Maintenance	0	0	0	0	0	0	0	0	0	0
41	(-) Other Expenses	4,730	4,730	4,730	4,730	4,730	4,730	4,730	4,730	4,730	4,730
42	Cash Flow (after DS)	(803)	79	988	1,923	2,887	3,880	4,902	5,955	7,040	8,158
43
44	Annual Cash Flow	-$803	$79	$988	$1,923	$2,887	$3,880	$4,902	$5,955	$7,040	$8,158
45	(+) Principal Reduction	4,557	4,819	5,096	5,390	5,699	6,027	6,374	6,740	7,128	7,538
46	Loan Balance	359,193	354,373	349,277	343,887	338,188	332,161	325,787	319,047	311,919	304,381
47	Market Value	485,000	523,800	565,704	610,960	659,837	712,624	769,634	831,205	897,701	969,517
48	(+) Appreciation	38,800	41,904	45,256	48,877	52,787	57,010	61,571	66,496	71,816	77,561
49	Cash on Cash Return	-0.66%	0.07%	0.81%	1.59%	2.38%	3.20%	4.04%	4.91%	5.81%	6.73%
50	Implied Exit Cap	5.09%	4.88%	4.68%	4.48%	4.30%	4.12%	3.95%	3.78%	3.62%	3.47%
51
52	Rolling Equity	$125,807	$169,427	$216,427	$267,073	$321,649	$380,463	$443,847	$512,158	$585,782	$665,136
53	(-) Closing Costs	7,275	7,857	8,486	9,164	9,898	10,689	11,545	12,468	13,466	14,543
54	Proceeds After Sale	118,532	161,570	207,942	257,909	311,752	369,774	432,303	499,690	572,317	650,593
55	(+) Cum. Cash Flow	-803	-724	264	2,187	5,075	8,954	13,857	19,812	26,853	35,010
56	(-) Initial Cash Invested	121,250	121,250	121,250	121,250	121,250	121,250	121,250	121,250	121,250	121,250
57	Net Profit	-$3,520	$39,596	$86,956	$138,846	$195,576	$257,479	$324,909	$398,252	$477,919	$564,353
58	Return on Investment	-2.90%	32.66%	71.72%	114.51%	161.30%	212.35%	267.97%	328.46%	394.16%	465.45%
59
60	Notes/Miscellaneous
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77	All financial information, while not guaranteed, is from sources we believe to be reliable. Performance & Projections are estimated and subject to change. The provider shall be held harmless if returns are not met. All Investments have risks and Investors are urged to perform their own due diligence prior to investing.
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100