St Marks.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			$359,900
6							Down Payment		25%	$89,975
7							LTV (1st Loan)		75%	$269,925
8							Mortgage Rate - Payment		4.50%	$1,368
9							Amortization Term (years)		30	305,915.00
10							Property Taxes			$213
11							Insurance			$50
12							HOA Fees
13							Property Management			$120
14							Other Expenses
15							Total Monthly Expenses			$1,751
16										Low	High
17							Rent Range			1,950	2,000
18							Net Cash Flow (pre - tax)			$199	$249
19
20							Annualized
21	Property Address						Cash Return on Investment			$2,994	3.3%
22	St Marks						Principal Reduction			$4,265	4.7%
23	Map Link:						Tax Reduction - Based on 25% Tax Bracket			$2,450	2.7%
24	Property Information						Appreciation (Rate used is 7.00%)			$25,193	28.0%
25	Type Dwelling:	Single Family					Total ROI			$34,902	38.8%
26	Square Footage:	1,738
27	Year Built:	2022					Financial Indicators
28	Sales Details						Debt Coverage Ratio:			1.18x
29							Going-In Cap Rate:			5.39%
30							Appreciation (annual)			7.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	$24,000	$24,720	$25,462	$26,225	$27,012	$27,823	$28,657	$29,517	$30,402	$31,315
39	(-) Mortgage Payments	16,412	16,412	16,412	16,412	16,412	16,412	16,412	16,412	16,412	16,412
40	(-) Vacancy/Maintenance	0	0	0	0	0	0	0	0	0	0
41	(-) Other Expenses	4,594	4,594	4,594	4,594	4,594	4,594	4,594	4,594	4,594	4,594
42	Cash Flow (after DS)	2,994	3,714	4,455	5,219	6,006	6,816	7,651	8,511	9,396	10,308
43
44	Annual Cash Flow	$2,994	$3,714	$4,455	$5,219	$6,006	$6,816	$7,651	$8,511	$9,396	$10,308
45	(+) Principal Reduction	4,265	4,457	4,658	4,868	5,087	5,315	5,555	5,805	6,066	6,339
46	Loan Balance	265,660	261,202	256,544	251,677	246,590	241,275	235,720	229,915	223,849	217,511
47	Market Value	359,900	385,093	412,050	440,893	471,755	504,778	540,113	577,921	618,375	661,661
48	(+) Appreciation	25,193	26,957	28,843	30,863	33,023	35,334	37,808	40,454	43,286	46,316
49	Cash on Cash Return	3.33%	4.13%	4.95%	5.80%	6.67%	7.58%	8.50%	9.46%	10.44%	11.46%
50	Implied Exit Cap	5.39%	5.23%	5.06%	4.91%	4.75%	4.60%	4.46%	4.31%	4.17%	4.04%
51
52	Rolling Equity	$94,240	$123,891	$155,505	$189,216	$225,165	$263,504	$304,393	$348,005	$394,526	$444,151
53	(-) Closing Costs	5,399	5,776	6,181	6,613	7,076	7,572	8,102	8,669	9,276	9,925
54	Proceeds After Sale	88,842	118,114	149,324	182,603	218,089	255,932	296,291	339,337	385,250	434,226
55	(+) Cum. Cash Flow	2,994	6,707	11,162	16,381	22,387	29,203	36,854	45,365	54,761	65,069
56	(-) Initial Cash Invested	89,975	89,975	89,975	89,975	89,975	89,975	89,975	89,975	89,975	89,975
57	Net Profit	$1,860	$34,847	$70,512	$109,009	$150,501	$195,160	$243,170	$294,726	$350,036	$409,320
58	Return on Investment	2.07%	38.73%	78.37%	121.15%	167.27%	216.91%	270.26%	327.56%	389.04%	454.93%
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