133 wickersham.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			$434,900
6							Down Payment		25%	$108,725
7							LTV (1st Loan)		75%	$326,175
8							Mortgage Rate - Payment		4.50%	$1,653
9							Amortization Term (years)		30
10							Property Taxes			$494
11							Insurance			$50
12							HOA Fees			$0
13							Property Management			$141
14							Other Expenses
15							Total Monthly Expenses			$2,337
16										Low	High
17							Rent Range			2,300	2,350
18							Net Cash Flow (pre - tax)			($37)	$13
19
20							Annualized
21	Property Address						Cash Return on Investment			$150	0.1%
22	Wickersham						Principal Reduction			$5,154	4.7%
23	Map Link:						Tax Reduction - Based on 25% Tax Bracket			$2,960	2.7%
24	Property Information						Appreciation (Rate used is 8.00%)			$34,792	32.0%
25	Type Dwelling:	Single Family					Total ROI			$43,057	39.6%
26	Square Footage:	2,174
27	Year Built:	2021					Financial Indicators
28	Sales Details						Debt Coverage Ratio:			1.01x
29							Going-In Cap Rate:			4.59%
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	$28,200	$29,046	$29,917	$30,815	$31,739	$32,692	$33,672	$34,682	$35,723	$36,795
39	(-) Mortgage Payments	19,832	19,832	19,832	19,832	19,832	19,832	19,832	19,832	19,832	19,832
40	(-) Vacancy/Maintenance	0	0	0	0	0	0	0	0	0	0
41	(-) Other Expenses	8,218	8,218	8,218	8,218	8,218	8,218	8,218	8,218	8,218	8,218
42	Cash Flow (after DS)	150	996	1,868	2,765	3,690	4,642	5,623	6,633	7,673	8,745
43
44	Annual Cash Flow	$150	$996	$1,868	$2,765	$3,690	$4,642	$5,623	$6,633	$7,673	$8,745
45	(+) Principal Reduction	5,154	5,386	5,629	5,882	6,147	6,423	6,712	7,014	7,330	7,660
46	Loan Balance	321,021	315,634	310,006	304,124	297,977	291,554	284,842	277,828	270,498	262,838
47	Market Value	434,900	469,692	507,267	547,849	591,677	639,011	690,132	745,342	804,970	869,367
48	(+) Appreciation	34,792	37,575	40,581	43,828	47,334	51,121	55,211	59,627	64,398	69,549
49	Cash on Cash Return	0.14%	0.92%	1.72%	2.54%	3.39%	4.27%	5.17%	6.10%	7.06%	8.04%
50	Implied Exit Cap	4.59%	4.43%	4.28%	4.12%	3.98%	3.83%	3.69%	3.55%	3.42%	3.29%
51
52	Rolling Equity	$113,879	$154,058	$197,262	$243,725	$293,699	$347,457	$405,290	$467,515	$534,472	$606,529
53	(-) Closing Costs	6,524	7,045	7,609	8,218	8,875	9,585	10,352	11,180	12,075	13,041
54	Proceeds After Sale	107,356	147,012	189,653	235,507	284,824	337,871	394,938	456,334	522,397	593,489
55	(+) Cum. Cash Flow	150	1,147	3,014	5,780	9,469	14,111	19,734	26,366	34,040	42,785
56	(-) Initial Cash Invested	108,725	108,725	108,725	108,725	108,725	108,725	108,725	108,725	108,725	108,725
57	Net Profit	-$1,219	$39,434	$83,942	$132,562	$185,568	$243,258	$305,946	$373,976	$447,712	$527,548
58	Return on Investment	-1.12%	36.27%	77.21%	121.92%	170.68%	223.74%	281.39%	343.96%	411.78%	485.21%
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