You will develop an Excel spreadsheet with 5-year trend data on a variety of key performance
indicators and budget items showing the financial status of the selected institution.
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. Use link: Retrieving IPEDS Data for Selected Institutions in the
Learn section for a helpful video tutorial with the step-by-step instructions.
In this assignment, you will download data that are publicly available from IPEDS (if you cannot
locate the information from your own institution’s website). Use the most recently available 5
years of reported data for the following most important key performance indicators and budget
data that must be included in the spreadsheet:
1. Fall Enrollment
 Enrollment of first time in college (FTIC) students
 Enrollment of new transfer students
 Total undergraduate enrollment
 Total graduate enrollment
 Full-time enrollment
 Part-time enrollment
 Grand total enrollment
2. Retention Rates
 Full-time retention rate
 Part-time retention rate
3. Completions
 Bachelor’s degrees
 Master’s and doctoral degrees combined
 Grand total completions
4. Graduation Rates
 150% of normal time
5. Student Financial Aid and Net Price
 Number of undergraduate students awarded federal, state, local, institutional or
other sources of grant aid
 Percent of undergraduate students awarded federal, state, local, institutional, or
other sources of grant aid
 Average amount of federal, state, local, institutional, or other sources of grant aid
awarded to undergraduate students
 Number of undergraduate students awarded federal student loans
 Percent of undergraduate students awarded federal student loans
 Average amount of federal student loans awarded to undergraduate students
6. Frequently Used/Derived Variables
Page 2 of 2
 Total price for in-state students living on campus
 Total price for out-of-state students living on campus
7. Finance
 Revenues
i. Tuition and fees
ii. Sales and services of auxiliary enterprises
iii. Total operating revenues
iv. Gifts, including contributions from affiliated organizations
v. Total nonoperating revenues
vi. Capital grants and gifts
vii. Total all revenues and other additions
 Expenses and salaries and wages by function and total expenses by natural
i. Instruction current year total
ii. Research current year total
iii. Public service current year total
iv. Academic support current year total
v. Student services current year total
vi. Institutional support current year total
vii. Auxiliary enterprises current year total
 Endowment assets
i. Value of endowment assets at the end of the fiscal year
 Assets and liabilities
i. Total assets
ii. Total liabilities
 Plant, property, equipment
i. Total for plant, property and equipment
ii. Other capital assets – ending balance
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.

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

We value our customers and so we ensure that what we do is 100% original..
At Custom Writing, we believe in exemplary services that are fully geared toward customer satisfaction. That is why we don’t shy away from giving you the following guarantees;

Money-back guarantee

Trusting us with your work is the best decision you have made, our pleasure lies in seeing you satisfied at 100%. If in the rear chance it happens that you are not satisfied, then know that we will equally not be satisfied. But worry not, our 30 days- Money back guarantee is all you need and that is what we promise you..

Read more

Zero-plagiarism guarantee

We utilize profoundly equipped and gifted writers who produce unique papers liberated from any form of plagiarism. To guarantee this, we run all papers finished by our scholars through a Plagiarism checker to ensure uniqueness and originality. In any case, on the off chance that you have vulnerabilities about the originality or falsification of any paper we have finished and conveyed to you, please get in touch with us straight away. We will quickly investigate, and if the paper is seen as counterfeited, we will take suitable actions including but not limited to, revising the paper for free and in extreme cases we will activate the money back guarantee.

Read more

Free-revision policy

We have an obligation deliver great and specially composed assignments. Our revision strategy endeavors to ensure total client satisfaction, comfort, and a genuine feelings of serenity. We make minor updates and corrections to the underlying request as part of our continuous assistance. However, revisions should just incorporate changes and alterations that were not effectively met, in the underlying request and that are inside the rules as per the current request structure..

Read more

Privacy policy

Our client's Data is an Integral part of our business but clearly, we are not in the business of offering our clients' very own data to others. We realize that you care how your online data is utilized and shared, we equally value your trust that we will do so cautiously and sensibly. We Promise to ensure the security of your own data during transmission by utilizing encryption conventions and programming. Likewise assist us with securing your information by not sharing your passwords and usernames.

Read more

Fair-cooperation guarantee

In submitting a request with us, you consent to the services we give. We will strive to take the necessary steps to convey a far reaching paper according to your prerequisites. Equally we depend on your cooperation to guarantee that we convey on this order.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages