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,197	13,197	13,197	13,197	13,197	13,197	13,197	13,197	13,197	13,197	13,197	13,197	13,197	13,197	13,197
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,874	15,954	16,037	16,122	16,210	16,300	16,393	16,489	16,588	16,690	16,794	16,902	17,014	17,128	17,246
Annual Cash Flows	4,466	5,057	5,668	6,299	6,951	7,625	8,321	9,041	9,785	10,553	11,347	12,168	13,016	13,893	14,799

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,303	2,441	2,972	2,786	4,087	4,673	5,279	5,041	6,552	7,220	7,911	7,614	9,363	10,125	10,913
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	46,495
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,823	5,064	5,595	5,409	6,711	7,297	7,902	7,664	9,175	9,843	10,534	10,237	11,986	12,749	384,835
Total Return On Investment (IRR)	21.04%

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.