|
PNW Economics
<br />
<br />Page 5
<br />Prepared for: City of Eugene
<br />Prepared by: PNW Economics
<br />Response to MUPTE Citizen Advisory Committee Meeting #2 Questions
<br />
<br />
<br />
<br />REVISED Scenario 2: Applicant-Assumed Rent Income
<br />Applicant-Assumed Rent Income Without MUPTE
<br />
<br />Table 2 expresses the revised pro forma replacing Table 13 from the original MUPTE application
<br />review document. With corrected, lower operating expenses and corrected, higher absorption
<br />vacancy as explained:
<br />• The project continues to perform more poorly in Year 1 with estimated cash-on-cash
<br />return of -7.9% instead of only -5.1%.
<br />• Starting in Year 2, again the project does perform better with lower per-unit operating
<br />expenses, with cash-on-cash return of 5.4% and reaching the minimum benchmark of at
<br />least 6% by Year 3 instead of Year 4.
<br />• Without MUPTE, and very aggressively assuming the project earns all amenity rent
<br />premiums above market rents, the project suffers significant cash loss the first year and
<br />will not recover the loss until Year 3.
<br />
<br />Table 4 – Scenario 2 Pro Forma Without MUPTE: Market-Achievable Rents & Amenity Income (Replaces Review Table 13)
<br />
<br />
<br />
<br />
<br />Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
<br />2020 2021 2022 2023 2024 2025 2026 2027 2028 2029
<br />Apartment Rent Income $2,415,543 $2,488,010 $2,562,650 $2,639,529 $2,718,715 $2,800,277 $2,884,285 $2,970,814 $3,059,938 $3,151,736
<br />Retail Lease Income $296,654 $307,037 $317,784 $328,906 $340,418 $352,332 $364,664 $377,427 $390,637 $404,309
<br />Amenity Income $563,211 $580,107 $597,511 $615,436 $633,899 $652,916 $672,503 $692,678 $713,459 $734,863
<br />Misc. Income 4%$108,488 $111,802 $115,217 $118,737 $122,365 $126,104 $129,958 $133,930 $138,023 $142,242
<br />Gross Project Income $3,383,897 $3,486,956 $3,593,161 $3,702,609 $3,815,397 $3,931,629 $4,051,410 $4,174,849 $4,302,057 $4,433,150
<br /> - Stabilized Vacancy 5%($169,195) ($174,348) ($179,658) ($185,130) ($190,770) ($196,581) ($202,571) ($208,742) ($215,103) ($221,657)
<br /> - Absorption Vacancy & Concessions ($1,165,503) ($23,083) ($23,775) ($24,489) ($25,223) ($25,980) ($26,760) ($27,562) ($28,389) ($29,241)
<br /> Year 1 Absorption Vacancy 37%($1,090,255)$0 $0 $0 $0 $0 $0 $0 $0 $0
<br /> Year 1 Model Unit and Concessions ($75,248)($23,083)($23,775)($24,489)($25,223)($25,980)($26,760)($27,562)($28,389)($29,241)
<br /> = Effective Gross Income $2,049,198 $3,289,525 $3,389,728 $3,492,989 $3,599,404 $3,709,068 $3,822,080 $3,938,544 $4,058,565 $4,182,252
<br /> - Apartment Operating Expense ($456,348) ($764,630) ($787,569) ($811,196) ($835,532) ($860,598) ($886,416) ($913,008) ($940,399) ($968,611)
<br /> - Retail Operating Expense ($55,758) ($57,430) ($59,153) ($60,928) ($62,756) ($64,638) ($66,578) ($68,575) ($70,632) ($72,751)
<br /> + MUPTE $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br /> = Net Operating Income (NOI)$1,537,093 $2,467,465 $2,543,005 $2,620,865 $2,701,116 $2,783,831 $2,869,087 $2,956,961 $3,047,534 $3,140,890
<br /> - Debt Service (79% Loan-to-Cost)($2,087,537)($2,087,537)($2,087,537)($2,087,537)($2,087,537)($2,087,537)($2,087,537)($2,087,537)($2,087,537)($2,087,537)
<br /> = Before Tax Cash Flow ($550,444)$379,928 $455,468 $533,328 $613,579 $696,294 $781,550 $869,424 $959,997 $1,053,353
<br />Cash-on-Cash Return -7.9% 5.4% 6.5% 7.6% 8.8% 9.9% 11.2% 12.4% 13.7% 15.0%
<br />Value - 6% Cap Rate 6%$25,618,219 $41,124,410 $42,383,421 $43,681,088 $45,018,601 $46,397,186 $47,818,111 $49,282,678 $50,792,233 $52,348,163
<br />Maximum Private Loan (6% Interest)
<br />Loan-to-Cost (Applicant Plan)79%($27,000,000)
<br />Loan-To-Value 75%($30,843,307)$3,843,307 If negative, represents a gap in maximum debt due to insufficient NOI under Loan-to-Value method
<br />Debt Coverage Ratio 1.2 ($28,580,028)$1,580,028 If negative, represents a gap in maximum debt due to insufficient NOI under Debt Coverage Ratio method
<br />Total Development Cost $34,000,000
<br />Developer-Planned Equity (Total Cost Less Loan)$7,000,000
<br />October 17, 2018, Work Session – Item 2
|