Financial Review and History of Ranch Programs

Slide Note

Explore the financial review and history of programs at the Ranch, including key acquisitions, revenue breakdown, expenses, and net outcomes. Understand the Board's interest in financials and ongoing efforts on future planning and decision-making.

coombes_f Follow

Uploaded on Oct 04, 2024 | 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. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

E N D

Presentation Transcript

July 11, 2023

Why we are doing this? Normal review of programs Interest by the Board in the financials of the Ranch What have we done so far? Presented facts 10/29/2019, 4/5/2022,1/24/2023, and 4/25/2023 Preparation of a 4-year instructional plan Research options Plan for tonight Hear feedback Review financials Present the instructional plan Review optional actions Allow the Board to discuss and decide the future

History of the Purchase April 12, 2002 Purchased 147.77 Acres for $750,000 (lower section) July 30, 2003 Purchased 49.39 Acres for $1,250,000 (upper section)

PUBLIC COMMENTS

Financial Review Vet Tech (6/15/23) 2023 Revenue Vet Tech State Funding $53,349 $53,349 Vet Tech Tuititon & Fees $67,491 $110,797 Non-Department Courses (estimate) $66,608 $66,608 SUBTOTAL $187,448 $230,754 2022 2021 2020 2019 2018 2017 2016 2015 2014 $39,088 $85,131 $66,608 $190,827 $42,557 $90,643 $66,608 $199,808 $53,014 $114,995 $66,608 $234,617 $66,648 $76,360 $66,608 $209,616 $88,428 $119,896 $66,608 $274,932 $68,619 $99,848 $66,608 $235,075 $87,212 $147,318 $66,608 $301,138 $97,377 $154,215 $66,608 $318,200 Personnel Expenses Vet Tech Program : Full Time Vet Tech Program : Substitute Pay Vet Tech Program : Part Time Vet Tech Program : Overload Vet Tech Program : Summer Non-Department Courses (estimate) Estimated Benefits $172,711 $10,230 $191,140 $7,684 $182,572 $178,997 $167,802 $177,787 $171,543 $164,798 $166,975 $168,621 $0 $0 $0 $28 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $84 $0 $126 $7,289 $33,950 $44,256 $33,560 $286,984 $3,982 $5,867 $44,256 $34,542 $271,671 $7,588 $24,859 $44,256 $38,228 $313,755 $6,927 $17,850 $44,256 $36,514 $288,120 $7,438 $30,290 $44,256 $35,799 $296,808 $7,132 $32,488 $44,256 $35,557 $297,221 $6,926 $40,117 $44,256 $34,309 $297,151 $8,704 $27,142 $44,256 $32,960 $277,860 $6,720 $15,909 $44,256 $33,395 $267,255 $5,268 $12,337 $44,256 $33,724 $264,206 SUBTOTAL Other Expenses Vet Tech Program : Central Duplicating Vet Tech Program : Other - Supplies Vet Tech Program : Postage Vet Tech Program : Film Badges Vet Tech Program : Accreditation Vet Tech Program : Travel Vet Tech Program : Travel-Instruction Vet Tech Program : Non Travel Related Meals Vet Tech Program : Insurance-HC Vet Tech Program : Instructional Vet Tech Program : Student Tracki Vet Tech Program : Student Testing Vet Tech Program : Required Tech Vet Tech Program : Other Expenses #1 Vet Tech Program : Other Expenses #2 $527 $398 $29 $392 $1,745 $569 $22 $589 $200 $1,194 $378 $74 $745 $3,155 $430 $134 $166 $400 $840 $2,172 $136 $1,483 $2,945 $830 $1,267 $23,425 $1,612 $26,739 $109 $572 $2,500 $1,499 $1,205 $27,113 $1,538 $23,917 $103 $3,029 $28,802 $339 $3,398 $29,125 $137 $21,281 $154 $402 $3,035 $59 $348 $4,745 $1,649 $104 $70 $286 $4,245 $2,252 $164 $0 $0 $0 $0 $0 $2,577 $688 $238 $0 $0 $73 $276 $334 $2,000 $1,360 $6,067 $9,352 $58 $0 $0 $260 $0 $0 $0 $4,843 $4,998 $3,456 $74 $0 $511 $0 $2,000 $1,320 $10,341 $0 $0 $0 $0 $0 $0 $0 $170 $0 $0 $0 $9,367 $3,503 $501 $0 $0 $0 $9,543 $450 $0 $0 $0 $5,583 $620 $40 $0 $0 $7,709 $759 $0 $0 $0 $4,632 $0 $0 $0 $2,000 $1,815 $8,339 $10,380 $9,690 $36,695 $308,366 $2,635 $11,065 $10,960 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 SUBTOTAL $31,336 $345,091 $27,038 $315,158 $30,863 $327,671 $44,637 $331,621 $47,277 $344,497 $45,380 $342,530 $35,094 $312,953 $45,537 $312,792 $41,507 $305,713 TOTAL EXPENSES NET ($120,918) ($114,337) ($124,331) ($127,863) ($97,004) ($134,881) ($67,598) ($77,878) ($11,654) $12,487

