Annual Property Operating Data
Retail - Office
The APOD is a very useful snapshot of the status of a property investment as of the projected Acquisition Date, showing most of the information relevant to the investment, absent any projections of performance.
|
Purpose |
For Sale |
|
Name |
Retail - Office |
|
Location |
USA |
|
Property Type |
Retail - Office |
|
Date |
18 April 2008 |
|
Square Feet |
20,000 |
|
Price |
$4,000,000 |
|
-Loans |
2,267,138 |
|
Down Payment |
1,732,862 |
|
+Acq Costs |
20,000 |
|
+Loan Points |
22,671 |
|
Investment |
1,775,534 |
|
|
$/SqFt |
% of GI |
Annual $ |
|
Gross Income |
|
|
|
|
201 Office (10,000 sf) |
12.00 |
32.5% |
120,000 |
|
102 Drug Store (7,500 sf) |
12.60 |
25.6% |
94,500 |
|
103 Beauty Salon (2,000 sf) |
14.50 |
7.9% |
29,000 |
|
104 Donuts (2,000 sf) |
14.50 |
7.9% |
29,000 |
|
105 Flowers (1,000 sf) |
14.50 |
3.9% |
14,500 |
|
Base Rental Revenue |
$14.35 |
77.7% |
$287,000 |
|
Percentage Rent |
$0.20 |
1.1% |
$4,000 |
|
Total Reimbursements |
$3.91 |
21.2% |
$78,233 |
|
Total Gross Income |
$18.46 |
100.0% |
$369,233 |
|
- Vacancy & Credit Loss |
0.00 |
0.0% |
0 |
|
Effective Income |
$18.46 |
100.0% |
$369,233 |
|
Less: Operating Expenses |
|
|
|
|
Maintenance |
0.57 |
3.1% |
11,400 |
|
Insurance |
0.23 |
1.2% |
4,600 |
|
Property Taxes |
2.00 |
10.8% |
40,000 |
|
Security |
0.15 |
0.8% |
3,000 |
|
Utilities |
0.17 |
0.9% |
3,400 |
|
Management Fee |
0.70 |
3.8% |
14,000 |
|
Total Operating Expenses |
$3.82 |
20.7% |
$76,400 |
|
Net Operating Income |
$14.64 |
79.3% |
$292,833 |
|
Less: Debt Service |
|
|
|
|
Loan |
11.38 |
61.6% |
227,559 |
|
Total Debt Service |
$11.38 |
61.6% |
$227,559 |
|
Net Operating Cash Flow |
$3.26 |
17.7% |
$65,274 |
|
Capitalization Rate |
7.32% |
|
Gross Income Multiplier |
10.83 |
|
Cash on Cash |
3.68% |
|
Debt Coverage Ratio |
1.287 |
|
Price/SqFt |
$200 |
|
|
|
|
Use of Effective Income at Acquisition (
Retail - Office
|
|
|
|
Source of Gross Income at Acquisition ($
Retail - Office
|
|
|
|
Property Acquisition Report
Retail - Office
This report shows the projected cash requirement for acquisition of the Retail - Office on 1 January 2008.
|
Cost of Property Acquired |
|
|
|
|
Price of Property |
$4,000,000 |
|
|
|
+ Closing Costs (.5%) |
20,000 |
|
|
|
Total Cost of Property Acquired |
|
|
$4,020,000 |
|
|
|
|
|
|
Property Financing |
|
|
|
|
Loan Loan Principal |
$2,267,138 |
|
|
|
- Points (1 Point) |
22,671 |
|
|
|
Loan Loan Proceeds |
|
$2,244,466 |
|
|
Total Net Loan Proceeds |
|
|
2,244,466 |
|
Cash Required at Acquisition |
|
|
$1,775,534 |
|
|
|
|
Source of Acquisition Funds
Retail - Office
|
|
|
|
Retail - Office
Acquisition Annual Gross Income Tenant Rent Roll
|
Tenant Name |
Suite |
RSF |
Start |
End |
Rent/RSF |
Reimb/RSF |
Total/RSF |
Total $ |
|
Office |
201 |
10,000 |
1/08 |
1/10 |
12.00 |
3.58 |
15.58 |
155,789 |
|
Tenant Name |
Suite |
RSF |
Start |
End |
Rent/RSF |
Reimb/RSF |
Total/RSF |
Total $ |
|
Drug Store |
102 |
7,500 |
1/07 |
1/13 |
13.13 |
3.40 |
16.53 |
123,967 |
|
Tenant Name |
Suite |
RSF |
Start |
End |
Rent/RSF |
Reimb/RSF |
Total/RSF |
Total $ |
|
Beauty Salon |
103 |
2,000 |
1/08 |
4/08 |
14.50 |
3.40 |
17.90 |
35,791 |
|
Tenant Name |
Suite |
RSF |
Start |
End |
Rent/RSF |
Reimb/RSF |
Total/RSF |
Total $ |
|
Donuts |
104 |
2,000 |
1/08 |
11/08 |
14.50 |
3.40 |
17.90 |
35,791 |
|
Tenant Name |
Suite |
RSF |
Start |
End |
Rent/RSF |
Reimb/RSF |
Total/RSF |
Total $ |
|
Flowers |
105 |
1,000 |
1/08 |
7/13 |
14.50 |
3.40 |
17.90 |
17,896 |
|
Tenant Name |
Suite |
RSF |
Start |
End |
Rent/RSF |
Reimb/RSF |
Total/RSF |
Total $ |
|
Totals |
|
22,500 |
|
|
12.93 |
3.48 |
16.41 |
369,233 |
|
|
|
|
Rentable Square Feet Distribution
Retail - Office
|
|
|
|
Proforma Income Statement
Retail - Office
This Statement is for the Retail - Office as acquired on 1 January 2008 for a Price of $4,000,000, subject to a Loan of $2,267,138, for a Down Payment of $1,732,862.
|
|
2008 |
2009 |
2010 |
2011 |
2012 |
2013 |
2014 |
2015 |
2016 |
2017 |
|
Gross Income |
|
|
|
|
|
|
|
|
|
|
|
201 Office |
120,000 |
123,600 |
141,419 |
145,338 |
149,698 |
154,189 |
158,814 |
163,916 |
168,491 |
173,545 |
|
102 Drug Store |
94,500 |
94,500 |
99,225 |
99,225 |
99,225 |
119,902 |
122,701 |
126,382 |
130,173 |
134,078 |
|
103 Beauty Salon |
31,548 |
32,963 |
33,952 |
34,537 |
34,218 |
35,244 |
36,309 |
37,389 |
38,511 |
39,666 |
|
104 Donuts |
29,366 |
31,313 |
32,252 |
33,220 |
34,215 |
35,242 |
36,299 |
37,473 |
38,511 |
39,666 |
|
105 Flowers |
14,500 |
14,500 |
15,500 |
16,500 |
16,500 |
17,210 |
18,152 |
18,696 |
19,273 |
19,834 |
|
Base Rental Revenue |
$289,914 |
$296,876 |
$322,348 |
$328,820 |
$333,856 |
$361,786 |
$372,275 |
$383,856 |
$394,959 |
$406,791 |
|
Percentage Rent |
$4,000 |
$4,280 |
$4,566 |
$4,857 |
$5,154 |
$5,457 |
$5,766 |
$6,082 |
$6,403 |
$6,731 |
|
Total Reimbursements |
$78,233 |
$80,217 |
$47,812 |
$46,778 |
$48,936 |
$51,155 |
$53,438 |