economic project analysis - mt. pleasant corporate center

Upload: steve-oso

Post on 04-Jun-2018

217 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    1/24

    !"#$#%&" ($)*+,&, -./#012#3$1 4*.),)$1 5#0/#0)1. 5.$1.0

    2.%6.0,7"#$%&' ('&)#(*++ ,-.&%#/01+&2& 3#-)0-

    456*# 7#-* 8& (&%-90%% ,*#$

    ,-2&:;&) ?@>

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    2/24

    8 (9:! ;< 5 ;=8!=8>

    7)-A&6+ BC&65+02& 15::*)' DDDDDDDDDDDDDDDDDDDDDDDDE

    7)-A&6+ F)0G+0-HDDDDDDDDDDDDDDDDDDDDDDDDDDDDDI

    "##5:G+0-H#DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDJJ@ *6) -P +$& G)-G&

    S-H#+)56+0-H .0%% *%#- ;& 8-H& -H +$& )-*8.*' *8A*6&H+ +- +$& 6-)G-)*+& G*)/ 0H

    -)8&) +- 0:G)-2& +)*H#G-)+*+0-HJ LH -)8&) +- P0H*H6& +$& G)-A&6+= * %-*H -P

    VI=?=??? .-5%8 ;& 5#&8 *##5:0HR * >J

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    4/24

    4 -;?!58 E !>5-B48B;=

    U$& (-5H+ 7%&*#*H+ S-)G-)*+& S&H+&) 0# * >EJ=???=???= .0+$ +$& ;50%80

    8&:-%0+0-H +-+*%0HR VO?=???J 7$*#& @ .0%% 6-H#0#+ -P 6-H#+)56+0-H 6-#+# -P V>=???=??

    *H8 *H &HR0H&&)0HR P&& -P V>

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    5/24

    ( >>A248B;=>

    U$& P-%%-.0HR *##5:G+0-H# .&)& 5#&8 0H +$& &6-H-:06 *H*%'#0# -P +$& (-5H+

    7%&*#*H+ S-)G-)*+& S&H+&) %-6*+&8 0H 16)*H+-H= 7"J U$& *##5:G+0-H# *)& )&P%&6+

    0H +$& 6*%65%*+0-H# P-) +$& B[502*%&H+ XH0P-): "HH5*% S-#+ ]BX"S^ *H8 +$& P0H*% #*

    G)06 P-) +$& %-+# 0H6%58&8 0H +$& G)-A&6+J U$& *##5:G+0-H# P-) +$& G)-A&6+ *)& *#

    P-%%-.#_ 4*.H 6*)& :*0H+&H*H6& .0%% -665) +.&%2& +0: G&) '&*)= *+ * )*+& -P V

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    6/24

    L+ 0# *##5:&8 +$*+ +$& *HH5*% 0H+&)+ )*+& 5#&8 P-) +$& BX"S *H8 %-+ G)06

    6*%65%*+0-H# 0#

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    7/24

    E !5B>B;= 4 ;B=8>

    Income and Expenses

    The decisions made for the income and expenses for the Mount Pleasant

    Corporate Center were based off of the information in the project description and

    the assumptions located in the previous section.

    Using the assumptions above for the lawn maintenance, the total lawn

    care maintenance will amount to $5,000 per year. This includes mowing the

    grass around the lots and maintaining the landscape. The total lawn

    maintenance was found by multiplying 8 acres times $50 per acre times 12.

    The total road maintenance will amount to $4,000 per year. This includes

    fixing any problems with the roadway and snow plowing costs. The total

    maintenance cost for the first 3 years of the project was calculated to be $32,500

    per year. This cost includes lawn maintenance, insurance, and marketing costs.

    After the third year the total maintenance costs increase to $36,500 per year.

    The slight increase in maintenance cost is due to the road maintenance being

    added. As the lots are sold the total maintenance costs decrease by $1,000 per

    year.

    The low interest loan needed to fund the project was calculated to be

    $4,490,000. The 2.5% interest rate used for the loan was decided to be the

    prime interest rate for banks. The interest rate that was used for everything

    outside of the loan was decided to be 5%. This interest rate was used for the

    EUAC and helped to determine the total loan that was needed for the project. All

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    8/24

    of the other expenses listed in the project description were planned out according

    to the payment breakdown. The annual loan payment was calculated to be

    $630,000. The first loan payment and initial construction costs will come from the

    grant and company money. This payment will span 8 years, it will start when the

    land is initially purchased and continue until the last lot is sold.

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    9/24

    - B>F>

    9$&H 5H8&)R-0HR *H 0H2+:&H+= +$&)& *)& *%.*'# )0#/# 0H2-%2&8J 1&2&)*%

    +$0HR# 6-5%8 R- .)-HR 85)0HR +$& G)-A&6+ +$*+ 6-5%8 H&R*+02&%' *PP&6+ +$& -5+6-:& -

    :*/& +$& G)-A&6+ %# G)-P0+*;%&J 1-:& )0#/# P-) +$0# G*)+065%*) G)-A&6+ 0H6%58&_

    8&%. G.*)+, c U0:& 8&%*'# *)& -H& )0#/ +$*+ 0# G&60*%%' 0:G-)+*H+ +- +$0#

    G)-A&6+J "H *##5:G+0-H .*# :*8& +$*+ -H& %-+ .-5%8 ;& #-%8 &2&)' '&*)d $-.&2&)=

    +$&)& 0# * 6$*H6& +$*+ +$& %-+# .-5%8 +*/& %-HR&) +- #&%% .$06$ .-5%8 R02& 5# * +0:&

    8&%*' *H8 *88 :-)& 6-#+# +- +$& G)-A&6+J U$&)& *)& *%#- :*H' -+$&) P*6+-)# +$*+

    6-5%8 6*5#& +0:& 8&%*'# #56$ *# 6-H#+)56+0-H H-+ ;&0HR 6-:G%&+&8 -H +0:&J

    A$H#0.,..$ "#$G&1$, c U$&)& *)& #&2&)*% +'G -P 5HP-)&&H 6-H80+0-H#

    +$*+ 6-5%8 *GG&*)J 3H& -P .$06$ *)& H*+5)*% 80#*#+&)#J 16)*H+-H= 7&HH#'%2*H0* 0# H-

    * $0R$K)0#/ G%*6& P-) H*+5)*% 80#*#+&)# +- -665) #- 0+ 0# 5H%0/&%' +$*+ -H& .-5%8 *PP&

    +$& G)-A&6+d $-.&2&) +$&)& 0# *%.*'# * G-##0;0%0+'J 3+$&) G-##0;%& 5HP-)&&H

    6-H80+0-H# 0H6%58& G)-856+ #$-)+*R *H8 #+)0/= .$06$ 6-5%8 $*2& *H 0:G*6+ -H +$&

    G)-A&6+ *H8 &0+$&) )*0#& 6-#+# -) 6*5#& * +0:& 8&%*'J

    B$)""30)1. &$H#0%)1$ c 9$&H .-)/0HR -H * G)-A&6+ +$&)& 0# *%.*'# *

    G-##0;0%0+' +$*+ #-:& -P +$& 0HP-):*+0-H '-5 *)& .-)/0HR .0+$ 0# H-+ 6-:G%&+&%'

    *665)*+&J \*20HR 0H*665)*+& 0HP-):*+0-H 6*H )&*%%' $*2& * H&R*+02& *PP&6+ -H +$

    G)-A&6+ *H8 +$& +0:*+&8 6-#+# 6-5%8 R- 5GJ

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    10/24

    6-5%8 6*5#& :*A-) P0H*H60*% G)-;%&:#J LP * P0H*H60*% 0##5& *)0# +$*+ 0# #0RH0P0

    &H-5R$= +$& G)-A&6+ :*' $*2& +- ;& *;*H8-H&8 *%+-R&+$&)J

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    11/24

    EB>5A>>B;= ;<

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    12/24

    15;#&[5&H+%'= +$& *HH5*% %-*H G*':&H+ H&&8&8 +- ;& 6*%65%*+&8= *H8 +

    *HH50+' &[5*+0-H 5#0HR +$& G)0:& 0H+&)+ )*+& -P >JT=>?YJEY .*# -;+*0H&8= .$06$

    .*# )-5H8&8 +- *H )$$3)* /)+%.$1 #H LQRPNPPP J N-5H80HR 5G +$0# 2*%5& *PP&6+#

    +$& +-+*% 2*%5& -P +$& %-*H= .$06$ .-5%8 +$&H ;& )-5R$%' VI=?=??? *P+&) +$&

    *HH50+' &[5*+0-H 0# *R*0H *GG%0&8J U$0# )-5H80HR 5G )&P%&6+# 0H +$& BX"S .$06$

    6*%65%*+&8 0H %*+&) #&6+0-H# -P +$& Q0H*H60*% F0#65##0-HJ

    E.1.0%&$&$J 1K. :#1 40&".,

    "P+&) 8&+&):0H0HR +$& %-*H G*':&H+#= * :-)& 8&+*0%&8 P%-. 6$*)+ 6-5%8 ;&

    8&2&%-G&8= .0+$ +$& *HH5*% %-*H G*':&H+# *66-5H+&8 P-)J Q)-: +$0#= +$& G)06& P-) +$&

    %-+# 6-5%8 ;& 8&+&):0H&8 8&G&H80HR -H +$& +.- #6&H*)0-#J

    >".$)0 S T 8K. G.U.*#/.0 60.)V, .U.$ )H1.0 )** *#1, )0. ,#*G

    LH +$0# #6&H*)0-= +$& #*%& -P +$& %-+# 8-He+ R&H&)*+& *H' G)-P0+ P-)

    8&2&%-G&)J U$&)&P-)&= +$& G)06& P-) &*6$ %-+ H&&8# +- ;& ;0R &H-5R$ +- 6-2&) *%% 6

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    13/24

    +$*+ 6-:& .0+$ +$& G)-A&6+J LH -)8&) +- 6*%65%*+& +$& G)06& G&) *6)&= +$& H&+ 8&

    .*# 6*%65%*+&8 ;' *880HR +$& 6-#+# #G&60P0&8 0H +$& G)-A&6+ *##0RH:&H+ .0+$ +$

    *HH5*% %-*H G*':&H+#J U$& 2*%5& P-5H8 .*# VY=I=?I= .$06$ .*# )-5H8&8 +-

    VY==???J S*%65%*+0-H# 6*H ;& P-5H8 0H +$& H&C+ #&6+0-H -P +$& )&G-)+J

    Q)-: +$0# 2*%5&= 6*%65%*+0HR +$& G)06 G&) *6)& .*# A5#+ * :*++&) -P 802080H

    +$& H&+ 8&P060+ ;' +$& >@ *6) +$*+ )&G)&H+ +$& %*H8 P-) #*%&J " G)06& -P VI?Y

    G&) *6)& .*# P-5H8J Q)-: +$0# 2*%5&= 0+ .*# A5#+ * :*++&) -P :5%+0G%'0HR +$& #0Z& -P

    &*6$ %-+ #G&60P0&8 0H +$& G)-A&6+ :*#+&) G%*H *H8 5#0HR +$& &[5*+0-HF = P (1 + i ) n +-

    8&+&):0H&8 +$& )G&6+02& G)06& -P &*6$ %-+ 0H +$& '&*) +$&' .&)& ;&0HR #-%8J U

    G)06 -;+*0H&8 P-) +$0# #6&H*)0- .&)& +$& P-%%-.0HR ])-5H8&8 +- +$& H&*)+

    V?=???

    4-+ E ]EJE *6)^ f V@=Y?JO *6)^ f V@=TT

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    14/24

    .$06$ )&G)&H+# +$& 6-#+# 0H +$& G)&H+J U$&)&P-)&= +$& G)06& G&) *6)&

    :5%+0G%0&8 ;' @J@ +- -;+*0H * 2*%5& -P VIIY=??? G&) *6)&J U$& P-):5%*F = P (1 + i ) n

    .*# *%#- 5#&8 +- -;+*0H +$& G)06 -P +$& %-+# 0H +$&0) )G&6+02& '&*)# -P #*%

    ])-5H8&8 +- +$& H&*)+ V ]EJE *6)^ f V@=YO

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    15/24

    16&H*)0- @ _ F&2&%-G&) ;)&*/# &2&H

    o BX"S f KV>=>_ F&2&%-G&) :*/ @?W G)-P0+

    o BX"S f KV@EI=O>YJOE

    " H&R*+02& 2*%5& .*# -;+*0H&8 P-) ;-+$ BX"Se#J U$0# :&*H# +$*+ P-)

    ;-+$ #6&H*)0-# +$& 8&2&%-G&) $*# * H&R*+02& 6-#+= 0H -+$&) .-)8#= $&e# :*/0HR

    :-H&'J B2&H +$-5R$ 0H 16&H*)0- @ +$& 8&2&%-G&) 0# :*/0HR *;-5+ V>=>

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    16/24

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    17/24

    5 (>Z (=E 5 ;24A8(8B;=>

    B$&1&)*

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    18/24

    >".$)0 S T E.U.*#/.0 60.)V, .U.$

    >".$)0 W T E.U.*#/.0 %)V., SPX /0#H&1

    " # $ % & ' ( ) *

    !"#$%&&'() !"+$%&&'()

    !#$&&&$&&&,-./0123

    !4&&$&&&,56673

    !4&&$&&&,56673

    !#$&&&$&&&,89.7:);9: = D126 >9: %

    !%$&&&,>9:3

    >91.7

    E1/.:6.1.9:3

    !#$&&&,>9:3

    !4$&&&,>9:3

    !?&$&&&,@6A92/09.3

    !4#+$&&&,56673

    !4B$&&&,56673

    !=&&$&&&,C)1.:73

    !=$D+%$&&&E126 >9: 4

    !4$D#&$&&&E126 >9: #

    !4$B&%$&&&E126 >9: "

    !4$++%$&&&E126 >9: =

    !4$4%&$&&&E126 >9: %

    !%$&&&,>9:3

    >91.7

    F1/.:6.1.

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    19/24

    5#%/31)1$,

    " # $ % & ' ( ) *

    !"#$%&&'() !"+$%&&'()

    !#$&&&$&&&,-./0123

    !4&&$&&&,56673

    !4&&$&&&,56673

    !#$&&&$&&&,89.7:);

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    20/24

    Loan Value

    Annual Loan Payment

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    21/24

    Lot Prices

    Scenario 1

    Scenario 2

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    22/24

    Scenario 1 - Developer Breaks Even

    Scenario 2 - Developer makes 10% prot

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    23/24

    4 -;?!58 >A22(-D

    (-5H+ 7%&*#*H+ S-)G-)*+& S&H+&) G)-2&8 +- ;& 6$*%%&HR0HR .$&H *H*%'Z0HR

    +$& &6-H-:06 ;)&*/8-.H -P +$& G)-A&6+J Q-%%-.0HR *%% +$& #&H+0*% R508&%0H

    G$*# -P 6-H#+)56+0-H= * P*2-)*;%& -5+6-:& .*# 8&+&):0H&8 0H &*6$ -P +$& +.- P0H*%

    #6&H*)0-#J X#0HR +$& 0H0+0*% *##5:G+0-H# R02&H= * P%-. 6$*)+ 8&G06+0HR *%% +$&

    0H6%580HR :*0H+&H*H6& *H8 %-*H#= .*# 6-H#+)56+&8 0H -)8&) +- P5)+$&) 6-:G)&$&H8

    -5) P0H*H60*% #+*H8G-0H+J

    b02&H +$& G)&:0#= 0+ .*# &CG&6+&8 +$*+ 6&)+*0H &856*+&8 *##5:G+0-H

    .&)& :*8& 0H -)8&) +- P0%% 0H +$& :0##0HR 0HP-):*+0-H H&&8&8 P-) 6-:G%&+& +$&

    -2&)*%% G)-A&6+J 3H& -P +$& :*0H *##5:G+0-H# 0H6%58&8 +$& 6-#+ -P :*0H+&H*H6&J 9&

    *##5:&8 +$*+ @aE+$ -P +$& G)-G&)+' .*# R)*##= *H8 0H -)8&) +- 6*)& *H8 +&H8 P-) +$&

    R)*##= .& .-5%8 H&&8 +- G*' *+ * )*+& -P P0P+' 8-%%*)# G&) *6)&= +.&%2& +0: G&) '&*)J

    U$& )-*8 :*0H+&H*H6& .*# *##5:&8 *+ * +$-5#*H8 8-%%*)# G&) :*0H+&H*H6&= I +0:

    * '&*)J (*)/&+0HR 0# *H-+$&) &CG&H#02& #&H+0*% +- +$& R)-.+$ -P +$& 8RHJ 9

    *##5:&8 #&2&H +$-5#*H8 8-%%*)# * '&*) *H8 .0%% ;&R0H .$&H +$& G)-A&6+ 0# P0)#+

    G5)6$*#&8J b&H&)*% %0*;0%0+' 0H#5)*H6& 0# *##5:&8 +- 6-#+ +.&H+'KP02& +$-5#*H8

    8-%%*)# G&) '&*)= *H8 .0%% ;&R0H .$&H +$& %*H8 P-) +$& G)-A&6+ 0# P0)#+ G5)6$*#

    7*':&H+ P-) *%% +$& &CG&H# *)& &CG&6+&8 +- 6-:& P)-: %-*H# *# .&%% *# * P-5)K

    $5H8)&8 +$-5#*H8 8-%%*) R)*H+ +$*+ .& *##5:&8 +- ;& P*0)J "# &*6$ -P +$& %-+# .*#

    #-%8= +$& +-+*% :*0H+&H*H6& .-5%8 8&6)&*#& ;' * +$-5#*H8 8-%%*)# * '&*)J Q-) +$&

    %-*H#= * >J

  • 8/13/2019 Economic Project Analysis - Mt. Pleasant Corporate Center

    24/24

    80*R)*: P-) &*6$ #6&H*)0- *# .&%% *# +*/&H 0H+- P5)+$&) 8&+*0% 0H +$& g"##5:G+0-H#h

    G-)+0-HJ

    40/& *H' -+$&) G)-A&6+= +$0# G)-A&6+ *%#- $*# * H5:;&) -P G-##0;0%0+0 +$*+

    :*' $*):P5%%' *PP&6+ +$& 8RH*+&8 -5+6-: P-) +$& G)-A&6+J N0#/# *)& P)&[5&H+%'

    +*/&H 0H+- *66-5H+ .$&H 6)&*+0HR * %-HRK+&): G)-A&6+J U$& )0#/# 6*H 0H6%58

    8&+)0:&H+*% .&*+$&) 6-H80+0-H#= *H' 0H*665)*+& 0HP-):*+0-H +$*+ :*' ;& R02&H= *H8

    G-##0;%' +$& :-#+ 0:G-)+*H+ .-5%8 ;& *H' P0H*H60*% 0##5 +$*+ :*' *)0#&J

    \-.&2&)= %--/0HR *+ ;-+$ P0H*% #6&H*)0-#= &2&H *P+&) *%% +$& G*)6&%# *)& #-

    #+0%% $*8 * G)-P0+ -P V>=>