(1548) Port Charlotte 335K.xlsx

	A	C	D	E	F	G	H	I	J	K	L	M	O
1	34												SPREAD OVER 10 YEARS
2
3
4								Financial Information
5								Purchase Price			$335,000
6								Down Payment		25%	$83,750
7								LTV (1st Loan)		75%	$251,250
8								Mortgage Rate - Payment		#REF!	#REF!
9								Amortization Term (years)		30
10								Property Taxes			$429
11								Insurance			$50
12								HOA Fees			$0
13								Property Management ( 5% montly fee)			$113
14								Other Expenses			$0
15								Total Monthly Expenses			#REF!
16											Low	High
17								Rent Range			2,200	2,250
18								Net Cash Flow (pre - tax)			#REF!	#REF!
19
20								Annualized
21		Property Address						Cash Return on Investment			#REF!	#REF!
22		1548 3 bed 2 bath 2 car garage in Port Charlotte						Principal Reduction			#REF!	#REF!
23		Map Link:						Tax Reduction - Based on 25% Tax Bracket			$2,280	2.7%
24		Property Information						Appreciation (Rate used is 7.00%)			$23,450	28.0%
25		Type Dwelling:	Single Family					Total ROI			#REF!	#REF!
26		Square Footage:	1,548
27		Year Built:	2021-2022					Financial Indicators
28		Sales Details						Debt Coverage Ratio:			#REF!
29		Discounted Property Managment Rates (5%) through Lyons Property Management.https://www.lyonsrealestateinc.com/						Going-In Cap Rate:			5.94%
30								Appreciation (annual)			7.00%
31								Closing Cost			1.75%
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	$27,000	$27,810	$28,644	$29,504	$30,389	$31,300	$32,239	$33,207	$34,203	$35,229
39		(-) Mortgage Payments	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
40		(-) Vacancy/Maintenance	0	0	0	0	0	0	0	0	0	0
41		(-) Other Expenses	7,094	7,094	7,094	7,094	7,094	7,094	7,094	7,094	7,094	7,094
42		Cash Flow (after DS)	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
43
44		Annual Cash Flow	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
45		(+) Principal Reduction	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
46		Loan Balance	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
47		Market Value	335,000	358,450	383,542	410,389	439,117	469,855	502,745	537,937	575,592	615,884
48		(+) Appreciation	23,450	25,092	26,848	28,727	30,738	32,890	35,192	37,656	40,291	43,112
49		Cash on Cash Return	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
50		Implied Exit Cap	5.94%	5.78%	5.62%	5.46%	5.31%	5.15%	5.00%	4.85%	4.71%	4.57%
51
52		Rolling Equity	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
53		(-) Closing Costs	5,863	6,273	6,712	7,182	7,685	8,222	8,798	9,414	10,073	10,778
54		Proceeds After Sale	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
55		(+) Cum. Cash Flow	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
56		(-) Initial Cash Invested	83,750	83,750	83,750	83,750	83,750	83,750	83,750	83,750	83,750	83,750
57		Net Profit	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
58		Return on Investment	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
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