ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Call Steve Lipkin (802) 846-9575
3
ACTIVE690-720 West Milton Rd.
Milton
938-950 Shelburne Rd
South Burlington
64-66 Swift St
South Burlington
102 Juniper Ridge56 North Williston Road
Williston
25-27 Upper Main St
Essex
AVG%16-18 Lincoln St
Essex Junction
TEMPLATE
4
MLS #5068967507110550371665074773505905950686235033938
5
DOM12397323191126172347
6
LIST DATE11/07/2512/03/2504/21/251/23/202608/31/2511/04/2503/28/25
9
LIST PRICE$2,500,000$2,200,000$630,000$600,000$550,000$514,900$1,165,817 $2,650,000
10
SALE PRICE$2,500,000$2,200,000$630,000$600,000$550,000$514,900$1,165,817 $2,650,000
11
LIST TO SALE RATIO100%$1 #DIV/0!
12
LOT SIZE10.000.410.220.470.211.00 2.05 0.48
13
ZONINGResHigh Scale MixedResResVillage ResResVillage CenterRes
14
YEAR BUILT1970196619401965190019701952 1900
15
FINISHED SF ABOVE GRADE7,6808,1361,99615402,2932,20039747,824
17
PRICE PER SQUARE FOOT$326 $270 $316 $390$240 $234 $296$339 #DIV/0!
18
UNIT COUNT1082222 4 42
19
PRICE PER UNIT$250,000$275,000$315,000$300,000$275,000$257,450$278,742$662,500$0
20
BEDROOM COUNT20104465 8 66
21
PRICE PER BEDROOM$125,000 $220,000 $157,500 $150,000$91,667 $102,980 $141,191$441,667 $0
22
Unit 1$1600 (2 BR)$2,200 (2 BR)$2,000 (2 BR)$2,500 (2 BR-est. vacant)$2400 (3 BR - est)$1,700 (3 BR)$2,650 (4 BR)
23
Unit 2 $1500 (2 BR)$1,200 (2 BR)$1,850 (2 BR)$2,500 (2 BR-est. vacant)$2,400 (3 BR-est. vacant)$2,000 (2 BR)$1,500 (est. Commercial)
24
Unit 3$1100 (2 BR)$1,650 (2 BR)$2,250 (2 BR)
25
Unit 4$1100 (2 BR)$900 (1 BR)$1,500 (est. Commercial)
26
Unit 5$600 (2 BR)$1,000 (2 BR)
27
Unit 6$1100 (2 BR)$900 (1 BR)
28
Unit 7$1300 (2 BR)$3,500 (Commercial)
29
Unit 8$1100 (2 BR)$2,500 (Commercial)
30
Unit 9$1100 (2 BR)
31
Unit 10$1100 (2 BR)
32
Unit 11
33
Unit 12
34
AVERAGE RENT PER UNIT$1,160 $1,731 $1,925 $2,500$2,400 $1,850 $1,928$1,975 $0
35
AVERAGE RENT PER BEDROOM$580 $1,385 $963 $1,250$800 $740 $953$1,317 $0
36
GROSS MONTHLY INCOME$11,600$13,850$3,850$5,000$4,800$3,700$7,133$7,900$0
37
ANNUAL INCOME$139,200$166,200$46,200$60,000$57,600$44,400$85,600$94,800$0
38
ANNUAL EXPENSES
39
Property Taxes$21,714$25,648$7,707$8,161$6,322$8,754$13,05156%$14,968
40
Insurance$7,190$5,108$3,000 (estimated)$2,000 (estimated)$2,000 (estimated)$1,478 (estimated)$3,46315%$3,000 (estimated)$2,000 (estimated)
41
Trash Expense$2600 (estimated)$2,627$1,000 (estimated)$1000 (estimated)$1200 (estimated)$1,000 (estimated)$1,5717%$1,000 (estimated)$1200 (estimated)
42
Heat$647tenantstenantstenantstenants$1,795$1,2215%$2,000 (estimated)tenants
43
Hot Water Tank Rentalunknown$1,782unknownunknownunknownunknown$1,7828%unknownunknown
44
Electric$647tenantstenantstenantstenantstenants$6473%$1,000 (estimated)tenants
45
Snow/Landscaping$2500 (estimated)$2,640$500 (estimated)$500 (estimated)$500 (estimated)$1,275 (estimated)$1,3196%$500 (estimated)$500 (estimated)
46
Water/Sewer$636$2,132$1,200 (estimated)$1,200 (estimated)$1,400 (estimated)tenants?$1,3146%$1,200 (estimated)$1,400 (estimated)
47
Maintenance$5000 (estimated)$2,900$1,500 (estimated)$1000 (estimated)$1000 (estimated)$750 (estimated)$2,0259%$1,500 (estimated)$1000 (estimated)
53
TOTAL ANNUAL EXPENSES$40,934$42,837$14,907$13,861$12,422$15,052$23,336$25,168$6,100
54
NET OPERATING INCOME$98,266$123,363$31,293$46,139$45,178$29,348$62,265$69,632-$6,100
55
EXPENSE RATIO29.41%25.77%32.27%23.10%21.57%33.90%28%26.55%
56
CAP RATE 3.93%5.61%4.97%7.69%8.21%5.70%6.02%2.63%
57
*Estimated
58
The above information is deemed reliable but is not guarnteed - some figures may be estimated
59
Potential Return on Investment
60
Down Payment %25%25%25%25%25%25%25%25%25%
61
Sale Price (or Offer Price)$2,500,000$2,200,000$630,000$600,000$550,000$514,900$1,165,817$2,650,000
62
Down Payment$625,000$550,000$157,500$150,000$137,500$128,725$291,454$662,500$0
63
Financed Amount$1,875,000$1,650,000$472,500$450,000$412,500$386,175$874,363$1,987,500$0
64
Payments per Term Loan300300360360360360$340360360
65
Interest Rate of Loan6.00%6.00%6.00%6.00%6.00%6.00%6.00%6.00%6.50%6.00%
66
Number of Payments per year121212121212121212
67
Monthly Mortgage Payment$12,081$10,631$2,833$2,698$2,473$2,315$5,505$12,562$0
68
Annual Mortgage Payment$144,968$127,572$33,995$32,376$29,678$27,784$66,062$150,748$0
69
Cash Flow (Pre-Tax)-$46,702-$4,209-$2,702$13,763$15,500$1,564-$3,797-$81,116-$6,100
70
Cash on Cash Return-7.47%-0.77%-1.72%9.18%11.27%1.22%$0-12.24%
71
Capitalization Rate3.93%5.61%4.97%7.69%8.21%5.70%6.02%2.63%
72
Above Pro-Forma does not consider additional tax benefits of ownership including interest deduction and depreciation. Please check with your tax professional.
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108