IPEDS Reporting Year Finance 2012-13 (2011-12 Data)

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Overview

Finance Overview
| Purpose |
| The purpose of the IPEDS Finance component is to collect basic financial information from items associated with the institution's General Purpose Financial Statements. |
| |
| |
| |
| |

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 1-877-225-2568.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Finance - Public institutions

Reporting 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 this question will determine the forms you will receive for reporting finance data.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Finance - Public institutions

General Information
GASB-Reporting Institutions (aligned form)

To the extent possible, the finance data requested in this report should be provided from your institution's audited General Purpose Financial Statements (GPFS). Please refer to the instructions specific to each screen of the survey for details and references.

1. Fiscal Year Calendar
This report covers financial activities for the 12-month fiscal year: (The fiscal year reported should be the most recent fiscal year ending before October 1, 2012.)
Beginning: month/year (MMYYYY) | Month: | | Year: |
And ending: month/year (MMYYYY) | Month: | | Year: |

2. Audit Opinion
Did your institution receive an unqualified opinion on its General Purpose Financial Statements from your auditor for the fiscal year noted above? (If your institution is audited only in combination with another entity, answer this question based on the audit of that entity.)

Unqualified

Qualified
(Explain in
box below)

Don't know
(Explain in
box below)

3. Reporting Model
GASB Statement No. 34 offers three alternative reporting models for special-purpose governments like colleges and universities. Which model is used by your institution?

| | Business Type Activities
| | Governmental Activities
| | Governmental Activities with Business-Type Activities

4. Intercollegiate Athletics
If your institution participates in intercollegiate athletics, are the expenses accounted for as auxiliary enterprises or treated as student services?

| | Auxiliary enterprises
| | Student services
| | Does not participate in intercollegiate athletics
| | Other (specify in box below)

5. Endowment Assets
Does this institution or any of its foundations or other affiliated organizations own endowment assets ?

| | Yes - (report endowment assets)
| | No

You may use the space below to provide context for the data you've reported above.
Intercollegiate Athletics is a department.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Part A - Statement of Net Assets

Fiscal Year: July 1, 2011 - June 30, 2012
If your institution is a parent institution then the amounts reported in Parts A and D should include ALL of your child institutions

Line no. | | Current year amount | Prior year amount
| Current Assets | |
01 | Total current assets | | 1,004,159,993

| Noncurrent Assets | |
31 | Depreciable capital assets, net of depreciation | | 1,788,891,735

04

Other noncurrent assets
CV=[A05-A31]

979,296,938

1,000,797,651

05 | Total noncurrent assets | | 2,789,689,386

06

Total assets
CV=(A01+A05)

3,874,619,774

3,793,849,379

| Current Liabilities | |
07 | Long-term debt, current portion | | 165,388,613

08

Other current liabilities
CV=(A09-A07)

310,300,529

300,237,336

09 | Total current liabilities | | 465,625,949

| Noncurrent Liabilities | |
10 | Long-term debt | | 837,622,022

11

Other noncurrent liabilities
CV=(A12-A10)

0

1,519,347

12 | Total noncurrent liabilities | | 839,141,369

13

Total liabilities
CV=(A09+A12)

1,281,756,802

1,304,767,318

| Net Assets | |
14 | Invested in capital assets, net of related debt | | 965,176,426
15 | Restricted-expendable | | 197,139,690
16 | Restricted-nonexpendable | | 491,539,610

17

Unrestricted
CV=[A18-(A14+A15+A16)]

882,338,711

835,226,335

18

Total net assets
CV=(A06-A13)

2,592,862,972

2,489,082,061

You may use the space below to provide context for the data you've reported above.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Part A - Statement of Net Assets (Page 2)

Fiscal Year: July 1, 2011 - June 30, 2012

Line No.

Description

Ending balance

Prior year
Ending balance

| Capital Assets | |

21 | Land & land improvements | | 35,658,885
22 | Infrastructure | | 229,649,199
23 | Buildings | | 1,896,120,615
32 | Equipment, including art and library collections | | 603,313,148
27 | Construction in progress | | 108,017,054

Total for Plant, Property and Equipment
CV = (A21+ .. A27)

3,092,704,116

2,872,758,901

28 | Accumulated depreciation | | 1,086,552,237
33 | Intangible assets, net of accumulated amortization | | 0
34 | Other capital assets | | 2,685,071

You may use the space below to provide context for the data you've reported above.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Part E - Scholarships and Fellowships

Fiscal Year: July 1, 2011 - June 30, 2012
DO NOT REPORT FEDERAL DIRECT STUDENT LOANS (FDSL) ANYWHERE IN THIS SECTION

