HomeMy WebLinkAbout2016-09-28 Colliers HandoutReal Estate Cycle
The 7 -to 10 -Year Real Estate Cycle
IIII iiiriu irii l
Olifflice
LININCsACGEI.ER
Seirilimir VIII VIII liii iiii11iii1
Mr,
i
"Total Building SIF 30,000
Yearly Base Rent
$175,000
Office SF 5,000
$io.00 Yearly OP Expenses
$248,272
Tenants Rent
Warehouse SF 25,000
$5.00 Monthly Net Rent
$14,583
$14,583
Blended Net Rent $5.83
Monthly OP Expenses
$20,689
$20,689
Tax & OPIAp9$8.2
%of Office Build Out
17
$35,273
Annual Gross Income
$
423,272.00
Fess Operation Expenses
$
248,272..00
.Net Operad Income
175000.00
"legurrit'oll'tCosts
Purchase Price
30,000
$90.00
$
2,700,000.00
Office Improvements
5,000
$70.00
$
350,000.00
Itemized Improvements
See 1temm9d lmpv Sheet
$
-
Other
25,000
$0,00
$0
Land Costs (New Construction Only)
2.53 Acres
110,000
$3.00
$
330,000.00
Soil Corrections (New Construction Only)
Enter Total$ Amount 4
$
-
Sub Tetl Hard Costs
(Coverage Ratio)
MID
3,380,000.00
Soft Costs
see Soft casts
$
32,110.00
Total Acquisition Costs
$113.74
1L41211'0-
Total Acquisition Costs
100%
$
3,412,110.00
1 st Mortgage
75%
$
2,559,082.50
2nd Mortgage or SBA
o%
$
Total Mortgage
75%
2,559, 82..50
alt ilrir r rt
25%
Ann.n97-
.i14f0rnJ ga""; aP,".P.ne f+vifii"
SV ,n�io-➢6�DriJ;-.
"VUN, rfa__
J�f9�W'`;b �f6Uio ."..
1st Mortgage
$2;559,083
20
4.50%
$
194,280.23
2nd Mortgage
$0
20
4 5CM.
$
-
Total Mortgage a Cost Yearly
$2,559,083
20
#DIV/01
19 ,280.23
Total Mortclaae Cost Mont4 l
161 02
mm p y I1V III m � m+
ll�kh�fiti h'W �1G,�a�r�
.
Annual Net Income
$
175,000.00
Minus Vacancy Net Expenses
0%
0
$683
$
Minus Vacancy Operating Expenses
o°%
0
$8.28
$
%lUulr'!JYIM&.
N9'IJ`fgu. ....
8k�bu��'
Reserves / Improvements
$0
20
3.00%
$
Equals Annual Adjusted Net
s
L75,000-00
Hono,.lm�pn Li�nieaJ,«
"TIP Income
$0
0
0.00%
0
Adjusted Net Income
$
175,000.00
Mortgage Payment
$
(194„280.23)
Yearly as Fly
(19,280.23)
Monthly Cash Flow
1,6 m6
Retetrrt err l ve traerrt
-226%
Debt onstant
7.5
aW a-WValue
5.13%
ir
traat ty Casetrrt
5.13”
An €urforeaaahon is judged raHable, however, rico wamartty or represernadort ds made to 14 a-ura or Domplederueea
Michael A. Brass I Vice President
612.750.4312 1 mike@mikebrass.com
9/28/2016 1 3:34 PM
Page 1 of 1
L3O
CIL
Go
cv
S2
2 w
WA?
CD <� r-
t9
cli &"
nc,
� in
cli V.id
C.,
I 011 <0 j 117 P.TM'k OI IXC!
S La
k
W
cz plAayp
CDMy
CR
4.
CO
4, Nva
iA
CY
609 r� NEA
2
a.�Cg
co�
NO
A.9 29
to'
C�Iff'1�411� 110
C,
-rw
CD
CID
cc
i
co
cj vi fV
toD.
A& fH
CC UJ
a
LU Lij
iy
CD
pp
CON
vp C�
z
LLF
§ R co
i it Q.
au
LLI
qq 60.
10;
CG
A C4
cc 0 Ill -
=2 4 Lu
m
CL cc I. -
L3O
CIL
Go
cv
S2
2 w
WA?
CD <� r-
t9
cli &"
nc,
� in
cli V.id
C.,
I 011 <0 j 117 P.TM'k OI IXC!
S La
k
W
cz plAayp
CDMy
CR
4.
tdOd
40),
C,J� �o
CY
5:
in
Z; uin—
2
a.�Cg
co�
NO
A.9 29
to'
C�Iff'1�411� 110
C,
-rw
CD
CID
cc
i
96,
V lull
C,j
C%I, CN
iy
CD
pp
CON
vp C�
co CF) RI
co
§ R co
i it Q.
au
qq 60.
10;
CG
A C4
L6
-4
m
C31;
I.IF 4CD
-1 Di
OR
O CR co
F- C:,
cu.. co,
CD
2
C:; Co.. C>
9�
P.
Lri
cq A
U, co
Lf
�r'o a Lo
c
;z
to
Ci
fRy 4FD,
C%I CD
r%
m
o
c g Cj
LO
cSSSS
P%
A
cu Cl.
%O�'.
C,
f.9, co cis
co% cq�
C. -A)
�q ON �
.60 in "fi
C,
WIN
cr
cq la
T � Z��. � s "!V --
m P;! 6231
SIN
I �
_1..l.
im
$2
12 N"!
e
Q.
N, cri �N's lk
`BHI
'N
cr, Im �zcNn
L
pI
co
. Z�;
iz �&g
CD
c::o c!
P� RM
cl
C6
K11.
Ifl!�2 g : OF CL C�L ts
, -
�wjcu
Cj,
l
01
r10
m�:
Lq prj,
R CQ
co
pt ea
NN
ca W�
Ell,
CID
6!
EIL
qr
Flz Q�j al a
C�
O.CI pp°InAaO fn
AF., 00 1
C�
cr), C6
M'r
co: 6 CA�
m
C�
Go
!Q�
CD CD
I — , I fFV
'MR
11�CD
e
- . �!
- m L. I -L 'o
cq
Ail'
ll
C,
C,4
rT RAD,
co
Qp
le
Cj
11
CNT
W5
y}y
m
SPIN/"
k
c
cm, �
COn-
N IN CD
ZD- LC3, pp-
97, 1,Q m
CIS IM
4 403,
4 9
CE),
Z a7
F�L ED
mij,%p
cr
Ell
m .11
691
7 2
1C., CU lei 12:
;z 1 Ki
COMBy
1z
C. 53
rn!kg
C, �CD
C, tdi
- ,
ck 1-2 1 F
16g4F)-
C%j
L,
INS'
Lu
2E.
C6,
29
U)
ID in
LU
UJ:
~2 1
Jj in
LU UA
C)
z 11.110
K LU W!mIm
FS
z
Ll�l LU
3r
U3
LLI
0
LU L, LLJ
LLJ
Ir
uj
,:c U),
10 LL,
C-3 U)
LL,
Ir -Er 0
0 LLJ LLJ
Lu iE-
P510
0
fn] Lu
IF l� j3
0
SEC
or
7
U)
<ILSIZ §
co 4 In w
LLJ C3 LU LLI .2
51Lf
0
EL
�-c cc LU
LL
< o LLI
LU -j
-1 LU
m1g:
CC (n F dC 0 0 C.) �rj, 14' ZICL
z
m Cu
0 CL 0
.Zc dK
C., 0
L3O
CIL
Go
cv
S2
2 w
-100 w
E
My
FIF
'""
Totall Buflding SIF 30,000
Yearly Base Rent
$195,000
Office SF 5,000
$11.00 Yearly OP Expenses
$248,272
Tenants Renil
Rent
Warehouse SIF 25,000
$5.60 Monthly Net Rent
$16,250
$16,250
Blended Not Rent $6.50
Monthly OP Expenses
$20,689
$20,689
"T"ax & 01P $8.28
% of Offjce Bufld Out
170/6
$36,939
Annual Gross Income
443,272..00
Less Operatjon Expenses
$
248,272.00
Net Operati income
195,
Purchase Price
30,000
$90,00
$
2,700,000.00
Office Improvements
5,000
$7000
$
350,000.00
Itemized Improvements
See Itemized Impv Sheet
$
-
Other
25.000
$0-00
$0
Land Costs (New Construction Only)
2.53 Acres 110,000
$3.00
$
330,000.00
Soil Corrections (New Construction Only) Enter Total$ Amount 4
$
Sub Total Hard Costs
(Coverage Ratio) 27%
$
%380,000.00
Soft Costs
see soft is
$
328110.00
'Total Acquisition Costs
-------
$113.74
$
3, 4"12,110.00
Filmucing Sudtnnm)�
Total AcqOsffion Costs
100%
$
3,412,110.00
'I st Mortgage
75%
$
2,559,082.50
2nd IMoirtgage or SBA
(r/0
$
Total Mortgage
75%
2,559,082.50
853.027.50
,11,fonyg�awe Details
st Mortgage
$2,559,083 20
450%
$
194,280..23
,1
2nd Mortgage
$0 20
4-50%
$
Total Mortgage Cost Yearly
$2,559,083 20
#DIV/01
$
194,28023
Total o s e Cost Monthl'V
_$16 190.02
m,,u,,,ses
Annual Net Income
$
195,000.00
Minus Vacancy Net Expenses
0% 0
$6.50
$
Wnus Vacancy Operating Expenses
0% 0
$8.28
$
Reserves / lrnlprovernents
$0 20
3,00%
$
Equals ,Annual Ai "ustedNet
Botrom, Dire
TIF(Income
$0 0
0,0098°
Adjusted Net Income
$
-I 9"000.00
Mortgage IPayinnent
$
(194,280.23)
Yearly Cash Flow
719.177
nthly Cash Flow
59.
ji;iu' -o—n
Debt Constant
7.69%
Debt Ratio
1.00,
a ate alue5.71%
Straialit Cash Retum
5.71%'
AN information is judged r0abile, however, ino warranty or representation is made to it accuracy or completeness
Michael A. Brass I Vice President
612.750.4312 1 mike@mikebrass.com
9/28/2016 1 3:36 PM
Page 1 of 1
� oN
�
4 O O O M1
W t7 to Nl] pf
GPI
Mi
Iqi
W
LU O O O 1
LNS N � LO
f
0
LLrz
OM
m
LU
LL :c F
LL
0
W
2
51i 0
'211
�i w
J
wIDf • LL
0
LL.W I. V 4
� LU
kt
0 Q O
ggN ON1C -NNRLN
PE tn- m
tn`ol
�mz����u'„u4
IX"RW
1
m L
y
&'gjCD
Idl T
I
WtintN
N m.rc'�nu
rF„
Hb✓ '
fI
U31 LID N
,
nn
��IX
���'MmI'
1.11M
O
I
W N N
CWIIYm-f
101
CM
Gw llf N R
Oi
f P a
-
LO
C 6O N
GFS
W F
�
a
W
d
IN j'. �, i� YWipp �g
� k f �i� m
m0: r-�i�l �,rr-�
Np: pp oo p ph mho¢ Fil
Nsy31LH�O�O�IN9�
LLI
mN'
W
N
m
CID
r,
mNk
lPM
= Z S9 W
ILIcc Q
Off; M'Om1�M^Wy�j
hlKji
E
d Cl Q H Gam.
2
E �Ofh a IT pf ESS lil ✓; 4
mid'" c 2R 8e J', °end
d o
'�%1 e'�,^9c°De�
ggN ON1C -NNRLN
PE tn- m
tn`ol
�mz����u'„u4
IX"RW
i�
n �"^
y
&'gjCD
Idl T
I
WtintN
N m.rc'�nu
e4ien�P'� �ryrf _!`'�{
�j
r M,
NN N`.:.:,,A NN N,. Y���y
CA'0I
r E9f'rB .I
r«rfi
q�.V6vx
d�9,R
nn
��IX
���'MmI'
1.11M
O
I
W N N
CWIIYm-f
101
/
IN j'. �, i� YWipp �g
� k f �i� m
m0: r-�i�l �,rr-�
Np: pp oo p ph mho¢ Fil
Nsy31LH�O�O�IN9�
'-
J r
A m”
NMddd1�A
mN'
W
N
m
CID
r,
mNk
lPM
C
G¢Mr- ,
rlf':W CnP�
Off; M'Om1�M^Wy�j
hlKji
.
p,p
::d /i% _ �
�
!
fH
k+e� d4
f91,
'gm,Ill��b
.:.�y►E
lby= {
I
175 1Ig�
e0 �fD Sg ICO im0 h //, � ;dNO
-E pphO O Of0 06Q K:dWOj S�i' i :'+�
[{Pi � wf6
`-P110I I�I:m GMI
t+N I ,UpDpl
�
[7{
,
mppIX &
O
d�k m_
N I
N Qm Wph
ham• {
R"R..i! A
co
! 6HI!.�&RkNfp'�dq�
�}h'?�-',�9G;t'W5
DEQ
np•U ti
SII ��tI cp
NE�91
III IP *dim
i4g� E°I� I� ,,,, { 1fA99W99WE9f�lI
Gf7t
t[m�OpIMI:d°IyI
fl;�
. 5�
s ;m: -mlYd C
N co 3w o�ilrnt, Ey��I
'm Iii -mI�JNCO'C,TY
ti
m liva'
�g�r
udlky�''�1�+.
C, p },��
p�LO [p tf31 O1 O177-iEly [GO�-1LG�'Oy9N V' {'"i `-:[�S Its
N.tAP O. O f -O y` �;A? 07�a[)
CQ 4"it,�
�IUFII$ iw11 / T�
emo`doI hem .IXr'F'A�ci•p'+Sfi,
4�01hEN Ni�O Oa
n'v RRkS
�,€�, o
C9Cmill�f
l &
g'Q
�!!!
mFI�
��A
pf
#(p
P ,;y 4'f
[Vnu�ikc4i
LN]� L"! LO
CO_. N��
[�I to
"'{y!r.
+.I
I
g .,.Y
it
7"
��im
c�+
�
Q
f
�;g'D
'" ok
fr�k �!
a2� Nyt 3E �@j t�
�,001�.pQl Q400 O" �Ol Q1 N,"I:NepftO JiC f. Z�fINI �4]3
�'%= r mt
t9181a. t �:69 lV (d
N^EA ��ti Oa bW�4
�u
'r i to"'f :ar
f`hCiN m(ti M
Nt1 b' Les
OgV! f O+,p
]j
�y
[� :n�gpepo
� 4)WPIA"
i �CIYtt
�Y
�W.Q
e
tp
'ta"Nr
W IIS
�'dym
9
tm�
lCs�
tNN1�I. NII
ce"R O 4
f
P01 p�
(per R tib / rl fA
1 EAI
O?:
I iE9R �NMYttlS
F
i^
i(fSr
„ '
Om :3ei g f SE�� ltOf
r O¢p-O pI�4O r0 �
tlN m,r WST4
ICJ TIX%
CO
WC!
L9'
fZgN,tT,
4
n
N tD
1 A? { M✓fIIR
mGIISJ
py
.12j1 GIA
µ^M' a LLl
T4k,rm
uJ:'h to
lm/1 i V Y
Ifl Qt'a'8k
N'
O
Ir O
C� 6"q�pr�0�
NF O�Itla �¥19E a4 N�GRrO I'^'•M' G9
NC ! pp 3 ��I�I�i0�1]4.u0l
/� r. Gh}EA
r, M,�,R,
m���77 q,4S[h
O M,,yy
97q ;Y
l(L�f lgplp
8Pdp
m
re'W LV
d.41
IXQ�M
(�I (�}
N
:k Q�
•:,r
j to NSM IINII/ta
,.G9t�31iF'rN
�yypppp'�'RtpgRQ
l
�FFitl
lfi;f$p
..,r
iii
hoi 9 o� i�'qm""� �{py srni
Wiy�Qy
Cp(O C Qe "� p Of t`nll IaP
Vim`- mq� ce~�Rlm
Ns�@ f
p I
1O tp Lp: tO qq!C V'A,�C'78d
sr'»
D uh
GKAl.•
t
„�C
KM
m�Mnu
u'1
�O
dH"iNn�
E
mea
!
�t A•I
,1p.,
O.. m�gO H314#FfY,964 (A p" 60/J h f► LP'fO
p J
N —i O1RA'R C� w:il0 -O�f
? � q n'
`' * tH
m2W"AYf
Sni i'�{fA tp 1V.f
SA �. v, S?
C"
C�]
N9h M
U
- C?
ppR
J
N M
(ll�]gC
C7
Y p
v� tl�
f6� Nr
t71
c6
ANA OI
h a
'mss
I Ih
r
�N�
hY
4ap1
a vs
E911I&Y�G�e
w
I l
1
c� p I� ��y
.moi codOf. e3e ONi� pm ,! E ��d S1t��I �:!m
m Ep %O q p Op G*"p0 i'2� N �'
o Loi' kS to Rraq q'�� 69f�, V3 `R 1 !^ wgg
d'OI { iIn C -i Y
R�ac7?C lGGt7TUW
E9 (VNpM
,a°O
n'II:Y4htt�y
411"oDPt�o
1� b<sR
�4:M#
Q
(� y
LOpE P'
O�sll
GI
p N_
„O
d, �'�k iiia
N
c'!
N@
�e� �
;N
co
I�j t�P`
NIGg. W, ....�
4g IKII ', 69
W
� d •:.
(V
A
y)
Q
Cl)
C
4'WIr
r.V
L9�IXly
IXM III��Of
''^y7P
tRI 1 �/
R a
%
to li
�. �W 69
6%n
��
CID a�E P `$i tor' 3��?°Ern„LLSk;
W,m,
mF�� g`. N 'Io� Wy j �+
p69M
o+ki p 7
9P7 y!pb°O tpit�i
my sar mmuw
„sl
�n
�sdM lJkaa
k�ifia2
tOftCo
cmikilll
eOR
g C
�• Na
d:kld
m
t�
T'`i9`c
Ow�ph
,y
aM&�
;"//////////,,,,,,,,�
N tgi�r O X169 O} GfA� I O CISEMi {�
p lIIII11�066
fd4� i aG91 :rcdmu +::F}l
e
Clfhc�. ^ gWMS
Ef3 'P (! fsYk::.:MM�
N, j
X� Iht}
l
�pg
Rj'I
"1
�Gq• i2
aP2 - 1A
C�i�59111P
t7 `Gf3:
t9
f�Y
N!
J
/
� I
�` k ��I t;m $6' l �
�tA t�10. �k :� f O ttl
dCrA
` I ry M
aG^t7 tl:i M�
htl:Nlm�ttf
m�
J r4
vN
M
k
N c� cam��Imo
Rl
ntl!
'tri
I �m
GO
ff5 �i
`--'
cJR 6M�II�
S f y p }LO
6�p� N'
p
O1NM4
R.IN�
�jC[) M IX
i
o OIE
( lo,oiotig g o m,Fg�$�I
ISIm r� A 5 ,OsW �
II pp O O F{
' O YJ"�k4] O,ERyE9 tCf� �m I' M4
tR OI N
.�;rl �OS b d�Y 1/0 (. lV� Im;:yy
DISI
R§ m �d
[ _, CD��O� [NIO R"JIH,
'I��fJ3 I1"mom 4k"
V �fi Nsi^ MR
�.�3 ' fi(A
!
N rr
r�M.8,
�(mm�I
to !�b•M
m
7
Q
N M
:Ah
d
m
r: fRffR��'��T•.
r_IW M.
(y�N
IXrS,bW'a
_
E
•P$7C
1_.N
f
1
�ile
f
i f
LU
i O 'I
6W
LU
,fig
p�d{
ILt� �; i0 ;F
{w� i ? lZi[4~cZtZ
��{ U. r N Y/UiW
W UJfi �:y, 1'W W ¢J S1.S li g1:�6¢p.'.
�r �� —�;c
S71LD W
i y
�56�� pp
�r Z
°.7
lLy
r2
��
pZ�
_ �
{I
¢tWl
WN�yJ�
aW
¢ yjO
I
€
PWII
UE
[
{ d Zfl �UCi iZ�a�iW
Z z i co [moi �, W X 7 7 W ly��1 I t
J,.:Q{d
'd��
t � H�
Qµ� ��0�¢ ¢
Uk
Z
UIQ
X
�qW�Q
'W C7
Q
C.�3 H
I
P 'CJ
{61
h xx II
sQF
{ -
p33333g 6�' Z W W QIP W QBIQ s~
WWVU Cn J Ok0 H W W J Y I N
� {{Z z [r U w �' yW�F�HE 'JW
Q Z• fd Q W W H7Z 7 H H C` ¢4C�l�H"g
m m ��s yf�yZNCCdUJ
��
d�f¢¢t� f J a U
wC7f0 ,LL w
.,2 U
za
J
WAN�QI"
m¢IIII
qq&W
H�
H
'H C74
s¢ ZIp(;%
"Q ip
r `�0
W
ppgy O
LL
�f DC7
kz
I' �•[WRUmLL
”
F
cc
CT
Z.4 7C
WryW ZlQ,O
3e W �dCAgH Q C?tde'�:=_
a Id 9Q'� W
dI�IN�:U�a�
X
Qt
FRQ
LL
Q,
Q J
„U Ugh
O Wm._'7
m
�.m.0 C7
H 61
2