Data Vet Tech Fall 2022 Fall 2021 Fall 2020 Fall 2019 Fall 2018 Fall 2017 Fall 2016 Fall 2015 Fall 2014 Student Data Headcount Average Class Size 23 39 12 29 31 11 38 13 46 14 45 40 11 47 12 9 9 9 22-23 21-22 20-21 19-20 18-19 17-18 27 40 38 14 23 12 - - 86% 100% 16-17 15-16 14-15 117 21 83% 100% Majors Graduates Placement Rates 54 23 44 17 64 27 73 20 143 24 96% 93% 93% Fall 2022 Fall 2021 Fall 2020 Fall 2019 Fall 2018 Fall 2017 Fall 2016 Fall 2015 Fall 2014 Faculty Data Full-Time Faculty Part-Time Faculty 2 1 3 1 3 1 3 1 3 1 3 1 3 1 3 1 3 1

Financial Review Agriculture (6/15/23) 2023 2022 2021 2020 2019 2018 2017 2016 2015 2014 Revenue Agriculture State Funding Agriculture Tuition Non-Department Courses (estimate) $8,835 $20,294 $10,618 $39,747 $8,835 $23,027 $10,618 $42,480 $11,031 $29,466 $10,618 $51,115 $10,436 $26,877 $10,618 $47,931 $10,404 $24,215 $10,618 $45,237 $15,483 $35,775 $10,618 $61,876 $16,428 $38,275 $10,618 $65,321 $10,683 $23,223 $10,618 $44,524 $16,015 $32,050 $10,618 $58,683 $21,673 $43,024 $10,618 $75,315 SUBTOTAL Personnel Expenses Agriculture Sciences : Full Time Agriculture Sciences : Faculty Stipends Agriculture Sciences : Part Time Agriculture Sciences : Overload Non-Department Courses (estimate) Estimated Benefits $3,918 $0 $0 $16,135 $39,507 $1,790 $7,531 $45,397 $500 $3,332 $1,035 $7,908 $9,079 $67,251 $51,766 $500 $3,266 $860 $7,908 $10,353 $74,653 $59,532 $600 $3,171 $4,175 $7,908 $11,906 $87,292 $24,917 $63,746 $53,237 $0 $0 $0 $0 $0 $0 $0 $0 $9,082 $13,211 $12,826 $0 $0 $0 $0 $9,002 $7,908 $4,983 $46,811 $5,543 $7,908 $12,749 $89,946 $7,567 $7,908 $10,647 $79,359 $7,908 $784 $21,691 $7,908 $7,908 $3,227 $40,095 $7,908 $7,901 $64,638 $0 SUBTOTAL $21,119 Other Expenses Agriculture Sciences : Central Duplicating Agriculture Sciences : Other - Supplies Agriculture Sciences : Postage Agriculture Sciences : Travel Agriculture Sciences : Eq.>5000 $104 $199 $0 $0 $0 $303 $75 $214 $0 $0 $0 $289 $16 $42 $90 $31 $53 $612 $7,100 $12 $237 $1,334 $1,253 $12,425 $7,773 $61 $1,739 $9,818 $6,567 $23 $3,822 $16,755 $0 $0 $0 $0 $0 $0 $0 $85 $0 $2 $0 $0 $6 $4 $1,200 $9,550 $18,468 $65,279 $5,799 $0 $0 $0 SUBTOTAL $1,350 $41,445 $1,295 $65,933 $12,600 $79,851 $9,603 $84,257 $9,873 $97,165 $10,424 $100,370 $22,795 $102,154 TOTAL EXPENSES $21,994 $21,408 NET $17,753 $21,072 $9,670 ($18,002) ($34,614) ($22,381) ($31,844) ($20,755) ($41,687) ($26,839)