| | |

Line No. | Source | Current year amount | Prior year amount
01 | Pell grants (federal) | | 21,763,800
02 | Other federal grants (Do NOT include FDSL amounts) | | 8,791,780
03 | Grants by state government | | 9,316,158
04 | Grants by local government | | 0
05 | Institutional grants from restricted resources | | 10,740,666

06

Institutional grants from unrestricted resources
CV=[E07-(E01+...+E05)]

75,559,917

63,814,698

07 | Total gross scholarships and fellowships | | 114,427,102

| Discounts and Allowances | |
08 | Discounts & allowances applied to tuition & fees | | 89,968,950

09

Discounts & allowances applied to sales & services of
auxiliary enterprises

-3,659,848

10

Total discounts & allowances
CV=(E08+E09)

107,296,368

86,309,102

11

Net scholarships and fellowships expenses after deducting
discounts & allowances
CV= (E07-E10) This amount will be carried forward to C10 of the expense section.

30,506,999

28,118,000

You may use the space below to provide context for the data you've reported above.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Part B - Revenues and Other Additions

Fiscal Year: July 1, 2011 - June 30, 2012

Line No. | Source of Funds | Current year amount | Prior year amount
| Operating Revenues | |
01 | Tuition & fees, after deducting discounts & allowances | | 246,626,964
| Grants and contracts - operating | |
02 | Federal operating grants and contracts | | 129,791,018
03 | State operating grants and contracts | | 40,054,479
04 | Local government/private operating grants and contracts | 46,334,677 | 42,656,944
| 04a | Local government operating grants and contracts | | 0
| 04b | Private operating grants and contracts | | 42,656,944

05

Sales & services of auxiliary enterprises,
after deducting discounts & allowances

401,320,020

06

Sales & services of hospitals,
after deducting patient contractual allowances

616,482,579

26 | Sales & services of educational activities | | 15,403,026
07 | Independent operations | | 0

08

Other sources - operating
CV=[B09-(B01+ ....+B07)]

35,984,225

19,747,271

09 | Total operating revenues | | 1,512,082,301

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Part B - Revenues and Other Additions

Fiscal Year: July 1, 2011 - June 30, 2012

Line No. | Source of funds | Current year amount | Prior year amount
| Nonoperating Revenues | |
10 | Federal appropriations | | 21,222,964
11 | State appropriations | | 228,144,650
12 | Local appropriations, education district taxes, & similar support | | 0
| Grants-nonoperating | |
13 | Federal nonoperating grants Do NOT include Federal Direct Student Loans | | 21,763,800
14 | State nonoperating grants | | 0
15 | Local government nonoperating grants | | 0
16 | Gifts, including contributions from affiliated organizations | | 28,408,229
17 | Investment income | | 120,317,092

18

Other nonoperating revenues
CV=[B19-(B10+...+B17)]

2,434,971

0

19 | Total nonoperating revenues | | 419,856,735
27 | Total operating and nonoperating revenues CV=[B19+B09] | 1,913,732,269 | 1,931,939,036
28 | 12-month Student FTE from E12 | 30,013 | 29,442
29 | Total operating and nonoperating revenues per student FTE CV=[B27/B28] | 63,763 | 65,618

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Part B - Revenues and Other Additions

Fiscal Year: July 1, 2011 - June 30, 2012

Line No. | Source of funds | Current year amount | Prior year amount
| Other Revenues and Additions | |
20 | Capital appropriations | | 4,486,644
21 | Capital grants & gifts | | 8,632,320
22 | Additions to permanent endowments | | 13,714,076

23

Other revenues & additions
CV=[B24-(B20+...+B22)]

42,316,001

0

24 | Total other revenues and additions | | 26,833,040

25

Total all revenues and other additions
CV=[B09+B19+B24]

1,981,169,735

1,958,772,076

You may use the space below to provide context for the data you've reported above.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Part C - Expenses and Other Deductions

Fiscal Year: July 1, 2011 - June 30, 2012
Report Total Operating AND Nonoperating Expenses in this section

| | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8

Line No.

Description

Total amount

Salaries & wages

Employee fringe benefits

Operation and maintenance of plant

Depreciation

Interest

All other

PY Total
Amount

| Expenses and Deductions |
01 | Instruction | | | | | | | 21,703,241 | 279,102,208
02 | Research | | | | | | | 46,081,060 | 163,656,061
03 | Public service | | | | | | | 27,586,192 | 110,437,370
05 | Academic support | | | | | | | 13,330,721 | 69,024,814
06 | Student services | | | | | | | 7,770,710 | 32,561,996
07 | Institutional support | | | | | | | 0 | 53,571,713

