ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
PROFORMA DATA
2
3
4
5
6
Building Data
Investment Data
7
Square Feet 10,140 Purchase Price $ 16,550,000
8
Rent Per Square Foot
 $ 15,600.00
Terminal Cap Rate
7.70%
9
Other Income $ 10,000
Cost of Sale EOY 5
6.00%
10
Vacancy Year 19.00%
11
12
First Year Operating Statement
Financing Data
13
Potential Rental Income $ 158,184,000
Loan Interest Rate
6.00%
14
Vacancy & Credit Loss9.00%
Loan Amortization (years)
240
15
Effective Rental Income $ 143,947,440 LTV80%
16
Other Income $ - DSCR1.25
17
Gross Operating Income $ 143,947,440
Loan Amount (LTV)
 $ 13,240,000
18
Property Taxes $ 146,500
Loan Amount (DSCR)
 $ 1,660,757,174
19
Insurance $ 15,000
Maximum Loan Amount
 $ 13,240,000
20
Maintenance $ 90,000 Initial Equity $ 3,310,000
21
Management Fee $ 18,982,080
Monthly Debt Service
$66,200
22
Reserves for Replacement $ 35,000
Annual Debt Service
$794,400
23
Other expenses $ 122,000
24
Total Expenses $ 19,390,580
25
Net Operating Income $ 124,556,860
26
Debt Service $ 794,400
27
Cash Flow Before Tax $ 123,762,460
28
29
30
Inflation / Variable Rates
31
Year 1Year 2Year 3Year 4Year 5Year 6
32
Potential Rental IncomeN/A1.00%1.00%1.00%1.00%1.00%
33
Other IncomeN/A1.00%1.00%1.00%1.00%1.00%
34
Vacancy9.00%8.00%7.00%6.00%5.00%5.00%
35
Operating ExpensesN/A1.00%1.00%1.00%1.00%1.00%
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
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