Data Agriculture Fall 2022 Fall 2021 Fall 2020 Fall 2019 Fall 2018 Fall 2017 Fall 2016 Fall 2015 Fall 2014 Student Data Headcount Average Class Size 17 10 29 15 29 17 33 8 35 13 46 17 38 15 20 13 27 10 22-23 21-22 20-21 19-20 18-19 17-18 16-17 15-16 14-15 37 46 35 46 2 2 0 2 Majors Graduates 27 1 38 3 64 0 66 1 61 2 Fall 2022 Fall 2021 Fall 2020 Fall 2019 Fall 2018 Fall 2017 Fall 2016 Fall 2015 Fall 2014 Faculty Data Full-Time Faculty Part-Time Faculty 1 1 0 2 0 2 2 1 2 1 2 1 1 1 0 2 1 1

Financial Review Continuing Education (6/15/23) 2023 2022 2021 2020 2019 2018 2017 2016 2015 2014 Revenue Tuition CE Reg Bill : Ranch Progr Oth fees CE Reg bill : Ranch Prog Other Income : Special Events Misc Fees CE Reg Bill; Ranch Progr $5,971 $3,912 $30,730 $162,349 $202,961 $7,001 $9,768 $34,705 $170,053 $221,527 $6,561 $161,433 $29,005 $1,675 $198,674 $3,963 $112,617 $24,115 $5,842 $154,036 $79,943 $6,576 $172,637 $4,753 $154,936 $2,350 $6,730 $136,995 $1,650 $4,258 $110,061 $3,242 $85,339 $2,100 $0 $0 $0 $0 $0 $0 $0 $0 $0 SUBTOTAL $140,695 $239,821 $179,213 $162,039 $145,375 $114,319 $90,681 Personnel Expenses Ranch Programs : CE: Part-time Ranch Programs : Professional Salaries Ranch Programs : Miscellaneous Salaries Ranch Programs : Non-Work Study Estimated Benefits $61,438 $44,852 $101 $93,218 $52,560 $10,319 $84,366 $49,777 $9,640 $63,255 $48,952 $9,251 $79,949 $45,862 $9,978 $60,735 $40,069 $11,923 $435 $20,161 $133,323 $59,638 $69,723 $50,421 $70,505 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,657 $0 $0 $0 $0 $0 $0 $21,258 $127,649 $29,156 $185,253 $26,828 $170,611 $22,441 $143,900 $25,162 $160,952 $11,928 $79,223 $13,945 $83,667 $10,084 $60,506 $14,101 $84,606 SUBTOTAL Other Expenses Ranch Programs : Central Duplicating Ranch Programs : Other - Supplies Ranch Programs : Postage Ranch Programs : Dues and Memberships Ranch Programs : Travel Ranch Programs : Advertising Ranch Programs : Other Expenses $0 $0 $0 $82 $86 $234 $75 $0 $21 $17 $37,466 $150 $285 $2,238 $1,500 $13,241 $54,879 $182,528 $58,482 $275 $52,071 $158 $35,163 $180 $33,740 $163 $40,732 $165 $28,550 $233 $23,832 $20,688 $122 $16,754 $27 $0 $362 $0 $0 $13 $0 $0 $0 $0 $0 $95 $162 $1,000 $11,486 $64,973 $235,584 $0 $0 $0 $0 $0 $0 $0 $0 $968 $1,500 $13,614 $74,839 $260,092 $2,118 $1,500 $8,397 $47,439 $191,339 $1,172 $10,651 $10,651 $56,463 $217,415 $982 $180 $0 $175 $0 $0 SUBTOTAL $42,294 $175,617 $29,033 $108,255 $24,222 $107,889 $20,831 $81,337 $16,784 $101,390 TOTAL EXPENSES NET $20,433 ($38,565) ($36,909) ($50,644) $22,406 $3,596 $53,783 $37,486 $32,982 ($10,709)