08

Operation & maintenance
of plant (see instructions)

0

38,214,758

0

10

Scholarships and fellowships
expenses, excluding discounts & allowances (from E11)

30,506,999

30,506,999

28,118,000

11 | Auxiliary enterprises | | | | | | | 116,478,638 | 396,000,306
12 | Hospital services | | | | | | | 295,670,509 | 639,617,343
13 | Independent operations | | | | | | | 0 | 0

14

Other expenses
& deductions
CV=[C19-(C01+...+C13)]

873,151

0

0

0

0

0

873,151

2,820,280

19 | Total expenses & deductions | | | | 0 | | | 598,215,979 | 1,774,910,091
| Prior year amount | 1,774,910,091 | 869,495,428 | 208,634,410 | | 102,077,404 | 31,635,926 | 563,066,923 |
20 | 12-month Student FTE from E12 | 30,013 | | 29,442
21 | Total expenses and deductions per student FTE CV=[C19/C20] | 62,552 | | 60,285

You may use the space below to provide context for the data you've reported above.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Part D - Summary of Changes In Net Assets

Fiscal Year: July 1, 2011 - June 30, 2012

Line No. | Description | Current year amount | Prior year amount
01 | Total revenues & other additions (from B25) | 1,981,169,735 | 1,958,772,076

02 | Total expenses & deductions (from C19) | 1,877,387,323 | 1,774,910,091

03

Change in net assets during year
CV=(D01-D02)

103,782,412

183,861,985

04 | Net assets beginning of year | | 2,305,220,075

05

Adjustments to beginning net assets and other gains or losses
CV=[D06-(D03+D04)]

-1

1

06 | Net assets end of year (from A18) | 2,592,862,972 | 2,489,082,061

You may use the space below to provide context for the data you've reported above.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Part H - Details of Endowment Assets

Fiscal Year: July 1, 2011 - June 30, 2012
Line No. | Value of Endowment Assets | Market Value | Prior Year Amounts
| Include not only endowment assets held by the institution, but any assets held by private foundations affiliated with the institution. | |
01 | Value of endowment assets at the beginning of the fiscal year | | 510,554,667
02 | Value of endowment assets at the end of the fiscal year | | 586,413,339

You may use the space below to provide context for the data you've reported above.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Part J - Revenue Data for Bureau of Census

Fiscal Year: July 1, 2011 - June 30, 2012
Source and type | Amount

Total for all funds
and operations
(includes
endowment funds,
but excludes component units)

Education and general/independent operations

Auxiliary enterprises

Hospitals

Agriculture extension/experiment services

| (1) | (2) | (3) | (4) | (5)
01 | Tuition and fees | 379,553,171 | 379,553,171 | | |
02 | Sales and services | 1,075,100,608 | | 401,542,418 | 656,903,319 |
03 | Federal grants/contracts (excludes Pell Grants) | 125,583,640 | | | |
| Revenue from the state government:
04 | State appropriations, current & capital | 203,712,087 | | | |
05 | State grants and contracts | 37,827,238 | | | |
| Revenue from local governments:
06 | Local appropriation, current & capital | 0 | | | |
07 | Local government grants/contracts | 0 | | | |
08 | Receipts from property and non-property taxes | |
09 | Gifts and private grants, including capital grants | |
10 | Interest earnings | |
11 | Dividend earnings | |
12 | Realized capital gains | |

You may use the space below to provide context for the data you've reported above.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Part K - Expenditure Data for Bureau of Census

Fiscal Year: July 1, 2011 - June 30, 2012
Category | Amount

Total for all funds and operations (includes endowment funds, but excludes component units)

Education and general/
independent operations

Auxiliary enterprises

Hospitals

Agriculture extension/
experiment services

| (1) | (2) | (3) | (4) | (5)
01 | Salaries and wages | 904,845,298 | | 202,981,530 | 235,549,452 |
02 | Employee benefits, total | 235,052,291 | | 42,282,727 | 73,170,184 |
03 | Payment to state retirement funds (maybe included in line 02 above) | 0 | | | |
04 | Current expenditures other than salaries | 587,669,626 | | | |
| Capital outlay: |
05 | Construction | 162,948,428 | | | |
06 | Equipment purchases | 36,400,954 | | | |
07 | Land purchases | 5,006,084 | | | |
08 | Interest on debt outstanding, all funds & activities | |
09 | Scholarships/fellowships | 137,803,367 | 137,803,367 |

You may use the space below to provide context for the data you've reported above.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Part L - Debt and Assets, page 1

