SLIDE 16 Page 16 of 28
ASSUMPTIONS Flat Enrollment Budget 2021-2022 Flat Enrollment Budget 2020-2021 Flat Enrollment Budget 2019-2020 Budget 2018-2019 Forecast 2017-2018 FY 2016-2017 UDG Students FTE 963 963 963 963 927 854 GRAD Students FTE 76 76 76 76 87 94 TOTAL Students Numbers FTE 1039 1039 1039 1039 1014 949 % of Students Increase FTE 0.00% 0.00% 0.00% 2.47% 6.85%
tuition Increase (except masters) 1.00% 1.00% 1.00% 2.22% 3.50% 3.50% Full Tuition 30,990 30,685 30,380 30,080 29,320 28,180 Annual Security fees 180 Total Summary without Restricted Funds P&L Flat Enrollment Budget 2021-2022 Flat Enrollment Budget 2020-2021 Flat Enrollment Budget 2019-2020 Budget 2018-2019 Forecast 2017-2018 FY 2016-2017
REVENUE
OPERATING REVENUE Undergraduate income 25,069,136 24,820,926 24,575,175 24,331,856 23,112,520 20,414,639 Summer Income 1,517,088 1,502,068 1,487,196 1,472,471 1,311,800 1,351,362 Masters Income 1,830,091 1,830,091 1,830,091 1,830,091 2,087,444 2,254,046 Other Student Income 536,066 530,758 525,503 520,300 501,423 451,637 Other Income 908,320 899,326 890,422 881,606 1,045,178 1,144,081 GIFTS & GRANTS TFAS 412,500 412,500 412,500 412,500 346,675 687,225 Release of Campaign Gift to finance double rents 175,138 185,066 OTHER INCOME Contingency & Depreciation 40,740 40,740 40,740 40,740 115,342 168,572 Currency Exchange Difference 617 16,764 TOTAL REVENUE 30,489,078 30,221,475 29,761,626 29,489,564 28,520,999 26,488,326
% of increase to previous year
1% 2% 1% 3% 8%
EXPENSES
COMPENSATION French Salaries 11,868,074 11,750,569 11,634,226 11,241,259 11,102,441 9,786,256 US Salaries 384,646 380,838 377,067 373,334 219,453 272,288 Taxes & Social Charges on Salaries 6,367,009 6,303,969 6,241,553 5,983,688 6,199,562 6,132,080 OTHER EXPENSES Premises 4,587,996 4,557,689 4,724,013 4,994,825 5,011,730 4,199,010 Exceptional lease amortization, financial costs and double rent covered by Release of Campaign Gifts 175,138 185,066 Conferences, Travel & Entertainement 874,519 865,861 857,288 848,800 671,630 553,898 Fairs, Advertising & Publications 383,679 379,880 376,119 372,395 343,305 283,641 Other costs 683,304 676,538 669,840 663,208 671,969 704,400 Contingency & Depreciation 2,015,370 1,920,455 1,788,548 1,555,589 1,114,809 997,137 Currency Exchange Difference 55,929 53,289 Books, Database & Cultural Program 1,574,990 1,559,396 1,543,957 1,528,670 1,353,155 1,333,351 Financial cost (other than buildings loans) 360,605 357,035 353,500 350,000 342,594 220,321 Honorariums 1,139,666 1,128,383 1,117,210 1,106,149 1,151,841 976,314 TOTAL EXPENSES 30,414,998 30,065,679 29,683,323 29,017,917 28,238,418 25,511,985
% of increase to previous year
1% 1% 2% 3% 11%
NET OPERATING RESULT (after use of restricted funds to finance double rent, moving expenses and QO interests) 74,080 155,796 78,304 471,647 282,581 976,341 NET OPERATING RESULT (Before use of Restricted Funds to finance Double Rents, Moving Expenses and QO Interests)
78,304 471,647 282,581 976,341
4Y P&L and CASH FORECAST 2017 - 2022
SLIDE 17 Page 17 of 28
ASSUMPTIONS Flat Enrollment Budget 2021-2022 Flat Enrollment Budget 2020-2021 Flat Enrollment Budget 2019-2020 Budget 2018-2019 Forecast 2017-2018 FY 2016-2017 Exceptional Costs Financed by Campaign Gifts (double rents, moving expenses, financial costs …)
NET OPERATING RESULT (Before use of Restricted Funds to Finance Renovation)
78,304 471,647 282,581 976,341 Campaign costs Financed directely by Gifts
- 64,660
- 64,660
- 64,660
- 64,660
- 501,156
- 387,625
Assets Financed by Restricted Gifts
Total Gifts used to finance the Campus Costs and campaign
- 239,798
- 249,726
- 64,660
- 3,758,288
- 501,156
- 3,054,209
TOTAL CASH RESTRICTED CASH BOSQUET CASH Letter of Credit CASH Operating CASH
CASH OPENING BALANCE 18,697,877 2,336,898 7,870,000 8,490,979 Cash from Operating Activities Net Result 282,581 282,581 Non Cashable Income . Release of provision for Depreciation & Amortization 115,342 115,342 Non Cashable Expenses . Accruals for Depreciation & Amortization 1,114,809 1,114,809 Working Capital Variation Allocation of YE Result to Management Designated Fund 1,430,653
Total Cash From Operating Activities 1,282,048 1,430,653
Cash From Restricted Funds Specific Activity Campaign New Gifts available for Campus Renovation 2,159,403 2,159,403 Other New Gifts (Campaign, Mellon,…) 1,710,055 1,710,055 Expenses Financed by Campus Funds
Expenses Financed by Campaign and Other Gifts (Mellon…)
Total Cash From Restricted Funds 2,488,899 2,488,899 Capital Expenditures Asset
Campus Renovation Quai d'Orsay
- 20,165,312
- 5,165,312
- 15,000,000
Total Cash from Capital Expenditures
- 20,596,903
- 5,165,312
- 15,431,591
Cash From Financing Activities Loan to finance the QO Purchase 15,000,000 15,000,000 Contractual Amortization of the 3 M€ Grenelle Loan
Contractual Amortization of the 15 M€ Fix Loan Quai Orsay
Total Cash From Financial Activities 14,223,314 14,223,314 TOTAL CASH CONSUMPTION OF THE YEAR
3,919,552
CASH CLOSING BALANCE 16,095,234 6,256,450 2,704,688 7,134,097
CASH FLOW FORECAST FY 17/18
CASH FLOW STATEMENT FORECAST GIFTS CONSUMPTIONS FOR THE CAMPUS PLAN MEANS OF FINANCING
SLIDE 23
Page 23 of 28
Campaign Expenses Budget - 25MGoal V May 18 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Campaign Totals
Fiscal Year 2014-15 2015-16 2016-17 2017-18 2018-19 2019-20 2020-21 2021-22 2022-23 Annual Campaign Cost € 62,795 € 126,849 € 322,965 € 523,856 € 514,368 € 514,368 € 514,368 € 514,368 € 514,368 € 3,608,305 Annual Campaign Costs Allocated to operating results € 87,360 € 514,368 € 514,368 € 514,368 € 514,368 € 514,368 € 2,659,200 Total Campaign Costs allocated to Campaign Revenue € 949,105
Comprehensive Campaign Revenue v. 03.18 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Campaign Totals
Dedicated to Campus Renovation ONLY Silent Phase
Fiscal Year 2014-15 2015-16 2016-17 2017-18 2018-19 2019-20 2020-21 2021-22 2022-23 Total Paid or Confirmed Pledges and Gifts 1,680,792.61 € 1,672,435.98 € 2,287,362.77 € 2,096,902.53 € 1,357,724.26 € 666,275.56 € 333,514.30 € 333,514.30 € 333,514.30 € 10,762,036.61 € Total Other Pending Pledges and Gifts 62,500.00 € 2,062,500.00 € 2,237,500.00 € 1,075,000.00 € 1,075,000.00 € 1,075,000.00 € 6,512,500.00 € Projected Annual Campaign Revenue 1,680,792.61 € 1,672,435.98 € 2,287,362.77 € 2,159,402.53 € 3,420,224.26 € 2,903,775.56 € 1,408,514.30 € 1,408,514.30 € 1,408,514.30 € 18,349,536.61 €
GLOBAL CHECK CAMPAIGN COSTS / RESTRICTED FUNDS
Annual Campaign Cost € 62,795 € 126,849 € 322,965 € 436,496 € 0 € 0 € 0 € 0 € 0 € 949,105 Other Costs Allocated to Campaign Revenue 64,660 64,660 64,660 64,660 64,660 64,660 64,660 64,660 € 517,283 TOTAL COSTS ALLOCATED TO THE CAMPAIGN € 62,795 € 191,509 € 387,625 € 501,156 € 64,660 € 64,660 € 64,660 € 64,660 € 64,660 € 1,466,388 Cumulated Costs Allocated to the Campaign € 62,795 € 254,304 € 641,930 € 1,143,086 € 1,207,747 € 1,272,407 € 1,337,068 € 1,401,728 € 1,466,388 CAMPAIGN GOAL € 26,007,211 € 26,007,211 € 26,007,211 € 26,007,211 € 26,007,211 € 26,007,211 € 26,007,211 € 26,007,211 € 26,007,211 € 26,007,211 CAMPAIGN PLEDGES € 13,494,711 € 13,494,711 € 13,494,711 € 13,494,711 € 13,494,711 € 13,494,711 € 13,494,711 € 13,494,711 € 13,494,711 € 13,494,711 In % of campaign Goal 0% 1% 2% 4% 5% 5% 5% 5% 6% In % of campaign Pledges or paid 0% 2% 5% 8% 9% 9% 10% 10% 11%
SLIDE 26
Page 26 of 28
5/1/2018 Budget 2022- 2023 Budget 2021-2022 Budget 2020- 2021 Budget 2019- 2020 Bdg 22-23 Bdg 21-22 Bdg 20-21 Bdg 19-20 Bdg 18-19 Bdg 17-18 Amelie Départ 12/18 28,997 69,592 67,696 68,174 72,090 60,873 Bosquet closed 188,629 450,000 Storage Garage université 4,909 6,962 4,328 2,165 Grenelle APEEL Saint-Jean 36,768 36,768 36,768 36,768 36,768 36,768 37,654 39,522 36,378 39,814 Grenelle APEEL Saint-Jean gde salle 8,200 Landrieu SCI Landrieu (loyer + charges) 332,520 332,520 332,520 332,520 332,520 332,520 334,078 331,698 333,459 326,997 Montessuy Congé pour fin Décembre 18 120,407 288,976 299,490 288,121 286,042 285,203 Pierre Villey possible rupture du bail sans préavis Fin 03/19 42,324 42,324 41,744 38,146 45,754 38,640 102 ST DO SCI Franques + ARIZONA (loyer + charges) 255,655 255,655 255,655 255,655 255,655 248,297 247,000 241,476 145,177 140,115 New ST DO Ground floor Arizona 340,080 340,080 340,080 340,080 340,080 56,680 118 ST DO closed 78,994 88,588 87,958 148 Université closed 1,239,592 1,023,100 80,011 Tour Maubourg CYS Loyer + Charges 836,860 836,860 836,860 836,860 836,860 827,865 769,809 837,842 107,281 Combes Genefim 1,021,864 1,021,864 1,021,864 1,023,592 1,025,211 1,026,850 1,029,490 966,558 924,546 912,294 Quai d'Orsay Financial cost only 165060 175,138 185,066 194,840 204,474 195,779 Grenelle Financial cost only 40584 44,868 49,068 53,169 57,183 61,111 59,882 3,029,391 3,043,753 3,057,881 3,073,484 3,280,478 3,186,762 2,891,752 4,137,085 3,263,572 2,424,070 1% inflation 72,075 54,056 36,038 18,019 Total rental costs 3,101,467 3,097,810 3,093,919 3,091,503 3,280,478 3,186,762 2,891,752 4,137,085 3,263,572 2,424,070 Other Premises in excess of Rent 1,681,977 1,665,324 1,648,836 1,632,510 1,714,347 1,824,968 1,307,313 1,324,848 959,970 790,132 TOTAL PREMISES BUDGETED (including double rents) 4,783,444 4,763,134 4,742,755 4,724,013 4,994,825 5,011,730 4,199,065 5,461,933 4,223,542 3,214,202 Other Premises in excess of Rent Security Costs 658,444 651,925 645,470 639,080 632,752 637,479 562,749 427,687 180,421 173,312 Maintenance, cleaning, heating … 634,915 628,629 622,405 616,242 610,141 493,919 485,111 449,524 370,720 383,260 Telephone & Internet 193,296 191,383 189,488 187,612 185,754 176,217 104,869 193,809 174,225 110,173 Insurance & local taxes 195,321 193,387 191,473 189,577 187,700 255,953 154,584 114,615 143,011 123,387 Moving expenses allocated or not to Building fund 98,000 104,122 91,593 Exceptional QO Overage allocated to P&L 261,400 35,091 Total Other Premises 1,681,977 1,665,324 1,648,836 1,632,510 1,714,347 1,824,968 1,307,313 1,324,848 959,970 790,132 Allocated to building fund Rent allocated to Building fund 1,239,592 Moving expenses 104,122 Dommage ouvrage 35,091 Financial costs allocated to building fund 165,060 175,138 185,066 165,060 175,138 185,066 1,378,805 165,060 175,138 185,066 TOTAL PREMISES BUDGETED WITHOUT DOUBLE RENT 4,618,384 4,587,996 4,557,689 4,724,013 4,994,825 5,011,730 4,199,065 4,083,128 4,223,542 3,214,202 2013-2014 Budget 2018- 2019 2014-2015 2015-2016 Forecast 2017- 2018 2016-2017