Financial Review Operations (6/15/23) 2023 2022 2021 2020 2019 2018 2017 2016 2015 2014 Revenue Other Income : Horse Boarding Other Income : Ranch Facility Ren Other Income : Ranch Residence re Other Income : Ranch: Sale of Liv $113,615 $138,337 $141,298 $143,503 $135,630 $126,906 $130,425 $114,158 $1,400 $19,100 $83,425 $875 $17,450 $77,511 $1,025 $19,800 $500 $98,836 $0 $0 $0 $0 $0 $0 $0 $13,600 $21,050 $16,500 $19,430 $11,600 $19,600 $21,150 $0 $0 $0 $0 $0 $0 $0 $25 $0 SUBTOTAL $127,215 $159,387 $157,798 $162,933 $147,230 $146,506 $151,575 $134,683 $101,750 Personnel Expenses Horse Boarding : Professional Salaries Horse Boarding : Support Staff Salaries Horse Boarding : Miscellaneous Salaries Highlander Ranch : Support Staff Highlander Ranch : Miscellaneous Ranch Administration : Professional Ranch Administration : Support Staff Estimated Benefits $33,432 $559 $24,442 $59,016 $42,152 $4,599 $24,163 $63,441 $40,061 $7,081 $17,271 $61,348 $39,371 $14,436 $9,397 $82,915 $37,247 $11,092 $11,140 $71,192 $2,342 $34,488 $10,307 $12,630 $59,680 $4,273 $48,485 $14,502 $4,287 $64,689 $34,334 $13,804 $37,316 $13,844 $3,006 $42,255 $23,596 $13,117 $780 $48,464 $0 $53,089 $5,276 $84,529 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $83,492 $25,210 $40,423 $245,546 $81,855 $24,731 $38,353 $230,897 $15,892 $24,073 $161,343 $14,437 $28,422 $174,821 $0 $18,601 $136,050 $22,039 $156,395 $21,698 $147,459 $27,345 $173,464 $23,906 $156,919 $37,151 $228,183 SUBTOTAL Other Expenses Horse Boarding : Other - Supplies Horse Boarding : Postage Horse Boarding : Telephone Cell Horse Boarding : Travel Highlander Ranch : Other - Supplies Highlander Ranch : Utilities Highlander Ranch : Other Expenses Highlander Ranch : Eq.>5000 Ranch Administration : Central Duplicating Ranch Administration : Other - Supplies Ranch Administration : Telephone Ranch Administration : Travel Ranch Administration : Required T $46,577 $43,098 $51,924 $38,806 $45,883 $54,667 $46,797 $56,111 $146 $49,243 $139 $198 $31,925 $0 $0 $0 $0 $0 $0 $37 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $99 $470 $0 $5,437 $50,704 $56,820 $0 $143 $1,946 $30,282 $38,761 $176 $1,957 $33,301 $47,274 $181 $0 $4,574 $38,950 $84,458 $7,306 $38,447 $72,079 $12,885 $46,614 $79,519 $9,619 $41,308 $64,506 $9,882 $39,057 $74,575 $11,047 $43,085 $61,614 $9,500 $13,025 $44,425 $59,096 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $25 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $24 $733 $600 $0 $120 $1,541 $704 $1,058 $600 $816 $120 $168,720 $414,266 $2,109 $55 $583 $120 $148,322 $379,219 $650 $0 $0 $0 $0 SUBTOTAL $117,709 $253,759 $125,805 $282,199 $179,943 $327,401 $156,637 $330,101 $184,926 $341,845 $172,345 $333,688 $170,961 $345,782 $183,159 $411,342 TOTAL EXPENSES NET ($126,544) ($122,812) ($169,603) ($167,167) ($194,615) ($187,181) ($194,208) ($276,659) ($312,515) ($280,383)

