ATTACHMENT F
<br />Pro-forma with MUPTE
<br />Below is the 10-year pro-forma with the MUPTE and the additional payments to the City.
<br />The guaranteed payments Core Campus proposes to make to the City total $1,030,000,
<br />which is 20% of the MUPTE savings for the 10-year period. The average cash on cash
<br />return for the 10-year period is 9.66%.
<br />............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
<br />With MUPTE
<br />Year I
<br />Year 2
<br />Year 3
<br />Year 4
<br />Year 5
<br />Year 6
<br />Year 7
<br />Year 8
<br />Year 9
<br />Year 10
<br />Income
<br />4,649,100
<br />4,695,600
<br />4,742,500
<br />4,790,000
<br />4,837,900
<br />4,886,200
<br />4,935,100
<br />4,984,500
<br />5,034,300
<br />5,084,600
<br />Vacancy
<br />232,500
<br />234,800
<br />237,100
<br />239,500
<br />241,900
<br />244,300
<br />246,700
<br />249,200
<br />251,700
<br />254,200
<br />Effective Gross Rent
<br />4,416,600
<br />4,460,800
<br />4,505,400
<br />4,550,500
<br />4,596,000
<br />4,641,900
<br />4,688,400
<br />4,735,300
<br />4,782,600
<br />4,830,400
<br />Operating Exp
<br />1,413,300
<br />1,427,500
<br />1,441,700
<br />1,456,200
<br />1,470,700
<br />1,485,400
<br />1,500,300
<br />1,515,300
<br />1,530,400
<br />1,545,700
<br />Property Tax
<br />(449,000)
<br />(462,500)
<br />(476,400)
<br />(490,700)
<br />(505,400)
<br />(520,600)
<br />(536,200)
<br />(552,300)
<br />(568,900)
<br />(586,000)
<br />(saved by MUPTE)
<br />Add'I Pymt to City
<br />30,000
<br />60,000
<br />165,000
<br />300,000
<br />475,000
<br />IND
<br />3,452,300
<br />3,495,800
<br />3,540,100
<br />3,585,000
<br />3,630,700
<br />3,647,100
<br />3,664,300
<br />3,607,300
<br />3,521,100
<br />3,395,700
<br />Debt SeNce
<br />2,491,522
<br />2,491,522
<br />2,491,522
<br />2,491,522
<br />2,491,522
<br />2,491,522
<br />2,491,522
<br />2,491,522
<br />2,491,522
<br />2,491,522
<br />CIF
<br />960,778
<br />1,004,278
<br />1,048,578
<br />1,093,478
<br />1,139,178
<br />1,155,578
<br />1,172,778'
<br />1,115,778
<br />1,029,578
<br />904,178
<br />Cash on Cash Return
<br />-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<br />8.7%
<br />9.1%
<br />9.5%
<br />9.9%
<br />10.4%
<br />10.5%
<br />10.7%
<br />10.1%
<br />9.4%
<br />8.2% J
<br />The financial analysis on the without MUPTE pro-forma is in the June 10 Agenda Item
<br />Summary, Attachment I.
<br />
|