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 Lease3.1%3.1%3.1%3.1%0.0%
8
9
Revenues
10
Gross Scheduled Rents(GSR)@100%
$259,212 $392,712 $392,712 $404,493 $416,628 $429,127
11
Physical Vacancy$39,271 $31,417 $24,270 $24,998 $25,748
12
Concessions$0 $0 $0 $0 $0
13
Loss to Lease$12,104$12,104$12,467$12,841$0
14
Rental Income$341,337 $349,191 $367,756 $378,789 $403,379 $342.71$350.59$369.23$380.31$405.00
15
Utility Reimbursement$0$0$0$0$0Increase Per Yr3.00%1300
16
Other Income$0 $0 $0 $0 $0 Increase Per Yr3.00%
17
Total Income$341,337 $349,191 $367,756 $378,789 $403,379
18
19
Expenses
20
Taxes$0 $68,605 $70,663 $72,783 $74,967 $77,216 Increase Per Yr3.00%
21
Insurance$0 $17,600 $19,008 $20,529 $22,171 $23,945 Increase Per Yr8.00%
22
Repairs and Maintenance$0 $28,275 $29,124 $29,997 $30,897 $31,824 Increase Per Yr3.00%
23
General/ Admin$0 $0 $0 $0 $0 $0 Increase Per Yr3.00%
24
Management %$0 $21,206 $10,476 $11,033 $11,364 $12,101 3.00%
25
Asset Management$0 $0 $6,984 $7,355 $7,576 $8,068 2.00%
26
Marketing$0 $0 $0 $0 $0 $0 Increase Per Yr3.00%
27
Electric$0 $0 $0 $0 $0 $0 Increase Per Yr3.00%
28
Gas$0 $0 $0 $0 $0 Increase Per Yr3.00%
29
Water$0 $28,275 $29,124 $29,997 $30,897 $31,824 Increase Per Yr3.00%
30
Trash$0 $0 $0 $0 $0 Increase Per Yr3.00%
31
Pest$0 $0 $0 $0 $0 Increase Per Yr3.00%
32
Supplies$0 $0 $0 $0 $0 Increase Per Yr3.00%
33
Contract Services$0 $0 $0 $0 $0 $0 Increase Per Yr3.00%
34
Payroll$0 $0 $0 $0 $0 $0 Increase Per Yr3.00%
35
Total Expenses$90,724 $163,962 $165,378 $171,694 $177,872 $184,978
36
Expenses as ratio of Total Income48%47%47%47%46%
37
Net Operating Income (NOI)$168,488 $177,374 $183,813 $196,062 $200,918 $218,402 $3,120,026.37
38
$2,184,018.46($439,198)-36599.84618
39
Debt Service Mortgage657600
40
Debt Service $132,750 $132,750 $132,750 $160,147 $160,147 $160,147 $1,436,007.91-30.58%
41
42
Net Cash Flow $35,738 $44,624 $51,063 $35,915 $40,771 $58,255
43
44
Cap Rate5.62%5.91%6.13%6.54%6.70%7.28%
45
Capital Reserves $80,073 $80,073 $80,073 $80,073 $80,073 $80,073
46
Cash on Cash Return %3.09%3.85%4.41%3.10%3.52%5.03%
47
Value if Reversion Cap is7.00%$2,406,969 $2,533,920 $2,625,898 $2,800,889 $2,870,252 $3,120,026 $37,143.17$37,143.17
48
Loan Balance$2,191,993 $2,191,993 $2,160,327 $2,126,741 $2,091,119 $2,053,337 $3,120,026.37
49
Cost of Sale2%$36,105 $38,009 $39,388 $42,013 $43,054 $46,800
50
Net Proceeds$178,871 $303,918 $426,183 $632,135 $736,080 $1,019,889
51
52
Total Deal Summary
53
Year 0Year 1Year 2Year 3Year 4Year 5
54
Cash Flow-$1,158,073$44,624 $51,063 $35,915 $40,771 $58,255
55
Net Sales Proceeds$1,099,963
56
Total-$1,158,073$44,624 $51,063 $35,915 $40,771 $1,158,218
57
IRR3.03%
58
Equity Multiple1.15
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