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 Harvard UNIversity for the Case Study: Institutional 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? PLEASE FOLLOW DIRECTIONS VERY CAREFULLY! IT IS IMPORTANT TO READ THE QUESTION AND BE PRECISE WITH THE STEPS OF FORMING THE EXCEL SHEET!