xSummary_Main (2)
10/21/2017 8:55 AM
CWU CHMP - Financial Planning Workbook v1.25
Current projections going forward. 89% occupancy ResHalls 85% Apts, 5% increase in housing, 4% in Dining. $1.75 in preservation. Projects shown through 2026, Welcome Center Construction Costs $7 mil beginning in the spring of 2017
New Hall at 400 Beds, Dining at 4% and Housing at 4% after 2018. 4.5% bond payment planning rate.
Go To Parameters
ALL FUND 573
Fiscal Year
2015
2016
2017
2020
2018
2019
2021
2022
2023
2024
2025
2026
2027
Fiscal Year
REVENUES Revenue (Res Halls) Revenue (Apartments)
14,970,648 4,140,680
18,503,000 4,694,000
15,743,000 4,750,000
15,537,000 4,513,000
19,089,000 19,573,000 20,351,000 21,507,000
22,030,000 22,914,000
24,543,000 5,682,000
11,656,992 3,729,331
13,293,759 4,205,884
4,883,000
5,080,000
5,280,000
5,492,000
5,711,000
5,939,000
Summer/Other Revenue (Res Halls) Summer/Other Revenue (Apartments) Revenue (Dining)
15,699,618 1,177,423
19,110,000 1,310,000
15,870,000 1,210,000
16,470,000 1,259,000
19,650,000 20,400,000 21,180,000 21,990,000
23,050,000 23,930,000
24,840,000 1,727,000
12,490,076 1,335,244
14,146,749 1,427,915
1,363,000
1,418,000
1,475,000
1,534,000
1,596,000
1,660,000
Revenue (Conf Ctr)
41,333
200,000
250,000
200,000
200,000
200,000
200,000
200,000
200,000
200,000
200,000
Revenue (Misc Ops [ex Interest Inc])
205,898
262,898
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
Revenue ADJS-Housing Revenue ADJS-Other
- -
- -
36,029,702
43,817,000
37,823,000
37,979,000
45,185,000 46,671,000 48,486,000 50,723,000
52,587,000 54,643,000
56,992,000
Total Revenue
29,417,542
33,337,205
yearly increase
-2.7%
13.3%
8.1%
5.0%
0.4%
15.4%
3.1%
3.3%
3.9%
4.6%
3.7%
3.9%
4.3%
OPERATING EXPENSES Operating Expenses (Res Halls) Operating Expenses (Apartments) Operating Expenses (Dining) Operating Expenses (Conf Ctr) Operating Expenses (Misc Ops)
9,165,438 3,085,886 11,789,338 1,156,318
10,870,000 3,448,000 14,895,291 1,349,000
9,001,000 3,563,000 12,369,538 1,270,000
9,315,000 3,348,000 12,838,230 1,309,000
10,551,000 10,494,000 10,806,000 11,496,000
11,410,000 11,753,000
12,512,000 3,932,000 19,362,992 1,662,000
6,927,475 2,860,749 10,020,118 1,201,095
7,652,985 2,338,390 11,033,766 1,347,163
3,552,000
3,661,000
3,772,000
3,883,000
3,997,000
4,119,000
15,316,435 15,900,583 16,507,242 17,137,287
17,963,584 18,650,040
1,390,000
1,432,000
1,475,000
1,520,000
1,566,000
1,613,000
172,867
243,101
200,000
231,525
255,256
268,019
281,420
295,491
310,266
325,779
342,068
121,286
191,774
25,369,848
30,805,392
26,403,538
27,041,755
31,064,691 31,755,602 32,841,663 34,331,778
35,246,849 36,460,819
37,811,060
Total Operating Expenses
21,130,723
22,564,077
12.4%
13.9%
4.1%
2.4%
0.8%
2.2%
3.4%
4.5%
2.7%
3.4%
3.7%
Change
-3.7%
6.8%
10,659,854
13,011,608
11,419,462
10,937,245
14,120,309 14,915,398 15,644,337 16,391,222
17,340,151 18,182,181
19,180,940
NET OPERATING INCOME
8,286,819
10,773,129
-1.1%
19.0%
7.1%
-4.2%
8.5%
5.6%
4.9%
4.8%
5.8%
4.9%
5.5%
Change
-0.1%
30.0%
NON-OPERATING
(1,444,207)
(1,400,000)
(1,444,207)
(1,400,000)
(1,400,000)
(1,400,000)
(1,400,000)
(1,400,000)
(1,400,000)
(1,400,000)
(1,400,000)
Administrative Charge
(1,444,205)
(1,444,207)
(445,813) (532,890) (725,779) (2,118,217) (1,961,580)
(441,813) (529,890) (725,885) (2,023,938) (2,589,682) (2,098,750) (8,409,957) (5,000,000) (964,688) (964,688)
Bond Payment (Sue) Bond Payment (Kamola) Bond Payment (SURC) Bond Payment (WHH) Bond Payment (Barto)
(453,189) (531,324) (737,258) (2,308,163) (2,125,384)
(445,813) (531,324) (737,258) (2,307,600) (1,965,829)
(450,063) (526,390) (726,364) (2,014,138) (2,011,866)
(443,563) (528,265) (726,045) (2,027,538) (2,008,432)
(444,563) (529,540) (725,832) (2,023,938) (2,591,267) (2,773,750)
(446,563) (528,890) (725,832) (2,027,338) (2,586,338) (2,770,000)
(447,813) (532,940) (725,832) (2,028,088) (1,810,062) (2,774,750)
(448,313) (531,540) (725,779) (2,026,088) (1,804,881) (2,772,500)
(446,113) (534,645) (726,290) (2,026,338) (1,803,920) (2,773,500)
(448,513) (531,483) (725,992) (2,028,588) (2,601,983) (2,772,500)
(445,313) (527,580) (725,949) (2,027,588) (2,600,699) (2,774,500)
-
-
-
-
-
Planned Bond Payment (NEW)
(5,784,278)
(5,728,820)
(5,733,842)
(9,088,889)
(9,084,960)
(8,319,484)
(8,309,100)
(8,310,805)
(9,109,057)
(9,101,628)
Sub-Total Bond Payments
(6,155,317)
(5,987,823)
-35.0%
Projects Funded From Reserves Preservation (CIDM)-Housing
-
-
(1,044,383) (614,310) (614,310)
(4,911,233) (875,000) (875,000)
-
(2,000,000) (1,012,922) (1,012,922)
(1,500,000) (1,063,568) (1,063,568)
(5,500,000) (1,116,746) (1,116,746)
(4,000,000) (1,172,584) (1,172,584)
(7,000,000) (1,231,213) (1,231,213)
(1,000,000) (1,292,774) (1,292,774)
(9,000,000) (1,357,412) (1,357,412)
(918,750) (918,750)
(646,973) (646,973) (372,344) (9,265,812)
(575,001) (575,001) (1,454,016) (10,036,049)
Preservation (CIDM)-Other
-
-
-
-
-
-
-
-
-
-
-
Other Non-Operating Expenditures
(9,501,488)
(16,739,332)
(13,834,261)
(8,971,342)
(14,514,733) (14,112,096)
(17,452,977) (16,054,268)
(19,173,230) (14,094,604)
(22,216,452)
Total Non-Operating
1,158,367 185,261
(3,727,725)
Net To (From) Reserves
(978,993) 228,378
737,080 240,145
(2,414,799)
1,965,903
(394,424) 200,000
803,302 200,000
(1,808,639)
336,954 200,000
(1,833,080)
4,087,577
(3,035,513)
200,000
Investment Earnings on Reserves
200,000
200,000
200,000
200,000
200,000
200,000
Reserve Balance
13,834,921 14,812,146 16,155,774
13,940,975 16,106,878 12,579,154 12,384,730 13,388,032 11,779,392 12,316,346 10,683,267 14,970,844 12,135,331
9.1%
-21.9%
Change
-5.1%
7.1%
-13.7%
15.5%
-1.5%
8.1% -12.0%
4.6%
-13.3%
40.1%
-18.9%
1.84
1.55
Debt Service Coverage Ratio Other Info Reserve Balance as % Debt Service
1.35
1.80
1.99
1.91
1.55
1.64
1.88
1.97
2.09
2.00
2.11
225%
247%
279%
243%
281%
150%
136%
147%
142%
148%
129%
164%
133%
8,409,957 4,169,196
9,088,889 3,295,841
9,084,960 4,303,072
8,319,484 3,459,908
8,309,100 4,007,246
8,310,805 2,372,462
9,109,057 5,861,787
9,101,628 3,033,703
Minimum Reserve Required
5,728,820 8,212,155
5,733,842 10,373,036
Max Amount available above MRR
Made with FlippingBook flipbook maker