|
Rental Revenue Inflation
<br />Other Income Inflation
<br />Commercial Inflation (Every year)
<br />Inflation on Expenses
<br />Vacancy Rate
<br />Income
<br />Commercial Income
<br />Less: Vacancy
<br />Less: Expense on Vacancy
<br />Total Commercial Income
<br />Effective Gross income
<br />14. EHLERS
<br />City of Ramsey
<br />Oppidan Industrial - 60% PAYGO
<br />405,300 Sq. Ft. Industrial
<br />15-year operating Proforma
<br />3.00%
<br />3.00%
<br />3.00%
<br />2.00%
<br />5.00%
<br />2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
<br />Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
<br />2,563,523 2,640,428 2,719,641 2,801,230 2,885,267 2,971,825 3,060,980 3,152,809 3,247,394 3,344,815
<br />-128,176-132,021-135,982-140,062-144,263-148,591-153,049 -157,640 -162,370 -167,241
<br />O 0 0 0 0 0 0 0 0 0
<br />2,435,346 2,508,407 2,583,659 2,661,169 2,741,004 2,823,234 2,907,931 2,995,169 3,085,024 3,177,575
<br />2,435,346 2,508,407 2,583,659 2,661,169 2,741,004 2,823,234 2,907,931 2,995,169 3,085,024 3,177,575
<br />2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
<br />Expenses
<br />Year 1
<br />Year 2 Year 3
<br />Year 4 Year 5
<br />Year 6 Year 7
<br />Year 8 Year 9 Year 10
<br />Reserves
<br />Total Expenses
<br />O 81,060 81,060 81,060 81,060 81,060 81,060 81,060 81,060 81,060
<br />O 81,060 81,060 81,060 81,060 81,060 81,060 81,060 81,060 81,060
<br />Net Operating Income
<br />2,435,346 2,427,347 2,502,599 2,580,109 2,659,944 2,742,174 2,826,871 2,914,109 3,003,964 3,096,515
<br />TIF Payments
<br />14,272 136,049 194,587 194,587 194,587 194,587 194,587 194,587 194,587 0
<br />R:: c'„ICC'.a.a:S,..:��c'„�..,:.
<br />Debt Service
<br />Debt Service - Series A
<br />Debt Service - Series B
<br />Debt Service - Series C
<br />2,137,728 2,137,728 2,137,728 2,137,728 2,137,728 2,137,728 2,137,728 2,137,728 2,137,728 2,137,728
<br />O 0 0 0 0 0 0 0 0 0
<br />O 0 0 0 0 0 0 0 0 0
<br />Total Debt Service
<br />2,137,728 2,137,728 2,137,728 2,137,728 2,137,728 2,137,728 2,137,728 2,137,728 2,137,728 2,137,728
<br />Annual Debt Coverage
<br />114.59% 119.91% 126.17% 129.80% 133.53% 137.38% 141.34% 145.42% 149.62% 144.85%
<br />CASH FLOW AFTER FINANCING
<br />311,890 425,668 559,458 636,968 716,803 799,033 883,730 970,968 1,060,823 958,786
<br />Other Expenses Paid From Net Cash Flow
<br />O 0 0 0 0 0 0 0 0 0
<br />NET CASH TO DEVELOPER
<br />311,890 425,668 559,458 636,968 716,803 799,033 883,730 970,968 1,060,823 958,786
<br />Returns Analysis
<br />(Cash on Cash Annual Return
<br />Cash on Cash Average Annual Return
<br />(Cash on Cost Annual Return - With TIF
<br />Cash on Cost Annual Return - Without TIF
<br />Cash on Cost Average - With TIF
<br />Year
<br />2.92% 3.98% 5.24% 5.96% 6.71% 7.48% 8.27% 9.09% 9.93% 8.97%
<br />2.92% 3.45% 4.05% 4.53% 4.96% 5.38% 5.79% 6.21% 6.62% 6.86%
<br />5.73% 6.00% 6.31% 6.49% 6.68% 6.87% 7.07% 7.27% 7.48% 7.25%
<br />5.70% 5.68% 5.86% 6.04% 6.22% 6.42% 6.62% 6.82% 7.03% 7.25%
<br />5.73% 5.87% 6.01% 6.13% 6.24% 6.35% 6.45% 6.55% 6.66% 6.72%
<br />1 2 3 4 5 6 7 8 9 10
<br />
|