|
EXHIBIT 2 – PHASED PROJECT
<br />
<br />Sources
<br />annual d/s
<br /> Equity $27,414,000 30%
<br /> Conventional Debt $63,966,000 70% $4,851,700
<br /> $91,380,000
<br />
<br /> WITHOUT MUPTE
<br />Pro-Forma
<br />The Phased Project pro-forma below is derived from applying a standardized set of assumptions to the developers provided information. (The
<br />assumptions are described in the financial analysis provided as Attachment F to the Agenda Item Summary for April 23 item number 4.)
<br />
<br />
<br />Without MUPTEYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
<br />
<br />
<br />
<br />Income$ 9,946,200$ 10,045,700$ 10,146,200$ 10,247,700$ 10,350,200$ 10,453,700$ 10,558,200$ 10,663,800$ 10,770,400$ 10,878,100
<br />
<br />
<br /> - Vacancy (6%)$ 602,400 $ 608,500 $ 614,500 $ 620,700 $ 626,900 $ 633,200 $ 639,500 $ 645,900 $ 652,300 $ 658,900
<br />
<br /> = Effective Gross Rent$ 9,343,800$ 9,437,200$ 9,531,700$ 9,627,000$ 9,723,300$ 9,820,500$ 9,918,700$ 10,017,900$ 10,118,100$ 10,219,200
<br />
<br />
<br /> - Operating Exp (32%)$ 2,990,000$ 3,019,900$ 3,050,100$ 3,080,600$ 3,111,400$ 3,142,500$ 3,174,000$ 3,205,700$ 3,237,700$ 3,270,100
<br />
<br />
<br /> = NOI$ 6,353,800$ 6,417,300$ 6,481,600$ 6,546,400$ 6,611,900$ 6,678,000$ 6,744,700$ 6,812,200$ 6,880,400$ 6,949,100
<br />
<br />
<br /> - Debt Service$ 4,851,700$ 4,851,700$ 4,851,700$ 4,851,700$ 4,851,700$ 4,851,700$ 4,851,700$ 4,851,700$ 4,851,700$ 4,851,700 Exhibit 2
<br />
<br />
<br /> = CF$ 1,502,100$ 1,565,600$ 1,629,900$ 1,694,700$ 1,760,200$ 1,826,300$ 1,893,000$ 1,960,500$ 2,028,700$ 2,097,400
<br />–
<br />Cash on Cash Return 5%6%6%6%6%7%7%7%7%8%
<br />
<br />Phased Project
<br />Value$ 87,639,000$ 88,514,000$ 89,401,000$ 90,295,000$ 91,199,000$ 92,110,000$ 93,030,000$ 93,961,000$ 94,902,000$ 95,850,000
<br />DCR 1.31
<br />
<br />
<br />
|