FY 2020/2021 Q4 Review: Financial Highlights and Analysis

september 17 2021 n.w
1 / 33
Embed
Share

"Explore the detailed review of FY 2020/2021 Q4 results, including total year summary, Covid-19 impact, reclassification adjustments, operating results, PPP forgiveness, and more. Gain insights into sales, operating income, investments, and liabilities for informed decision-making."

  • Financial Analysis
  • Quarterly Review
  • FY 2020/2021
  • Business Performance
  • Investment

Uploaded on | 0 Views


Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.

E N D

Presentation Transcript


  1. September 17, 2021 FY 2020/2021 Q4 Review 1

  2. Total Year Summary Results Post Audit Audit Adjustments June and 4th Quarter Overview Key Activities Operating Statements Total Year Results Year-over-Year comparison Capital Expense & Investments Financial Statements Campus Contributions FY 2020/2021 Q4 Review 2

  3. Total Year Covid Impacted Results: Sales - $10,263,290 Operating Income (Before G&A/Invest.) ($2,559,373) Reported Net Contribution ($561,461) Benefited from PPP Loan forgiveness and Investments Operating Cash Flow of ($2,570,590) Net of second PPP loan funded March 2021 FY 2020/2021 Q4 Review 3

  4. Reclassification adjustments of $75,103 No Material Deficiencies Reported Done Done FY 2020/2021 Q4 Review 4

  5. June and 4th Quarter results mixed Ongoing low volume Operating Results Sales primarily limited to Bookstore activity at 50% Great Plates Program Terminated June/Q4 Sales of $60,316 and $157,926 respectively All Other Retail Food Sales $12,823 & $43,701 Strong Grad Commissions of $400K Non-Operating Gains and benefits Loan Forgiveness - $2M Investment Returns - $459K for the quarter FY 2020/2021 Q4 Review 5

  6. Paycheck Protection Program PPP Forgiveness Initial SBA Loan for $2M received in April 2020 Forgiven in Total on 6/11/2021 Reflected as Income in June Reduction in Liabilities Post Retirement Actuarial assessment Withdrew $400K in June Overfunded by $13K based on prior Actuarial Liability decrease of $643,465 from last year Benefitted from $1.4M investment gain Physical Inventory Minimal shrinkage $57K write-off against a $109K reserve FY 2020/2021 Q4 Review 6

  7. $500K Unemployment Insurance (UIP) accrual Self Insured through AORMA 5 year pay down at 3.5% interest CalPERS Actuarial impact of $1,024,129 Unfunded Liability up to $4,506,552 per GASB68 Did not fund contributions per 2019 BOD Plan Consider 2021/2022 catchup pending cash flow FY 2020/2021 Q4 Review 7

  8. June FY2020/2021 Actual Budget Variance $ $ $ $ $ $ $ $ $ $ $ Reported Sales Cost of Goods Gross Margin Operating Expenses Credit & Revenue Operating Income G&A Allocation PERS/UIP/VEBA adj Operating Contribution Other Income/Investments Reported Net Contribution $ $ $ $ $ $ $ $ $ $ $ 451,001 317,774 133,227 631,927 405,274 (93,426) 235,493 508,538 (837,457) 2,031,539 1,194,082 $ $ $ $ $ $ $ $ $ $ $ 738,619 431,870 306,749 781,958 284,877 (190,332) (130,463) (287,618) 114,096 (173,522) 150,031 120,397 96,906 (365,956) (508,538) (777,588) 2,001,539 1,223,951 -38.9% 29.5% 41.5% -56.6% 19.2% -20.7% 52.2% 112.8% -185.7% -25.8% -17.7% 0.0% -8.1% 50.9% - (59,869) 30,000 (29,869) -1298.8% 264.8% -4.0% 4097.7% FY 2020/2021 Q4 Review 8

  9. Actual 2,298,137 $ 1,295,927 $ 1,002,210 $ 1,915,543 $ $ (437,895) $ $ $ (1,637,169) $ 2,459,386 $ $ Budget 3,204,054 $ 1,590,913 $ 1,613,141 $ 2,706,091 $ 395,572 $ (697,378) $ 428,439 $ $ (1,125,817) $ $ (1,035,817) $ Variance Reported Sales Cost of Goods Gross Margin Operating Expenses Credit & Revenue Operating Income G&A Allocation PERS Accrual Adj. Operating Contribution Other Income/Investments Reported Net Contribution $ $ $ $ $ $ $ $ $ $ $ (905,917) 294,986 (610,931) 790,548 79,866 259,483 (262,297) (508,538) (511,352) 2,369,386 1,858,034 -28.3% 43.6% 50.3% -37.9% 475,438 -37.2% -61.2% 690,736 508,538 30.1% 22.1% -71.2% 13.4% 0.0% -35.1% - 45.4% 90,000 822,217 35.8% -32.3% -179.4% FY 2020/2021 Q4 Review 9

  10. Current Period - June 2021 Operating Income 193,619 $ (121,464) (176,160) (93,427) $ Budgeted Sales 671,400 $ 23,135 44,084 738,619 $ Budgeted Contribution 200,789 $ (84,726) (185,057) (59,869) $ Variance Operating Inc 51,317 $ (27,778) 70,450 96,905 $ Variance Net Contribution (589,362) $ (777,588) $ Sales Net Contribution (388,573) $ (172,827) (247,086) (28,971) (837,457) $ -185.7% 2,951,630 $ (920,091) $ 1,194,080 $ Budgeted O/I 142,302 $ (93,686) (246,610) (190,332) $ -25.8% Variance Sales (342,214) $ (19,109) (287,618) $ Bookstore/Comp Store Food Service/C-Stores Residential Dining ID Card Office Operating Contribution $ $ 329,186 66,729 30,111 24,975 451,001 43,594 30,111 (88,101) (62,029) (38,096) - 10,578 7,662 9,125 2,916 -20.7% -8.1% 15,000 15,000 (29,869) -4.0% 5.1% - - 96,905 5.1% -178% Corporate Income FMV Adjustment Net Contribution $ $ 738,619 $ - - $ $ $ $ $ (287,618) $ - - $ $ $ $ $ $ 2,936,630 (935,091) 1,223,949 268.8% $ $ - $ 451,001 (93,427) -20.7% (190,332) $ -25.8% 264.8% -38.9% FY 2020/2021 4th Quarter Results Operating Income 348,368 (265,079) (553,988) (437,895) $ Budgeted Sales 2,103,733 191,102 789,760 119,459 3,204,054 $ Budgeted Contribution (260,688) (342,617) (525,229) (1,125,816) $ Variance Operating Inc 332,665 50,397 (137,473) 13,893 259,482 $ Variance Net Contribution (341,044) (136,219) (511,353) $ Sales 1,827,422 201,627 170,806 98,282 2,298,137 Net Contribution (601,732) (348,205) (661,448) (25,784) (1,637,169) $ Budgeted O/I 15,703 (315,476) (416,515) 18,911 (697,377) $ Variance Sales (276,311) (618,954) (21,177) (905,917) $ Bookstore/Comp Store Food Service/C-Stores Residential Dining ID Card Office $ 10,525 (5,588) 32,804 2,718 (28,502) Total Div. 1 Corporate Income Div. 1 FMV Adjustment Net Operating Results $ $ $ - - $ - - 2,973,322 (513,936) 822,217 $ 3,204,054 $ - - (697,377) $ - - (1,035,816) $ 45,000 45,000 (905,917) $ - - 259,482 $ - - $ 2,928,322 (558,936) 1,858,033 2,298,137 (437,895) FY 2020/2021 Q4 Review 10

  11. Note: Budget assumed Spring in person classes Operationally and Volume challenged Sales down across all business units $6,776,884 (39.8%) below budget Withdrew $3.8M from Investments/Reserves Total Year Results much better than Planned Non-Core Business Benefits $489,867 Great Plates Sales $2M PPP Loan Forgiveness Aggregate Investment gains of $4.4M FY 2020/2021 Q4 Review 11

  12. June Y-T-D FY2020/2021 Actual 10,263,290 $ 6,288,271 $ 3,975,019 $ 8,021,775 $ 1,487,384 $ (2,559,372) $ 2,332,286 $ $ (5,400,196) $ 4,838,735 $ (561,461) $ Budget 17,040,174 $ 8,730,260 $ 8,309,914 $ 11,445,050 $ 1,324,948 $ (1,810,188) $ 2,879,203 $ $ (4,689,391) $ $ (4,329,391) $ Variance (6,776,884) $ 2,441,989 $ (4,334,895) $ 3,423,275 $ $ (749,184) $ $ (508,538) $ (710,805) $ 4,478,735 $ 3,767,930 $ Reported Sales Cost of Goods Gross Margin Operating Expenses Credit & Revenue Operating Income G&A Allocation PERS/UIP/VEBA adj Operating Contribution Other Income/Investments Reported Net Contribution -39.8% 38.7% 48.8% -52.2% 162,436 -24.9% 22.7% 5.0% -52.6% -10.6% 16.9% 0.0% -27.5% -41.4% 546,917 508,538 - 15.2% 360,000 -5.5% -25.4% 87.0% FY 2020/2021 Q4 Review 12

  13. Year to Date - June 2021 Operating Income 528,928 $ (1,105,639) (2,093,147) 110,485 (2,559,373) $ Budgeted Sales 11,657,182 $ 846,154 3,936,272 600,566 17,040,174 $ Budgeted Contribution (1,094,928) $ (1,516,306) (2,068,646) (9,511) (4,689,391) $ -27.5% 180,000 $ 180,000 $ (4,329,391) $ -25.4% Variance Operating Inc (345,952) $ 267,687 (689,643) 18,723 (749,185) $ -14.3% $ (749,185) $ -14.3% Variance Net Contribution (621,267) $ (307,384) (710,806) $ Sales 8,111,152 587,981 1,021,996 542,161 10,263,290 Net Contribution (1,716,195) $ (1,268,389) (2,376,030) (39,583) (5,400,197) $ Budgeted O/I 874,880 $ (1,373,326) (1,403,504) 91,762 (1,810,188) $ -10.6% $ (1,810,188) $ -10.6% Variance Sales (3,546,030) $ (258,173) (2,914,276) (58,405) (6,776,884) $ Bookstore/Comp Store Food Service/C-Stores Residential Dining ID Card Office Operating Contribution $ $ 247,917 (30,072) -24.9% -52.6% 3,055,858 $ 1,782,877 $ (561,463) $ -25% Corporate Income FMV Adjustment Net Contribution $ 17,040,174 $ - - - - $ (6,776,884) $ - - - - $ $ 2,875,858 1,602,877 3,767,929 19.9% $ 10,263,290 (2,559,373) $ -24.9% -5.5% -39.8% Note: $490K of Food Service Sales pertain to Great Plates Program FY 2020/2021 Q4 Review 13

  14. FY 2020/2021 Q4 Review 14

  15. Operating results behind last year Year vs full Covid Year Sales and Operating Income down across the board Sales down $18,372,953 (64.2%) Bookstore and Res Dining down 33% and 89% Retail Dining non-existent Margin rates down at 38.7% vs 54.3% Net Contribution up $1.7M Operating Expense down $7.7M (48.9%) Investments/PPP Loan up $4.0M FY 2020/2021 Q4 Review 15

  16. Year-To-Year Comparison YTD June 2021 10,263,290 $ 6,288,271 $ 3,975,019 $ 8,021,775 $ 1,487,384 $ (2,559,372) $ 2,332,286 $ $ (5,400,196) $ 4,838,735 $ (561,461) $ June 2020 28,636,243 $ 13,088,495 $ 15,547,748 $ 15,712,022 $ 1,972,387 $ 1,808,113 $ 3,711,762 $ $ (2,528,062) $ $ (2,240,505) $ Variance (18,372,953) $ 6,800,224 $ (11,572,729) $ 7,690,247 $ (485,003) $ (4,367,485) $ 1,379,476 $ $ (2,872,134) $ 4,551,178 $ 1,679,044 $ Reported Sales Cost of Goods Gross Margin Operating Expenses Credit & Revenue Operating Income G&A Allocation PERS/UIP/VEBA adj Operating Contribution Other Income/Investments Reported Net Contribution -64.2% 38.7% 54.3% -74.4% -24.9% 22.7% 5.0% -52.6% 6.3% 13.0% 2.2% -8.8% -241.5% 508,538 624,413 115,875 113.6% 287,557 -5.5% -7.8% -74.9% FY 2020/2021 Q4 Review 16

  17. Year to Year Comparison - June Pre-audit Year-to-Date June 2020 June 2021 Total Year Variance Operating Income 528,928 $ (1,105,639) (2,093,147) 110,485 (2,559,373) $ Operating Income 1,010,790 $ (1,136,942) 1,883,426 50,838 1,808,112 $ Net Variance Operating Inc (481,862) $ 31,303 (3,976,573) 59,647 (4,367,485) $ -31.3% $ (4,367,485) $ -31.3% Variance Net Contribution (891,296) $ (2,890,997) (2,872,133) $ Sales 8,111,152 587,981 1,021,996 542,161 10,263,290 Net Contribution (1,716,195) $ (1,268,389) (2,376,030) (39,583) (5,400,197) $ Sales 12,122,948 $ 6,984,271 9,037,346 491,678 28,636,243 $ Contribution (824,899) $ (2,194,519) 514,967 (23,613) (2,528,064) $ Variance Sales (4,011,796) $ (6,396,290) (8,015,350) (18,372,953) $ Bookstore/Comp Store Food Service/C-Stores Residential Dining ID Card Office Operating Contribution $ $ 926,130 50,483 (15,970) -24.9% - - -52.6% 3,055,858 $ 1,782,877 (561,463) $ 6.3% -8.8% 324,468 $ (36,911) $ (2,240,507) $ -43.8% 2,731,390 1,819,788 1,679,045 Div. 1 Corporate Income Div. 1 FMV Adjustment Net Contribution $ $ 10,263,290 $ - - $ (2,559,373) $ $ (18,372,953) $ - - - - $ $ 28,636,243 $ 1,808,112 $ -24.9% -5.5% 6.3% -7.8% -64.2% 2.4% FY 2020/2021 Q4 Review 17

  18. FY2020/2021 FY 2020/2021 Q4 Review 18

  19. Current Year Expenditures of $260,397 $32,523 IT Storage System $10,500 Bookstore ADA doors $23,980 Bookstore HVAC $96,750 Point of Sale PCI compliance ($121K Budget) $98,464 for Carts Prior year Budget of $160K 6 Pre-Covid build to order completed in March Cancelled last 3 FY 2020/2021 Q4 Review 19

  20. FY 2020/2021 EXPENDITURES FY2020/2021 Budget 37,000 $ 209,980 187,000 433,980 $ 160,000 593,980 $ Budgeted/ Carryover $ $ $ Unbudgeted $ Total 32,523 $ 34,480 103,004 170,007 $ 90,390 260,397 $ Variance $ 175,500 83,996 263,973 $ 69,610 333,583 $ Corporate Bookstore Food Service Subtotal Capital Budget Prior Year Carryover Unbudgeted Items Total Capital 32,523 34,480 103,004 170,007 90,390 - - 4,477 $ - - - - - - 260,397 $ - Carry Over - FY19/20 Residual Budget Electric Carts - 6 of 9 precovid Starbucks Minor Remodel $ 160,000 $ $ 98,464 (8,074) FY 2020/2021 Q4 Review 20

  21. Markets continued to grow during the quarter Q4 Investment gain of $448,548 MorganStanley up $502,591(5.3%) BIG (SMIF) up $39,406 (6.1%) up VEBA Trust gains of $396,362 (6.2%) Total Year gain of $4.4M Withdrawal of $3.8M to support operation $3.0M from Morgan Stanley $800K from VEBA Balance Sheet liability (actuarial) at Zero FY 2020/2021 Q4 Review 21

  22. Beginning Balance Advisory Fees Interest Income Fair Value Adjustment Deposits (Withdrawals) Month end Valuation Account# July August September October November December January February March April May June $ $ $ $ $ $ $ $ $ $ $ $ 10,185,250 10,647,664 11,126,616 10,933,377 10,811,948 8,841,925 9,217,368 9,195,352 9,429,664 9,538,375 9,860,314 9,951,774 $ $ $ $ $ $ $ $ $ $ $ $ $ (8,858) (1,251) (1,243) (9,543) (1,122) (944) (7,634) (749) (851) (7,920) (1,280) (1,363) (42,759) $ $ $ $ $ $ $ $ $ $ $ $ $ 19,168 18,155 21,744 9,357 16,431 49,210 9,566 10,748 14,288 9,425 11,229 16,690 206,010 $ $ $ $ $ $ $ $ $ $ $ $ $ 452,105 462,048 (213,739) (121,244) 1,014,668 327,177 (23,948) 224,313 95,274 320,434 81,511 73,866 2,692,465 $ $ $ $ (3,000,000) $ $ $ $ $ $ $ $ (3,000,000) $ - - - - $ $ $ $ $ $ $ $ $ $ $ $ 10,647,664 11,126,616 10,933,377 10,811,948 8,841,925 9,217,368 9,195,352 9,429,664 9,538,375 9,860,314 9,951,774 10,040,966 - - - - - - - Q4 Portfolio up $502,591 (5.3%) $3M withdrawn in support of operations YTD Portfolio up $2, 855,717 (Est 30.0%) FY 2020/2021 Q4 Review 22

  23. Interest/Capital Income (Re- invested) Beginning Balance Other & Settlements Adj. Realized Gain/Loss Unrealized Gain/Loss Month end Valuation Account# July August September October November December January February March April May June $ $ $ $ $ $ $ $ $ $ $ $ 522,998 543,929 570,852 555,740 548,190 603,606 623,726 619,922 629,958 641,976 665,128 656,573 $ $ $ $ $ $ $ $ $ $ $ $ $ - - - $ $ $ $ $ $ $ $ $ $ $ $ $ - - (64) $ $ $ $ $ $ $ $ $ $ $ $ $ 20,637 26,662 (16,537) (9,392) 55,168 18,414 (4,288) 17,530 11,050 22,170 (8,759) 23,765 156,420 $ $ $ $ $ $ $ $ $ $ $ $ $ 294 261 1,489 729 249 1,706 483 230 1,181 983 205 1,044 8,854 $ $ $ $ $ $ $ $ $ $ $ $ 543,929 570,852 555,740 548,190 603,606 623,726 619,922 629,958 641,976 665,128 656,573 681,382 8,568 - - - (7,724) (214) (7,456) - - - - - - - - (7,520) (0) 0 - 630 Portfolio up $39,406 (6.1%) for the Quarter Portfolio up $158,384 (30.3%) Year-to-Date FY 2020/2021 Q4 Review 23

  24. Summary Of Fund MARKET VALUE AS OF 03/01/2021 6 , 373 , 219 . 18 EARNINGS NET INCOME CASHRECEIPTS 8 ,529 . 98 FEES AND OTHER EXPENSES 2 , 382 . 19 - REALIZED GAIN OR LOSS 118. 14 UNREALIZED GAIN OR LOSS 22 , 012 .38 - TOTAL EARNINGS 15 , 746 . 45 - TOTAL MARKET VALUE AS OF 03/31/2021 Ending Asset Allocation 6 , 357 , 472 . 73 44. 9% 2, 854, 59 7. 72 MUTUAL FUND - DOMESTICEQUITY 35. 5% 2, 254, 91 9. 56 MUTUAL FUND - FIXED INCOME 11. 2% 710, 050. 75 MUTUAL FUND - INTERNATIONALEQUI 8. 4% 537, 904. 70 MUTUAL FUND - REAL ESTATE 100. 0% 6, 357, 47 2. 73 Total Investment gain of $396,362 6.2% for the 4th Quarter Total Year gain of $1,443,464 (23%) Withdrew $400K in June 2021for retiree medical Balanced overfunding and liability reporting FY 2020/2021 Q4 Review 24

  25. FY2020/2021 FY 2020/2021 Q4 Review 25

  26. Investment Report Cash/Investment Similar to last year at $15.4M Includes second PPP Loan of $2M $4.4M investment gain $3M Withdrawal from MorganStanley $800K ($400K * 2) VEBA withdrawal for retiree Medical Balance Sheet Inventory and A/R down $660K & $200K respectively Reduced business volume Liabilities Down $600K New PPP Loan and forgiveness netted out CalPERS up $650K, VEBA Down $643K Payroll & Other down $300K@ Cash Flow Statement June/YTD Cash Flow of negative $1.2M/$2.6M FY 2020/2021 Q4 Review 26

  27. **BALANCE** **INCOME/VALUATION ADJUSTMENTS** YEAR TO DATE June, 2021 CURRENT MONTH PRIOR YEAR TO DATE LAST MO. MAY 2021 CURR. MO. JUNE 2021 LAST YR. INTEREST FMV ADJ. INTEREST FMV ADJ. INTEREST FMV ADJ. CASH - WORKING CAPITAL Cash/Payroll Accounts CNB Business Ladder SUB-TOTAL CASH $ 4,054,391 408,264 $ 4,462,655 $ 2,285,319 2,408,291 $ 4,693,610 $ 3,093,862 1,407,973 $ 4,501,835 $ - 34 $ 34 $ - - 402 $ - $ 402 $ - $ - - 3,677 $ - $ 3,677 $ - $ $ - - - *DESIGNATED FUNDS Beach Investments Group - Wells Fargo Sick Leave Reserves Beach Club Deposits PERS Unfunded Liability SRB Funding - Outpost VEBA / Post Retirement Medical UDP Repair / Replacement SBA Loan Unemployment Insurance SUB-TOTAL DESIGNATED FUNDS $ 4,000,000 12,885,784 $ 656,781 768,432 400,000 3,482,423 3,178,148 400,000 $ 11,726,203 $ 681,590 520,000 447,862 4,506,552 3,070,339 $ 523,206 768,432 400,000 3,862,825 3,178,148 400,000 2,000,000 11,132,611 $ - - - - 2,000,000 499,860 - - $ - $ - $ - $ - $ - $ - **AUXILIARY FUNDS: BIG (SMIF) - Well Fargo Investment Brokers Allowance for Fair Market Value Investments - Offset / Fees Investments - Offset / Other Income SUB-TOTAL AUXILIARY FUNDS $ 4,077,824 (6,799,222) (2,277,228) $ - $ (5,614,832) (1,003,645) $ - $ 1,500,620 (2,179,624) (424,155) $ - 1,044 16,690 17,734 $ $ 23,765 $ 73,866 (1,363) 96,268 $ 8,854 206,010 214,864 $ $ 156,420 2,692,465 (42,759) 2,806,126 $ $ $ $ 11,228 254,849 $ (37,119) $ 10,747 (5,495) - (42,371) 444,170 460,860 4,150,327 254,849 - - - - - - - - - - - - - - - - - 266,077 TOTAL CASH/INVESTMENTS 15,071,211 $ 15,416,168 $ 15,210,291 $ 17,768 $ 96,268 $ 215,266 $ 2,806,126 $ $ 269,754 $ (37,119) VEBA (Off-Balance Sheet) Funded Amount $ $ 6,620,214 4,000,000 $ $ 6,353,835 4,000,000 5,710,371 $ 4,000,000 $ FY 2020/2021 Q4 Review 27

  28. LIABILITIES & NET ASSETS Current Liabilities Accounts Payable Accrued Payroll and Benefits Accrued Payroll Expenses Accrued Taxes (sales &w/h ) Other Accrued Liablities Total Current Liabilities ASSETS Current Assets Total Cash (269,665) 1,368,177 564,304 30,571 658,703 2,352,089 15,416,167 4,693,610 11,726,202 (1,003,646) Cash on hand and in commercial accounts Designated funds Savings and other investments Total Accounts Receivable 970,579 Long-Term Liabilities Accrued Post Retirement Benefits Bonds Payable 2236 - SBA LOAN #2 2303 - NOTES PAYABLE-CHANCELLORS OFFI PERS/PEPRA Unfunded Liability Total Long-Term Liabilities Total Inventory 1,031,915 (13,331) 5,057,531 2,000,000 3,057,531 4,506,552 9,550,751 Total Prepaid Expenses 50,798 Total Current Assets 17,469,459 Fixed Assets Total Fixed Assets Less Accumulated Depreciation Net Fixed Assets 25,547,387 (19,355,028) 6,192,359 TOTAL LIABILITIES 11,902,841 Net Assets Without Donor Restrictions Net Contribution YTD Fund Balance-Auxiliary Fund Balance-Designated Total Net Assets Without Donor Restrictions TOTAL ASSETS $ 23,661,818 (561,461) 11,916,638 403,800 11,758,977 TOTAL NET ASSETS 11,758,977 TOTAL LIABILITIES & NET ASSETS $ 23,661,818 FY 2020/2021 Q4 Review 28

  29. Actual Jul-20 Actual Aug-20 Actual Sep-20 Actual Oct-20 Actual Nov-20 Actual Dec-20 Actual Jan-21 Actual Feb-21 Actual Mar-21 Actual Apr-21 Actual May-21 Actual Jun-21 TOTAL YEAR FY20/21 REVENUES: TOTAL REVENUE $ 676,647 $ 2,268,784 1,063,809 $ $ 712,809 $ 467,842 $ 514,405 1,495,813 $ $ 745,289 1,031,702 $ $ 1,048,062 $ 869,238 $ 856,275 $ 11,750,675 $ $ $ 676,647 336,814 339,833 50.2% 431,516 2,268,784 1,608,163 660,621 29.1% 466,646 $ $ $ $ 1,063,809 $ 538,743 $ 525,066 $ $ $ $ 712,809 333,634 379,175 53.2% 495,229 $ $ $ 467,842 165,810 302,032 64.6% 408,077 $ $ $ 514,405 246,277 268,128 52.1% 406,913 1,495,813 $ 915,207 $ 580,606 $ $ $ $ 745,289 355,342 389,947 52.3% 400,621 1,031,702 $ 492,354 $ 539,348 $ $ $ $ 1,048,062 643,579 404,483 38.6% 461,407 $ $ $ 869,238 334,574 534,664 61.5% 407,466 $ $ $ 856,275 317,774 538,501 62.9% 408,667 $ $ $ 11,750,675 6,288,271 5,462,404 46.5% 5,243,967 OPERATING CASH IN: COST OF SALES COMBINED GROSS MARGIN 49.4% 459,724 38.8% 479,358 52.3% 418,343 $ $ $ $ $ $ $ $ $ $ $ $ LABOR COST & BENEFITS $ 180,027 $ 52,320 $ 139,992 $ 330,625 $ 146,973 $ 167,463 $ 78,923 $ 126,776 $ 114,742 $ 123,249 $ 115,864 $ 188,076 $ 1,765,030 OPERATING EXPENSE (NET DEP) 234,703 219,113 210,081 259,750 (183,271) 211,175 247,477 217,202 225,320 242,086 213,156 744,031 $ $ 2,840,823 GENERAL & ADMINISTRATIVE PERS\POST RETIREMENT MEDICAL GENERAL & ADMINISTRATIVE - $ 234,703 $ 219,113 $ 210,081 $ 259,750 $ (183,271) $ 211,175 $ 247,477 $ 217,202 $ 225,320 $ 242,086 $ 213,156 $ 744,031 2,840,823 1,183,060 $ $ 2,346,242 1,348,540 $ 1,419,238 $ $ 537,589 1,031,828 $ 1,720,965 $ $ 1,099,941 1,250,759 $ $ 1,470,321 1,071,060 $ $ 1,658,548 $ 16,138,091 OPERATING CASH OUT: $ (506,413) $ (77,458) $ (284,731) $ (706,429) $ (69,747) (517,423) $ $ (225,152) $ (354,652) $ (219,057) $ (422,259) $ (201,822) $ (802,273) $ (4,387,416) NET CONTRIBUTION W/O DEPR/INV OTHER CASH/NON-CASH IN/OUT(+) CAPITAL EXPENDITURES OUTPOST SRB PAYMENT PERS /FAS 106/IC UNEMPLOYMENT INS RESERVE VEBA ACTUARIAL ADJUSTMENT VEBA WITHDRAWAL INTEREST INCOME/NO FMV FAIR MARKET VALUE (GAIN)/LOSS SUBTOTAL OTHER IN/OUT(+) (463,884) (95,981) $ 7,040 - 380,402 $ 107,140 $ 2,541 - - - - - (23,302) 231,583 210,822 $ 42,587 (1,068,714) (983,127) $ 7,284 95,000 (344,647) (394,610) $ 970 - - - - - $ 8,623 - - - - - (10,065) 35,870 34,428 $ 2,438 - - - - - (10,991) (241,094) (249,647) (105,473) (80,559) $ 40,383 $ 262 - - - - - $ 3,327 - - - - - (11,468) (71,471) (79,612) 1,024,129 499,860 (643,647) (400,000) (17,768) (96,268) 393,594 $ 27,288 $ 249,883 95,000 1,404,531 499,860 (643,647) (400,000) (215,279) (2,807,174) (1,816,826) - - - - - - - - - - - - - - - - - - - - - - - (19,539) (18,488) (487,459) (398,807) (10,141) 139,067 171,513 (16,697) (50,933) (15,469) (10,418) (334,684) (344,840) 15,210,291 $ 1,087,079 $ (410,432) $ (410,432) $ $ $ $ OPENING CASH BALANCE TOTAL CASH OUT NET MONTHLY CASH FLOW CUMULATIVE CASH FLOW 1,947,435 321,349 (89,083) $ $ $ 1,559,362 $ (495,553) $ (584,636) $ 1,590,751 $ (877,942) $ (1,462,578) $ $ $ $ (445,538) 913,380 (549,198) 637,218 (122,813) $ (672,011) $ $ 1,755,393 (259,580) (931,591) 850,294 (105,005) (1,036,596) $ $ $ 1,170,200 $ (138,498) $ (1,175,094) $ 1,125,481 (77,419) (1,252,513) $ $ $ $ $ 991,448 (122,210) (1,374,723) $ $ 2,052,142 (1,195,867) $ (2,570,590) $ $ $ 14,321,265 (2,570,590) FY 2020/2021 Q4 Review 29

  30. FY 2020/2021 Q4 Review 30

  31. FY 2017/2018 Actual FY 2018/2019 Actual FY 2019/2020 Actual FY 2020/2021 Budget FY 2020/2021 Actual FY 2021/2022 Budget DESCRIPTION $ 267,167 1,361,508 625,806 765,557 3,020,038 $ $ 270,603 1,476,120 683,990 395,777 2,826,490 $ $ 291,950 1,162,175 721,553 142,655 2,318,333 $ $ $ 192,740 460,815 649,939 581,980 1,885,474 $ $ 95,659 127,224 492,368 34,480 749,731 $ $ 219,260 842,522 452,879 250,000 1,764,661 Donations Partnerships Reimbursed Services Capital Improvements Total Contributions FY 2020/2021 Q4 Review 31

  32. FY 2017/2018 Actual FY 2018/2019 Actual FY 2019/2020 Actual FY 2020/2021 Budget FY 2020/2021 Actual FY 2021/2022 Budget DESCRIPTION Donations Japanese Garden HFHM Chair Endowment BIG (SMIF) Bloomberg Terminal Scholarships - 49er Shops Student Presidents Scholars/Student Emergency 20,000 Promotions - Bookstore Res Halls Merit Scholar Meals Text Book Scholarships Misc Contributions - HFHM, Alumni, CCPA Total Donations $ $ - $ $ 134,049 270,603 $ - $ 100,000 - $ - $ - $ - - - - - 25,000 11,000 20,000 49,732 26,000 26,500 26,000 26,500 10,000 $ 11,000 10,000 $ 7,750 17,760 130,730 10,000 7,750 80,666 119,954 10,000 25,547 267,167 $ 17,760 155,000 10,000 140,100 61,909 10,000 20,822 $ 15,850 291,950 - $ - - 192,740 95,659 219,260 Partnerships Res Halls Commission Athletics - MOU - Pyramid/Blair Commissions - Royalties (LRG/CSTV) Print/Computer labs - ATS(Horn Center) - College of Business - Art Dept/Design/Learning Asst - Library Beach Hut Rent* Art Store Rent* S/U Conv Store-Rent Library Starbucks-Rent* Total Partnerships $ 786,901 $ 854,490 $ 703,130 $ 317,179 $ 71,608 $ 703,152 97,500 225,834 24,884 97,500 267,817 27,788 97,500 118,700 32,870 - - - - - - 30,000 32,909 31,000 26132 6723 81713 49018 6,000 18,000 26,803 12,000 1,361,508 1,476,120 $ 28,609 7,018 79,671 48,104 13,800 1,162,175 $ 18,905 4,897 89,854 35,763 13,800 $ 9,000 3,000 40,000 20,000 8,000 89 9,000 3,000 40,000 20,000 232 $ - - - 127,224 $ - $ - 29,123 22,200 24,556 22,200 10,320 23,316 460,815 186 14,170 22,200 842,522 22,200 FY 2020/2021 Q4 Review 32

  33. FY 2017/2018 Actual FY 2018/2019 Actual FY 2019/2020 Actual FY 2020/2021 Budget FY 2020/2021 Actual FY 2021/2022 Budget DESCRIPTION Reimbursed Services EO-1000 * ITS Network* Repairs Communications Centrally Paid Indirect Costs - CSU Utilities Supplies Total Reimbursed Services $ $ 103,453 71,301 18,195 80,096 44,085 277,768 30,908 625,806 $ $ 109,185 121,889 38,230 60,873 45,701 276,715 31,397 683,990 $ $ 109,185 102,706 16,279 60,903 45,550 360,547 26,383 721,553 $ $ 32,600 146,904 30,000 60,000 60,000 305,435 15,000 649,939 $ $ 32,611 156,304 9,453 45,772 46,343 190,180 11,705 492,368 $ $ 26,811 113,597 20,000 60,000 41,351 176,120 15,000 452,879 Capital Improvements Starbucks/Coffee House Dining Plaza Outpost renovation Bookstore USU C-Store/Blair/Pyramid Total Capital Improvements $ 765,557 $ 385,673 41,547 150,331 188,006 $ 395,777 $ 230,139 141,871 8,446 $ 25,185 59,480 27,431 30,559 $ $ 65,000 291,000 $ 75,000 125,000 20,000 30,000 - - 209,980 16,000 581,980 34,480 - 15,321 $ 142,655 $ 34,480 $ 250,000 $ 3,020,038 2,826,490 $ $ 2,318,333 $ 1,885,474 $ 749,731 $ 1,764,661 Total Contributions FY 2020/2021 Q4 Review 33

More Related Content