152 Bevis LN.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			$339,900
6							Down Payment		25%	$84,975
7							LTV (1st Loan)		75%	$254,925
8							Mortgage Rate - Payment		4.50%	$1,292
9							Amortization Term (years)		30
10							Property Taxes			$152
11							Insurance			$50
12							HOA Fees			$13
13							Property Management			$111
14							Other Expenses
15							Total Monthly Expenses			$1,617
16										Low	High
17							Rent Range			1,795	1,845
18							Net Cash Flow (pre - tax)			$178	$228
19
20							Annualized
21	Property Address						Cash Return on Investment			$2,735	3.2%
22	152 Bevis Ln						Principal Reduction			$4,028	4.7%
23	Map Link:						Tax Reduction - Based on 25% Tax Bracket			$2,313	2.7%
24	Property Information						Appreciation (Rate used is 7.00%)			$23,793	28.0%
25	Type Dwelling:	Single Family					Total ROI			$32,869	38.7%
26	Square Footage:	1,738
27	Year Built:	2021					Financial Indicators
28	Sales Details						Debt Coverage Ratio:			1.18x
29							Going-In Cap Rate:			5.36%
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	$22,140	$22,804	$23,488	$24,193	$24,919	$25,666	$26,436	$27,229	$28,046	$28,888
39	(-) Mortgage Payments	15,500	15,500	15,500	15,500	15,500	15,500	15,500	15,500	15,500	15,500
40	(-) Vacancy/Maintenance	0	0	0	0	0	0	0	0	0	0
41	(-) Other Expenses	3,905	3,905	3,905	3,905	3,905	3,905	3,905	3,905	3,905	3,905
42	Cash Flow (after DS)	2,735	3,399	4,083	4,788	5,513	6,261	7,031	7,824	8,641	9,482
43
44	Annual Cash Flow	$2,735	$3,399	$4,083	$4,788	$5,513	$6,261	$7,031	$7,824	$8,641	$9,482
45	(+) Principal Reduction	4,028	4,210	4,399	4,597	4,804	5,020	5,246	5,482	5,729	5,987
46	Loan Balance	250,897	246,687	242,288	237,691	232,887	227,867	222,621	217,139	211,410	205,423
47	Market Value	339,900	363,693	389,152	416,392	445,540	476,727	510,098	545,805	584,011	624,892
48	(+) Appreciation	23,793	25,459	27,241	29,147	31,188	33,371	35,707	38,206	40,881	43,742
49	Cash on Cash Return	3.22%	4.00%	4.80%	5.63%	6.49%	7.37%	8.27%	9.21%	10.17%	11.16%
50	Implied Exit Cap	5.36%	5.20%	5.03%	4.87%	4.72%	4.56%	4.42%	4.27%	4.13%	4.00%
51
52	Rolling Equity	$89,003	$117,006	$146,864	$178,701	$212,653	$248,861	$287,477	$328,666	$372,602	$419,469
53	(-) Closing Costs	5,099	5,455	5,837	6,246	6,683	7,151	7,651	8,187	8,760	9,373
54	Proceeds After Sale	83,905	111,551	141,026	172,455	205,970	241,710	279,826	320,479	363,841	410,096
55	(+) Cum. Cash Flow	2,735	6,133	10,216	15,004	20,517	26,778	33,809	41,633	50,274	59,757
56	(-) Initial Cash Invested	84,975	84,975	84,975	84,975	84,975	84,975	84,975	84,975	84,975	84,975
57	Net Profit	$1,665	$32,709	$66,268	$102,484	$141,512	$183,513	$228,660	$277,138	$329,141	$384,877
58	Return on Investment	1.96%	38.49%	77.99%	120.61%	166.53%	215.96%	269.09%	326.14%	387.34%	452.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