Description
You will develop an Excel spreadsheet with 3-year trend data on a variety of key performance indicators and budget items showing the financial status of the institution selected for the Case Study Institution Profile earlier in the course.
**I have attached the case study institution profile
Budget Spreadsheet Instructions
You will develop an Excel spreadsheet with 3-year trend data on a variety of key performance indicators and budget items showing the financial status of the institution selected for the Case Study Institution Profile earlier in the course . In addition to providing data on your selected institution, please select the following key state and national trends, assuming the data are available publicly:
Total undergraduate enrollment
Total graduate enrollment
Total in-state enrollment
Total out-of-state enrollment
Student loan default rate
Student borrowing
Core revenues per student FTE
Core expenses per student FTE by function
Total state support for higher education
Total federal support for higher education
As you review the data, how does your institution compare to the state and national trends? Is there anything that catches your attention, either positively or negatively?
The US Department of Education’s National Center for Education Statistics coordinates the Integrated Postsecondary Education Data System (IPEDS) surveys every year. The IPEDS surveys are federal requirements of all institutions that receive Title IV aid. IPEDS data are especially helpful for enrollment and budget analysts to compare their own institutions with comparative peer institutions. Here is a link to a helpful video tutorial with the step-by-step instructions on retrieving IPEDS data for selected institutions:
https://www.airweb.org/EducationAndEvents/IPEDSTraining/Tutorials/DataCenter/Pages/Overview.aspx
In this assignment, you will download data that are publicly available from US Department of Education’s National Center for Education Statistics coordinates the Integrated Postsecondary Education Data System (IPEDS) if you cannot locate the information from your own institution’s website. Use the most recently available 3 years of reported data.
One option that might be simpler is to download multiple years of the Data Feedback Report. You can identify your institution, then select “View Previous Data Feedback Reports.” This report provides you with a single year snapshot of these measures all in one file, so you would then need to download prior years to get the historical data. Here is the link:
https://nces.ed.gov/ipeds/datacenter/Expt/SelectComparisonInstitution.aspx
You are welcome to provide additional information as a means of preparing broader context about the institution. Because of the amount of details required for this budget assignment, it is recommended that you use multiple worksheets within the same Excel file instead of placing all the data into the same worksheet.
This assignment is due by 11:59 p.m. (ET) on Sunday of Module/Week 6.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
1
The total number undergraduate and graduate students enrollment at Yale university was
among the lowest at 12, 974 compared to the other universities despite the university having one
of the highest number of full time instructors. Only Boston and New York Universities have
received state grants worth more than one million dollars for the three year period with New
York University receiving $2.5 million dollars worth of state grant in 2017. Yale University has
received state grants lower than one million dollars with the highest grant being in 2017 of $729,
408. Despite the small amount of support, Yale University was also among the universities that
were awarded the least amount of loans to its undergraduate students compared to the other
universities.
In addition, Yale University also benefit more than any other university in 2017 in terms
of financial support from the federal government. It had the highest average amount of federal
grand aid of $7,021 per student while Harvard University had the lowest average of $4,524 per
student. Harvard had also the lowest state grant and contracts of However, Columbia University
in the City of New York had the lowest average amount of federal grant aid averaging $3,203 per
student.
Institution
Boston University
Columbia University in the City of New York
Harvard University
Massachusetts Institute of Technology
New York University
Stanford University
University of Chicago
University of Pennsylvania
Yale University
Total
assets
(F1617_F1
A)
Total
liabilities
(F1617_F1
A)
Federal
operating
grants
and
contracts
(F1617_F1
A)
Total
gross
scholarshi
ps and
fellowship
s
(F1617_F1
A)
4-year
Graduatio
n rate bachelor's
degree
within
100% of
normal
time
(GR200_1
7)
80
89
86
82
81
75
86
87
88
All ranks
(S2017_SIS
All fulltime
instr...