Detailed 10 Year Housing Pro-Forma FY2017
FY2018
FY2019
FY2020
FY2025
FY2027
Operating Revenues - Housing Operating Revenues - Dining Other Revenues (Incl. conferences) Total Operating Revenues Operating Expenses - Housing Operating Expenses - Dining Other Expenses (Incl. conferences) Total Operating Expenses
$19,111,328 $20,493,000 $20,050,000 $23,197,000 $27,741,000 $30,225,000 $15,699,618 $15,870,000 $16,470,000 $19,110,000 $23,050,000 $24,840,000 $1,218,756 $1,460,000 $1,459,000 $1,510,000 $1,796,000 $1,927,000 $36,029,702 $37,823,000 $37,979,000 $43,817,000 $52,587,000 $56,992,000 (12,251,324) (12,564,000) (12,663,000) (14,318,000) (15,407,000) (16,444,000) (11,789,338) (12,369,538) (12,838,230) (14,895,291) (17,963,584) (19,362,992) (1,329,185) (1,470,000) (1,540,525) (1,592,101) (1,876,266) (2,004,068) (25,369,848) (26,403,538) (27,041,755) (30,805,392) (35,246,849) (37,811,060) 10,659,854 11,419,462 10,937,245 13,011,608 17,340,151 19,180,940 (1,444,207) (1,444,207) (1,400,000) (1,400,000) (1,400,000) (1,400,000) (1,228,619) (1,750,000) (1,837,500) (1,929,375) (2,462,426) (2,714,824)
Net Operating Income Insitutional Support Preservation Expenses Existing Debt Service New Debt Service Total Debt Service
Net Revenues before Debt Service
7,987,028
8,225,255
7,699,745
9,682,233 13,477,725 15,066,115
(5,784,278) (5,728,820) (5,733,842) (6,311,207) (5,537,304) (6,327,128)
(2,098,750) (2,773,500) (2,774,500)
(5,784,278) (5,728,820) (5,733,842) (8,409,957) (8,310,804) (9,101,628)
Net Revenues after Debt Service
2,202,750
2,496,435 45,000,000
1,965,903
1,272,276
5,166,921
5,964,488
Bond Proceeds
Major Capital Expenditures New Hall Other Renovation Projects
(45,000,000)
(1,044,383) (4,911,233)
0 (5,000,000) (7,000,000) (9,000,000)
Investment Earnings
185,261
200,000
200,000
200,000
200,000
200,000
Net change in Fund Balance
1,158,367 (2,414,798)
1,965,903 (3,727,724) (1,833,079) (3,035,512)
Ending Fund Balance
$16,155,774 $13,940,976 $16,106,879 $12,579,155 $10,683,268 $12,135,332 $10,371,496 $8,212,156 $10,373,037 $4,169,198 $2,372,464 $3,033,705
Amount Above Minimum Reserve
Debt Service Coverage
1.84
1.99
1.91
1.55
2.09
2.11
19
Made with FlippingBook flipbook maker