Property Analysis | 104 Spruce St

Property Analysis For: 104 Spruce St

Year	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15

Revenue
Rental Income	20,340	21,011	21,705	22,421	23,161	23,925	24,715	25,530	26,373	27,243	28,142	29,071	30,030	31,021	32,045

Expenses (Recurring)
Mortgage Payment	13,368	13,368	13,368	13,368	13,368	13,368	13,368	13,368	13,368	13,368	13,368	13,368	13,368	13,368	13,368
Estimated Annual Property Taxes	2,005	2,065	2,127	2,191	2,257	2,324	2,394	2,466	2,540	2,616	2,695	2,775	2,859	2,944	3,033
Estimated Annual Homeowners Insurance	672	692	713	734	756	779	802	826	851	877	903	930	958	987	1,016
Annual Property Mgmt Fee	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Total Expenses (Recurring)	16,045	16,125	16,208	16,293	16,381	16,471	16,564	16,660	16,759	16,860	16,965	17,073	17,184	17,299	17,417
Annual Cash Flows	4,295	4,886	5,497	6,128	6,780	7,454	8,150	8,870	9,614	10,382	11,177	11,997	12,846	13,722	14,628

Expenses (Periodic)
Vacancy Costs	163	840	868	897	926	957	989	1,021	1,055	1,090	1,126	1,163	1,201	1,241	1,282
Maintenance & Repairs	0	1,576	1,628	1,682	1,737	1,794	1,854	1,915	1,978	2,043	2,111	2,180	2,252	2,327	2,403
Tenant Placement Credit	-848	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Tenant Placement/Lease Renewal Fees	848	200	200	934	200	200	200	1,064	200	200	200	1,211	200	200	200
Total Expenses (Periodic)	163	2,616	2,696	3,513	2,863	2,951	3,042	4,000	3,233	3,333	3,436	4,554	3,653	3,767	3,885

Total Return On Investment
Acquisition Down Payment	-57,250	0	0	0	0	0	0	0	0	0	0	0	0	0	57,250
Acquisition Closing Costs	-6,500	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Net Rental Income	4,133	2,270	2,801	2,615	3,917	4,503	5,108	4,870	6,381	7,050	7,740	7,443	9,192	9,955	10,743
Tax Savings	2,623	2,623	2,623	2,623	2,623	2,623	2,623	2,623	2,623	2,623	2,623	2,623	2,623	2,623	-24,482
Principal Paydown	0	0	0	0	0	0	0	0	0	0	0	0	0	0	45,865
Estimated Home Price Appreciation	0	0	0	0	0	0	0	0	0	0	0	0	0	0	347,631
Total Selling, Holding & Closing Costs	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-52,971
Total Capital In/Out	-56,994	4,893	5,424	5,238	6,540	7,126	7,731	7,494	9,004	9,673	10,363	10,066	11,815	12,578	384,035
Total Return On Investment (IRR)	20.83%

Returns are estimated and not guaranteed. Actual investment performance, including IRR, varies and cannot be precisely predicted. Assumptions should be independently assessed. There may be other additional costs.