Fiscal Year: July 1, 2011 - June 30, 2012

Debt
Category | Amount
01 | Long-term debt outstanding at beginning of fiscal year |
02 | Long-term debt issued during fiscal year |
03 | Long-term debt retired during fiscal year |
04 | Long-term debt outstanding at end of fiscal year |
05 | Short-term debt outstanding at beginning of fiscal year |
06 | Short-term debt outstanding at end of fiscal year |

You may use the space below to provide context for the data you've reported above.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Part L - Debt and Assets, page 2

Fiscal Year: July 1, 2011 - June 30, 2012
Assets
Category | Amount
07 | Total cash and security assets held at end of fiscal year in sinking or debt service funds |
08 | Total cash and security assets held at end of fiscal year in bond funds |
09 | Total cash and security assets held at end of fiscal year in all other funds |

You may use the space below to provide context for the data you've reported above.

Institution: University of Missouri-Columbia (178396)
User ID: 29C0011

Prepared by

This survey component was prepared by:
| | Keyholder | | SFA Contact | | HR Contact | | Finance Contact | | Other |
| Name: | |
| Email: | |

How long did it take to prepare this survey component? | | hours | | minutes |

The name of the preparer is being collected so that we can follow up with the appropriate person in the event that there are 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 the reporting 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 Collection System.
Thank you for your assistance.

Institution: University of Missouri-Columbia (178396) | User ID: 29C0011

Summary

Finance Survey Summary

IPEDS collects important information regarding your institution. All data reported in IPEDS survey components become available in the IPEDS Data Center and appear as aggregated data in various Department of Education reports. Additionally, some of the reported data appears specifically for your institution through the College Navigator website and is included in your institution’s Data Feedback Report (DFR). The purpose of this summary is to provide you an opportunity to view some of the data that, when accepted through the IPEDS quality control process, will appear on the College Navigator website and/or your DFR. College Navigator is updated approximately three months after the data collection period closes and Data Feedback Reports will be available through the ExPT and sent to your institution’s CEO in November 2013.

Please review your data for accuracy. If you have questions about the data displayed below after reviewing the data reported on the survey screens, please contact the IPEDS Help Desk at: 1-877-225-2568 or [email-masked].

Core Revenues

Revenue Source | Reported values | Percent of total core revenues | Core revenues per FTE enrollment
Tuition and fees | $278,532,096 | 30% | $9,280
Government appropriations | $220,537,358 | 24% | $7,348
Government grants and contracts | $187,572,463 | 20% | $6,250
Private gifts, grants, and contracts | $105,022,991 | 11% | $3,499
Investment income | $14,751,332 | 2% | $491
Other core revenues | $122,583,051 | 13% | $4,084
Total core revenues | $928,999,291 | 100% | $30,953

Total revenues | $1,981,169,735 | | $66,010

Core revenues include tuition and fees; government appropriations (federal, state, and local); government grants and contracts; private gifts, grants, and contracts; investment income; other operating and nonoperating sources; and other revenues and additions. Core revenues exclude revenues from auxiliary enterprises (e.g., bookstores, dormitories), hospitals, and independent operations.

Core Expenses

Expense function | Reported values | Percent of total core expenses | Core expenses per FTE enrollment
Instruction | $319,116,510 | 40% | $10,633
Research | $160,685,186 | 20% | $5,354
Public service | $110,367,939 | 14% | $3,677
Academic support | $75,181,572 | 9% | $2,505
Institutional support | $61,693,991 | 8% | $2,056
Student services | $36,444,460 | 5% | $1,214
Other core expenses | $31,380,150 | 4% | $1,046
Total core expenses | $794,869,808 | 100% | $26,484

Total expenses | $1,877,387,323 | | $62,552

Core expenses include expenses for instruction, research, public service, academic support, institutional support, student services, operation and maintenance of plant, depreciation, scholarships and fellowships expenses, other expenses, and nonoperating expenses.

| Calculated value
FTE enrollment | 30,013

The full-time equivalent (FTE) enrollment used in this report is the sum of the institution’s FTE undergraduate enrollment and FTE 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:  University of Missouri-Columbia (178396) | User ID:  29C0011
Edit Report

Finance

University of Missouri-Columbia (178396)
Source | Description | Severity | Resolved | Options
Screen: Net Assets
Screen Entry | Net assets (beginning of year) is expected to be equal to the prior year's net assets (end of year). Please explain. (Error #5303) | Explanation | Yes |
Reason: | There is a 1,500 difference between Columbia prior year ending balance and current year beginning. This was due to a bad journal entry in prior years that had the wrong business unit header.