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,357	12,357	12,357	12,357	12,357	12,357	12,357	12,357	12,357	12,357	12,357	12,357	12,357	12,357	12,357
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,034	15,114	15,197	15,282	15,370	15,460	15,553	15,649	15,748	15,850	15,954	16,062	16,173	16,288	16,406
Annual Cash Flows	5,306	5,897	6,508	7,139	7,791	8,465	9,161	9,881	10,625	11,393	12,188	13,008	13,856	14,733	15,639

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	5,144	3,281	3,812	3,626	4,928	5,514	6,119	5,881	7,392	8,060	8,751	8,454	10,203	10,966	11,754
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	49,724
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	-55,983	5,904	6,435	6,249	7,551	8,137	8,742	8,504	10,015	10,683	11,374	11,077	12,826	13,589	388,905
Total Return On Investment (IRR)	22.14%

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.