Finance 2011-12
Institution: Indiana University-Northwest (151360)
User ID: 88G2401

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: Indiana University-Northwest (151360)
User ID: 88G2401

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: Indiana University-Northwest (151360)
User ID: 88G2401

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, 2011.)
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.)
    UnqualifiedQualified
(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.

Institution: Indiana University-Northwest (151360)
User ID: 88G2401

Part A - Statement of Net Assets
Fiscal Year: July 1, 2010 - June 30, 2011
 
Line no. Current year amountPrior year amount
 Current Assets  
01Total current assets 17,730,788
 
 Noncurrent Assets  
31Depreciable capital assets, net of depreciation 56,910,815
04Other noncurrent assets
CV=[A05-A31]
858,183 768,824
05Total noncurrent assets 57,679,639
 
06Total assets
CV=(A01+A05)
78,334,759 75,410,427
 
 Current Liabilities  
07Long-term debt, current portion 1,233,321
08Other current liabilities
CV=(A09-A07)
3,935,158 3,388,105
09Total current liabilities 4,621,426
 
 Noncurrent Liabilities  
10Long-term debt 24,603,439
11Other noncurrent liabilities
CV=(A12-A10)
1,229,804 1,137,940
12Total noncurrent liabilities 25,741,379
 
13Total liabilities
CV=(A09+A12)
29,769,233 30,362,805
 
 Net Assets  
14Invested in capital assets, net of related debt 31,074,055
15Restricted-expendable 3,111,146
16Restricted-nonexpendable 10,000
17Unrestricted
CV=[A18-(A14+A15+A16)]
14,713,085 10,852,421
18Total net assets
CV=(A06-A13)
48,565,526 45,047,622
 
You may use the space below to provide context for the data you've reported above.
 

Institution: Indiana University-Northwest (151360)
User ID: 88G2401

Part A - Statement of Net Assets (Page 2)
Fiscal Year: July 1, 2010 - June 30, 2011
 
Line No.DescriptionEnding balancePrior year
Ending balance
 Capital Assets  
 
21Land & land improvements3,093,633
22Infrastructure3,285,431
23Buildings82,224,389
32Equipment, including art and library collections7,164,625
27Construction in progress222,447
Total for Plant, Property and Equipment
CV
= (A21+ .. A27)
97,036,62395,990,525
28Accumulated depreciation39,079,710
33Intangible assets, net of accumulated amortization0
34Other capital assets0
 
 
You may use the space below to provide context for the data you've reported above.
 

Institution: Indiana University-Northwest (151360)
User ID: 88G2401

Part B - Revenues and Other Additions
Fiscal Year: July 1, 2010 - June 30, 2011
 
Line No.Source of FundsCurrent year amountPrior year amount
 Operating Revenues  
01Tuition & fees, after deducting discounts & allowances22,013,757
 Grants and contracts - operating  
02Federal operating grants and contracts838,695
03State operating grants and contracts394,201
04Local government/private operating grants and contracts99,331425,811
04aLocal government operating grants and contracts0
04bPrivate operating grants and contracts425,811
05Sales & services of auxiliary enterprises,
after deducting discounts & allowances
958,960
06Sales & services of hospitals,
after deducting patient contractual allowances
0
26Sales & services of educational activities553,038
07Independent operations0
08Other sources - operating
CV=[B09-(B01+ ....+B07)]
1,085,007938,180
09Total operating revenues26,122,642
 
 

Institution: Indiana University-Northwest (151360)
User ID: 88G2401

Part B - Revenues and Other Additions
Fiscal Year: July 1, 2010 - June 30, 2011
 
Line No.Source of fundsCurrent year amountPrior year amount
 Nonoperating Revenues  
10Federal appropriations0
11State appropriations21,142,949
12Local appropriations, education district taxes, & similar support0
 Grants-nonoperating  
13Federal nonoperating grants9,151,223
14State nonoperating grants0
15Local government nonoperating grants0
16Gifts, including contributions from affiliated organizations419,188
17Investment income46,910
18Other nonoperating revenues
CV=[B19-(B10+...+B17)]
00
19Total nonoperating revenues30,760,270
27Total operating and nonoperating revenues CV=[B19+B09]57,080,64656,882,912
2812-month Student FTE from E12
CV
=[B28a+B28b]
4,607
28aUndergraduates4,158
28bGraduates449
29Total operating and nonoperating revenues per student FTE CV=[B27/B28]12,390
 
 

Institution: Indiana University-Northwest (151360)
User ID: 88G2401

Part B - Revenues and Other Additions
Fiscal Year: July 1, 2010 - June 30, 2011
 
Line No.Source of fundsCurrent year amountPrior year amount
 Other Revenues and Additions  
20Capital appropriations0
21Capital grants & gifts44,250
22Additions to permanent endowments0
23Other revenues & additions
CV=[B24-(B20+...+B22)]
00
24Total other revenues and additions44,250
 
25Total all revenues and other additions
CV=[B09+B19+B24]
57,176,58656,927,162
 
You may use the space below to provide context for the data you've reported above.
 

Institution: Indiana University-Northwest (151360)
User ID: 88G2401

Part C - Expenses and Other Deductions
Fiscal Year: July 1, 2010 - June 30, 2011
  12345678
Line No.DescriptionTotal amountSalaries & wagesEmployee fringe benefitsOperation and maintenance of plantDepreciationInterestAll other                    PY Total
Amount
 Expenses and Deductions 
01Instruction2,085,73725,335,688
02Research24,641575,899
03Public service292,1371,186,055
05Academic support959,2887,097,752
06Student services692,1364,575,329
07Institutional support1,321,9482,863,153
08Operation & maintenance
of plant
(see instructions)
03,284,0860
10Scholarships and fellowships
expenses
, excluding discounts & allowances
 6,236,9976,465,472
11Auxiliary enterprises537,3661,984,384
12Hospital services00
13Independent operations00
14Other expenses
& deductions
CV=[C19-(C01+...+C13)]
327,414327,41400000229,391
19Total expenses & deductions015,434,33650,313,123
 Prior year amount50,313,12323,618,7267,789,3162,940,191 2,256,73613,708,154
2012-month Student FTE from E12
CV
=[C20a+C20b]
4,607
20aUndergraduates4,158
20bGraduates449
21Total expenses and deductions per student FTE CV=[C19/C20]11,495
 
You may use the space below to provide context for the data you've reported above.
 

Institution: Indiana University-Northwest (151360)
User ID: 88G2401

Part D - Summary of Changes In Net Assets
Fiscal Year: July 1, 2010 - June 30, 2011
 
Line No.DescriptionCurrent year amountPrior year amount
01Total revenues & other additions (from B25)57,176,58656,927,162
 
02Total expenses & deductions (from C19)52,958,26050,313,123
 
03Change in net assets during year
CV=(D01-D02)
4,218,3266,614,039
04Net assets beginning of year37,306,648
05Adjustments to beginning net assets and other gains or losses
CV=[D06-(D03+D04)]
-700,4221,126,935
06Net assets end of year (from A18)48,565,52645,047,622
 
You may use the space below to provide context for the data you've reported above.
 

Institution: Indiana University-Northwest (151360)
User ID: 88G2401

Part E - Scholarships and Fellowships
Fiscal Year: July 1, 2010 - June 30, 2011
   
Line No.SourceCurrent year amountPrior year amount
01Pell grants (federal)9,014,286
02Other federal grants240,227
03Grants by state government0
04Grants by local government0
05Institutional grants from restricted resources626,007
06Institutional grants from unrestricted resources
CV=[E07-(E01+...+E05)]
813,083662,501
07Total gross scholarships and fellowships10,543,021
 
 Discounts and Allowances  
08Discounts & allowances applied to tuition & fees 4,077,549
09Discounts & allowances applied to sales & services of
auxiliary enterprises
CV= (E10-E08)
59,8980
10Total discounts & allowances
CV=(E07-E11)
6,778,2944,077,549
 
11Net scholarships and fellowships expenses after deducting
discount & allowances (from C10)
6,236,9976,465,472
 
You may use the space below to provide context for the data you've reported above.
 

Institution: Indiana University-Northwest (151360)
User ID: 88G2401

Part H - Details of Endowment Assets
Fiscal Year: July 1, 2010 - June 30, 2011
Line No.Value of Endowment AssetsMarket ValuePrior Year Amounts
  Include not only endowment assets held by the institution, but any assets held by private foundations affiliated with the institution.  
01Value of endowment assets at the beginning of the fiscal year  8,214,975
02Value of endowment assets at the end of the fiscal year  8,002,549
 
You may use the space below to provide context for the data you've reported above.
 

Institution: Indiana University-Northwest (151360)
User ID: 88G2401

Part J - Revenue Data for Bureau of Census
Fiscal Year: July 1, 2010 - June 30, 2011
Source and typeAmount
Total for all funds
and operations
(includes
endowment funds,
but excludes component units)
Education and general/independent operationsAuxiliary enterprises Hospitals Agriculture extension/experiment services
 (1)  (2)(3)(4)(5)
01Tuition and fees28,887,37428,887,374   
02Sales and services1,643,5771,055,910
03Federal grants/contracts (excludes Pell Grants)919,349
 Revenue from the state government:
04State appropriations, current & capital19,229,228
05State grants and contracts32,201
 Revenue from local governments:
06Local appropriation, current & capital0
07Local government grants/contracts0
08Receipts from property and non-property taxes 
09Gifts and private grants, including capital grants 
10Interest earnings 
11Dividend earnings 
12Realized capital gains 
 
You may use the space below to provide context for the data you've reported above.
 

Institution: Indiana University-Northwest (151360)
User ID: 88G2401

Part K - Expenditure Data for Bureau of Census
Fiscal Year: July 1, 2010 - June 30, 2011
CategoryAmount
Total for all funds and operations (includes endowment funds, but excludes component units)Education and general/
independent operations
Auxiliary enterprisesHospitals Agriculture extension/
experiment services
 (1)(2)(3)(4)(5)
01Salaries and wages24,376,771189,298
02Employee benefits, total8,512,38858,285
03Payment to state retirement funds (maybe included in line 02 above)407,234
04Current expenditures other than salaries8,941,360
 Capital outlay: 
05Construction110,405
06Equipment purchases621,384
07Land purchases1,159,226
08Interest on debt outstanding, all funds & activities 
09Scholarships/fellowships13,015,29113,015,291 
 
You may use the space below to provide context for the data you've reported above.
 

Institution: Indiana University-Northwest (151360)
User ID: 88G2401

Part L - Debt and Assets, page 1
Fiscal Year: July 1, 2010 - June 30, 2011
Debt
CategoryAmount
01Long-term debt outstanding at beginning of fiscal year
02Long-term debt issued during fiscal year
03Long-term debt retired during fiscal year
04Long-term debt outstanding at end of fiscal year
05Short-term debt outstanding at beginning of fiscal year
06Short-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: Indiana University-Northwest (151360)
User ID: 88G2401

Part L - Debt and Assets, page 2
Fiscal Year: July 1, 2010 - June 30, 2011
Assets
CategoryAmount
07Total cash and security assets held at end of fiscal year in sinking or debt service funds
08Total cash and security assets held at end of fiscal year in bond funds
09Total 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: Indiana University-Northwest (151360) User ID: 88G2401
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 2012.

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 ipedshelp@rti.org.

Core Revenues
Revenue Source Reported values Percent of total core revenues Core revenues per FTE enrollment
Tuition and fees $22,168,978 39% $4,812
Government appropriations $19,133,288 34% $4,153
Government grants and contracts $12,455,828 22% $2,704
Private gifts, grants, and contracts $556,644 1% $121
Investment income $97,222 0% $21
Other core revenues $1,768,614 3% $384
Total core revenues $56,180,574 100% $12,195
 
Total revenues $57,176,586   $12,411
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 $27,529,097 54% $5,975
Research $602,968 1% $131
Public service $1,216,826 2% $264
Academic support $6,743,433 13% $1,464
Institutional support $3,520,816 7% $764
Student services $4,682,123 9% $1,016
Other core expenses $6,564,411 13% $1,425
Total core expenses $50,859,674 100% $11,040
 
Total expenses $52,958,260   $11,495
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 4,607
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:  Indiana University-Northwest (151360) User ID:  88G2401
Edit Report
 Finance
Institution: Indiana University-Northwest (151360)
SourceDescriptionSeverityResolvedOptions
Screen: Scholarships & Fellowships
Screen EntryThe number entered, 6,718,396, has an expected range of between 2,038,775 and 6,116,323 based on last year's amount. Please explain this difference. (Error #5301)ExplanationYesBack to survey data
Reason:Used different allocation method from prior year. Last year we used a percentage of tuition (student fees) to determine scholarship allowance across campuses. This year we used the percentage computed from our scholarship allowance annual adjusting entry and allocated across campuses.