Develop an Excel spreadsheet with 5-year trend data on a variety of key performance indicators and budget items

Develop an Excel spreadsheet with 5-year trend data on a variety of key performance indicators and budget items

Course Project: Part 1 – Budget SpreadsheetAssignment Instructions

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

• 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 classification

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.

Answer preview to Develop an Excel spreadsheet with 5-year trend data on a variety of key performance indicators and budget items

Develop an Excel spreadsheet with 5-year trend data on a variety of key performance indicators and budget items

excel

Get instant access to the full solution from  by clicking the purchase button below








We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.