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	12,858	12,858	12,858	12,858	12,858	12,858	12,858	12,858	12,858	12,858	12,858	12,858	12,858	12,858	12,858
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,535	15,615	15,698	15,783	15,871	15,961	16,054	16,150	16,249	16,351	16,456	16,564	16,675	16,789	16,907
Annual Cash Flows	4,805	5,396	6,007	6,638	7,290	7,964	8,660	9,380	10,124	10,892	11,686	12,507	13,355	14,232	15,137

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,642	2,780	3,311	3,125	4,426	5,012	5,618	5,380	6,891	7,559	8,250	7,953	9,702	10,464	11,252
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,770
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,485	5,403	5,934	5,748	7,049	7,635	8,241	8,003	9,514	10,182	10,873	10,576	12,325	13,087	386,450
Total Return On Investment (IRR)	21.48%

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.