Complete Ranch - Financial Review (6/15/23) 2023 $202,961 $127,215 $187,448 $39,747 $557,371 SUMMARY Revenue Continuing Education Operational Veterinary Technology Agriculture TOTAL 2022 2021 2020 2019 2018 2017 2016 2015 2014 $221,527 $159,387 $230,754 $42,480 $654,149 $198,674 $157,798 $190,827 $51,115 $598,415 $140,695 $162,933 $199,808 $47,931 $551,367 $239,821 $147,230 $234,617 $45,237 $666,905 $179,213 $146,506 $209,616 $61,876 $597,211 $162,039 $151,575 $274,932 $65,321 $653,867 $145,375 $134,683 $235,075 $44,524 $559,657 $114,319 $101,750 $301,138 $58,683 $575,891 $90,681 $98,836 $318,200 $75,315 $583,032 Expenses Continuing Education Operational Veterinary Technology Agriculture Insurance Costs (Estimated) TOTAL $2,022 $182,528 $253,759 $308,366 $21,994 $14,117 $780,764 $2,022 $260,092 $282,199 $345,091 $21,408 $12,833.87 $921,624 $2,021 $235,584 $327,401 $315,158 $41,445 $11,667 $931,255 $2,020 $191,339 $330,101 $327,671 $65,933 $11,317 $915,043 $2,019 $217,415 $341,845 $331,621 $79,851 $10,752 $970,732 $2,018 $175,617 $333,688 $344,497 $84,257 $10,215 $938,058 $2,017 $108,255 $345,782 $342,530 $97,165 $9,705 $893,733 $2,016 $107,889 $411,342 $312,953 $65,279 $9,220 $897,463 $2,015 $81,337 $414,266 $312,792 $100,370 $8,759 $908,765 $2,014 $101,390 $379,219 $305,713 $102,154 $8,322 $888,476 Net ($223,393) ($267,476) ($332,841) ($363,676) ($303,826) ($340,847) ($239,867) ($337,806) ($332,874) ($305,444) Additional Expenses Capital Improvement Fund 2023 $0 2022 2021 2020 2019 2018 2017 2016 $0 2015 $0 2014 $0 $30,028 $19,290 $35,010 $45,737 $191,814 $70,165 Net (with Capital Improvement Fund) ($223,393) ($297,504) ($352,131) ($398,686) ($349,563) ($532,661) ($310,032) ($337,806) ($332,874) ($305,444) *Total Capital Improvements since 2002 - $682,714

Instructional Four Instructional Four- -Year Strategic Plan for the Ranch Strategic Plan for the Ranch Year

Strengths and Opportunities Ranch offers the College and the Community: The perfect base for hands-on learning for a variety of programs Established relationships with the community Successful, established programs with dedicated staff Established relationships with local and regional leaders in agriculture and veterinary technology Cross-institution collaboration is already established and functioning Absence of significant agriculture-based programming for community and credit courses at Temple, Hill, and Navarro Colleges Waco is home to large, national food manufacturers that need training and workers New state funding model incentivizes workforce and community programs, collaboration with peer institutions, and expansion of pathways with universities and business/industry

Weaknesses and Challenges Ongoing maintenance requirement and deferred maintenance items need attention Veterinary Technology program expense driven by required standards for accreditation and animal welfare Limited direct, targeted marketing for Ranch offerings Expanding and adding programs requires updates and new structures and take time to establish Retention of current boarders and development of new equine programs and partnerships are challenging Competition from other educational institutions Ranch property is very attractive to individuals and private investors

