finance 2018-19 institution: pima community college (105525)finance 2018-19 institution: pima...
TRANSCRIPT
Finance 2018-19Institution: Pima Community College (105525)User ID: P1055251
OverviewFinance Overview
Purpose The purpose of the IPEDS Finance component is to collect basic financial information from items associated with theinstitution's General Purpose Financial Statements.
There are a few minor additions to the 2018-19 collection.
• For GASB institutions, guidance has been added to Part D and Part C to accommodate implementation ofGASB Statements 74/75. Please carefully review FAQ #21 and the specified parts' instructions.
• For FASB not-for-profit institutions, a crosswalk has been developed to provide guidance for FASBAccounting Standard Update 2016-14, Not-for-profit Entities (Topic 950): Presentation of FinancialStatements of Not-for-profit Entities.
Resources:To download the survey materials for this component: Survey Materials
To access your prior year data submission for this component: Reported Data
If you have questions about completing this survey, please contact the IPEDS Help Desk at (877) 225-2568.
Institution: Pima Community College (105525)User ID: P1055251
Finance - Public Institutions' Reporting StandardReporting Standard
Please indicate which reporting standards are used to prepare your financial statements: GASB (Governmental Accounting Standards Board), using standards of GASB 34 & 35
FASB (Financial Accounting Standards Board)
Please consult your business officer for the correct response before saving this screen. Your response to thisquestion will determine the forms you will receive for reporting finance data.
Institution: Pima Community College (105525)User ID: P1055251
Finance - Public Institutions Using GASB StandardsGeneral Information
GASB-Reporting Institutions (aligned form)To the extent possible, the finance data requested in this report should be provided from your institution's auditedGeneral Purpose Financial Statements (GPFS). Please refer to the instructions specific to each screen of the survey fordetails and references.1. Fiscal Year CalendarThis report covers financial activities for the 12-month fiscal year: (The fiscal year reported should be the mostrecent fiscal year ending before October 1, 2018.)Beginning: month/year (MMYYYY) Month: 7 Year: 2017And ending: month/year (MMYYYY) Month: 6 Year: 20182. Audit OpinionDid your institution receive an unqualified opinion on its General Purpose Financial Statements from your auditor for thefiscal year noted above? (If your institution is audited only in combination with another entity, answer this question basedon the audit of that entity.) Unqualified Qualified
(Explain inbox below)
Don't know OR in progress(Explain inbox below)
3. Reporting ModelGASB Statement No. 34 offers three alternative reporting models for special-purpose governments like colleges anduniversities. Which model is used by your institution? Business-type activities
Governmental Activities
Governmental Activities with Business-Type Activities
4. Intercollegiate AthleticsIf your institution participates in intercollegiate athletics, are the expenses accounted for as auxiliary enterprises ortreated as student services? Auxiliary enterprises
Student services
Does not participate in intercollegiate athletics
Other (specify in box below)
5. Endowment AssetsDoes this institution or any of its foundations or other affiliated organizations own endowment assets ? No
Yes - (report endowment assets)
6. PensionDoes your institution include pension liabilities, expenses, and/or deferrals for one or more defined benefit pension plansin its General Purpose Financial Statements? No
Yes You may use the space below to provide context for the data you've reported above.
Institution: Pima Community College (105525)User ID: P1055251
Part A - Statement of Net Position Page 1Fiscal Year: July 1, 2017 - June 30, 2018
If your institution is a parent institution then the amounts reported in Parts A and D should include ALL of yourchild institutions
Line no. Current year amount Prior year amount
Assets 01 Total current assets 104,234,903 91,822,400
31 Depreciable capital assets, net of depreciation 80,448,375 84,991,86704 Other noncurrent assets
CV=[A05-A31] 49,872,169 46,872,190
05 Total noncurrent assets 130,320,544 131,864,057
06 Total assetsCV=(A01+A05)
234,555,447 223,686,457
19 Deferred outflows of resources 16,228,856 25,132,919 Liabilities
07 Long-term debt, current portion 0 008 Other current liabilities
CV=(A09-A07) 18,668,931 18,952,240
09 Total current liabilities 18,668,931 18,952,240
10 Long-term debt 1,067,207 011 Other noncurrent liabilities
CV=(A12-A10) 127,471,731 140,680,484
12 Total noncurrent liabilities 128,538,938 140,680,484
13 Total liabilitiesCV=(A09+A12)
147,207,869 159,632,724
20 Deferred inflows of resources 15,167,495 17,294,371 Net Position
14 Invested in capital assets, net of related debt 96,772,449 100,330,57015 Restricted-expendable 12,451,846 11,339,87616 Restricted-nonexpendable 0 017 Unrestricted
CV=[A18-(A14+A15+A16)] -20,815,356 -39,778,165
18 Net positionCV=[(A06+A19)-(A13+A20)]
88,408,939 71,892,281
You may use the space below to provide context for the data you've reported above. Decreased pension-related liabilities, increased net position in total,specifically unrestricted net position.
Institution: Pima Community College (105525)User ID: P1055251
Part A - Statement of Net Position Page 2Fiscal Year: July 1, 2017 - June 30, 2018
Line No. Description Ending balance Prior year
Ending balance Capital Assets
21 Land and land improvements 15,291,311 15,291,31122 Infrastructure 0 023 Buildings 193,712,220 193,712,22032 Equipment, including art and library collections 37,198,722 36,873,77927 Construction in progress 2,361,583 47,392
Total for Plant, Property and EquipmentCV = (A21+ .. A27)
248,563,836 245,924,702
28 Accumulated depreciation 150,462,567 145,594,13233 Intangible assets, net of accumulated amortization 0 034 Other capital assets 0 0
You may use the space below to provide context for the data you've reported above.
Institution: Pima Community College (105525)User ID: P1055251
Part D - Summary of Changes In Net PositionFiscal Year: July 1, 2017 - June 30, 2018
If your institution is a parent institution then the amounts reported in Parts A and D should include ALL of yourchild institutions
Line No. Description Current year amount Prior year amount
01 Total revenues and other additions for thisinstitution AND all of its child institutions
191,910,735 185,280,165
02 Total expenses and deductions for this institution
AND all of its child institutions 175,471,248 179,653,104
03 Change in net position during year
CV=(D01-D02) 16,439,487 5,627,061
04 Net position beginning of year for this institutionAND all of its child institutions
71,892,281 66,287,286
05 Adjustments to beginning net position and othergains or lossesCV=[D06-(D03+D04)]
77,171 -22,066
06 Net position end of year for this institution AND allof its child institutions (from A18)
88,408,939 71,892,281
The notes below provide context for the data reported above and should reflect whether the institution wasimpacted by implementation of GASB 74/75 - Reporting for Postemployment Benefits Other than Pension(OPEB).
• Institutions NOT impacted by GASB 74/75 (e.g., cases where the system office or another entity absorbs allthe OPEB liabilities/assets for the campuses) should select option (1) "Non-applicable..." from the dropdownmenu and enter any additional comments in the context box.
• Institutions impacted by GASB 74/75 should include the full net OPEB liability/asset in line 05 and 06 andselect either the 2nd or 3rd option.***Choosing option (2) will require you to enter the amount of the net OPEB liability/asset in the context boxusing a specific number format ###,###,###. Choosing option (3) will allow you to enter the amount of the netOPEB liability/asset in the context box AND any other comments to explain the data. Place the OPEB amountin parentheses using the format (###,###,###) prior to entering the explanation text.***
(3) Institution’s adjustment to beg. net position includes net OPEB liability/asset. Enter amount and other notes. (164,336) The amount for the net OPEB adjustment is $164,336.
Institution: Pima Community College (105525)User ID: P1055251
Part E - Scholarships and FellowshipsFiscal Year: July 1, 2017 - June 30, 2018
Do not report Federal Direct Student Loans (FDSL) anywhere in this section.
LineNo.
Scholarships and Fellowships Current yearamount
Prior yearamount
01 Pell grants (federal) 29,632,177 27,042,55902 Other federal grants (Do NOT include FDSL amounts) 1,142,769 1,118,52003 Grants by state government 94,327 99,20904 Grants by local government 0 005 Institutional grants from restricted resources 669,619 740,83306 Institutional grants from unrestricted resources
CV=[E07-(E01+...+E05)] 1,106,514 1,019,359
07 Total revenue that funds scholarships and fellowships 32,645,406 30,020,480 Discounts and Allowances
08 Discounts and allowances applied to tuition and fees 16,095,920 14,570,91109 Discounts and allowances applied to sales and services of
auxiliary enterprises 0 0
10 Total discounts and allowancesCV=(E08+E09)
16,095,920 14,570,911
11 Net scholarships and fellowships expenses after deducting
discounts and allowancesCV= (E07-E10) This amount will be carried forward to C10 of theexpense section.
16,549,486 15,449,569
You may use the space below to provide context for the data you've reported above.
Institution: Pima Community College (105525)User ID: P1055251
Part B - Revenues by Source (1)Fiscal Year: July 1, 2017 - June 30, 2018
Report in whole dollars only Line No. Source of Funds Current year amount Prior year amount Operating Revenues
01 Tuition and fees, after deducting discounts and allowances 28,532,331 28,834,580 Grants and contracts - operating
02 Federal operating grants and contracts 627,287 371,34503 State operating grants and contracts 443,327 483,18004 Local government/private operating grants and contracts 1,696,311 1,805,824
04a Local government operating grants and contracts 744,370 671,520 04b Private operating grants and contracts 951,941 1,134,304
05 Sales and services of auxiliary enterprises,after deducting discounts and allowances
1,067,161 1,720,067
26 Sales and services of educational activities 0 008 Other sources - operating (CV)
CV=[B09-(B01+ ....+B26)] 1,008,383 924,053
09 Total operating revenues 33,374,800 34,139,049
Institution: Pima Community College (105525)User ID: P1055251
Part B - Revenues by Source (2)Fiscal Year: July 1, 2017 - June 30, 2018
LineNo.
Source of funds Current yearamount
Prior yearamount
Nonoperating Revenues 10 Federal appropriations 0 011 State appropriations 0 012 Local appropriations, education district taxes, and similar support 111,324,689 106,823,980
Grants-nonoperating 13 Federal nonoperating grants Do NOT include Federal Direct Student
Loans 42,048,279 39,191,021
14 State nonoperating grants 844,122 1,015,64315 Local government nonoperating grants 478,993 528,59516 Gifts, including contributions from affiliated organizations 661,829 711,22317 Investment income 706,141 323,91018 Other nonoperating revenues
CV=[B19-(B10+...+B17)] 2,391,232 2,507,224
19 Total nonoperating revenues 158,455,285 151,101,59627 Total operating and nonoperating revenues
CV=[B19+B09] 191,830,085 185,240,645
28 12-month Student FTE from E12 14,013 13,74329 Total operating and nonoperating revenues per student FTE
CV=[B27/B28] 13,689 13,479
Institution: Pima Community College (105525)User ID: P1055251
Part B - Revenues by Source (3)Fiscal Year: July 1, 2017 - June 30, 2018
Line No. Source of funds Current year amount Prior year amount
Other Revenues and Additions 20 Capital appropriations 0 021 Capital grants and gifts 80,650 39,52022 Additions to permanent endowments 0 023 Other revenues and additions
CV=[B24-(B20+...+B22)] 0 0
24 Total other revenues and additionsCV=[B25-(B9+B19)]
80,650 39,520
25 Total all revenues and other additions 191,910,735 185,280,165
You may use the space below to provide context for the data you've reported above.
Institution: Pima Community College (105525)User ID: P1055251
Part C-1 - Expenses by Functional ClassificationFiscal Year: July 1, 2017 - June 30, 2018
Report Total Operating AND Nonoperating Expenses in this sectionLine No. Expense: Functional Classifications Total amount Prior Year
Total AmountSalaries and wages Prior Year
Salaries and wages (1) (2)
01 Instruction 60,288,404 62,064,291 40,202,259 39,470,82802 Research 0 0 0 003 Public service 0 0 0 005 Academic support 29,022,699 29,813,498 17,218,872 17,293,19106 Student services 31,489,971 32,831,577 18,230,773 17,729,37707 Institutional support 31,178,569 38,532,850 17,433,582 16,888,68410 Scholarships and fellowships expenses,
net of discounts and allowances(from Part E, E11)
16,549,486 15,449,569
11 Auxiliary enterprises 901,202 961,319 100,603 116,07614 Other Functional Expenses and deductions
CV=[C19-(C01+...+C11)] 6,040,917 0 0 0
19 Total expenses and deductions 175,471,248 179,653,104 93,186,089 91,498,156
Institution: Pima Community College (105525)User ID: P1055251
Part C-2 - Expenses by Natural ClassificationFiscal Year: July 1, 2017 - June 30, 2018
Line No. Expense: Natural Classifications Total Amount Prior year amount
19-2 Salaries and Wages(from Part C-1,Column 2 line 19) 93,186,089 91,498,15619-3 Benefits 26,526,766 26,139,44219-4 Operation and Maintenance of Plant (as a natural expense) 14,767,795 16,299,38819-5 Depreciation 7,117,410 7,701,08319-6 Interest 32,493 019-7 Other Natural Expenses and Deductions
CV=[C19-1 - (C19-2 + ... + C19-6)] 33,840,695 38,015,035
19-1 Total Expenses and Deductions(from Part C-1, Line 19)
175,471,248 179,653,104
20-1 12-month Student FTE (from E12 survey) 14,013 13,74321-1 Total expenses and deductions per student FTE
CV=[C19-1/C20-1] 12,522 13,072
You may use the space below to provide context for the data you've reported above.
Institution: Pima Community College (105525)User ID: P1055251
Part M - Pension InformationFiscal Year: July 1, 2017 - June 30, 2018
Line No. Description Current year amount Prior Year amount
01 Pension expense 2,271,810 7,325,521 02 Net Pension liability 123,727,324 137,501,128 03 Deferred inflows related to pension 15,167,495 17,294,371 04 Deferred outflows related to pension 16,228,856 25,132,919
You may use the space below to provide context for the data you've reported above. A decrease in pension expense and deferred outflows related to pensionswere due to prior year contributions to retirement plans.
Institution: Pima Community College (105525)User ID: P1055251
Part H - Details of Endowment AssetsFiscal Year: July 1, 2017 - June 30, 2018
LineNo.
Value of Endowment Assets MarketValue
Prior YearAmounts
Include not only endowment assets held by the institution, but any assets held byprivate foundations affiliated with the institution.
01 Value of endowment assets at the beginning of the fiscal year 5,441,676 5,396,62902 Value of endowment assets at the end of the fiscal year 5,546,220 5,441,676
You may use the space below to provide context for the data you've reported above.
Institution: Pima Community College (105525)User ID: P1055251
Part J - Revenue Data for the Census BureauFiscal Year: July 1, 2017 - June 30, 2018
Source and type AmountTotal for all
fundsand operations
(includesendowment
funds,but excludescomponent
units)
Education andgeneral/independent
operations
Auxiliaryenterprises
Hospitals Agricultureextension/experiment
services
(1) (2) (3) (4) (5)01Tuition and fees 44,628,251 44,628,251 02Sales and services 1,067,161 0 1,067,161 003Federal
grants/contracts(excludes Pell Grants)
11,316,286 11,316,286 0 0 0
Revenue from the state government:04State appropriations,
current & capital 0 0 0 0 0
05State grants andcontracts
1,287,439 1,287,439 0 0 0
Revenue from local governments:06Local appropriation,
current & capital 0 0 0 0 0
07Local governmentgrants/contracts
994,370 994,370 0 0 0
08Receipts from propertyand non-propertytaxes
111,324,689
09Gifts and privategrants,NOT including capitalgrants
1,868,673
10Interest earnings 626,296 11Dividend earnings 0 12Realized capital gains 0 You may use the space below to provide context for the data you've reported above.
Institution: Pima Community College (105525)User ID: P1055251
Part K - Expenditure Data for the Census BureauFiscal Year: July 1, 2017 - June 30, 2018
Category Total for all funds and operations (includesendowment funds,
but excludes componentunits)
Education andgeneral/
independentoperations
Auxiliaryenterprises
Hospitals Agricultureextension/experiment
services
(1) (2) (3) (4) (5)02Employee benefits, total 27,955,883 27,925,318 30,565 0 003Payment to state retirement funds
(may be included in line 02 above) 9,104,091 9,104,091 0 0 0
04Current expenditures includingsalaries
135,237,797 134,391,104 846,693 0 0
Capital outlays 05Construction 2,314,191 2,314,191 0 0 006Equipment purchases 2,245,371 2,245,371 0 0 007Land purchases 0 0 0 0 008Interest on debt outstanding, all
funds and activities 0
You may use the space below to provide context for the data you've reported above.
Institution: Pima Community College (105525)User ID: P1055251
Part L - Debt and Assets for Census Bureau, page 1Fiscal Year: July 1, 2017 - June 30, 2018
DebtCategory Amount01 Long-term debt outstanding at beginning of fiscal year 002 Long-term debt issued during fiscal year 1,433,58203 Long-term debt retired during fiscal year 104,76204 Long-term debt outstanding at end of fiscal year 1,328,82005 Short-term debt outstanding at beginning of fiscal year 006 Short-term debt outstanding at end of fiscal year 0
You may use the space below to provide context for the data you've reported above.
Institution: Pima Community College (105525)User ID: P1055251
Part L - Debt and Assets for Census Bureau, page 2Fiscal Year: July 1, 2017 - June 30, 2018
AssetsCategory Amount07 Total cash and security assets held at end of fiscal year in sinking or debt service funds 008 Total cash and security assets held at end of fiscal year in bond funds 009 Total cash and security assets held at end of fiscal year in all other funds 123,788,581 You may use the space below to provide context for the data you've reported above.
Institution: Pima Community College (105525)User ID: P1055251
Prepared byThe name of the preparer is being collected so that we can follow up with the appropriate person in the event that thereare questions concerning the data. The Keyholder will be copied on all email correspondence to other preparers.The time it took to prepare this component is being collected so that we can continue to improve our estimate of thereporting burden associated with IPEDS. Please include in your estimate the time it took for you to review instructions,query and search data sources, complete and review the component, and submit the data through the Data CollectionSystem.Thank you for your assistance. This survey component was prepared by: Keyholder SFA Contact HR Contact
Finance Contact Academic Library Contact Other
Name: Nicola Richmond Email: [email protected] How many staff from your institution only were involved in the data collection and reporting process of thissurvey component? 3.00Number of Staff (including yourself) How many hours did you and others from your institution only spend on each of the steps below whenresponding to this survey component?
Exclude the hours spent collecting data for state and other reporting purposes. Staff member Collecting Data
NeededRevising Data to MatchIPEDS Requirements
Entering Data Revising andLocking Data
Your office hours hours hours hours Other offices hours hours hours hours
Institution: Pima Community College (105525) User ID: P1055251Summary
Finance Survey Summary
IPEDS collects important information regarding your institution. All data reported in IPEDSsurvey components become available in the IPEDS Data Center and appear as aggregated datain various Department of Education reports. Additionally, some of the reported data appearsspecifically for your institution through the College Navigator website and is included in yourinstitution’s Data Feedback Report (DFR). The purpose of this summary is to provide you anopportunity to view some of the data that, when accepted through the IPEDS quality controlprocess, will appear on the College Navigator website and/or your DFR. College Navigator isupdated approximately three months after the data collection period closes and Data FeedbackReports will be available through the Data Center and sent to your institution’s CEO inNovember 2018.
Please review your data for accuracy. If you have questions about the data displayed belowafter reviewing the data reported on the survey screens, please contact the IPEDS Help Desk at:1-877-225-2568 or [email protected].
Core Revenues
Revenue Source Reported values Percent of total corerevenues
Core revenues per FTEenrollment
Tuition and fees $28,532,331 15% $2,036
State appropriations $0 0% $0
Local appropriations $111,324,689 58% $7,944
Government grants and contracts $45,186,378 24% $3,225
Private gifts, grants, and contracts $1,613,770 1% $115
Investment income $706,141 0% $50
Other core revenues $3,480,265 2% $248
Total core revenues $190,843,574 100% $13,619
Total revenues $191,910,735 $13,695
Other core revenues include federal appropriations; sales and services of educational activities; other operating andnonoperating sources; and other revenues and additions (e.g., capital appropriations, capital grants and gifts, etc.). Corerevenues exclude revenues from auxiliary enterprises (e.g., bookstores, dormitories), hospitals, and independent operations.For institutions reporting in Full parent/child relationships, core revenues per FTE enrollment amounts will not be allocated tochild institutions.
Core Expenses
Expense function Reported values Percent of total coreexpenses
Core expenses per FTEenrollment
Instruction $60,288,404 35% $4,302
Research $0 0% $0
Public service $0 0% $0
Academic support $29,022,699 17% $2,071
Institutional support $31,178,569 18% $2,225
Student services $31,489,971 18% $2,247
Other core expenses $22,590,403 13% $1,612
Total core expenses $174,570,046 100% $12,458
Total expenses $175,471,248 $12,522
Other core expenses include scholarships and fellowships, net of discounts and allowances, and other expenses. Core expensesexclude expenses from auxiliary enterprises (e.g., bookstores, dormitories), hospitals, and independent operations. Forinstitutions reporting in Full parent/child relationships, core expenses per FTE enrollment amounts will not be allocated to childinstitutions.
Calculated value
FTE enrollment 14,013
The full-time equivalent (FTE) enrollment used in this report is the sum of the institution’s FTE undergraduate enrollment andFTE graduate enrollment (as calculated from or reported on the 12-month Enrollment component). FTE is estimated using 12-month instructional activity (credit and/or contact hours). All doctor’s degree students are reported as graduate students.
Institution: Pima Community College (105525) User ID: P1055251Edit Report
Finance
Pima Community College (105525)
Source Description Severity Resolved OptionsScreen: Statement of net position (1)
ScreenEntry
The value of this field is expected to be greater thanzero. Please correct your data or explain. (Error#5148)
Explanation Yes
Reason: Decreased pension-related liabilities, increased net position in total, specifically unrestricted net position.Screen: Revenues Part 3
ScreenEntry
The amount of additions to permanent endowmentsreported in Part B (line 22) should not be zero orblank. Please confirm that the data reported arecorrect. (Error #5231)
Confirmation Yes
RelatedScreens:
Revenues Part 3
Screen: PensionScreenEntry
The amount reported is outside the expected range ofbetween 4,761,589 and 9,889,453 when comparedwith the prior year value. Please correct your data orexplain. (Error #5301)
Explanation Yes
Reason: A decrease in pension expense and deferred outflows related to pensions were due to prior year contributions toretirement plans.
ScreenEntry
The amount reported is outside the expected range ofbetween 16,336,398 and 33,929,440 when comparedwith the prior year value. Please correct your data orexplain. (Error #5301)
Explanation Yes
Reason: A decrease in pension expense and deferred outflows related to pensions were due to prior year contributions toretirement plans.