ABCDEFGHIJKLMNOPQR
1
5 Year Pro Forma and Budget
2
Year 0Year 1Year 2Year 3Year 4Year 5
3
Operating Assumptions
4
Rent Growth0.0%0.0%3.0%3.0%3.0%
5
Vacancy10.0%8.0%6.0%6.0%6.0%
6
Concessions 0.0%0.0%0.0%0.0%0.0%
7
Loss to Lease0.0%0.0%0.0%0.0%0.0%
8
9
Revenues
10
Gross Scheduled Rents(GSR)@100%
$277,775 $312,000 $312,000 $321,360 $331,001 $340,931
11
Physical Vacancy$31,200 $24,960 $19,282 $19,860 $20,456
12
Concessions$0 $0 $0 $0 $0
13
Loss to Lease$0$0$0$0$0
14
Rental Income$280,800 $287,040 $302,078 $311,141 $320,475 $281.93$288.19$303.29$312.39$321.76
15
Utility Reimbursement$0$0$0$0Increase Per Yr3.00%1300
16
Other Income$5,340 $5,500 $5,665 $5,835 $6,010 Increase Per Yr3.00%
17
Total Income$286,140 $292,540 $307,744 $316,976 $326,485
18
19
Expenses
20
Taxes$58,555 $66,902 $68,909 $70,976 $73,106 $75,299 Increase Per Yr3.00%
21
Insurance$15,715 $15,715 $16,972 $18,330 $19,796 $21,380 Increase Per Yr8.00%
22
Repairs and Maintenance$4,149 $14,236 $14,663 $15,103 $15,556 $16,023 Increase Per Yr3.00%
23
General/ Admin$5,695 $5,866 $6,042 $6,223 $6,410 Increase Per Yr3.00%
24
Management %$15,592 $8,776 $9,232 $9,509 $9,795 3.00%
25
Asset Management$5,800 $5,851 $6,155 $6,340 $6,530 2.00%
26
Lawncare/Snow & Cleaning$4,490 $1,795 $1,849 $1,904 $1,961 $2,020 Increase Per Yr3.00%
27
Electric$2,367 $2,367 $2,438 $2,511 $2,586 $2,664 Increase Per Yr3.00%
28
Gas$9,438 $9,438 $9,721 $10,013 $10,313 $10,623 Increase Per Yr3.00%
29
Water$4,380 $7,182 $7,397 $7,619 $7,847 $8,083 Increase Per Yr3.00%
30
Trash$3,524 $3,523 $3,629 $3,738 $3,850 $3,965 Increase Per Yr3.00%
31
Pest$594 $0 $0 $0 $0 Increase Per Yr3.00%
32
Supplies$2,530 $0 $0 $0 $0 Increase Per Yr3.00%
33
Sewer$9,984 $7,182 $7,397 $7,619 $7,847 $8,083 Increase Per Yr3.00%
34
Wifi$601 $0 $0 $0 $0 Increase Per Yr3.00%
35
Total Expenses$116,329 $155,426 $153,468 $159,242 $164,936 $170,873
36
Expenses as ratio of Total Income54%52%52%52%52%
37
Net Operating Income (NOI)$166,786 $130,714 $139,072 $148,502 $152,040 $155,612 $2,223,025.30
38
$1,556,117.71($501,988)-41832.35241
39
Debt Service Mortgage657600
40
Debt Service $71,685 $71,685 $71,685 $86,479 $86,479 $86,479 $1,166,907.59-43.02%
41
42
Net Cash Flow $95,101 $59,029 $67,387 $62,023 $65,561 $69,132
43
44
Cap Rate10.30%8.07%8.58%9.17%9.39%9.61%
45
Capital Reserves $43,240 $43,240 $43,240 $43,240 $43,240 $43,240
46
Cash on Cash Return %10.75%6.67%7.62%7.01%7.41%7.82%
47
Value if Reversion Cap is7.00%$2,382,660 $1,867,343 $1,986,749 $2,121,455 $2,172,005 $2,223,025 $26,464.59$26,464.59
48
Loan Balance$1,183,677 $1,183,677 $1,166,577 $1,148,440 $1,129,204 $1,108,802 $2,223,025.30
49
Cost of Sale2%$35,740 $28,010 $29,801 $31,822 $32,580 $33,345
50
Net Proceeds$1,163,244 $655,656 $790,371 $941,192 $1,010,221 $1,080,878
51
52
Total Deal Summary
53
Year 0Year 1Year 2Year 3Year 4Year 5
54
Cash Flow-$884,593$59,029 $67,387 $62,023 $65,561 $69,132
55
Net Sales Proceeds$1,124,117
56
Total-$884,593$59,029 $67,387 $62,023 $65,561 $1,193,250
57
IRR11.56%
58
Equity Multiple1.64
59
60
This preliminary information package offers only limited descriptive material regarding an investment in the Property known as:
61
This summary does not purport to be complete and will be supplemented with additional information at such time as it is requested by an interested investor. The use of this material is authorized only for those to whom it is originally provided. This is not an offer security. An offer can only be made through the complete Private Placement Memorandum.
62
63
64
65
66
67
68
69
70
71
72
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