5003 Oak Estate.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			$399,900
6							Down Payment		25%	$399,900
7							LTV (1st Loan)		75%	$299,925
8							Mortgage Rate - Payment		5.63%	$1,727
9							Amortization Term (years)		30	299,925.00
10							Property Taxes			$217
11							Insurance			$50
12							HOA Fees
13							Property Management			$0
14							Other Expenses
15							Total Monthly Expenses			$1,994
16										Low	High
17							Rent Range			2,395	2,445
18							Net Cash Flow (pre - tax)			$401	$451
19
20							Annualized
21	Property Address						Cash Return on Investment			$5,412	1.4%
22	5003 Oak Estates						Principal Reduction			$3,848	1.0%
23	Map Link:						Tax Reduction - Based on 25% Tax Bracket			$2,722	0.7%
24	Property Information						Appreciation (Rate used is 8.00%)			$31,992	8.0%
25	Type Dwelling:	Single Family					Total ROI			$43,974	11.0%
26	Square Footage:	2,232
27	Year Built:	2022					Financial Indicators
28	Sales Details						Debt Coverage Ratio:			1.26x
29	Hardie and Brick, very nice neighborhood						Going-In Cap Rate:			6.53%
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,340	$30,220	$31,127	$32,061	$33,022	$34,013	$35,033	$36,084	$37,167	$38,282
39	(-) Mortgage Payments	20,718	20,718	20,718	20,718	20,718	20,718	20,718	20,718	20,718	20,718
40	(-) Vacancy/Maintenance	0	0	0	0	0	0	0	0	0	0
41	(-) Other Expenses	3,209	3,209	3,209	3,209	3,209	3,209	3,209	3,209	3,209	3,209
42	Cash Flow (after DS)	5,412	6,292	7,199	8,133	9,095	10,085	11,106	12,157	13,239	14,354
43
44	Annual Cash Flow	$5,412	$6,292	$7,199	$8,133	$9,095	$10,085	$11,106	$12,157	$13,239	$14,354
45	(+) Principal Reduction	3,848	4,064	4,293	4,534	4,789	5,059	5,343	5,644	5,961	6,296
46	Loan Balance	296,077	292,013	287,721	283,186	278,397	273,339	267,995	262,352	256,390	250,094
47	Market Value	399,900	431,892	466,443	503,759	544,060	587,584	634,591	685,358	740,187	799,402
48	(+) Appreciation	31,992	34,551	37,315	40,301	43,525	47,007	50,767	54,829	59,215	63,952
49	Cash on Cash Return	1.35%	1.57%	1.80%	2.03%	2.27%	2.52%	2.78%	3.04%	3.31%	3.59%
50	Implied Exit Cap	6.53%	6.25%	5.99%	5.73%	5.48%	5.24%	5.01%	4.80%	4.59%	4.39%
51
52	Rolling Equity	$103,823	$139,879	$178,723	$220,572	$265,662	$314,246	$366,596	$423,007	$483,796	$549,308
53	(-) Closing Costs	5,999	6,478	6,997	7,556	8,161	8,814	9,519	10,280	11,103	11,991
54	Proceeds After Sale	97,824	133,400	171,726	213,016	257,502	305,432	357,077	412,726	472,694	537,317
55	(+) Cum. Cash Flow	5,412	11,705	18,904	27,036	36,131	46,216	57,322	69,479	82,718	97,072
56	(-) Initial Cash Invested	399,900	399,900	399,900	399,900	399,900	399,900	399,900	399,900	399,900	399,900
57	Net Profit	-$296,664	-$254,795	-$209,270	-$159,847	-$106,267	-$48,252	$14,499	$82,305	$155,512	$234,489
58	Return on Investment	-74.18%	-63.71%	-52.33%	-39.97%	-26.57%	-12.07%	3.63%	20.58%	38.89%	58.64%
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