Laserfiche WebLink
Annual D/S <br /> <br />ATTACHMENT E <br /> <br />Financial Analysis <br /> <br /> <br />The Pro-Forma for Broadway Lofts (below) shows three key reasons that the project would not be built <br />without MUPTE. First, the debt coverage ratio (Net Operating Income (NOI) divided by debt service) is <br />1.22, below the amount needed to qualify for conventional financing. (The common bank preference is <br />for 1.25 or higher.) Second, the perceived risk is high demonstrated by the Cash on Cash return (Cash <br />Flow divided by the equity that is invested by the developer) well below the market-expected 10% to <br />15% level. The Cash on Cash only reaches 4% by year 10. Third, the project valuation is below the <br />amount needed to qualify for conventional financing. (The value is determined by NOI divided by the <br />capitalization rate.) At project stabilization, the projected value of the property is $3.25 million or 77% <br />loan to value. <br /> <br />Sources <br /> <br />Total Cost <br /> <br />EQ$ 1,392,573 33% <br /> <br />City$ 300,0007% <br /> <br />Conventional Debt$ 2,500,000 60% <br /> <br />Total project$ 4,192,573 <br /> <br />The City (through its Urban Renewal Agency) provided $500,000 in acquisition financing from the <br />Downtown Revitalization Loan Program - $300,000 to be repaid within 10 years and $200,000 to be <br />repaid upon reaching 12% return. The $200,000 portion is included as part of equity for this analysis. <br />The total loan would be due on sale of the property. <br /> <br />Pro-Forma <br /> <br /> <br />Without MUPTEYear 1Year 2Year 10 <br /> <br />Rent Income$ 347,772 $ 351,250 $ 380,353 <br /> <br /> <br /> - Vacancy (5%)$ 17,389$ 17,562$ 19,018 <br /> <br /> = Effective Gross Rent$ 330,383 $ 333,687 $ 361,335 <br /> <br /> <br /> - Operating Exp (25%)$ 86,943$ 87,812$ 95,088 <br /> <br /> = NOI$ 243,440 $ 245,875 $ 266,247 <br /> <br /> - Debt Service$ 199,404 $ 199,404 $ 199,404 <br /> <br /> <br /> = CF$ 44,036$ 46,471$ 66,843 <br /> <br />Cash on Cash Return 3%3%4% <br /> <br /> <br />Value$ 3,246,000$ 3,278,000$ 3,550,000 <br /> <br />dsc 1.22 <br /> <br /> <br /> <br />S:\CMO\2012 Council Agendas\M120123\S1201235.doc <br />