Phase I 2023-24 Form a Ranch Advisory Local and regional leaders in agriculture and food science as well as education and industry partners Identify local workforce training needs Re-introduce popular sustainable agriculture course to Ranch through continuing education Increase Ranch usage by existing academic/workforce programs (i.e., Biology and Environmental Sciences) Increase marketing of Vet Tech, Vet Assistant, Agriculture, and the Ranch to the Community Review expenses and contracts in Vet Tech Program for savings

Phase I 2023-24 (Continued) Apply for USDA NIFA Workforce Training Grant (Dec 2023) to meet workforce training need Increase Ranch staffing (two part-time barn attendants and one full-time riding specialist) to support: Expand horse riding lessons to meet community demand Expand boarding capacity with 10 new stalls and an additional pasture Estimated initial outlay of $110,794.

Phase II 2024-25 Begin transition of sustainable agriculture from non-credit training to credit training. Add continuing education training in equine management and natural resource (water and soil conservation) management. Move Vet Tech to a hybrid/online model Explore alternative usage of open acreage with Texas AgriLife, state, and federal agriculture programs such as establishing natural habitats and conservation plots with possible research opportunities. Open a pet wellness clinic for faculty, staff, and students Expand boarding capacity with 5 new stalls Estimated initial outlay of $6,127.

Phase III 2025-2027 Continue to expand educational credential offerings in natural resource management and equine management Work with local agricultural and food science businesses to meet workforce training needs Partner with universities to use Ranch as a teaching site for upper-level courses Continue to seek grants to support new programs Develop an equine cross-country course, dressage arena, and concession area to host more shows and clinics Estimated initial outlay of $15,500

Financial Analysis Proposed Changes Projected 2024 Projected 2025 Projected 2026 Projected 2027 Revenue Additional related camps, clinics, and lessons related to additional staff 10 stalls in stallion barn 4 horse pasture (Epp's pasture) additional riding lessons Sustainable agriculture New workforce training Pet Wellness Clinic Total Expenses Riding Specialist 10 stalls in stallion barn* 4 horse pasture (Epp's pasture)* additional horses* $ 45,212 $ 72,000 $ 15,600 $ 28,800 $ 2,970 $ - $ - $ 164,582 $ 47,473 $ 72,000 $ 15,600 $ 28,800 $ 5,940 $ - $ 1,300 $ 171,113 $ 49,846 $ 72,000 $ 15,600 $ 28,800 $ 5,940 $ 14,640 $ 1,300 $ 188,126 $ 52,339 $ 72,000 $ 15,600 $ 28,800 $ 8,910 $ 14,640 $ 1,300 $ 193,589 $ 50,000 $ 72,675 $ 15,917 $ 10,449 $ 51,000 $ 46,050 $ 10,917 $ 5,449 $ 52,020 $ 46,050 $ 10,917 $ 5,449 $ 53,060 $ 46,050 $ 10,917 $ 5,449 Sustainable agriculture New workforce training $ 99 $ - $ 99 $ 1,000 $ 198 $ 8,052 $ 396 $ 8,052 Vet Tech/Ranch Marketing Pet Wellness Clinic Total Net $ 200 $ 200 $ 1,300 $ 116,015 $ 55,098 $ 200 $ 1,300 $ 124,186 $ 63,941 $ 200 $ 1,300 $ 125,424 $ 68,165 *includes the cost of the part-time barn attendants $ 149,340 $ 15,242

