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,027	13,027	13,027	13,027	13,027	13,027	13,027	13,027	13,027	13,027	13,027	13,027	13,027	13,027	13,027
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)	15,704	15,784	15,867	15,952	16,040	16,130	16,223	16,319	16,418	16,520	16,625	16,733	16,844	16,958	17,076
Annual Cash Flows	4,636	5,227	5,838	6,469	7,121	7,795	8,491	9,211	9,955	10,723	11,517	12,338	13,186	14,063	14,969

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,473	2,611	3,142	2,956	4,257	4,843	5,449	5,211	6,722	7,390	8,081	7,784	9,533	10,295	11,083
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	47,130
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,654	5,234	5,765	5,579	6,880	7,466	8,072	7,834	9,345	10,013	10,704	10,407	12,156	12,918	385,640
Total Return On Investment (IRR)	21.26%

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.