Financial Analysis Overall As of 6/15/23 2022 Projected 2024 Projected 2025 Projected 2026 Projected 2027 2023 Revenue Existing Continuing Education Existing Operations Existing Vet Tech Existing Agriculture $ 221,527 $ 159,387 $ 230,754 $ 42,480 $ 202,961 $ 127,215 $ 187,448 $ 39,747 $ 255,731 $ 160,291 $ 229,436 $ 50,081 $ 322,221 $ 201,967 $ 254,478 $ 280,830 $ 343,736 $ 420,733 $ 63,102 $ 79,509 $ 100,181 $ 405,998 $ 11,558 $ 320,642 Additional related camps, clinics, and lessons related to additional staff 10 stalls in stallion barn 4 horse pasture (Epp's pasture) additional riding lessons Sustainable agriculture New workforce training Pet Wellness Clinic Total $ - $ - $ - $ - $ - $ - $ - $ 654,148 $ - $ - $ - $ 45,212 $ 72,000 $ 15,600 $ 28,800 $ 2,970 $ - $ - $ 14,640 $ 14,640 $ - $ 1,300 $ 1,300 $ 1,300 $ 860,121 $ 1,039,232 $ 1,271,847 $ 1,546,703 $ 47,473 $ 49,846 $ 52,339 $ 72,000 $ 72,000 $ 72,000 $ 15,600 $ 15,600 $ 15,600 $ 28,800 $ 28,800 $ 28,800 $ 5,940 $ 5,940 $ 8,910 $ - $ - $ - $ 557,371

Financial Analysis - Overall As of 6/15/23 2022 Projected 2024 Projected 2025 Projected 2026 Projected 2027 2023 Expenses Existing Continuing Education Existing Operations Existing Vet Tech Existing Agriculture Insurance Riding Specialist 10 stalls in stallion barn* 4 horse pasture (Epp's pasture)* Additional horses* Sustainable agriculture New workforce training $ 260,092 $ 282,199 $ 345,091 $ 21,408 $ 12,834 $ - $ - $ - $ - $ - $ - $ 182,528 $ 229,985 $ 289,781 $ 365,125 $ 460,057 $ 253,759 $ 319,736 $ 402,868 $ 507,613 $ 639,593 $ 308,366 $ 388,541 $ 489,562 $ 616,848 $ 777,228 $ 21,994 $ 27,712 $ 34,918 $ 43,996 $ 55,435 $ 14,117 $ 15,529 $ 17,082 $ 18,790 $ 20,669 $ - $ 50,000 $ 51,000 $ 52,020 $ 53,060 $ - $ 72,675 $ 46,050 $ 46,050 $ 46,050 $ - $ 15,917 $ 10,917 $ 10,917 $ 10,917 $ - $ 10,449 $ 5,449 $ 5,449 $ 5,449 $ - $ 99 $ 99 $ 198 $ 396 $ - $ - $ 1,000 $ 8,052 $ 8,052 Vet Tech/Ranch Marketing Pet Wellness Clinic $ - $ - $ 200 $ 200 $ 200 $ 200 $ 1,300 $ 1,300 $ 1,300 $ 780,764 $ 1,130,844 $ 1,348,925 $ 1,675,258 $ 2,077,106 Total $ 921,624 Net $ (267,476) $ (223,393) $ (270,723) $ (309,693) $ (403,410) $ (530,404)

Plan Summary Current and New Ranch based programs fulfill the mission of MCC and work towards meeting goals Ranch offers potential to help MCC meet the local and regional workforce and training needs Ranch supports community needs Proposed changes cover their own expenses, but do not eliminate the overall loss

Capital Investments Type Project 2023-24 2024-25 2025-26 2026-27 2026-27 FUNDED FROM ANNUAL CAPITAL IMPROVEMENT FUND: Proposed Proposed Proposed Proposed Proposed Road Repairs and Maintenance 25,000 25,000 25,000 5,000 5,000 Lots & Roads Fence Replacement and Maintenance Landscape Improvements House Demolition 25,000 5,000 8,500 25,000 5,000 25,000 5,000 25,000 5,000 25,000 5,000 Renovations Construction Infrastructure Contingency Tractor and Other Equipment Needs 10,000 41,000 10,000 5,000 10,000 5,000 10,000 5,000 10,000 5,000 Plant Infrastructure TOTAL CIF 5 YEAR PLAN $114,500 $70,000 $70,000 $50,000 $50,000

Options Retain the Ranch Continue current operations with some investments to increase use Retain the Ranch Implement the Instructional Plan with additional investments Accept Proposals to Sell the Ranch Estimated market price = $4-5 million Accept 3rd Party Partnership Proposals Retain and operate some aspects of the current ranch programs Relocate or eliminate some aspects of the current ranch programs